Blog: John Hallas

210 blogs updated: 65 min. ago
Creating a database link using a tnsnames entry
I have had this in my draft posts for a couple of weeks and I refrained from publishing because it was too simple. However the main purpose ...
29-12-2017 17:25:01 John Hallas Oracle
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...
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 ...
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...
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...
21-11-2017 08:51:41 John Hallas Oracle
Managing the WINDOW_ID in Goldengate V11.
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...
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...
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-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

© 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.