Robert Jackson

Having studied a generic Business Computing degree at university, I was fortunate to do my work placement as an Oracle DBA. I enjoyed the challenges of the job and found that my skills were suited to it, also.
Since graduating with a 1st class honours degree in Computing - Database Systems, I have worked my way up from a Junior Oracle DBA to a DBA Team Leader.

rss feed Author's Website

Robert Jackson's Latest Posts

Invalid SYS Objects after 10g to 11g Upgrade

The Problem When upgrading from to, and applying the latest patchset, which was patchset 8 at the time of writing this, I found there to be several invalid objects in the SYS schema. I raised an SR with Oracle support who informed me that I could drop these objects because they were no […]

Continue Reading

Duplicate SYS Objects after 11g Upgrade

Duplicate SYS Objects after 11g Upgrade The Problem After an 11g upgrade you see the following presented to you: =================================================== Number of Duplicate Objects Owned by SYS and SYSTEM =================================================== Counting duplicate objects …. COUNT(1) ———- 4 ========================================= Duplicate Objects Owned by SYS and SYSTEM ========================================= Querying duplicate objects …. OBJECT_NAME                      OBJECT_TYPE ——————————-  ——————- AQ$_SCHEDULES                   […]

Continue Reading

11g High Version Count – Bind Mismatch

The Problem While running Oracle version I noticed that there were a high number of SQL statements which had a high version count. The CURSOR_SHARING parameter was set to FORCE. When looking in V$SQL_SHARED_CURSOR you will see a Y in the column BIND_LENGTH_UPGRADEABLE. The Cause The reason for this happening is described in detail in […]

Continue Reading