Category Archives: Uncategorized

Storage syncronization to mirror took too long at 11′th Apr. Omon “physical reads” graphs indicated a clear peek of physical reads. 24 hours graph:   A few weeks graph:     A few weeks graph aggregated into 200 bars: AWR … Continue reading →

Skip using IGNORE_ROW_ON_DUPKEY_INDEX Hint in 11.2. Wait until 12c. Your data can be corrupted by letting in duplicate rows. Patch which might help is 11865420. However if PSU’s are installed on top of 11.2 then patch merge request must be … Continue reading →

Omon is a tool to output in graphical form AWR/PERFSTAT data. All it needs is a running Oracle HTTP server in any form (as long as it supports mod_plsql) and 10g database to hold OMON PL/SQL stored procedures and few … Continue reading →

To reproduce the problem, flashback query was used. Normal case: select /*+full(a)*/ count(1) from iftp_dw.ar as of timestamp to_date(’2012.10.05 01:00′, ‘yyyy.mm.dd hh24:mi:ss’) a; COUNT(1) ———- 2014667 Elapsed: 00:00:10.54 Execution Plan ———————————————————- Plan hash value: 1818353562 ——————————————————————- | Id | Operation … Continue reading →

The problem: select from table (full scan) runs for hours on 400MB table generating lot of (physical) IO on UNDO. The table has 250MB of indexes (counting 3.) Every time the excessive UNDO IO is generated the process A “select … Continue reading →

New AWR views: VIEW_NAME DBA_HIST_ASH_SNAPSHOT DBA_HIST_BASELINE_DETAILS DBA_HIST_BASELINE_METADATA DBA_HIST_BASELINE_TEMPLATE DBA_HIST_CLUSTER_INTERCON DBA_HIST_COLORED_SQL DBA_HIST_DISPATCHER DBA_HIST_DYN_REMASTER_STATS DBA_HIST_EVENT_HISTOGRAM DBA_HIST_IC_CLIENT_STATS DBA_HIST_IC_DEVICE_STATS DBA_HIST_INTERCONNECT_PINGS DBA_HIST_IOSTAT_DETAIL DBA_HIST_IOSTAT_FILETYPE DBA_HIST_IOSTAT_FILETYPE_NAME DBA_HIST_IOSTAT_FUNCTION DBA_HIST_IOSTAT_FUNCTION_NAME DBA_HIST_MEMORY_RESIZE_OPS DBA_HIST_MEMORY_TARGET_ADVICE DBA_HIST_MEM_DYNAMIC_COMP DBA_HIST_MUTEX_SLEEP DBA_HIST_MVPARAMETER DBA_HIST_PERSISTENT_QMN_CACHE DBA_HIST_PERSISTENT_QUEUES DBA_HIST_PERSISTENT_SUBS DBA_HIST_PLAN_OPERATION_NAME DBA_HIST_PLAN_OPTION_NAME DBA_HIST_RSRC_CONSUMER_GROUP DBA_HIST_RSRC_PLAN DBA_HIST_SHARED_SERVER_SUMMARY DBA_HIST_SQLCOMMAND_NAME DBA_HIST_TABLESPACE DBA_HIST_TOPLEVELCALL_NAME New AWR view … Continue reading →

New V$ views: VIEW_NAME V_$ADVISOR_CURRENT_SQLPLAN V_$ASH_INFO V_$ASM_ACFSSNAPSHOTS V_$ASM_ACFSVOLUMES V_$ASM_ACFS_ENCRYPTION_INFO V_$ASM_ACFS_SECURITY_INFO V_$ASM_ATTRIBUTE V_$ASM_DISK_IOSTAT V_$ASM_FILESYSTEM V_$ASM_USER V_$ASM_USERGROUP V_$ASM_USERGROUP_MEMBER V_$ASM_VOLUME V_$ASM_VOLUME_STAT V_$CALLTAG V_$CELL V_$CELL_CONFIG V_$CELL_REQUEST_TOTALS V_$CELL_STATE V_$CELL_THREAD_HISTORY V_$CORRUPT_XID_LIST V_$CPOOL_CC_INFO V_$CPOOL_CC_STATS V_$CPOOL_CONN_INFO V_$CPOOL_STATS V_$DATABASE_KEY_INFO V_$DETACHED_SESSION V_$DIAG_ADR_CONTROL V_$DIAG_ADR_INVALIDATION V_$DIAG_ALERT_EXT V_$DIAG_AMS_XACTION V_$DIAG_CRITICAL_ERROR V_$DIAG_DDE_USER_ACTION V_$DIAG_DDE_USER_ACTION_DEF V_$DIAG_DDE_USR_ACT_PARAM V_$DIAG_DDE_USR_ACT_PARAM_DEF … Continue reading →

Bug 10318123 – lgwr regularly stalls for 3 seconds at a time [ID 10318123.8] Oracle proposed resolution: “An upgrade in veritas library from 5.0 to 5.1 (which includes ODM), resolved the LGWR issue.”

A good metalink note is here: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=1320966.1

Found it finally: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=790205.1 UNABLE TO START INSTANCE WITH LARGE SGA ORA-27102 SVR4 ERROR: 22: INVALID ARGUMENT [ID 790205.1]\ https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=1644977629090275&id=460424.1&_afrWindowMode=0&_adf.ctrl-state=cw8egzrhl_391 Solaris 10 memory management conflicts with Automatic PGA Memory Management [ID 460424.1] Citation (this is what I do): “…Sleep 5 … Continue reading →