| Dictionary tables taking a lot of time [message #61034] |
Sun, 21 March 2004 23:58  |
Shikha
Messages: 36
Registered: January 2002
|
Member |
|
|
Hi,
Somehow while querying dictionary tables like:
select * from user_indexes
where table_name='ACCT_MASTER';
is taking a lot of time (nearly a minute) to show off results. What could be the reason? The database is 8i and the regular table queries are as such pretty fast.
TIA,
Shikha
|
|
|
|
|
|
| Re: Dictionary tables taking a lot of time [message #61045 is a reply to message #61034] |
Mon, 22 March 2004 05:37  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Also
- check to make sure the dictionary objects are NOT analyzed.
- make sure you have sized shared_pool appropriately
- make sure SYSTEM is not the default or TEMPORARY tablespace for non-sys user.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
