Blog: John Hallas

208 blogs updated: 2 min. ago
Using DataGuard broker to show apply lag and throughput
To determine how much lag there is I normally run a script similar to this select sequence#, applied, to_date(to_char(first_tim e,'DD-MON-YY...
20-06-2017 09:34:39 John Hallas Oracle
Downgrading a RAC database from to
It is not often that I see a database downgrade activity performed and so I thought it would be worthwhile just noting how it was done. 2 no...
04-05-2017 09:19:05 John Hallas Oracle
What is the future for an Oracle DBA?
I have worked with Oracle databases for around 25 years now and during that time I have been very fortunate in that there has always been wo...
10-04-2017 10:40:19 John Hallas Oracle
GoldenGate – Restarting a replicat with the command filterduptransactions
If a Goldengate replicat process fails then occasionally on the restart it skips the correct RBA and loses it's position'. The relative byte...
04-04-2017 12:44:45 John Hallas Oracle
Problem with V$RECOVERY_AREA_USAGE view and FRA space not being reclaimed
We received the following alert from our alerting system Flash Recovery Area for FOLPRD1A has 9.97 percent of usable space left. This is a s...
16-03-2017 15:35:49 John Hallas Oracle
Xmas day -150 hits. What is wrong with the world
Yes, very tongue in cheek. I know everyone does not celebrate Xmas. I was still surprised though. This is what was viewed Best wishes for 20...
30-12-2016 21:42:34 John Hallas Oracle
RMAN checksyntax function
I was looking at the RMAN DEBUG options and came across the CHECKSYNTAX function which I had not used before. Firstly a quick recap on the D...
29-12-2016 10:22:03 John Hallas Oracle
Performance problems with OEM AWR warehouse
The Enterprise Manager AWR Warehouse is designed to hold performance data from multiple databases for long-term analysis. It promoses that i...
20-12-2016 11:52:14 John Hallas Oracle
Reorganising data within tablespaces
I am currently interested in managing storage on our Exadata platform which is primarily used for running a data warehouse. The ongoing chal...
19-12-2016 13:25:22 John Hallas Oracle
Resolving two errors on Datapump export – parameter cluster=N/Y
I attempt to export a table with 76,000 rows using a relatively standard datapump command expdp schemas=ODI_TEMP cluster=y directory=MCB con...
05-12-2016 10:23:16 John Hallas Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.