Oracle XE 11g master-slave (standby replication) on Docker
In this demo I show how to setup two oracle XE 11g instances as Master Standby replication configured on two Docker containers.
Showing posts with the label oracleShow all
View Oracle sessions by CPU usage and status
As a database guy one of the most common questions I get asked is to display a list of Oracle processes sorted by CPU usage. This might not be entire…
Find which table has a particular column in Oracle
Sometimes we need to find out which tables contain a particular column. In Oracle this can be simply done by querying the DBA_TAB_COLUMNS system tabl…
Oracle measure Transactions per Second (TPS)
In a previous post I described how I was tasked to produce a number of KPIs and queried Oracle's AWR to get such data. I was also asked to get th…
Oracle measure number of Active Sessions
I was recently asked to produce some KPIs for our three node Oracle cluster database. One of the KPIs was to display a graph trend for total number o…
Oracle export with query
If you need to produce an Oracle export with a filter/query, you may encounter syntax errors because you need to escape certain characters. This is t…
List user or table privileges in Oracle
This morning I was asked by the auditors to give them a list of privileges which have been granted to users USER_A and USER_B. You can do this by usi…
Output table contents in PL/SQL stored procedure
With Oracle stored procedures the database developer can display output to the SQL client. This is very handy when you want to use a stored procedure…
List all indexes in an Oracle tablespace
Sometimes Oracle DBAs need to do some tablespace cleaning and moving indexes from one tablespace to another. If you have hundreds of indexes this may…
