04 2023 档案
摘要:select action,ACTION_TIME,STATUS,TARGET_VERSION,PATCH_ID,DESCRIPTION from dba_registry_sqlpatch;
阅读全文
摘要:Troubleshooting Waits for 'SQL*Net message to client' and 'SQL*Net more data to client' Events from a Performance Perspective (Doc ID 1404526.1) 什么是“S
阅读全文
摘要:Parameter enabled_pdbs_on_standby and STANDBYS Option With Data Guard Subset Standby (Doc ID 2417018.1) create pluggable databases ... STANDBYS option
阅读全文
摘要:Troubleshooting: 'Log file sync' Waits (Doc ID 1376916.1)
阅读全文
摘要:1.定位具体xid和sql,可以看到回滚段大小,具体的sqlid SQL> @trans SID SERIAL# USERNAME USED_UBLK USED_UREC STATUS START_DATE XID 497 6069 SYS 1 1 ACTIVE 20-APR-23 05001100
阅读全文
摘要:下载 https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=272133523880062&id=1513912.1&_afrWindowMode=0&_adf.ctrl-state=fghvcgapa_617a 安装 [ro
阅读全文
摘要:SELECT max(a.value) as highest_open_cur, p.value as max_open_cur FROM v$sesstat a, v$statname b, v$parameter p WHERE a.statistic# = b.statistic# and b
阅读全文
摘要:select b.tablespace_name,a.file#,b.file_name,a.block#,a.blocks,a.CORRUPTION_CHANGE#,a.CORRUPTION_TYPE,con_id from v$database_block_corruption a,dba_da
阅读全文
摘要:我在session 876中執行完下面sql后 select * from table 在到另一session中執行 SELECT /*+ ORDERED */ sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN ( SELECT
阅读全文
摘要:通过DBMS_MONITOR.session_trace_enable开启会话跟踪 - 文章详情 (itpub.net) EXEC DBMS_MONITOR.session_trace_enable(session_id =>5350, serial_num=>1620, waits=>TRUE,
阅读全文
摘要:(18条消息) Oracle 高 Version counts 问题说明_Dave的博客-CSDN博客 主要查看视图 v$sqlarea v$sql_shared_cursor
阅读全文
摘要:How to Check enq: FB - contention Format Block Enqueue for Insert statements (Doc ID 2277855.1) Enq: FB – contention we can assume that two sessions h
阅读全文
摘要:19c临时表空间使用率(实际正在使用的) select total_extents,free_extents,used_extents,added_extents from v$sort_segment;select case when exists(select * from v$tempseg_
阅读全文