| oracle load information [message #158958] |
Wed, 15 February 2006 04:13  |
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
|
Member |
|
|
How can i know what's going on in the database ? whenever user ask me this question i usually query two table to see locks & long runnig statements in v$locked_object & v$session_longops where time_remaining > 0. what other views i can query to know what else is going on in system ?
Thanks in advance
Chandan Singh
|
|
|
|
| Re: oracle load information [message #159146 is a reply to message #158958] |
Thu, 16 February 2006 06:46  |
Lehmann
Messages: 3
Registered: February 2006
|
Junior Member |
|
|
Use statspack to make snapshots during eg. a peek periode and watch the spreport output for high consuming SQL and spread of IO activity in datafiles. Futhermore wait events tell you what the system is wating for.
for 10g use AWR through the dbconsole og the grid console if you got it installed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
