Blog: John Hallas

210 blogs updated: 14 min. ago
Oracle Cloud Total Cost of ownership Calculator – rather confusing
I was interested enough to try out the Oracle TCO calculator that I was sent an email about. I can honestly say it has rather confused me in...
01-08-2018 17:34:49 John Hallas Oracle
12C Grid – GENO process causes high CPU usage
This is an interesting bug which has affected a number of our databases perhaps because we are not patched to the latest levels in every cas...
11-07-2018 09:44:25 John Hallas Oracle
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

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