Databases and Performance

All about Performance of Oracle and other relational databases on Linux and UNIX based systems. How to measure it, analyse it, tune it, and manage it over time.

Saturday, 19 January 2019

Time SQL Execution with Python

›

I've said before in this blog how I find Python to be very useful for doing various things, including processing data to or from an ...

2 comments:

Monday, 25 June 2018

Interactive Complex SQL Scripts - A Solution

›

Often you will find that you need to run a relatively simple SQL query and see the results from it. Normally your choice of how to run thi...

Monday, 21 May 2018

Advanced Compression no good for Data Warehousing

›

This post is about experiencing " table fetch continued row " in compressed data warehouse tables that experience some level of ...

Saturday, 21 April 2018

Top Oracle Monitoring Views & Tables

›

Introduction I can be a bit "old school" at times on some things, and I like to be familiar with the underlying technology ...

Wednesday, 28 March 2018

Hash Join Overflow to Disk Summary

›

[I'm a bit busy at the moment working with a new client on a large and complex database, so I'm afraid I've only got time to do ...

Wednesday, 14 February 2018

Hash Join Overflow Costing #4 - Temporary Space + PGA Use

›

Now I want to look at the value reported for "Temporary Space" (TempSpc) and how to check whether the hash table is close to fitt...

Tuesday, 6 February 2018

Hash Join Overflow Costing #3 - Simpler Formula

›

So far I have offered a formula for how a Hash Join that overflows to disk is costed and confirmed that this is only costed in terms of sin...

›

Home

View web version

About Me

John Brady: An Oracle Database professional with over 20 years experience of using Oracle on large, complex, high performance database systems. Excellent knowledge of Oracle internals and scalability, especially on UNIX and Linux systems.

Experience:
* Oracle Database from 7 through to 12c
* Database Design, SQL, PL/SQL
* Database Administration

Specialities:
* Oracle Database Performance Tuning and Troubleshooting
* Database Design for large scale databases and fast data access
* Oracle Internals - Query Optimizer, Execution Plans
* Back end application development in SQL, PL/SQL, Python, C, Java

Read more about the various Oracle database services I offer at Bottleneck Data Solutions.

View my complete profile