Profile

Cover photo
Martin Berger (berx)
Lives in Wien
732 followers|547,240 views
AboutPostsPhotosVideosReviews

Stream

Martin Berger (berx)

Shared publicly  - 
 
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...
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 allow any access to the databases host ...
1
Add a comment...

Martin Berger (berx)

Shared publicly  - 
7
Add a comment...

Martin Berger (berx)

Shared publicly  - 
 
ORA-08176 with DB-link, create table and isolation level SERIALIZABLE
Today I had some fun identifying how a ORA-08176 can happen. It started with a ticket similar to "we get an ORA-08176 during a select, please fix the database." After some questions it refined to "we do a CREATE TABLE x AS SELECT in one session, and a SELEC...
1
Add a comment...

Martin Berger (berx)

Shared publicly  - 
8
1
Add a comment...

Martin Berger (berx)

Shared publicly  - 
 
if you write SQL, be specific!
Today  I got a ticket from a developer where he claimed Oracle has a bug somewhere. The reason for this claim was a statement similar to SELECT   * FROM     table1 WHERE    tab1col1  IN         (        SELECT   tab1col1                 FROM    table2 ) Thi...
2
Add a comment...

Martin Berger (berx)

Shared publicly  - 
 
access to CHM raw data - without manipulating the -MGMTDB
In Version 12.1 Oracle introduced the Grid Infrastructure Management Repository ( GIMR ) called ‑MGMTDB. This self managed pluggable database is a required component of Grid Infrastructure and should never require direct interactions. (there can be some int...
1
Add a comment...

Martin Berger (berx)

Shared publicly  - 
 
 
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, ...
View original post
1
Add a comment...

Martin Berger (berx)

Shared publicly  - 
5
Christoph Wallner (woina)'s profile photo
 
😂👌
Add a comment...

Martin Berger (berx)

Shared publicly  - 
 
Instance parameters derived from cpu_count - 12.1.0.2
About 6 years ago I wanted to know which instance parameters are derived from cpu_count . So it tested a 11.1.0.7 DB - in that version there 21 parameters changed based on the value of cpu_count. Some DB versions passed by so I decided it's time for another...
1
Add a comment...
Story
Tagline
of course I do not look busy, I did it right the first time
Introduction
kind of Oracle DBA; sometimes a not-TeamLead, not project manager, not system architect and not troubleshooter
 inter sedilibus 
 
Bragging rights
etc.
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Wien
Previously
Melk
Links
Other profiles
Contributor to
Work
Occupation
information manager; TeamLead DBA
Skills
DBA; Performance analysis; Capacity planning; Teamleader
Basic Information
Gender
Male
Looking for
Friends, Networking
Relationship
Married
Other names
berx
Schöne Tiere, Leider fühlt sich die Gestaltung der Preise und die Präsentation nach Abzocke an. 😞
Public - a month ago
reviewed a month ago
Sehr schöner Garten, gute Weine und freundliche Bedienung
Public - a month ago
reviewed a month ago
Super Pizza, wir haben auch immer einen Platz bekommen.
Public - 2 months ago
reviewed 2 months ago
34 reviews
Map
Map
Map
leider nicht empfehlenswert! Hatte entgegen der Informationen des Heurigenkalenders der Wachau nicht offen.
Public - a month ago
reviewed a month ago
Public - a month ago
reviewed a month ago