Drop all schema objects
Drop all schema objects Be careful when you drop all … Read more
Oracle DBA
How To Find CPU Usage For a Session
How to Find CPU Usage For a Session? SET linesize … Read more
How To Find Database Objects With Datafiles?
How To Find Database Objects With Datafiles? SELECT DISTINCT t.ts#,t.name … Read more
Find Total Undo Statistics
To Find Total Undo Statistics ALTER SESSION SET nls_date_format=’dd-mon-yy hh24:mi’; … Read more
List All Datafile Of Undo Tablespace
List All Datafile Of Undo Tablespace SELECT tablespace_name,file_name,file_id,autoextensible,bytes / 1048576 … Read more
Datewise Occurrence Of ORA-1555
Datewise Occurrence Of ORA-1555 SELECT To_char(begin_time, ‘mm/dd/yyyy hh24:mi’) “Int. Start”,ssolderrcnt … Read more
Extent Count And Total Blocks
Extent Count And Total Blocks set linesize 152col tablespace_name FOR … Read more
How To Generate ASH Report in Oracle Database?
To generate ASH Report in an Oracle database. It’s simple … Read more
How To Generate ADDM Report in Oracle Database?
To generate ADDM Report in an Oracle database. It’s simple … Read more
How To Generate AWR Report in Oracle Database?
To generate AWR report, ASH report, and ADDM report for … Read more