Prompted by a question on OTN I came up with a strategy for producing an ORA-00060 deadlock that DIDN’T produce a deadlock graph (because there isn’t one) and didn’t get reported in the alert log (at least, not when tested on 22.214.171.124). It’s a situation that shouldn’t arise in a production system because it’s doing the sorts of things that you shouldn’t do in a production system: but possibly if you’re trying to do some maintenance or upgrades while keeping the system live it could happen.
Yesterday my colleague Alex and I had the pleasure to do some extra presentations during AMIS’s Oracle OpenWorld preview evening. While still not getting around...
I have ORACLE 11g client and server in a single machine. I run an application which has its own signal handling. Since BEQ is hosting processes i get errors in my application functioning (which works absolutely fine when client and server are hosted in different machines).
I want to know what are side effects of disabling BEQ protocol?
Can anybody please advice?
One area which has always interested me within the Oracle ‘world’ is Backup and Recovery, and there is one utility in particular that I think stands out – RMAN. Oracle Recovery Manager, or RMAN as it is widely known, is one of the most important database utilities, and one that every Oracle DBA should be […]
This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 126.96.36.199. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.
After having installed the Documentum Administrator, one of our test was to open a document. When I opened one for the first time the content was empty although I knew it contained text. But the correct content was well displayed when I opened it a second time.
In the ucf trace file I had:
I enabled an huge 70G table for inmemory population, I expected the inmemory population to take a while, but the population didn’t complete even after letting it run for a day. Why?
Initial review of the server shows no issues, no resource starvation. This must be a problem with Oracle processes itself. I started digging further, and ASH data shows that in numerous samples the process was seen reading block using single block I/I calls. Also object_id matches with the table I was trying to populate.
In the previous post in this series we introduced a crude test case in which we had data packed in to a single block which was causing severe buffer contention. To re-cap – here is a chart of ASH data demonstrating the issue, the large grey stripe is time wasted on global cache contention.
This was tested on Oracle 11.2:
After the restart of a 12c inmemory database with 300GB+ SGA, I noticed that an Oracle background process sa00 was consuming a bit of CPU. Documentation suggests that it is SGA Allocator process, however, ipcs -ma command shows that the shared memory segment is already allocated. I was curious, of course, what would that background process will be allocating?.
Process stack of the process shows that it is touching SGA pages to pre-page SGA memory pages.