ORACLE INTERNALS & DATABASE PERFORMANCEWARSAW, PL ↗ WORLDWIDE

YOU KNOW YOUR DATABASE. WE KNOW ITS INTERNALS.

DATABASES
MUST WORK.

NO EXCUSES.

Where others stop investigating, we open the dump. Oracle tuning, internals and the difficult cases. Deep knowledge. Straight answers.

[ INSIDE THE ENGINE ]
ora600@internals:~_

❯ ./go-deeper --no-bullshit

 .d8888b.   .d8888b.   .d8888b.
d88P  Y88b d88P  Y88b d88P  Y88b
888       888    888 888    888
888d888b. 888    888 888    888
888P Y88b 888    888 888    888
Y88b d88P Y88b  d88P Y88b  d88P
 "Y888P"   "Y8888P"   "Y8888P"

ORACLE DATABASE WHISPERERS

0x00000600 ───────────────────────────

[ OK ] Reading between the bytes.

[ OK ] SQL → WAIT EVENTS → INTERNALS

[ OK ] Root cause. Found.

MODE: DEEP DIVE100% HUMAN EXPERTISE
01 / ROOT CAUSE OVER GUESSWORK0x600
NO MAGIC. PURE ENGINEERING.ORACLE · SQL · PL/SQL · EXADATA · HA/DR↓

01 / WHAT WE DO

Difficult cases?
Our favourite sport.

We don’t sell reports destined for a drawer. We help you understand the problem and get it sorted.

All services ↗

02 / NO BLACK BOXES

We don’t believe in
“that’s just how it is”.

We believe in traces, measurements and root causes. From the application through SQL and engine mechanisms down to memory structures. When something makes no sense, we say so. Then we get to work.

V$ / X$ / TRACEEVIDENCE > OPINIONSACCOUNTABILITY INCLUDED
Meet the people under the hood ↗

ORA-600 / JAS-MIN / PERFORMANCE AUDITS

A chart is not
a diagnosis.

JAS-MIN crunches the data. We dig into the cause. We combine AWR and STATSPACK analysis with internals expertise to explain more than the slowdown: what to investigate, what to change and how to verify the result.

How we audit performance ↗
JAS-MIN — Oracle Performance Evidence

0x01AWR / STATSPACKData, not a hunch.

0x02SIGNALS + EVIDENCESQL / WAITS / DB TIME / DB CPU

0x03OUR INTERPRETATIONCorrelation is just the beginning.

0x04ACTION PLANPriority. Change. Test.

AUDIT WORKFLOW / NOT A LIVE FEED

03 / ORA-600 × DBVISIT

TECHNOLOGY PARTNER

Your data is
not disposable.

We value tools built on sound engineering. That’s why we’re a DBvisit partner. StandbyMP with the Zero Data Loss option adds continuous redo streaming to Oracle Standard Edition protection.

Meet Zero Data Loss ↗
STANDBYMP / ZERO DATA LOSS
<1s

RPO in a qualified environment.

PRIMARY → REDO → STANDBY
Less data to reconcile. More reasons to sleep well.

04 / KNOWLEDGE IS FOR SHARING

Knowledge grows
when you share it.

The blog, publications, conferences, POUG and conversations without the necktie. Internals are better in good company.

NEXT COMMAND / LET’S TALK

Got a problem?
You’re in the right place.

↗