已有 157374 人访问
张林 ID.7639
博客(352)
张林的博客
Linux's %iowait statistic The iostat manpage documents %iowait as:Show the percentage of time that the CPU or CPUs were idle during which the system had an outstanding disk I/O request. It turns out t
413°/4134 人阅读/0 人点赞/0 条评论
Basic components of an Oracle server The following diagram illustrates some of the basic components of an Oracle server at the memory, database and disk layers. The numbers indicate the order of the f
483°/4830 人阅读/0 人点赞/0 条评论
CBO心得(选择率,基数,直方图)cbo心得(选择率,基数cardinality,直方图Histogram)(一)http://sunwgneuqsoft.itpub.net/post/34741/456500cbo心得(选择率,基数,直方图)(二)http://sunwgneuqsoft.itpub.net/post/34741/456501cbo心得(选择率,基数,直方图)(三)http://
484°/4840 人阅读/0 人点赞/0 条评论
ORACLE10g自动收集统计信息--自动analyze     从Oracle Database 10g开始，Oracle在建库后就默认创建了一个名为GATHER_STATS_JOB的定时任务，用于自动收集CBO的统计信息。这个自动任务默认情况下在工作日晚上10：00-6：00和周末全天开启。调用DBMS_STATS.GATHER_DATABASE_STATS_J
433°/4337 人阅读/0 人点赞/0 条评论
change database id of databaseSQL script to change database id of database. . oraenvsqlplus / as sysdbashutdown immediate (shutdown abort if need)startup mounthost nid target=/ (tesed, why it hold her
388°/3885 人阅读/0 人点赞/0 条评论
Purging SYSAUX tablespace (Purging AWR reports) Dump below is of a session clearing the sysaux tablespace. It turned out that something went wrong with the automatic AWR gathering/purging and the sys
681°/6812 人阅读/0 人点赞/0 条评论
SQL> exec DBMS_SWRF_INTERNAL.MOVE_TO_AWR(SCHNAME => 'AWR_STAGE');BEGIN DBMS_SWRF_INTERNAL.MOVE_TO_AWR(SCHNAME => 'AWR_STAGE'); END;*ERROR at line 1:ORA-20105: unable to move AWR data to SYSOR
835°/8356 人阅读/0 人点赞/0 条评论
How to move AWR data to another repository Connect to Source Instance as SYS @?/rdbms/admin/awrextr.sqlThe script will prompt for dbid Number of days worth of snapshots to display for selection (just
698°/6989 人阅读/0 人点赞/0 条评论
 做人 . 做事 . 做自己做事的永远做事， 不做事的永远不做事； 做事的主动找事做， 不做事的有事也不做； 做事的有做不完的事， 不做事的无事可做； 做事的做了大事也以为是小事， 不做事的做了小事也会吹成是了不起的大事； 做事的整天埋头做事， 不做事的整天满
373°/3721 人阅读/0 人点赞/1 条评论
Maven权威指南学习笔记（1-8章）(1)简单mavn工程创建及操作     1、创建简单的工程     mvn archetype:create -DgroupId=org.sonatype.mavenbook.ch03 -DartifactId=simple -DpackageName=org.sonatype.mavenbook&
549°/5498 人阅读/0 人点赞/0 条评论