How To Move a Table To a Different TableSpace
How To Move a Table To a Different TableSpace? SYNTAXALTER … Read more
tutorailwale
Find Total Undo Statistics
To Find Total Undo Statistics ALTER SESSION SET nls_date_format=’dd-mon-yy hh24:mi’; … 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
List All Datafile Of Undo Tablespace
List All Datafile Of Undo Tablespace SELECT tablespace_name,file_name,file_id,autoextensible,bytes / 1048576 … Read more
Undo Space Used By All Transactions
Undo Space Used By All Transactions set lines 200col sid … Read more
List Of Long Running Queries
List of long running queries set head OFFSELECT ‘LIST OF … Read more
Undo Tablespace Utilization By All Sessions
Undo Tablespace Utilization By All Sessions set lines 200col sid … Read more
SQL Query To Check Active Transactions
SQL Query To Check Active Transactions set head ONSELECT usn,extents,Round(rssize … 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