Home » RDBMS Server » Server Administration » list of dynamic views
list of dynamic views [message #50458] Sat, 16 March 2002 23:00 Go to next message
Baskaran
Messages: 2
Registered: March 2002
Junior Member
Dear's

i want to have a list of oracle dynamic and static permormance views. is it possible to get it?

tell me the link or give me the document if u have.

TIA

V.Baskaran

Report message to a moderator

Re: list of dynamic views [message #50462 is a reply to message #50458] Sun, 17 March 2002 15:41 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
In Oracle database, you can find a dictionary table in SYSTEM. From these two table, you will find tha table usage and column defination. if i don't mistaken the tables' name should like below

dba_dictionary or dba_dict_colms

Report message to a moderator

Re: list of dynamic views [message #50524 is a reply to message #50458] Tue, 19 March 2002 20:51 Go to previous message
Andrew Lenz
Messages: 16
Registered: August 1999
Junior Member
this SQL will list all the V$ views in the database.

select object_name
from dba_objects
where object_name like 'V$%';

Report message to a moderator

Previous Topic: Who is querying tables?
Next Topic: semmns: very urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 12:13:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.