Home » RDBMS Server » Server Administration » views (oracle 9i and 10G)
views [message #335728] Wed, 23 July 2008 07:44 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Sad


Dear all

I need to find out big indexes means

which view will get me table_owner,table_name,table_size_in_mb,index_name,index_size_in_mb



global indexes on partitioned tables that are not used for enforcing a constraint (primary key, unique).



MViews with the last refresh date ...........

kindly let me know which view will get me all this information i need ....

please help me to find out this
Re: views [message #335734 is a reply to message #335728] Wed, 23 July 2008 07:58 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
I found it difficult to follow the question, but you can start with
user_segments
Re: views [message #335736 is a reply to message #335728] Wed, 23 July 2008 08:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I need to find out big indexes means

Well, I think it depends on your point of view some will find 100MB big, for others it is 1GB, others 10GB and so on.

Quote:
which view will get me table_owner,table_name,table_size_in_mb,index_name,index_size_in_mb

None, you have to join several ones like dba_indexes and dba_segments.

Quote:
global indexes on partitioned tables that are not used for enforcing a constraint (primary key, unique).

Idem with other views.

Quote:
MViews with the last refresh date ...........

Idem with other view.

Quote:
kindly let me know which view will get me all this information i need ....

select * from dict;

Regards
Michel
Re: views [message #335916 is a reply to message #335736] Thu, 24 July 2008 02:55 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
hi
thank you for your useful info

and now i need to find all foreign keys in my DB and also i have to see which foreign key is indexed and which is not

which view wil able to see me

Regards
Re: views [message #335925 is a reply to message #335916] Thu, 24 July 2008 03:06 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No view for this, you have to create your query based upon other views.
...or just search on AskTom for "non indexed foreign key", you'll find an already created one.

Regards
Michel
Previous Topic: Table disappeared
Next Topic: DB 9i migration to 10g - Network configuration
Goto Forum:
  


Current Time: Fri Dec 09 23:32:14 CST 2016

Total time taken to generate the page: 0.06096 seconds