~Database Version : 10.2.0.4.0
~Database Up Since : 12:04:10 ÏÂÎç, 8ÔÂ 18 2010
~Buffer Cache Hit Ratio : 99.8207
~Library Cache Miss Ratio : 0.3843
~Dictionary Cache Miss Ratio : 0.1009
[Shared Pool Usage] Query Failed! ORA-01476: divisor is equal to zero
[Archive Log Info] Exec Time 0 seconds
~ Average Log Switches Per Day : 16.78
~ Hard Drive Storage (in Mb) for this many archive logs : 5035.34
! Error using UTL_FILE to examine alert log!
! Error using UTL_FILE
! Possible causes:
! 1) You don't have privileges to execute the UTL_FILE package.
! 2) UTL_FILE_DIR initialization parameter does not include one of these lines:
! utl_file_dir=/oracle/oracle/admin/chora/bdump
! utl_file_dir=*
! 3) alert.log file name is not among the following:
! (if this is the case please inform Quest support)
! alert_chora.log
! choraalrt.log
! 4) No directory has been created for /oracle/oracle/admin/chora/bdump,
! or directory exists but privileges have not been granted for it.
[Redo Log Group Sizes and Quantities] Exec Time 0 seconds
~ Number of Log Groups : 3
! Number of Members per Log Group: 1
~ All redo log members are 300M in size.
[Rollback Segments with wait ratios > 1 %] Exec Time 0 seconds
~ None
[Objects which can't extend because there is not
enough room in the tablespace] Exec Time 0 seconds
~ None
[Jobs] Exec Time 0 seconds
~ None
[redundant object privs with conflicting grant option] Exec Time 0 seconds
~ None
[Profiles that are not granted to any user] Exec Time 0 seconds
~ None
[Tablespace Fragmentation] Exec Time 0 seconds
~ A common set of extent sizes is a good way to reduce tablespace fragmentation.
~ Sometimes fragmentation can be improved with 'Alter tablespace <tblspace> coalesce'.
~ Tablespace fragmentation should not be a problem if you use locally managed tablespaces.
~
======================================================================
== TableSpace Name % # of # of ==
== Fragmented Extents Holes ==
======================================================================
! CH_PRODUCE 70 233 537
[Tablespaces with less than 10% free space] Exec Time 0 seconds
~ None
执行如下语句:
select tablespace_name,sqrt(max(blocks)/sum(blocks))*
(100/sqrt(sqrt(count(blocks)))) FSFI
from dba_free_space
group by tablespace_name