Home » RDBMS Server » Performance Tuning » How to join performance views ?
How to join performance views ? [message #65023] Tue, 30 March 2004 16:35 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi,

For example, I know we can join v$session with v$process. However, which columns can be used for this join.

Same goes for a variety of tables:

v$statname, v$sysstat, v$sgastat, v$event_name, v$system_event etc ....

Is there anywhere a document detailing how to joing these performance views??

 

Thanks ... IA.
Re: How to join performance views ? [message #65025 is a reply to message #65023] Wed, 31 March 2004 06:29 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
v$session.paddr=V$process.addr

You can get the definition of these views from the Reference manual and Performance tuning guide.

Also ,if you have any specific questions, you can always ask here..

-Thiru
Previous Topic: Buffer Cache Hit rate stays low
Next Topic: nested select statements
Goto Forum:
  


Current Time: Fri Mar 29 06:15:49 CDT 2024