nabhesh-joshi-oracledba

Sunday, 2 July 2017

Get explain plans of a sql query from AWR using DBMS_XPLAN.DISPLAY_AWR

set lines 2000 pages 2000
SELECT * FROM table(DBMS_XPLAN.DISPLAY_AWR('7q4fs7yuu5fyk'));
Posted by Nabhesh Joshi at 4:37 am
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Performance

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • ASM (1)
  • Data Guard (4)
  • Golden Gate (1)
  • Installation (13)
  • OEM (4)
  • ORA-Errors (1)
  • Patching (1)
  • Performance (15)
  • RMAN (1)
  • Upgrade (3)

About Me

My photo
Nabhesh Joshi
View my complete profile

Blog Archive

  • ►  2023 (2)
    • ►  November (2)
  • ►  2022 (4)
    • ►  December (3)
    • ►  January (1)
  • ►  2021 (10)
    • ►  January (10)
  • ►  2020 (3)
    • ►  December (2)
    • ►  April (1)
  • ►  2018 (3)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
  • ▼  2017 (31)
    • ►  December (1)
    • ►  September (3)
    • ►  August (3)
    • ▼  July (2)
      • Get explain plans of a sql query from AWR using DB...
      • Run SQL tuning advisor for a sql_id
    • ►  June (4)
    • ►  April (2)
    • ►  March (2)
    • ►  February (7)
    • ►  January (7)
Simple theme. Theme images by andynwt. Powered by Blogger.