Profile cover photo
Profile photo
Martin Berger (berx)
734 followers -
of course I do not look busy, I did it right the first time
of course I do not look busy, I did it right the first time

734 followers
About
Martin's posts

Post has attachment
search for the missing ORA-04068
Oracle Active Dataguard is a great software for offloading read only activities from the primary nodes to nodes which is not utilized anyhow (at least during non-disaster times). A very good example for doing so is regular extraction of data for processing ...

Post has attachment
Can I flush the shared pool of all RAC Instances in an Active DataGuard?
That's a good question. And the answer is simple: Yes , but NO ! Well, ok; that's not very helpful. But whenever is anything simple in modern IT? So I'll show why Yes , it's possible: first as SYS create a dummy user without special permissions and a functi...

Post has attachment
Can I flush the shared pool of all RAC Instances in an Active DataGuard?
That's a good question. And the answer is simple: Yes , but NO ! Well, ok; that's not very helpful. But whenever is anything simple in modern IT? So I'll show why Yes , it's possible: first as SYS create a dummy user without special permissions and a functi...

Post has attachment
interconnect fragmentation kills the cluster
On a particular Oracle 2 node cluster (12.1) we faced random instances failing. Servicerequests at Oracle were open with limited result, as it was quite random and we could not link it to any trigger. As it looked somehow like a communication problem betwee...

Post has attachment
cost vs. gets
Last week I hit an interesting performance issue: A Table (T) has 2 index (of interest). One (IX_1) is only on column S, the other (IX_2) on (C, S). The optimizer calculates the plan with IX_1 more expensive than the plan with IX_2 - as this should be more ...

Post has attachment
no peek in PL/SQL
Connor McDonald wrote a blog about differences between bind peeking and SYS_CONTEXT in SQL queries. This even led to an proposal in Database Ideas: CBO should peek at SYS_CONTEXT values just like bind values  (feel free to vote and comment, if you like it) ...

Post has attachment
OTN Appreciation Day : ONLINE
This post is inspired by Tim Hall . Thinking about "what is my single favourite feature of Oracle", when all the products of Oracle (or at least all I know about) can be covered sounds stupid or impossible. There are far to many features which could be inte...

Post has attachment
Oracle DIRECTORY access on OS layer
Oracle DIRECTORY objects are very nice to handle access for external tables or other procedures. It just can be challenging to enable proper access to those files for other users than the database user (I call it oracle here). If there are any concerns to a...

Post has shared content
Choices to throwing away our last ounce of dignity
In or Out became David or Boris Neither, oh crickey, look I'm in and if that means dancing with the devil then fine. Oh Boris won, oooook then.  Dave?  Dave mate, where are you.......tumble weed Boris or Gove, oh come on we all know Gove is c......Boris, ...
Wait while more posts are being loaded