Oracle DBA SQL Queries & Scripts
A comprehensive collection of Oracle DBA SQL queries and scripts … Read more
Apps DBA
Inactive Programs With Disk Reads
Inactive Programs With Disk Reads prompt inactive sessionsSELECT DISTINCT ( … Read more
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
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
Undo Space Used By All Transactions
Undo Space Used By All Transactions set lines 200col sid … Read more