Oracle para perranganos

Thursday, September 22, 2011

o get historical information on what SQL statements are incurring the most disk reads

SELECT * FROM ( SELECT sql_id, sum(disk_reads_delta) disk_reads_delta,

sum(disk_reads_total) disk_reads_total, sum(executions_delta) execs_delta, sum(executions_total) execs_total

FROM dba_hist_sqlstat GROUP BY sql_id ORDER BY 2 desc)

WHERE rownum <= 5;

Posted by KOMO KAGALLON POR SEKIA at 8:34 AM

No comments:

Post a Comment

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

Libro que me hubiera gustado escribir

Libro que me hubiera gustado escribir

Certificaciones del que os escribe

Certificaciones del que os escribe
Powered By Blogger

About Me

My photo
KOMO KAGALLON POR SEKIA
View my complete profile

Blog Archive

  • ►  2016 (1)
    • ►  September (1)
  • ►  2015 (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2014 (6)
    • ►  July (1)
    • ►  June (5)
  • ►  2012 (6)
    • ►  February (3)
    • ►  January (3)
  • ▼  2011 (19)
    • ►  November (2)
    • ►  October (1)
    • ▼  September (11)
      • o get historical information on what SQL statement...
      • top five recent SQL statements that performed the ...
      • Identifying Who Is Using the Temporary Tablespace
      • mapping an operating system process back to a data...
      • To view objects that are waiting for I/O resources
      • To determine which sessions are currently waiting ...
      • Which SQL are using excesive i/O
      • Gathering Statistics
      • Beautifying SqlPlus
      • steps to convert a RAC database to single instance
      • Dedicated vs Shared Servers
    • ►  August (2)
    • ►  July (3)
  • ►  2009 (2)
    • ►  August (2)
  • ►  2008 (3)
    • ►  November (1)
    • ►  October (2)
Awesome Inc. theme. Powered by Blogger.