Profile

Cover photo
Martin Berger (berx)
Lives in Wien
733 followers|525,688 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...
Have him in circles
733 people
Vishalaksha Vyas's profile photo
Martin Klier's profile photo
MrsCarley Rose's profile photo
Michael Moore's profile photo
Bettina Ringler (Tini89)'s profile photo
Anjo Kolk's profile photo
Kedar Vaijanapurkar's profile photo
Martin Bichler (maddin81)'s profile photo
Phil Clifford's profile photo

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  - 
 
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  - 
 
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...
People
Have him in circles
733 people
Vishalaksha Vyas's profile photo
Martin Klier's profile photo
MrsCarley Rose's profile photo
Michael Moore's profile photo
Bettina Ringler (Tini89)'s profile photo
Anjo Kolk's profile photo
Kedar Vaijanapurkar's profile photo
Martin Bichler (maddin81)'s profile photo
Phil Clifford's profile photo
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
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
Gutes Essen, leider extrem langsame und unmotivierte Bedienung.
Public - a month ago
reviewed a month ago
Ein schönes Gebiet für kleine Familienspaziergänge
Public - a month ago
reviewed a month ago
24 reviews
Map
Map
Map
Public - a month ago
reviewed a month ago
Perfect to leave our luggage on the last day of our trip
Public - 2 months ago
reviewed 2 months ago
Public - 4 months ago
reviewed 4 months ago