| views [message #335728] |
Wed, 23 July 2008 07:44  |
saagar
Messages: 79
Registered: December 2007
|
Member |
|
|
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 #335736 is a reply to message #335728] |
Wed, 23 July 2008 08:00  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 |
|
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
