Oracle DBA

Oracle Snapshot Standby

August 5, 2021July 13, 2021 by Mark Burgess

Oracle Data Guard Snapshot Standby offers powerful features to help maximise the value of your disaster recovery site.

October 24, 2020June 18, 2014 by Mark Burgess

Oracle Analytic SQL Sort Recently I have been optimising the Oracle analytic SQL sort operations…

October 24, 2020March 17, 2014 by Mark Burgess

Oracle RMAN Backup Transport Tablespace Limitations Oracle RMAN backup of transportable tablespace has a number…

August 6, 2021April 6, 2013 by Mark Burgess

Using Oracle DBRM The Oracle Database Resource Manager (DBRM) provides a wealth of functionality to…

October 23, 2020August 20, 2012 by Mark Burgess

I spend a lot of time working on issues of performance and scalability for clients…

July 13, 2021January 23, 2010 by Mark Burgess

Note: If you are using Oracle 11g or higher you really should be looking at…

November 26, 2020November 6, 2009 by Mark Burgess

The next requirement that I found a very good use for Oracle Flashback Query came…

October 23, 2020August 18, 2009 by Mark Burgess

Oracle Database Flashback Data Pump provides the ability to perform point in time data exports…