数据库管理
-
编辑 删除
判断索引是否要重建【转】
Determine if an index is a good candidate for a rebuild. It is important to regularly examine all the indexes to determine if they have become skewed and might need to be rebuilt.When an index ...
-
编辑 删除
查看临时表空间的使用情况
Temporary Tablespaces Data that is only used for the duration of a session is stored in a temporary tablespaces. Such data is for example the result of a sort (order by) operation. More sp...
-
编辑 删除
查询所有表空间的占用率
经常用这个SQL，省得每次重写，建议DBA们也收集TOAD的一些管理时常用的SQL，最好能理解SELECT a.tablespace_name, round(a.bytes_alloc / 1024 / 1024, 2) megs_alloc, &...
