问题描述
亲爱的专家，
我在电信领域工作，我们有AIA和SOA应用程序，我们正在为增加tps进行调整。即使同一会话正在访问数据库，我们也在下面观察到。我要求您为此提供建议或解决方案。
我在电信领域工作，我们有AIA和SOA应用程序，我们正在为增加tps进行调整。即使同一会话正在访问数据库，我们也在下面观察到。我要求您为此提供建议或解决方案。
SID USERNAME PROGRAM OSUSER EVENT STATE SQL SQL_ID SEC_ACTIVE
---------- ------------ ------------ ------------ ------------------------- -------------- ------------------------------ ------------- ----------
279 SCHEMA_NAME JDBC Thin C xxxxxxx SQL*Net message to client WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 0
3263 SCHEMA_NAME JDBC Thin C xxxxxxx SQL*Net message to client WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 0
2770 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 0
4787 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 0
2282 SYS sqlplus@PRE oracle SQL*Net message to client WAITED SHORT select distinct w.sid,s.userna 1pu0npbh8j535 0
4288 SCHEMA_NAME JDBC Thin C xxxxxxx SQL*Net message to client WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1008 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 1
1535 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 1
3016 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 1
3286 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 1
3521 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 1
4275 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 1
4 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
36 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1010 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1037 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1275 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1507 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1769 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
1790 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
2029 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
2290 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
2531 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
2777 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3009 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3031 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3262 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3523 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3539 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3759 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
3792 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
4013 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
4756 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
4786 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 1
522 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
1540 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
2004 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
2264 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
2511 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
2534 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
2767 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
2785 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
3023 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
3037 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
3268 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
3530 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
3770 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
4537 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 1
756 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 2
791 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 2
1273 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 2
3015 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 2
4521 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 2
4778 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 2
267 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
760 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
1265 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
2036 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
2507 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
2753 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
2756 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
3502 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
3525 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
4014 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 2
1775 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 2
2271 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 2
2285 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 2
2518 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 2
2538 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 2
3038 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 2
271 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 4
3279 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED KNOWN select VALUE from XREF_DATA w bk2mk4dh179y7 4
3019 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITED SHORT select VALUE from XREF_DATA w bk2mk4dh179y7 4
3289 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 4
4281 SCHEMA_NAME JDBC Thin C xxxxxxx latch: cache buffers chai WAITING select VALUE from XREF_DATA w bk2mk4dh179y7 4
75 rows selected.
01:35:49 SQL> select
count(*),
sql_id,
nvl(o.object_name,ash.current_obj#) objn,
substr(o.object_type,0,10) otype,
CURRENT_FILE# fn,
CURRENT_BLOCK# blockn
01:35:49 2 from v$active_session_history ash
01:35:49 3 , all_objects o
01:35:49 4 01:35:49 5 where event like 'latch: cache buffers chains'
01:35:49 6 01:35:49 7 01:35:49 8 and o.object_id (+)= ash.CURRENT_OBJ#
01:35:49 9 01:35:49 10 01:35:49 11 01:35:49 12 group by sql_id, current_obj#, current_file#,
current_block#, o.object_name,o.object_type
01:35:49 13 01:35:49 14 order by count(*)
/ 01:35:49 15
COUNT(*) SQL_ID OBJN OTYPE FN BLOCKN
---------- ------------- ---------------------------------------- ---------------------------------------- ---------- ----------
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218782
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 2131102
1 bk2mk4dh179y7 SYS_C0036790 INDEX 4 567326
1 b2rmqka1g2b24 XREF_VALUE INDEX 4 1793582
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218976
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2219081
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 2152098
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218339
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 1792285
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 1882844
1 bk2mk4dh179y7 XREF_DATA TABLE 4 2226047
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218504
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 58174
1 bk2mk4dh179y7 XREF_DATA TABLE 4 2227904
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 282955
1 bk2mk4dh179y7 XREF_DATA TABLE 4 2227942
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218987
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218564
1 bk2mk4dh179y7 XREF_DATA TABLE 4 2228194
1 bk2mk4dh179y7 XREF_DATA TABLE 4 2225593
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218827
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 267427
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 348478
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 1897072
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218538
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218409
1 bk2mk4dh179y7 SYS_C0036790 INDEX 4 655379
1 bk2mk4dh179y7 SYS_C0036790 INDEX 4 272285
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 2131168
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 347768
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218541
1 bk2mk4dh179y7 SYS_C0036790 INDEX 4 313616
1 8qku71rhyp5u3 MEDIATOR_INSTANCE TABLE PART 89 863180
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 1977727
1 bk2mk4dh179y7 XREF_VALUE INDEX 4 159889
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218170
1 b2rmqka1g2b24 XREF_VALUE INDEX 4 1621897
1 b2rmqka1g2b24 XREF_VALUE INDEX 4 165478
1 b2rmqka1g2b24 XREF_VALUE INDEX 4 1773458
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2219091
1 bk2mk4dh179y7 XREF_ROW_NUMBER INDEX 4 2218806
EVENT# EVENT_ID NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS
---------- ---------- --------------------------------- ----------------- ----------------- ----------------- ------------- ----------- -----------------
86 2779959231 latch: cache buffers chains address number tries 3875070507 4 Concurrency
SQL_ID : bk2mk4dh179y7
SHARABLE_MEM : 38022
PERSISTENT_MEM : 60216
RUNTIME_MEM : 59104
SORTS : 0
LOADED_VERSIONS : 1
OPEN_VERSIONS : 1
USERS_OPENING : 39
FETCHES : 166519
EXECUTIONS : 166534
PX_SERVERS_EXECUTIONS : 0
END_OF_FETCH_COUNT : 166517
USERS_EXECUTING : 1
LOADS : 1
FIRST_LOAD_TIME : 2017-03-14/18:51:46
INVALIDATIONS : 0
PARSE_CALLS : 278
DISK_READS : 1041
DIRECT_WRITES : 0
BUFFER_GETS : 1633139203
APPLICATION_WAIT_TIME : 0
CONCURRENCY_WAIT_TIME : 1367866445
CLUSTER_WAIT_TIME : 0
USER_IO_WAIT_TIME : 3605616
PLSQL_EXEC_TIME : 0
JAVA_EXEC_TIME : 0
ROWS_PROCESSED : 108263
COMMAND_TYPE : 3
OPTIMIZER_MODE : ALL_ROWS
OPTIMIZER_COST : 10
OPTIMIZER_ENV : E289FB89E226A8003D011000AEF9C3E2CFFA331056414555
519521105555551545545558591555449665851D5511058555555155515122555415A0EA0C555145
4265455454449081566E001696C6A35545150102541550441669899BA00214500800000800000040
0000000400008000000820401F00000000F6000033310004040000E0E0031000008099180000007B
00889BA002949191090890C908C8000008000C0828281414285000080000D0070000402928282890
A10F00009001030E0800080000FCFF0300A050C80001
OPTIMIZER_ENV_HASH_VALUE : 3952539766
PARSING_USER_ID : 171
PARSING_SCHEMA_ID : 171
PARSING_SCHEMA_NAME : PRODAIA_XREF
KEPT_VERSIONS : 0
ADDRESS : C0000004789A4B88
TYPE_CHK_HEAP : 00
HASH_VALUE : 1611900871
OLD_HASH_VALUE : 1804870301
PLAN_HASH_VALUE : 1427186440
CHILD_NUMBER : 2
SERVICE : aiaprepn.mti.abscbn.com
SERVICE_HASH : 0
MODULE : JDBC Thin Client
MODULE_HASH : -1748072636
ACTION :
ACTION_HASH : 0
SERIALIZABLE_ABORTS : 0
OUTLINE_CATEGORY :
CPU_TIME : 11348680000
ELAPSED_TIME : 15818792444
OUTLINE_SID :
CHILD_ADDRESS : C0000002D1DFB520
SQLTYPE : 6
REMOTE : N
OBJECT_STATUS : VALID
LITERAL_HASH_VALUE : 0
LAST_LOAD_TIME : 2017-04-04/02:30:24
IS_OBSOLETE : N
IS_BIND_SENSITIVE : Y
IS_BIND_AWARE : N
IS_SHAREABLE : Y
CHILD_LATCH : 0
SQL_PROFILE :
SQL_PATCH :
SQL_PLAN_BASELINE :
PROGRAM_ID : 0
PROGRAM_LINE# : 0
EXACT_MATCHING_SIGNATURE : 1705577883262083921
FORCE_MATCHING_SIGNATURE : 1705577883262083921
LAST_ACTIVE_TIME : 04-apr-2017 21:19:13
BIND_DATA : BEDA0B20020058E399EC00051FF0012003690642524D5F30
31F40107D003693A6F72616D64733A2F617070732F4149414D657461446174612F787265662F4355
53544F4D455250415254595F4143434F554E5449442E78726566F00120036906434F4D4D4F4EF401
07D003693A6F72616D64733A2F617070732F4149414D657461446174612F787265662F435553544F
4D455250415254595F4143434F554E5449442E78726566F40107D003692032643331333933313335
33333334333633303335333733323334333233313337
TYPECHECK_MEM : 0
IO_CELL_OFFLOAD_ELIGIBLE_BYTES: 0
IO_INTERCONNECT_BYTES : 8527872
PHYSICAL_READ_REQUESTS : 1041
PHYSICAL_READ_BYTES : 8527872
PHYSICAL_WRITE_REQUESTS : 0
PHYSICAL_WRITE_BYTES : 0
OPTIMIZED_PHY_READ_REQUESTS : 0
LOCKED_TOTAL : 338
PINNED_TOTAL : 166539
IO_CELL_UNCOMPRESSED_BYTES : 0
IO_CELL_OFFLOAD_RETURNED_BYTES: 0
-----------------
PL/SQL procedure successfully completed.
复制 专家解答
好的-你砍掉了sql文本:-(所以这不是那么有用，但是无论如何，看看这个:
16亿该1个sql语句的逻辑I/O，并且几乎没有磁盘活动。因此，它很可能一遍又一遍地访问一小部分数据 (因此很可能集中在几个块中)。
因此，你对这几个街区有争执。
从您提供的其他数据来看，您的行动过程看起来像是:
a) 调整SQL以读取更少的块，和/或
b) 查看更改XREF_DATA，XREF_ROW_NUMBER的存储参数，以将块分散到更宽的集合上，以缓解争用
EXECUTIONS : 166534 BUFFER_GETS : 1633139203 DISK_READS : 1041复制
16亿该1个sql语句的逻辑I/O，并且几乎没有磁盘活动。因此，它很可能一遍又一遍地访问一小部分数据 (因此很可能集中在几个块中)。
因此，你对这几个街区有争执。
从您提供的其他数据来看，您的行动过程看起来像是:
a) 调整SQL以读取更少的块，和/或
b) 查看更改XREF_DATA，XREF_ROW_NUMBER的存储参数，以将块分散到更宽的集合上，以缓解争用
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
相关阅读
Oracle RAC 一键安装翻车？手把手教你如何排错！
Lucifer三思而后行
604次阅读
2025-04-15 17:24:06
【纯干货】Oracle 19C RU 19.27 发布，如何快速升级和安装？
Lucifer三思而后行
595次阅读
2025-04-18 14:18:38
XTTS跨版本迁移升级方案（11g to 19c RAC for Linux）
zwtian
498次阅读
2025-04-08 09:12:48
Oracle数据库一键巡检并生成HTML结果，免费脚本速来下载!
陈举超
482次阅读
2025-04-20 10:07:02
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
465次阅读
2025-04-22 00:20:37
Oracle 19c RAC更换IP实战，运维必看！
szrsu
440次阅读
2025-04-08 23:57:08
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
438次阅读
2025-04-22 00:13:51
【活动】分享你的压箱底干货文档，三篇解锁进阶奖励！
墨天轮编辑部
430次阅读
2025-04-17 17:02:24
火焰图--分析复杂SQL执行计划的利器
听见风的声音
372次阅读
2025-04-17 09:30:30
3月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
362次阅读
2025-04-15 14:48:05
