ORA FAQ 性能调整系列之——本地管理表空间环境下查询dba_free_space很慢——有什么办法加速么？

最新推荐文章于 2024-11-13 16:56:52 发布

原创

最新推荐文章于 2024-11-13 16:56:52 发布 · 2.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #file #database #report #数据库 #query

当使用Oracle的本地管理表空间时，查询dba_free_space可能会非常慢。文章提供了创建一个更快的新视图DBA_FREE_SPACE_NEW的方法，以替代Oracle的原始视图，从而在50秒内完成原本需要50分钟的查询。文章还讨论了随着Oracle版本升级，可能需要更新自定义视图以适应新特性。

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 doesn't mean you have to use it. You might crea