已有 156654 人访问
张林 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
369°/3699 人阅读/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
420°/4206 人阅读/0 人点赞/0 条评论
CBO心得(选择率,基数,直方图)cbo心得(选择率,基数cardinality,直方图Histogram)(一)http://sunwgneuqsoft.itpub.net/post/34741/456500cbo心得(选择率,基数,直方图)(二)http://sunwgneuqsoft.itpub.net/post/34741/456501cbo心得(选择率,基数,直方图)(三)http://
445°/4451 人阅读/0 人点赞/0 条评论
ORACLE10g自动收集统计信息--自动analyze     从Oracle Database 10g开始，Oracle在建库后就默认创建了一个名为GATHER_STATS_JOB的定时任务，用于自动收集CBO的统计信息。这个自动任务默认情况下在工作日晚上10：00-6：00和周末全天开启。调用DBMS_STATS.GATHER_DATABASE_STATS_J
392°/3920 人阅读/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
349°/3494 人阅读/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
637°/6375 人阅读/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
785°/7854 人阅读/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
614°/6144 人阅读/0 人点赞/0 条评论
 做人 . 做事 . 做自己做事的永远做事， 不做事的永远不做事； 做事的主动找事做， 不做事的有事也不做； 做事的有做不完的事， 不做事的无事可做； 做事的做了大事也以为是小事， 不做事的做了小事也会吹成是了不起的大事； 做事的整天埋头做事， 不做事的整天满
333°/3325 人阅读/0 人点赞/1 条评论
Maven权威指南学习笔记（1-8章）(1)简单mavn工程创建及操作     1、创建简单的工程     mvn archetype:create -DgroupId=org.sonatype.mavenbook.ch03 -DartifactId=simple -DpackageName=org.sonatype.mavenbook&
517°/5172 人阅读/0 人点赞/0 条评论