Oracle Sys Table and View Study 1st week
Select Object_Type, count(*) from dba_objects Group by Object_Type order by count(*) desc Select * from dba_objects Where Object_Type = 'TABLE' Select Owner, Cluster_Name, TableSpace_Name, IOT_Name, Table_Name, Partitioned, Blocks, Num_Rows, Avg_Row_Len, Last_Analyzed, dt.* from dba_tables dt Where Owner = 'EJMIS' Order by 7 Desc Select dt.* from dba_tables dt Where Owner = 'EJMIS' Select SID, S..
dba view study 1
SELECT * FROM v$sort_usage Select * from v$sgastat order by bytes desc Select Pool, Name, Bytes, (Bytes/1000000) MB from v$sgastat where name like '%cache%' order by bytes desc Select * from v$librarycache Select sga.*, lbc.* from v$sgastat sga, (select NameSpace, Gets, GetHits, GetHitRatio, Pins, PinHits, PinHitRatio, Reloads, Invalidations from v$librarycache) lbc Where Upper(sga.Name) = lbc.n..
