| about all_ind_columns performance [message #56778] |
Wed, 23 April 2003 21:15  |
Peter
Messages: 62
Registered: August 2000
|
Member |
|
|
|
I have a delphi application running a sql statement to query oracle db (O734). It was running ok before but since last week it became very slow (from 10 sec down to 3 min). I use delphi's sql monitor and found it was stuck in a statement "select column_name from sys.all_ind_colimns where ...". Can someone help me to find what's going on? Thanks~
|
|
|
|
| Re: about all_ind_columns performance [message #56787 is a reply to message #56778] |
Thu, 24 April 2003 11:20  |
Andy Hofer
Messages: 6
Registered: December 2002
|
Junior Member |
|
|
Has anyone analyzed your database? If there are statistics on the SYS-owned objects, the database will perform poorly.
Check for statistics by looking for data in the 'last_analyzed' column of dba_tables (should be null for SYS-owned objects);
Statistics can be removed using:
analyze table
delete statistics;
HTH,
Andy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
