|
Home
|
Interno |
Passing Juice |
|
About
|
Interno |
Passing Juice |
|
Code
|
Interno |
Passing Juice |
|
Contact
|
Interno |
Passing Juice |
|
Topics
|
Interno |
Passing Juice |
|
Videos
|
Interno |
Passing Juice |
|
Consulting
|
Interno |
Passing Juice |
|
Training
|
Interno |
Passing Juice |
|
Practical Linux Performance & Troubleshooting
|
Interno |
Passing Juice |
|
Dimensional Analysis of System Performance with eBPF & xtop
|
Interno |
Passing Juice |
|
Efficient, Always-On Thread Level Observability with eBPF
|
Externo |
Passing Juice |
|
Testing the Datadog Explain Plan Visualizer with Oracle execution plans
|
Interno |
Passing Juice |
|
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity
|
Interno |
Passing Juice |
|
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
|
Interno |
Passing Juice |
|
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates
|
Interno |
Passing Juice |
|
pqr.sql: Generate QR Codes with Pure SQL in PostgreSQL
|
Interno |
Passing Juice |
|
The xCapture and xtop eBPF tools are now in beta, with a demo dataset
|
Interno |
Passing Juice |
|
CatVector Demo Website
|
Interno |
Passing Juice |
|
New Tool: xstack - Completely Passive eBPF Linux Stack Profiling Without Any Tracepoints
|
Interno |
Passing Juice |
|
Webinar: Testing High-Performance Vector Search With CatBench on Google AlloyDB Omni
|
Interno |
Passing Juice |
|
My Blog Has Turned 18 Years Old
|
Interno |
Passing Juice |
|
Catbench Vector Search App has Postgres Query Throughput and Latency Monitoring Now
|
Interno |
Passing Juice |
|
Using Postgres pg_test_fsync tool for testing low latency writes
|
Interno |
Passing Juice |
|
Find which Oracle SQL_ID hits the SQL*Net break/reset to client event
|
Interno |
Passing Juice |
|
New Tool: lsds - List All Linux Block Devices and Settings in One Place
|
Interno |
Passing Juice |
|
Optimizing eBPF I/O latency accounting when running 37M IOPS on a 384-CPU server
|
Interno |
Passing Juice |
|
xCapture v3: Linux Performance Analysis with Modern eBPF and DuckDB
|
Interno |
Passing Juice |
|
Core Function Words Translated between English, Spanish, German, French and Swedish
|
Interno |
Passing Juice |
|
When eBPF task->stack->pt_regs reads return garbage on the latest Linux kernels, blame Fred!
|
Interno |
Passing Juice |
|
TracepointArgs: List Any Linux Tracepoint with Their Arguments, Datatypes and Related Structs
|
Interno |
Passing Juice |
|
CatBench Vector Search Playground
|
Interno |
Passing Juice |
|
Embedding Vectors of the Same Image Rotated Over 360 Degrees
|
Interno |
Passing Juice |
|
SQL Plan Execution FlameGraphs with Loop and Row Counts
|
Interno |
Passing Juice |
|
Embedding Vectors vs. Vector Embeddings
|
Interno |
Passing Juice |
|
Video: Testing the Silk Platform in 2024 Interview (12 minutes)
|
Interno |
Passing Juice |
|
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a Single Cloud VM
|
Interno |
Passing Juice |
|
Visualizing and Comparing Embedding Vectors as Heatmaps (Videos)
|
Interno |
Passing Juice |
|
Visualizing and Comparing Embedding Vectors as Heatmaps
|
Interno |
Passing Juice |
|
Tracking, not Tracing, Linux Thread Activity for Complete System Visibility (eBPF Summit)
|
Interno |
Passing Juice |
|
Python Supports Profiling with Perf - How Does It Work?
|
Interno |
Passing Juice |
|
Can a User Process Consume Kernel Mode CPU Without a Syscall?
|
Interno |
Passing Juice |
|
Next Big Thing: X-Ray Vision for Linux Systems with eBPF
|
Interno |
Passing Juice |
|
Syscallargs: List All Linux System Calls With Their Arguments
|
Interno |
Passing Juice |
|
RTX4090 converted into an eGPU
|
Interno |
Passing Juice |
|
Oracle Hint Scopes and Join Level Cardinality Hint
|
Interno |
Passing Juice |
|
New Commenting System
|
Interno |
Passing Juice |
|
Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumps
|
Interno |
Passing Juice |
|
Oracle Index Parallel Degree Fix After Parallel Creation or Rebuild
|
Interno |
Passing Juice |
|
Report Current Oracle Session Wait Chains from GV$SESSION without ASH
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 13: OStackProf for Linux, Unix & MacOSX Clients
|
Interno |
Passing Juice |
|
Testing Oracle's Use of Optane Persistent Memory, Part 2 - Fast Log File Sync Waits
|
Interno |
Passing Juice |
|
Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits
|
Interno |
Passing Juice |
|
MySQL Now Shows its Thread Names at OS Level for Better Troubleshooting
|
Interno |
Passing Juice |
|
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 2)
|
Interno |
Passing Juice |
|
My New Learning Platform and What I'm Up To in 2022
|
Interno |
Passing Juice |
|
Achieving 10 GB/s Scanning Rate in a Single Cloud VM
|
Interno |
Passing Juice |
|
Testing The Silk Platform - Hands-On Technical Analysis of High-Performance I/O in the Cloud
|
Interno |
Passing Juice |
|
Virtual Conference: Troubleshooting Very Complex Oracle Performance Problems
|
Interno |
Passing Juice |
|
Do Not Use '>' in Your Command Prompt (and How to Stay Safe in Shell)
|
Interno |
Passing Juice |
|
Is Your Linux Version Hiding Interrupt CPU Usage From You?
|
Interno |
Passing Juice |
|
Video: High Performance Block I/O on Linux
|
Interno |
Passing Juice |
|
Achieving 11M IOPS & 66 GiB/s IO on a Single ThreadRipper Workstation
|
Interno |
Passing Juice |
|
Oracle Wait Event Name vs. Display Name
|
Interno |
Passing Juice |
|
Measuring Java JVM thread activity in Linux with task state sampling
|
Interno |
Passing Juice |
|
Reasons why SELECT * is bad for SQL performance
|
Interno |
Passing Juice |
|
High System Load with Low CPU Utilization on Linux?
|
Interno |
Passing Juice |
|
Hacking Session: 7 Levels of Hint Invalidity in Oracle SQL
|
Interno |
Passing Juice |
|
Hacking Session: Oracle SQL Monitoring - Understanding the Execution Timeline column and CPU usage
|
Interno |
Passing Juice |
|
Virtual Conference: Systematic Oracle SQL Optimization Interview Videos
|
Interno |
Passing Juice |
|
Oracle Fatal Background Processes
|
Interno |
Passing Juice |
|
Virtual Conference Update: Systematic Oracle SQL Optimization in 2020
|
Interno |
Passing Juice |
|
Oracle Shared Pool Internals: List Chunk Position in the LRU List
|
Interno |
Passing Juice |
|
SchedLat: a Low Tech Script for Measuring Process CPU Scheduling Latency on Linux
|
Interno |
Passing Juice |
|
Announcing My Retirement (in 2030)!
|
Interno |
Passing Juice |
|
ORA-12850: Could not allocate slaves on all specified instances error and a workaround for my scripts
|
Interno |
Passing Juice |
|
Oracle Performance Troubleshooting Without OS Access, Part 1: Identifying CPU Scheduling Latency
|
Interno |
Passing Juice |
|
Video: Troubleshooting Complex Oracle Performance Problems (Jan 2020)
|
Interno |
Passing Juice |
|
Hacking Session: Troubleshooting Complex Oracle Performance Problems (January 2020)
|
Interno |
Passing Juice |
|
help.sql: Show TPT Script Purpose and Syntax
|
Interno |
Passing Juice |
|
Oracle State Objects and Reading System State Dumps Hacking Session Video
|
Interno |
Passing Juice |
|
New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1)
|
Interno |
Passing Juice |
|
Dump Current Oracle SQL Execution Plan Line ID Using Oradebug
|
Interno |
Passing Juice |
|
pSnapper: Linux Process Snapper Page and Videos
|
Interno |
Passing Juice |
|
Announcing Linux Process Snapper tool and a Linux Troubleshooting Hacking Session (3rd April 9am PDT)
|
Interno |
Passing Juice |
|
What Caused This Wait Event: Using Oracle's wait_event[] tracing
|
Interno |
Passing Juice |
|
Tutorial: Troubleshooting Linux SSH Login Delay - Why does logging in always take 10 seconds?
|
Interno |
Passing Juice |
|
Practical Linux Performance & Application Troubleshooting Training Details and Table of Contents
|
Interno |
Passing Juice |
|
Scripts for Drilling Down Into Unknown Optimizer Changes
|
Interno |
Passing Juice |
|
Visualizing SQL Plan Execution Time With FlameGraphs
|
Interno |
Passing Juice |
|
Generate Oracle SQL Monitoring Reports as HTML using SQL Developer v18.3 (no Flash needed)
|
Interno |
Passing Juice |
|
Log file switch (checkpoint incomplete) wait events and LGWR waiting for checkpoint progress
|
Interno |
Passing Juice |
|
Oracle SQL Monitoring and Advanced ASH Usage Hacking Sessions!
|
Interno |
Passing Juice |
|
Oracle SQL Tuning training & Oracle Troubleshooting training and some Linux stuff too!
|
Interno |
Passing Juice |
|
Webinar: Troubleshooting a Complex Oracle Performance Issue
|
Interno |
Passing Juice |
|
My Performance & Troubleshooting scripts (TPT) for Oracle are now in GitHub and open sourced
|
Interno |
Passing Juice |
|
Video: Oracle X$TRACE, Wait Event Internals and Background Process Communication
|
Interno |
Passing Juice |
|
Secret Hacking Session: Oracle Background Process Communication, Exotic Wait Events and Some Tracing too
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting seminar in 2018!
|
Interno |
Passing Juice |
|
Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Month
|
Interno |
Passing Juice |
|
GNW01: In-Memory Processing for Databases
|
Interno |
Passing Juice |
|
My BIWA Summit Presentations
|
Interno |
Passing Juice |
|
RAM is the new disk – and how to measure its performance – Part 3 – CPU Instructions & Cycles
|
Interno |
Passing Juice |
|
My New Youtube Channel
|
Interno |
Passing Juice |
|
Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention
|
Interno |
Passing Juice |
|
SQL Monitoring in Oracle Database 12c
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting v2.5 (with 12c stuff too)
|
Interno |
Passing Juice |
|
RAM is the new disk – and how to measure its performance – Part 2 – Tools
|
Interno |
Passing Juice |
|
RAM is the new disk – and how to measure its performance – Part 1 – Introduction
|
Interno |
Passing Juice |
|
The Hybrid World is Coming
|
Interno |
Passing Juice |
|
Old ventures and new adventures
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide – Part 12: control file reads causing enq: SQ – contention waits?
|
Interno |
Passing Juice |
|
Sqlplus is my second home, part 8: Embedding multiple sqlplus arguments into one variable
|
Interno |
Passing Juice |
|
Oracle Exadata Performance: Latest Improvements and Less Known Features
|
Interno |
Passing Juice |
|
Oracle In-Memory Column Store Internals – Part 1 – Which SIMD extensions are getting used?
|
Interno |
Passing Juice |
|
About index range scans, disk re-reads and how your new car can go 600 miles per hour!
|
Interno |
Passing Juice |
|
Combining Bloom Filter Offloading and Storage Indexes on Exadata
|
Interno |
Passing Juice |
|
What the heck are the /dev/shm/JOXSHM_EXT_x files on Linux?
|
Interno |
Passing Juice |
|
Oracle Memory Troubleshooting, Part 4: Drilling down into PGA memory usage with V$PROCESS_MEMORY_DETAIL
|
Interno |
Passing Juice |
|
Slides of my previous presentations
|
Interno |
Passing Juice |
|
Where does the Exadata storage() predicate come from?
|
Interno |
Passing Juice |
|
Oracle X$ tables – Part 1 – Where do they get their data from?
|
Interno |
Passing Juice |
|
cell flash cache read hits vs. cell writes to flash cache statistics on Exadata
|
Interno |
Passing Juice |
|
Hard Drive Predictive Failures on Linux and Exadata
|
Interno |
Passing Juice |
|
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2?
|
Interno |
Passing Juice |
|
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?
|
Interno |
Passing Juice |
|
Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2)
|
Interno |
Passing Juice |
|
SGA bigger than the amount of HugePages configured (Linux – 11.2.0.3)
|
Interno |
Passing Juice |
|
Why doesn’t ALTER SYSTEM SET EVENTS set the events or tracing immediately?
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql
|
Interno |
Passing Juice |
|
Oracle Performance & Troubleshooting Online Seminars in 2013
|
Interno |
Passing Juice |
|
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)
|
Interno |
Passing Juice |
|
ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support
|
Interno |
Passing Juice |
|
Oracle 12c: Scalar Subquery Unnesting transformation
|
Interno |
Passing Juice |
|
Oracle Database 12c R1 (12.1.0.1.0) is finally released!
|
Interno |
Passing Juice |
|
Getting the Most Out of ASH online seminar
|
Interno |
Passing Juice |
|
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production?
|
Interno |
Passing Juice |
|
Debugger Dangers – Part 2
|
Interno |
Passing Juice |
|
List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts
|
Interno |
Passing Juice |
|
List Exadata Disk Layout and Topology with the exadisktopo scripts
|
Interno |
Passing Juice |
|
V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells
|
Interno |
Passing Juice |
|
Understanding what a hint affects using the V$SQL_FEATURE views
|
Interno |
Passing Juice |
|
Listing Exadata storage cells and their configuration info from V$CELL_CONFIG
|
Interno |
Passing Juice |
|
Alter session force parallel query doesn’t really force anything
|
Interno |
Passing Juice |
|
asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time
|
Interno |
Passing Juice |
|
ExaSnapper 0.7 beta download and the hacking session videos
|
Interno |
Passing Juice |
|
Peeking into Linux kernel-land using /proc filesystem for quick’n’dirty troubleshooting
|
Interno |
Passing Juice |
|
Even more Snapper – v4.03 now works in SQL Developer too!
|
Interno |
Passing Juice |
|
Manual “before” and “after” snapshot support in Snapper v4
|
Interno |
Passing Juice |
|
Snapper v4.02 and the Snapper launch party video
|
Interno |
Passing Juice |
|
Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session!
|
Interno |
Passing Juice |
|
Troubleshooting high CPU usage with poor-man’s stack profiler – in a one-liner!
|
Interno |
Passing Juice |
|
Session Snapper v4 – The World’s Most Advanced Oracle Troubleshooting Script!
|
Interno |
Passing Juice |
|
Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-)
|
Interno |
Passing Juice |
|
Japanese translation of some of my blog articles
|
Interno |
Passing Juice |
|
What the heck is the INTERNAL_FUNCTION in execution plan predicate section?
|
Interno |
Passing Juice |
|
A tip for lazy Oracle users – type less with ANSI DATE and TIMESTAMP SQL syntax
|
Interno |
Passing Juice |
|
Snapper v3.61 released – and more work is in progress!
|
Interno |
Passing Juice |
|
Select statement generating redo – and lost write detection
|
Interno |
Passing Juice |
|
Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output
|
Interno |
Passing Juice |
|
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven)
|
Interno |
Passing Juice |
|
The limitations of CURSOR_SHARING = FORCE and FORCE_MATCHING_SIGNATURE for SQL plan stability
|
Interno |
Passing Juice |
|
MOATS-like sqlplus “top” utility for RAC
|
Interno |
Passing Juice |
|
Oradebug hanganalyze with a prelim connection and “ERROR: Can not perform hang analysis dump without a process state object and a session state object.”
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?!
|
Interno |
Passing Juice |
|
Where is LOB data stored?
|
Interno |
Passing Juice |
|
Exadata Smart Scan predicate offloading and sequence.NEXTVAL
|
Interno |
Passing Juice |
|
Create a database link with the new host:port/service syntax
|
Interno |
Passing Juice |
|
Oracle Core: Essential Internals for DBAs and Developers book by Jonathan Lewis
|
Interno |
Passing Juice |
|
Profiling trace files with preprocessor external tables in 11g and some parallel execution hacking
|
Interno |
Passing Juice |
|
Evil things are happening in Oracle
|
Interno |
Passing Juice |
|
What the heck is the SQL Execution ID – SQL_EXEC_ID?
|
Interno |
Passing Juice |
|
V8 Bundled Exec call – and Oracle Program Interface (OPI) calls
|
Interno |
Passing Juice |
|
Full scans, direct path reads and ORA-8103 error hacking session video
|
Interno |
Passing Juice |
|
Are you getting the most out of your Exadata performance? Part 1
|
Interno |
Passing Juice |
|
What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?
|
Interno |
Passing Juice |
|
Another cache buffers chains latch contention troubleshooting example using LatchProf
|
Interno |
Passing Juice |
|
Tech Reviewer, Tech Reviewer! ;-)
|
Interno |
Passing Juice |
|
IOUG Select Journal Editor’s Choice Award 2011
|
Interno |
Passing Juice |
|
Knowing what you want to achieve before thinking of how to achieve it – a query optimization example
|
Interno |
Passing Juice |
|
Running SELECT … INTO :bind_variable from SQL
|
Interno |
Passing Juice |
|
Latch contention troubleshooting case study and Flashback Database performance issues with LOBs
|
Interno |
Passing Juice |
|
MOATS: The Mother of All Tuning Scripts!
|
Interno |
Passing Juice |
|
An index of my TPT scripts
|
Interno |
Passing Juice |
|
LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051)
|
Interno |
Passing Juice |
|
Implicit datatype conversion in the parsing phase – something new I learned today!
|
Interno |
Passing Juice |
|
ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!
|
Interno |
Passing Juice |
|
Exadata CAN do smart scans on bitmap indexes
|
Interno |
Passing Juice |
|
Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes?
|
Interno |
Passing Juice |
|
Finding Oracle Homes which Oracle instances are using on Linux
|
Interno |
Passing Juice |
|
New cursor_bind_capture_destination parameter in Oracle 11.2.0.2
|
Interno |
Passing Juice |
|
Performance Stories from Exadata Migrations
|
Interno |
Passing Juice |
|
Is this valid SQL syntax? :-)
|
Interno |
Passing Juice |
|
Snapper 3.52 – With Oracle 9.2 support!
|
Interno |
Passing Juice |
|
Asynch descriptor resize wait event in Oracle
|
Interno |
Passing Juice |
|
A little new feature for shared pool geeks :-)
|
Interno |
Passing Juice |
|
COUNT STOPKEY operation (the where ROWNUM <= N predicate) doesn't process over ~4 Billion rows and returns wrong results
|
Interno |
Passing Juice |
|
Read currently running SQL statement’s bind variable values using V$SQL_MONITOR.BIND_XML in Oracle 11.2
|
Interno |
Passing Juice |
|
The most fundamental difference between hash and nested loop joins
|
Interno |
Passing Juice |
|
Oracle Closed World presentation links
|
Interno |
Passing Juice |
|
Which number takes more space in an Oracle row?
|
Interno |
Passing Juice |
|
Exadata v2 Smart Scan Performance Troubleshooting article
|
Interno |
Passing Juice |
|
Dropping and creating tables in read only tablespaces?!
|
Interno |
Passing Juice |
|
The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements
|
Interno |
Passing Juice |
|
Oracle memory troubleshooting article
|
Interno |
Passing Juice |
|
Flexible Sqlplus command line history with RLWRAP
|
Interno |
Passing Juice |
|
Execution plan Quiz: Shouldn’t these row sources be the other way around ;-)
|
Interno |
Passing Juice |
|
Quiz: Explaining index creation
|
Interno |
Passing Juice |
|
cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting
|
Interno |
Passing Juice |
|
KGH: NO ACCESS – Buffer cache inside streams pool too!
|
Interno |
Passing Juice |
|
Non-trivial performance problems
|
Interno |
Passing Juice |
|
Calculate SQL_ID and SQL_HASH_VALUE from SQL text
|
Interno |
Passing Juice |
|
Oracle Latch Contention Troubleshooting
|
Interno |
Passing Juice |
|
Oracle Session Snapper v3.10
|
Interno |
Passing Juice |
|
How to CANCEL a query running in another session?
|
Interno |
Passing Juice |
|
New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning
|
Interno |
Passing Juice |
|
Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!
|
Interno |
Passing Juice |
|
Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris
|
Interno |
Passing Juice |
|
Oracle Wait Event reference
|
Interno |
Passing Juice |
|
Oracle Peformance Visualization…
|
Interno |
Passing Juice |
|
Bind Variable Peeking – execution plan inefficiency
|
Interno |
Passing Juice |
|
Recursive sessions…
|
Interno |
Passing Juice |
|
Sometimes things are easy (Part 1): How to fix wrapped execution plan text?
|
Interno |
Passing Juice |
|
Beyond Oracle Wait Interface – Part 2
|
Interno |
Passing Juice |
|
NULL is not zero!
|
Interno |
Passing Juice |
|
Measuring what matters
|
Interno |
Passing Juice |
|
Finding the reasons for excessive logical IOs
|
Interno |
Passing Juice |
|
Explain Plan For command may show you the wrong execution plan – Part 1
|
Interno |
Passing Juice |
|
Detect chained and migrated rows in Oracle – Part 1
|
Interno |
Passing Juice |
|
What’s a good way to learn some Oracle internals every day?
|
Interno |
Passing Juice |
|
SystemTap is production supported in Redhat EL5.4
|
Interno |
Passing Juice |
|
KGL simulator, shared pool simulator and buffer cache simulator – what are these?
|
Interno |
Passing Juice |
|
KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool!
|
Interno |
Passing Juice |
|
Oracle 11gR2 has been released – and with column oriented storage option
|
Interno |
Passing Juice |
|
latch: cache buffers chains latch contention – a better way for finding the hot block
|
Interno |
Passing Juice |
|
Select COUNT(*) and COUNT(column) are different things!
|
Interno |
Passing Juice |
|
Alter system kill session and ORA-00031: session marked for kill
|
Interno |
Passing Juice |
|
An interview with me
|
Interno |
Passing Juice |
|
How to detect when a cursor was closed from SQL trace output?
|
Interno |
Passing Juice |
|
Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile
|
Interno |
Passing Juice |
|
(Secret) Preview of Oracle 12g CBO leaked from Oracle labs…
|
Interno |
Passing Juice |
|
Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdump
|
Interno |
Passing Juice |
|
Using Perfsheet and TPT scripts for solving real life performance problems
|
Interno |
Passing Juice |
|
ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql
|
Interno |
Passing Juice |
|
Oracle Performance Visualization videos from Sydney
|
Interno |
Passing Juice |
|
Scripts for showing execution plans via plain SQL and also in Oracle 9i
|
Interno |
Passing Juice |
|
“Free” DBA_HIST AWR views in 11g…
|
Interno |
Passing Juice |
|
I have been troubleshooting since I was a kid! :)
|
Interno |
Passing Juice |
|
Tracing Oracle SQL plan execution with DTrace
|
Interno |
Passing Juice |
|
Seminar feedback and pictures from Singapore
|
Interno |
Passing Juice |
|
Read OS environment variables using DBMS_SYSTEM.GET_ENV()
|
Interno |
Passing Juice |
|
I’m an Oracle ACE Director now :)
|
Interno |
Passing Juice |
|
Oracle 11g: Reading alert log via SQL
|
Interno |
Passing Juice |
|
Another LatchProfX use case
|
Interno |
Passing Juice |
|
The real history of Oracle database revealed!
|
Interno |
Passing Juice |
|
Oracle, Timesten and PL/SQL support
|
Interno |
Passing Juice |
|
The full power of Oracle’s diagnostic events, part 1: Syntax for KSD debug event handling
|
Interno |
Passing Juice |
|
60000 bind variables?! Maybe it’s time to use a temporary table instead…
|
Interno |
Passing Juice |
|
SQL_ID is just a fancy representation of hash value
|
Interno |
Passing Juice |
|
Performance Visualization, Capacity planning and Hotsos Symposium
|
Interno |
Passing Juice |
|
When was a table last changed?
|
Interno |
Passing Juice |
|
Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint
|
Interno |
Passing Juice |
|
Identifying shared memory segment users using lsof
|
Interno |
Passing Juice |
|
Reliable latch waits and a new blog
|
Interno |
Passing Juice |
|
Oracle memory troubleshooting, Part 1: Heapdump Analyzer
|
Interno |
Passing Juice |
|
Performance Visualization made easy – PerfSheet 2.0 beta
|
Interno |
Passing Juice |
|
A little oradebug enhancement in Oracle 11g
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 9 – Process stack profiling from sqlplus using OStackProf
|
Interno |
Passing Juice |
|
Transportable tablespaces and ROWID uniqueness
|
Interno |
Passing Juice |
|
VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles
|
Interno |
Passing Juice |
|
Oracle hidden costs revealed, Part2 – Using DTrace to find why writes in SYSTEM tablespace are slower than in others
|
Interno |
Passing Juice |
|
Flexible sampling of any V$ or X$ view with sample.sql
|
Interno |
Passing Juice |
|
Case study on some rowcache internals, cached non-existent objects and a describe bug
|
Interno |
Passing Juice |
|
Why does even a small difference in SQL text cause a hard parse?
|
Interno |
Passing Juice |
|
Script: Display valid values for multioption parameters (including hidden parameters)
|
Interno |
Passing Juice |
|
The simplest query for checking what’s happening in a database
|
Interno |
Passing Juice |
|
Library cache latches gone in Oracle 11g
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX
|
Interno |
Passing Juice |
|
Closed database and WITH subquery
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf
|
Interno |
Passing Juice |
|
Another use case for WaitProf – diagnosing “events in waitclass Other”
|
Interno |
Passing Juice |
|
Killing an Oracle process from inside Oracle
|
Interno |
Passing Juice |
|
cursor_space_for_time To Be Deprecated
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain
|
Interno |
Passing Juice |
|
Debugger dangers
|
Interno |
Passing Juice |
|
Short note on KGX Mutexes
|
Interno |
Passing Juice |
|
Generating lots of rows using connect by – safely!
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!
|
Interno |
Passing Juice |
|
Performance Tools Quick Reference Guide
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue
|
Interno |
Passing Juice |
|
Snapper shortcut
|
Interno |
Passing Juice |
|
Querying the current tracefile name, using SQL – with tracefile_identifier
|
Interno |
Passing Juice |
|
Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation
|
Interno |
Passing Juice |
|
Performance and Scalalability Improvements in Oracle 10g and 11g
|
Interno |
Passing Juice |
|
Using autonomous transactions for sleeping
|
Interno |
Passing Juice |
|
SQL*Net break/reset to client
|
Interno |
Passing Juice |
|
SQL*Net message to client vs SQL*Net more data to client
|
Interno |
Passing Juice |
|
SQL*Net message to client wait isn’t really what it’s thought to be
|
Interno |
Passing Juice |
|
Oracle hidden costs revealed, part 1 – Does a batch job run faster when executed locally?
|
Interno |
Passing Juice |
|
Excellent article on Oracle 11g PL/SQL function result cache
|
Interno |
Passing Juice |
|
Can you write a working SQL statement without using any whitespace?
|
Interno |
Passing Juice |
|
Expensive calculator…
|
Interno |
Passing Juice |
|
Why does Oracle parameter count change during session lifetime?
|
Interno |
Passing Juice |
|
Systematic application troubleshooting in Unix
|
Interno |
Passing Juice |
|
Perl version of Snapper
|
Interno |
Passing Juice |
|
Sqlplus is my second home, part 5: Reading the name of currently executing script
|
Interno |
Passing Juice |
|
Oracle Security, Part 2: Your read only accounts aren’t that read only
|
Interno |
Passing Juice |
|
Sqlplus is my second home, part 4: Getting sqlplus parameter value into a variable
|
Interno |
Passing Juice |
|
A simple interview question
|
Interno |
Passing Juice |
|
How to resolve SQL object and column names all the way to base tables and columns in Oracle?
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 3: More adventures in process stack
|
Interno |
Passing Juice |
|
Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt
|
Interno |
Passing Juice |
|
Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP
|
Interno |
Passing Juice |
|
Operating systems are lazy allocating memory
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide, Part 2: No magic is needed, systematic approach will do
|
Interno |
Passing Juice |
|
Oracle Session Snapper, part 2: Getting most out of Snapper
|
Interno |
Passing Juice |
|
Oracle 11g internals part 1: Automatic Memory Management
|
Interno |
Passing Juice |
|
Oracle Session Snapper – real-time session-level performance stats for DBAs
|
Interno |
Passing Juice |
|
Sqlplus is my second home, Part 1: HTMLizing your sqlplus output
|
Interno |
Passing Juice |
|
Session-level statspack
|
Interno |
Passing Juice |
|
A gotcha with parallel index builds, parallel degree and query plans
|
Interno |
Passing Juice |
|
My version of SQL string to table tokenizer
|
Interno |
Passing Juice |
|
Advanced Oracle Troubleshooting Guide: When the wait interface is not enough [part 1]
|
Interno |
Passing Juice |