ORA FAQ Performance Adjustment Series - Queeries Against DBA_FREE_SPACE with LOCALLY Managed TableSpaces Are Slow - Is there? Local Management Table Space Environment Query DBA_FREE_SPACE Slow - Is there any way to accelerate? -------------------------------------------------- ------------------------------
Author's name: Hans-Peter SlootAuthor's Email: Hans-Peter.Sloot@atosorigin.comDate written: 9th August 2003Oracle version (s): 8i When Oracle introduced Locally managed tablespaces, they had to change their definition of the view dba_free_space to report free space IN LOCALLY MANAGED TABLESPACES. AS A Result, Some Systems Have Very Poor Response Times When Reporting Free Space. Is there. is the the. is the Local Management Table space, they have to modify the definition of view dba_free_space to report local management tables. Space free space. So some systems are poor when reporting free space. what can we do?
-------------------------------------------------- ------------------------------
Just because Oracle Corp. supplies a view definition, that does not mean you have to use it. You might create a new definition of dba_free_space that is much faster provides a view definition than the original one.Oracle company, does not mean You have to use it. You can create a new DBA_FREE_SPACE definition than the original fast.
On one database used for BAAN a query on dba_free_space lasted 50 minutes, whereas the following new definition returned the same results within 50 seconds.Of course, as versions of Oracle change, you may have to keep updating the definitions of your views to cater for NEW FEATURES. On a database of Baan, a query for DBA_FREE_SPACE lasts for 50 minutes, and the new definition below returns the same result within 50 seconds. With the Oracle version change, you may have to keep the definition of your view to utilize new features.
