共 9 篇文章 |
|
Listing 1-2: Initial view of temp extentsselect inst_id, file_id, extents_cached, extents_used from gv$temp_extent_pool order by 1,2;INST_ID FILE_ID EXTENTS_CACHED EXTENTS_USED---------- ---------- -------------- ------------ 1 1 0 0 1 2 0 0 2 1 22 22 2 2 23 23.../ INST_ID FILE_ID EXTENTS_CACHED EXTENTS_USED----------... 阅99 转1 评0 公众公开 13-01-12 17:46 |
gc buffer busy waits ?gc buffer busy waits.So, ASSM avoids just one type of gc buffer busy wait, which is freelists/freelist group based waits.sql wildcard,sql wildcards,sql rollback,rollback sql,sql copy table,sql sum,sql mirroring,sum sql,sql cluster,sql server performance,truncate in sql,backup sql,backup sql datab... 阅242 转2 评0 公众公开 13-01-12 17:45 |
RAC object remastering ( Dynamic remastering ...RAC object remastering ( Dynamic remastering )Enter Object remastering.FILE_ID OBJECT_ID CURRENT_MASTER PREVIOUS_MASTER REMASTER_CNT---------- ---------- -------------- --------------- ------------ 0 6099472 0 32767 1REM Opens are still increasing but remastering has alr... 阅172 转0 评0 公众公开 13-01-12 17:41 |
Column key for the above script is: CR block RX : GC CR blocks received CR time : Average GC CR receive time CUR blocks RX: GC CUR blocks received CUR time: Average GC CuR receive time CR blocks TX: GC CR blocks transmitted CUR blocks TX: GC CUR blocks transmitted tot blocks: Sum of transmitted + received for both CR ... 阅116 转0 评0 公众公开 13-01-12 17:40 |
SCN – What, why, and how? ?Oracle database i...SCN – What, why, and how?Database link and SCNSDatabase link based transactions can cause SCN increases too.In RAC, instance that receive the update from external system will increase the SCN of the database SCN to the new higher SCN. When other instances query for next... 阅72 转1 评0 公众公开 13-01-12 17:24 |
What’s in a voting disk? ?Oracle database in...What’s in a voting disk?I can’t discuss all possible scenarios in a blog entry, so we will discuss a simplistic 2-node single voting disk alone here.Voting disks are used to monitor the disk heart beats. It is preferable to have at least 3 voting disks or odd number of... 阅65 转0 评0 公众公开 13-01-12 17:23 |
What is ‘rdbms ipc message’ wait event? ?Ora...What is ‘rdbms ipc message’ wait event?In a nutshell, LGWR is sleeping on ‘rdbms ipc message’ for full 3 seconds if there is no work to be done. Another process can wakeup LGWR process and trigger a log write as indicated in line #4 and line #5. I will disable SQL t... 阅1446 转5 评0 公众公开 13-01-12 17:19 |
awr_redo_nologging_size.sql v1.00 by Riyaj Shamsudeen @orainternals.comTo generate Report about Redo rate from AWR tablesEnter the block size(Null=8192):Enter past number of days to search for (Null=30):21DB_NAME REDO_DATE redo_size (MB) phy_writes_dir (MB) phy_writes_dir_temp(MB)--------- ------------------- --------... 阅136 转0 评0 公众公开 13-01-12 17:18 |
Foreground process accounts this wait time for the undo segment block grants to the ‘gc cr disk read’ wait event.nam=''db file sequential read'' ela= 542 file#=7 block#=2758 blocks=1 obj#=75154 tim=1103291149nam=''gc cr disk read'' ela= 633 p1=6 p2=176 p3=43 obj#=0 tim=1103292048nam=&... 阅659 转4 评0 公众公开 13-01-12 17:15 |