East Coast Oracle Users Conference

What do you do when a performance incident lasts only a few minutes and AWR doesn’t capture what really happened?

That’s where ASH becomes incredibly useful. In this session, we’ll use Active Session History and interactive network graphs to uncover the session-level details behind elusive performance problems, including blocking chains, wait events, resource contention, and the sequence of events.

Through live demos, you’ll see the complete ASH troubleshooting workflow and leave with four free, ready-to-use scripts for analyzing those frustrating “it happened, then disappeared” incidents.

Meet Slick Eddie: a fraudster exploiting five people, gift cards, and three completely disconnected transactional systems with zero foreign keys between them. That’s where things get interesting.

Using Free-Tier Oracle 26ai and an AI Coding Assistant, I built a multi-phase fraud detection pipeline with PL/SQL, PGQL, vector embeddings, similarity search, and Property Graphs that narrowed 3.7 million paths down to 132. No Python.

But this isn’t a victory lap. I’ll show you what I tried, what blew up, and how curiosity plus AI helped solve in days what could have taken months solo. Vectors, graphs, SQL, all in one Oracle engine.

Ready to catch Slick Eddie?