Home » RDBMS Server » Performance Tuning » DBA_FREE_SPACE view in 10g taking more time
DBA_FREE_SPACE view in 10g taking more time [message #184803] Fri, 28 July 2006 02:09 Go to next message
vvoracle
Messages: 3
Registered: July 2006
Junior Member
Hi,

My SQL queires that are using DBA_FREE_SPACE view is taking more time to execute on 10g environment. I am seeing this behaviour
with 10.2.0.2 version.

I just would like to know from the forum if anyone of you have come acrross the same problem.

Regards,
vasu
Re: DBA_FREE_SPACE view in 10g taking more time [message #184865 is a reply to message #184803] Fri, 28 July 2006 06:27 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A known issue ( well, it depends on how you use the sql).
Did you already try this?
http://www.jlcomp.demon.co.uk/faq/freespace3.html
Previous Topic: Getting queries
Next Topic: hints required
Goto Forum:
  


Current Time: Thu Mar 28 13:54:12 CDT 2024