ORA FAQ 性能调整系列之——
Queries against dba_free_space with locally managed tablespaces are slow - is there any way to speed them up ?
本地管理表空间环境下查询dba_free_space很慢——有什么办法加速么?
--------------------------------------------------------------------------------
Author's name: Hans-Peter Sloot
Author's Email:Hans-Peter.Sloot@atosorigin.com
Date written: 9th August 2003
Oracle 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 anything you can do.
当Oracle引入本地管理表空间,他们不得不修改了视图dba_free_space的定义来报告本地管理表空间的空闲空间。于是一些系统在报告空闲空间时响应时间很差。我们能做什么?
--------------------------------------------------------------------------------
Just because Oracle Corp. supplies a view definition, that d