Profile

Cover photo
Martin Berger (berx)
Lives in Wien
733 followers|497,629 views
AboutPostsPhotosVideosReviews

Stream

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  - 
 
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...

Martin Berger (berx)

Shared publicly  - 
 
245. Geburtstag von Ludwig van Beethoven #GoogleDoodle
3
Add a comment...
Have him in circles
733 people
Bill Todd's profile photo
Martin Bach's profile photo
Daniel van Os's profile photo
Greg Hobbs's profile photo
Frank Dorst's profile photo
Paul Jackson's profile photo
Albin Rauchenberger's profile photo
Tony van Esch's profile photo
Ethan Post's profile photo

Martin Berger (berx)

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

Martin Berger (berx)

Shared publicly  - 
 
Well, the response of the app is frightful,
and users are getting spiteful.
They claim the database is slow,
“Make it go”, “Make it go”, “Make it go”

It doesn’t show signs of locking,
Yet the performance it still quite shocking,
The CPU is right down low,
but its slow, but its slow, but its slow.

When we finally trace the load,
The problem is rapidly found,
If you write lots of crappy code,
Then your app crumples to the ground

Now we write the application better,
The DB is no longer fettered,
So as long as we write good code,
It wont be slow, wont be slow, wont be slow.
4
Add a comment...

Martin Berger (berx)

Shared publicly  - 
 
handling disks for ASM - when DB, Linux and Storage admins work together
A proper management of ASM Disks can be a complicated task. On DOAG2015 I discussed with Martin Bach about the concept in my current company, where we implemented a setting which is consistent, robust and enables Storage, Linux and DB admins to work togethe...
A proper management of ASM Disks can be a complicated task. On DOAG2015 I discussed with Martin Bach about the concept in my current company, where we implemented a setting which is consistent, robust and enables Storage, Linux and DB admins to work together easily.
1
2
Add a comment...
People
Have him in circles
733 people
Bill Todd's profile photo
Martin Bach's profile photo
Daniel van Os's profile photo
Greg Hobbs's profile photo
Frank Dorst's profile photo
Paul Jackson's profile photo
Albin Rauchenberger's profile photo
Tony van Esch's profile photo
Ethan Post'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
Perfect to leave our luggage on the last day of our trip
Public - a month ago
reviewed a month ago
Public - 2 months ago
reviewed 2 months ago
Public - 10 months ago
reviewed 10 months ago
21 reviews
Map
Map
Map
Public - 10 months ago
reviewed 10 months ago
Public - 10 months ago
reviewed 10 months ago