Oracle para perranganos

Thursday, September 15, 2011

To view objects that are waiting for I/O resources

SELECT
object_name
,object_type
,owner
FROM v$session a
,dba_objects b
WHERE a.event LIKE 'db file%read'
AND b.data_object_id = a.row_wait_obj#
Posted by KOMO KAGALLON POR SEKIA at 4:16 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.