Installing sqlt

  Download sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip set db environment cd /home/oracle unzip sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip cd sqlt/install sqlplus / as sysdba sql> start ...

RECOVER TABLE USING RMAN

TO FIND THE CURRENT SCN ======================== select current_scn from v$database; TO FIND THE SCN FROM TIMESTAMP =============================== select ...

Script to check index column positons

set pages 1000 lines 1000 col column_name for a40 col index_name for a45 col column_expression for a40 set lines 120 pages 50000 select c.index_name, c.column_name “COLUMN_NAME”, ...

Script to find the session events

col sql format a35 col username format a20 col child format 999 col secs format 9999 col machine format a12 col event format a25 col state format a10 select /*+ rule */ distinct ...

Script to check temp used by session

set pagesize 10000 set linesize 133 column tablespace format a20 heading ‘Tablespace Name’ column segfile# format 9,999 heading ‘File|ID’ column spid format 9,999 heading ...

Start typing and press Enter to search