Tag: event

Next Event- Speaking Schedule/2020

Posted on by Osama Mustafa in News

I was honored this year to speak in different conferences around the world, and Due to Covid-19 most of the conference was Virtual, I miss my friends around the world, but saftey comes first, i hope everyone is safe.

I am writing this post to share with people the schedule of different conferences some of them already done but in case you missed something there is always next time, register in the virtual conferences and don’t miss the chance to learn something new.

My 2020 Schedule

Rule #1 in IT, never, and I do mean NEVER, stop learning.

Conference NameGroupDateLinkNote
Oracle Groundbreakers EMEA Virtual TourKSAOUG10-Oct-2020 1 2:30pmhttp://ogbemea.com/10-oct-2020/
SPOUG20SPOUGOctober 20, 2020 10:50 amhttp://spoug.es/spoug-20/
Oracle Groundbreakers APAC Virtual Tour 2020APAC Group19 October 2020, 10:00 amhttps://www.apacgbt.com/

This table will be updated depends on the schedule or any new conferences.

Regards

Osama

Oracle Statistics Tables.

Posted on by Osama Mustafa in Database
Hi ,

I am going to talk about Some Oracle Statistics Table that will be useful for tuning your database , and gathering information about your database , these table are very useful

For example Dynamic Performance View  :
**The below query will gives you the most sql statement taking more time in the CPU .
1-Select Sql_text , executions from v$sqlstats where cpu_time > 1000 ;
**Below Query Gives you some Details about Specific Machine 
2-Select * from v$session where machine = ‘OSAMA_PC’ and where
    logon_time > sysdate -1 ;
**finally , Lock in your database 
3- select sid,ctime from v$lock where block > 0 ;

Statistics Tables are :
**Display System Wide Statistics :
V$Sysstat
V$Statname
V$Sesstat

**Display System Wide Statistics :

V$Sgastat
V$Event_name
V$system_event

 **Display Session-Related Statistics
V$statname
V$Session
V$Session _Event
V$Session_Wait

**Display Service-Related Statistics
V$Service_stats
V$Services
V$Service_event
V$Service_wait_Class


**Display Information About Wait Class :

V$Session_Wait_Class
V$System_Wait_Class
V$Service_Wait_Class

**Display Session Wait

V$Session_Event : Session Wait By event for each session had to wait .
V$Session_Wait : Session Wait By Event For current active session that are waiting .
V$System_Event : Total waits for an event (All Session Together).

Wait Event : Information About session that had to wait or must wait for Different Reasons (V$Event_name).

Some Other Useful Tables :
-V$SQL
-V$SQLAREA

Thank You
Osama Mustafa