To Find Toad Sessions
How to find Toad Sessions in Oracle database SELECT p.spid,s.sid,s.process … Read more
Apps DBA
Inactive Session Details More Than 1 Hour
Inactive Session Details More Than 1 Hour set pagesize 50col … 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 Move a Table To a Different TableSpace
How To Move a Table To a Different TableSpace? SYNTAXALTER … Read more
List All Undo Datafiles With Status And Size
List All Undo Datafiles With Status And Size show parameter … Read more
To Check When a Table is Last Analysed
To Check When a Table is Last Analysed SELECT owner,table_name,tablespace_name,status,last_analyzed,partitioned,dependencies,droppedFROM … Read more
SQL Query To Check Active Transactions
SQL Query To Check Active Transactions set head ONSELECT usn,extents,Round(rssize … Read more
To Check Space Related Statistics Of Undo Tablespace
To Check Space Related Statistics Of Undo Tablespace selectsum(ssolderrcnt) ‘Total … Read more
To Check Space Related Statistics Of Undo Tablespace
To Check Space Related Statistics Of Undo Tablespace SELECT undoblks,begin_time,maxquerylen,unxpstealcnt,expstealcnt,nospaceerrcntFROM … Read more