Inactive Programs With Disk Reads
Inactive Programs With Disk Reads prompt inactive sessionsSELECT DISTINCT ( … Read more
tutorailwale
To Find Toad Sessions
How to find Toad Sessions in Oracle database SELECT p.spid,s.sid,s.process … Read more
Inactive Session Details More Than 1 Hour
Inactive Session Details More Than 1 Hour set pagesize 50col … Read more
Drop all schema objects
Drop all schema objects Be careful when you drop all … Read more
How to Get Counts of All Tables in a Schema in PL/SQL?
How to Get Counts of All Tables in a Schema … Read more
To Find Current Running sqls
To Find Current Running sqls select sesion.sid,sesion.username,optimizer_mode,hash_value,address,cpu_time,elapsed_time,sql_textfrom v$sqlarea sqlarea, v$session … Read more
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
How To Move a Table To a Different TableSpace
How To Move a Table To a Different TableSpace? SYNTAXALTER … Read more
Find Total Undo Statistics
To Find Total Undo Statistics ALTER SESSION SET nls_date_format=’dd-mon-yy hh24:mi’; … Read more