Blog: John Hallas


209 blogs updated: 12 min. ago
ORA-01450: maximum key length (3800) exceeded
This is an oddity as essentially I have an index on a table but I cannot rebuild it because it suggests the block size should be bigger than...
7
13-12-2017 10:55:16 John Hallas Oracle
How to add a metric extension and use a ‘control' table to test results
I have previously blogged about creating a User Defined Metric (UDM) before (7 years ago!) but the method I am using today demonstrates how ...
19
27-11-2017 12:22:50 John Hallas Oracle
DBA vacancy Bradford, West Yorkshire
I have a vacancy in my team and the details are in the link below database.html Lots of interesting work going including 85Tb Data Warehouse...
23
24-11-2017 10:01:25 John Hallas Oracle
Baselines – session creating privs v session running privs
A colleague Richard Wilkinson was telling me about an issue he had come across with baselines and I asked him to write it up as it was an in...
12
21-11-2017 08:51:41 John Hallas Oracle
Managing the WINDOW_ID in Goldengate V11.2.1.0.33
When we import data into the landing schema on a Dat Warehouse via Goldengate, we add 3 fields to each record detailing when and how the rec...
17
16-08-2017 12:02:13 John Hallas Oracle
HP Systems Management vacancy
I know I do not have the right readership on this blog for a Systems Management vacancy but if any readers have colleagues who have experien...
22
08-08-2017 11:47:53 John Hallas Oracle
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
20-06-2017 09:34:39 John Hallas Oracle
Downgrading a RAC database from 11.2.0.4 to 11.2.0.4
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...
22
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...
36
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...
23
04-04-2017 12:44:45 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.