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
Messages: 91
Registered: March 2004

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
Messages: 1089
Registered: May 2002
Senior Member

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..

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

Current Time: Sun Sep 20 23:03:08 CDT 2020