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: 64731
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: Sat Apr 29 18:32:35 CDT 2017

Total time taken to generate the page: 0.08257 seconds