How to avoid “ORA-00932: inconsistent datatypes: expected – got CLOB” when distinct CLOB datatypes.
Large objects (LOBs) are not supported in comparison conditions. However, you can use PL/SQL programs for comparisons on CLOB data.
提供综合数据库运维服务与优化方案(不限Oracle、MySQL、PG及国产数据库), 微信/Tel:(+86)134-365-60330
Large objects (LOBs) are not supported in comparison conditions. However, you can use PL/SQL programs for comparisons on CLOB data.
skgpspawn failed:category = 27143, depinfo = 24, op = pipe, loc = skgpspawn2
…
oracle 12c release 1版本引入新功能可隐藏列(invisible columns),这个特性有很多的争议,不明白为什么ORACLE会推出这个特性,因为这个特性可能会带来很多麻烦..
今天开发的同事找我说是一个报表系统的SQL执行第一次很快,再执行就慢的几乎查询无响应,找他要来了SQL,也是常见的表关连LIFT JOIN 、GROUP BY的统计报表, 出于篇幅原因不再贴SQL, 把SQL放到TOAD 中问题依然可以再现,..
Adaptive Log File sync was introduced in 11.2. the feature is exactly enabled since release 11.2.0.3 , It’s enabled through an underscore parameter called _use_adaptive_log_file_sync and the description of this parameter is: adaptively switch between post/wait and polling. Oracle can switches between the 2 methods: Post/wait, traditional method for posting completion of writes to redo … Read more
Sometimes we need to enable sql*net trace to diagnose sqlplus connection problems such as ora-125*
Below are the steps to configure Sql*Net verbose Client side tracing:
Each time your program performs a function call, information about the call is generated. That information includes the location of the call in your program, the arguments of the call, and the local variables ..
This script displays the top 50 longest idle times and list distribution of sessions on the instance..
高parse calls表示这些SQL不可以re-used 并且每次执行都要重新解析,理想的最佳状态是一次解析多次执行,你也知道频繁的解析会给library cache带来沉重的负担, 一个sql的执行必须先parse,解析过程包含sql 加载到shared pool, 语法检查…
When multiple connection created will insert a lot of rows in aud$ table, there may be contention in the segment header for the table. This contention can manifest itself as a buffer busy wait or a freelist wait.
top – 14:32:11 up 104 days, 20:27, 1 user, load average: 19.31, 19.10, 19.06 Tasks: 390 total, 19 running, 371 sleeping, 0 stopped, 0 zombie Cpu(s): 99.5%us, 0.1%sy, 0.0%ni, 0.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 8164276k total, 8111804k used, 52472k free, 403596k buffers Swap: 16386292k total, 224k used, 16386068k free, 5560532k cached [root@webxxx ~]# ps … Read more
alter system set memory_max_target=0 scope=spfile;
shutdown immediate
startup
SQL> show parameter target
…
memory_max_target big integer 3824M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x938E8C5, dbgtrReserveSpace()+99] [flags: 0x0, count: 1]
Errors in file /oracle/diag/rdbms/ora11g/ora11g/trace/ora11g_ora_13864.trc (incident=60801):
ORA-07445: exception encountered: core dump [dbgtrReserveSpace()+99] [SIGSEGV] [ADDR:0x10] [PC:0x938E8C5] [Address not mapped to object] []
Incident details in: /oracle/diag/rdbms/ora11g/ora11g/incident/incdir_60801/ora11g_ora_13864_i60801.trc
Use ADRCI or Support Workbench to package the incident.
shell统计linux系统中每个程序的内存使用情况,因为内存结构非常复杂,不一定100%精确,
scn(system change number) 结构主要维护 oracle数据库内部的数据一致性,SCN 有两部分组成: Base and wrap,wrap 是16bit的数字,base是32bit的数字,这样其实就可以算scn的有效范围,它的格式(redo dump trace)是wrap.base,当base超过了2的32次方,然后wrap 就会加1,其实用sql 很好验证。
Why SQL Test Case Builder? For most SQL problems, the single most important factor for a speedy bug resolution is to obtain a reproducible test case. However, this is normally the longest and most painful step for customers. The goal of the SQL Test Case Builder (TCB) is to automatically gather as much information as … Read more
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
DDE: Problem Key ‘ORA 312’ was flood controlled (0x5) (no incident)
ORA-00312: online log 2 thread 1: ‘/oracle/oradata/icme/redo02.log’
Error 19527 creating/clearing online redo logfile 2
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 17
ORA-06512: at “SYS.UTL_TCP”, line 267
2013-09-29 10:03:15 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, eicmec.prm: Object with object number 81069 is compressed. Table compression is not supported.
DEMO 1,How to use oradebug to call OS commands via the database
DEMO 2,Disable sys audit