Name: Using JAS-MIN like a PRO! DB Performance Profiling session
Start: 2025-06-20T11:30:00+05:30
End: 2025-06-20T12:30:00+05:30

**Session Abstract:**
Would you like to find out what is your database performance profile? Maybe you would like to see it in graphical representation?
Which wait events are crucial from overall database perspective, where are potential bottlenecks, what are the most important statistics,
heaviest SQLs and how all of this correlate with time spend on waitings? Can you identify existing or potential performance problems?
Ask JAS-MIN! She will give an answer! (She may be lying or hallucinating but she will definitely give you an answer)

For last year we are developing a open-source tool for community -> JAS-MIN <-
The tool was inspired by the internal Oracle tool, called AWR Miner, written in R.
The problem with AWR Miner is that it is not generally available to non-Oracle employees and that it doesn't analise Statspack.
JAS-MIN is written in Rust, it can parse hundreds of AWR and STATSPACK reports and it is not only visualysing performance statistics,
which makes possible to deep dive in database behavior, but it also integrates with modern LLMs,
allowing you to use built-in chat "AI Assistant" approach in order to talk with it about your database :)
All without publishing report data to the public services.

During this talk we will show you how to use JAS-MIN from scratch.
We will show you 5 practical examples of performance analysis that we did for our customers, using this practical tool.

**Speaker Bio:**
Oracle Database Whisperer, performance maker and story teller. Oracle Certified Master and member of Oracle OakTable. Owner of the ORA-600 [Database Whisperers sp. z o. o. sp. k.] company and blogger (blog.ora-600.pl). Founder of Pint with Oracle User Group (poug.org). Personally a big fan of Terry Pratchett: "Wisdom comes from experience. Experience is often a result of lack of wisdom."

Oracle Database Whisperer with a hardware background. Focused on problem-solving, delving into system internals, coding, striving to understand and ensure smooth operation across Oracle Database, Linux, Exadata Database Machine, virtualization, HA/DR architectures, IaaS and PaaS environments.
An Oracle DBA and Cloud Architect Certified Professional. Graduate of Electronics and Telecommunications from the AGH University of Science and Technology in Cracow.
Currently working with ORA-600 Database Whisperers and proudly supporting the POUG, Sym42 communities.

https://www.aioug.org/events/using-jas-min-like-a-pro-db-performance-profiling-session

Sairam

All India Oracle Users Group - Bangalore Chapter

Technology

MySQL

Database Professionals

Oracle

Big Data

Database Development

Apex

Oracle Application Business Solutions

NoSQL

Oracle Weblogic

Oracle Data Integrator

Oracle Big Data Appliance

Oracle Developers

Oracle APEX Development

Oracle PL/SQL Development

Oracle Database Administration

GOWTHAM BABU

Rashmi Jakhotiya

Sai Penumuru

Sumit Sahu

Sachin BS

Rajeev

David Raj

Using JAS-MIN like a PRO! DB Performance Profiling session

Online event

Share

All India Oracle Users Group - Bangalore Chapter

Using JAS-MIN like a PRO! DB Performance Profiling session

All India Oracle Users Group - Bangalore Chapter

Details

Members are also interested in