OraFAQ Forum: Performance Tuning » Do you know how to find out the underlying tables for a dynamic view?

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Do you know how to find out the underlying tables for a dynamic view? [message #355525]

Fri, 24 October 2008 11:58

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

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

efachim
Messages: 42
Registered: July 2008

Member

Thanks Michel.

Report message to a moderator

Previous Topic:	High CPU Utilizaion
Next Topic:	Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complete

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 04:47:14 CDT 2024