| RE:slow performance [message #62056] |
Tue, 22 June 2004 19:56  |
dhnish
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Hi
Query from dba_free_space_coalesced for a particular table is taking very long.I waited for 15 minutes but nothing appeared after which i cancelled. Is this normal?
Is there any other way i could get the info desired? Pls advice.Thank you and have a nice day
Yours in service
dhnish
|
|
|
|
| Re: RE:slow performance [message #62059 is a reply to message #62056] |
Wed, 23 June 2004 01:00  |
Ken Jones
Messages: 70
Registered: January 2004
|
Member |
|
|
Hi,
I have just run "select * from dba_free_space_coalesced;" on a 100Gb database with 6 tablespaces and the query result was instant.
Have you set up the data dictionary correctly? Try queries on other dba* tables.
Ken
|
|
|
|
| Re: RE:slow performance [message #62074 is a reply to message #62059] |
Wed, 23 June 2004 18:14 |
dhnish
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Hi
Have tried on other dba*table with no performance issue.Our consultant says it could be due to high fragmentation.Is that possible?
Pls advice
Thank you and have a nice day
Yours in service
dhnish
|
|
|
|
| Re: RE:slow performance [message #62087 is a reply to message #62074] |
Thu, 24 June 2004 04:39 |
Ken Jones
Messages: 70
Registered: January 2004
|
Member |
|
|
Hi,
SELECT dfsc.tablespace_name tablespace_name,
dfsc.percent_extents_coalesced
FROM dba_free_space_coalesced dfsc
Where dfsc.percent_extents_coalesced < 60
Order by 2
The above SQL statement will highlight fragmented tablespaces (i.e. tablespaces with coalescence of less than 60%). These tablespaces can then be coalesced.
Ken.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
