Home » RDBMS Server » Performance Tuning » Do you know how to find out the underlying tables for a dynamic view? (Oracle 11g, 11.1.0, Windows 2K3)
Do you know how to find out the underlying tables for a dynamic view? [message #355525] Fri, 24 October 2008 11:58 Go to next message
efachim
Messages: 42
Registered: July 2008
Member
Hi Guys,

Does anyone know the best way to identify the underlying GV$(or other tables) that a dynamic performance view queries? eg the tables from which v$session_wait_history is populated?

rgds, E
Re: Do you know how to find out the underlying tables for a dynamic view? [message #355527 is a reply to message #355525] Fri, 24 October 2008 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
V$view query GV$view (almost all of them).
Definitions are in [G]V$FIXED_VIEW_DEFINITION views.

Regards
Michel
Re: Do you know how to find out the underlying tables for a dynamic view? [message #355538 is a reply to message #355525] Fri, 24 October 2008 16:50 Go to previous message
efachim
Messages: 42
Registered: July 2008
Member
Thanks Michel.
Previous Topic: High CPU Utilizaion
Next Topic: Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complete
Goto Forum:
  


Current Time: Tue Dec 06 04:10:35 CST 2016

Total time taken to generate the page: 0.06710 seconds