Skip to content
  • ABOUT US
  • CONTACT US
  • TERMS AND CONDITIONS
ocptechnology
  • Home
  • ORACLE
    • RMAN
    • DATAGUARD
    • ASM
    • RAC
    • GOLDEN GATE
    • DATAPUMP
  • LINUX
  • ORA-ERROR
  • COURSES
  • ANDROID
ocptechnology
ocptechnology
  • Home
  • ORACLE
    • RMAN
    • DATAGUARD
    • ASM
    • RAC
    • GOLDEN GATE
    • DATAPUMP
  • LINUX
  • ORA-ERROR
  • COURSES
  • ANDROID

sql fulltext history

How To Find Execution History Of An sql_id

January 2, 2021 by Shripal

Hello friends, in this article I’m going to show you how to find execution history of an sql_id. The below script will display the execution history of a sql_id from AWR. It will join the dba_hist_sqlstat and dba_hist_sqlsnapshot table to get the required information. Read: ORA 25153 Temporary Tablespace is …

Read moreHow To Find Execution History Of An sql_id

Categories ORACLE, SCRIPTS 1 Comment

SUBSCRIBE

Like Us On Facebook

Facebook Pagelike Widget

Recent Posts

  • ORA-12919: Can not drop the default permanent tablespace
  • How To Export Tablespaces Using Expdp Data Pump Utility?
  • SQL Character Function
  • Single Row Functions
  • How to create a SEQUENCE step by step

Categories

  • 10G (3)
  • 11G (4)
  • 12c (3)
  • 18C (4)
  • 19c (9)
  • Android (2)
  • ASM (6)
  • DATAGUARD (6)
  • DataPump (8)
  • INTERVIEW (1)
  • Java (2)
  • Linux (5)
  • MySQL (2)
  • ORA -ERROR (6)
  • ORACLE (76)
  • PDF (1)
  • PL/SQL (1)
  • Putty (1)
  • RMAN (6)
  • SCRIPTS (3)
  • SQL (10)
  • TUNING (2)
  • WINDOWS (1)
  • ABOUT US
  • CONTACT US
  • TERMS AND CONDITIONS
©2021 www.ocptechnology.com