~Time to Connect : 0 seconds.~Database Version : Oracle Database 10g Release 10.1.0.2.0
~Database Up Since : 11:29:05 上午, 12月 23 2007
!Buffer Cache Hit Ratio : -44.5251
~Library Cache Miss Ratio : 0.5426
~Dictionary Cache Miss Ratio : 0.2112[Shared Pool Usage] Exec Time 0 seconds
~ Total Mb Unused : 114.31
~ Total Mb Used : 141.69
~ Total Mb : 256
~ Shared Pool Percent Used : 55.35
[Archive Log Mode Info] Exec Time 0 seconds
! Archiver : STOPPED
! Log Mode : NOARCHIVELOG
! log_archive_start (init.ora param) = FALSE[Archive Log Info] Exec Time 0 seconds
~ Average Log Switches Per Day : 42.57
~ Hard Drive Storage (in Mb) for this many archive logs : 4257.02
! 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=/opt/ora10/admin/mbop/bdump
! utl_file_dir=*
! 3) alert.log file name is not among the following:
! (if this is the case please inform Quest support)
! alert_mbop.log
! mbopalrt.log
! 4) No directory has been created for /opt/ora10/admin/mbop/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 : 9
! Number of Members per Log Group: 1
~ All redo log members are 100M in size. [Rollback Segments with wait ratios > 1 %] Exec Time 0 seconds
~ None
[Objects with Mixed-Case Names] Exec Time 2 seconds
! Constraint CRM.BIN$R8C6fCYLsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYMsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYNsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYOsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYPsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYQsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYRsqTgQLoKEfxKCg==$0
! Synonym PUBLIC.NameFromLastDDL
! Table CRM.c3po
! Type DMSYS.BayesInput
! Type DMSYS.PairCounts
! Type DMSYS.TargetValueCount
[Tables with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None
[Table Partitions with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None
[Segments with < 10% of extents remaining and (maxextents > 1)] Exec Time 0 seconds
~ None
[Segments with > 100 extents] Exec Time 0 seconds
! TABLE CRM.T_1231SUBMITHISTORY: 215 Extents
! TABLE CRM.T_1230STATUSREPORT: 131 Extents
! TABLE CRM.T_1230SUBMITHISTORY: 220 Extents
! TABLE CRM.T_1231STATUSREPORT: 129 Extents
! TABLE CRM.T_1228SUBMITHISTORY: 220 Extents
! TABLE CRM.T_1229STATUSREPORT: 133 Extents
! TABLE CRM.T_1229SUBMITHISTORY: 225 Extents
! TABLE CRM.T_1229USERSMREQUEST: 102 Extents
! TABLE CRM.T_1228STATUSREPORT: 128 Extents
! TABLE CRM.T_SENDWEBHISTORY: 207 Extents
! TABLE CRM.T_0305SUBMITHISTORY: 137 Extents
! TABLE CRM.T_0306STATUSREPORT: 105 Extents
! TABLE CRM.T_0306SUBMITHISTORY: 170 Extents
! TABLE CRM.T_0307STATUSREPORT: 111 Extents
! TABLE CRM.T_0307SUBMITHISTORY: 203 Extents
! TABLE CRM.T_0221STATUSREPORT: 112 Extents
! TABLE CRM.T_0221SUBMITHISTORY: 200 Extents
! TABLE CRM.T_0222SUBMITHISTORY: 145 Extents
! TABLE CRM.T_0225SUBMITHISTORY: 114 Extents
! TABLE CRM.T_0226SUBMITHISTORY: 116 Extents
! TABLE CRM.T_0227STATUSREPORT: 102 Extents
! TABLE CRM.T_0227SUBMITHISTORY: 167 Extents
! TABLE CRM.T_0228STATUSREPORT: 106 Extents
[Objects which can't extend because there is not
enough room in the tablespace] Exec Time 2 seconds
~ None
[Jobs] Exec Time 0 seconds
~ With Broken = 'Y'
~ With Next_date < sysdate
~ Running for 60 minutes============================================================================================================
== Job # Last Date Running Job Broken Schema =
== Began at User =
== What =
============================================================================================================
! 66 2008-3-3 9:22:40 Not Currently Executing Y CRM
! BEGIN
CRM.Job_Clearoptionlogrec;
END;
-----------------------------------------------------------------------------------------------------------
[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
~ None
[Tablespaces with less than 10% free space] Exec Time 0 seconds
~ None
~Database Up Since : 11:29:05 上午, 12月 23 2007
!Buffer Cache Hit Ratio : -44.5251
~Library Cache Miss Ratio : 0.5426
~Dictionary Cache Miss Ratio : 0.2112[Shared Pool Usage] Exec Time 0 seconds
~ Total Mb Unused : 114.31
~ Total Mb Used : 141.69
~ Total Mb : 256
~ Shared Pool Percent Used : 55.35
[Archive Log Mode Info] Exec Time 0 seconds
! Archiver : STOPPED
! Log Mode : NOARCHIVELOG
! log_archive_start (init.ora param) = FALSE[Archive Log Info] Exec Time 0 seconds
~ Average Log Switches Per Day : 42.57
~ Hard Drive Storage (in Mb) for this many archive logs : 4257.02
! 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=/opt/ora10/admin/mbop/bdump
! utl_file_dir=*
! 3) alert.log file name is not among the following:
! (if this is the case please inform Quest support)
! alert_mbop.log
! mbopalrt.log
! 4) No directory has been created for /opt/ora10/admin/mbop/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 : 9
! Number of Members per Log Group: 1
~ All redo log members are 100M in size. [Rollback Segments with wait ratios > 1 %] Exec Time 0 seconds
~ None
[Objects with Mixed-Case Names] Exec Time 2 seconds
! Constraint CRM.BIN$R8C6fCYLsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYMsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYNsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYOsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYPsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYQsqTgQLoKEfxKCg==$0
! Constraint CRM.BIN$R8C6fCYRsqTgQLoKEfxKCg==$0
! Synonym PUBLIC.NameFromLastDDL
! Table CRM.c3po
! Type DMSYS.BayesInput
! Type DMSYS.PairCounts
! Type DMSYS.TargetValueCount
[Tables with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None
[Table Partitions with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None
[Segments with < 10% of extents remaining and (maxextents > 1)] Exec Time 0 seconds
~ None
[Segments with > 100 extents] Exec Time 0 seconds
! TABLE CRM.T_1231SUBMITHISTORY: 215 Extents
! TABLE CRM.T_1230STATUSREPORT: 131 Extents
! TABLE CRM.T_1230SUBMITHISTORY: 220 Extents
! TABLE CRM.T_1231STATUSREPORT: 129 Extents
! TABLE CRM.T_1228SUBMITHISTORY: 220 Extents
! TABLE CRM.T_1229STATUSREPORT: 133 Extents
! TABLE CRM.T_1229SUBMITHISTORY: 225 Extents
! TABLE CRM.T_1229USERSMREQUEST: 102 Extents
! TABLE CRM.T_1228STATUSREPORT: 128 Extents
! TABLE CRM.T_SENDWEBHISTORY: 207 Extents
! TABLE CRM.T_0305SUBMITHISTORY: 137 Extents
! TABLE CRM.T_0306STATUSREPORT: 105 Extents
! TABLE CRM.T_0306SUBMITHISTORY: 170 Extents
! TABLE CRM.T_0307STATUSREPORT: 111 Extents
! TABLE CRM.T_0307SUBMITHISTORY: 203 Extents
! TABLE CRM.T_0221STATUSREPORT: 112 Extents
! TABLE CRM.T_0221SUBMITHISTORY: 200 Extents
! TABLE CRM.T_0222SUBMITHISTORY: 145 Extents
! TABLE CRM.T_0225SUBMITHISTORY: 114 Extents
! TABLE CRM.T_0226SUBMITHISTORY: 116 Extents
! TABLE CRM.T_0227STATUSREPORT: 102 Extents
! TABLE CRM.T_0227SUBMITHISTORY: 167 Extents
! TABLE CRM.T_0228STATUSREPORT: 106 Extents
[Objects which can't extend because there is not
enough room in the tablespace] Exec Time 2 seconds
~ None
[Jobs] Exec Time 0 seconds
~ With Broken = 'Y'
~ With Next_date < sysdate
~ Running for 60 minutes============================================================================================================
== Job # Last Date Running Job Broken Schema =
== Began at User =
== What =
============================================================================================================
! 66 2008-3-3 9:22:40 Not Currently Executing Y CRM
! BEGIN
CRM.Job_Clearoptionlogrec;
END;
-----------------------------------------------------------------------------------------------------------
[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
~ None
[Tablespaces with less than 10% free space] Exec Time 0 seconds
~ None
Number of Members per Log Group: 1 :必须为2,否则日志文件损坏很头疼的
数据库规模很小,看不出什么大问题
日志切换太频繁,保持在3-10次为最佳(最高峰期切换频率>5分钟,一般为30分钟切换一次)
没有做归档备份光有这些信息为调整的依据是源源不够的