:

The Latest Oracle Posts

ORA-39213: Metadata processing is not available

The Problem While using data pump in an Oracle 10g database, I got the following error: ORA-39006: internal error ORA-39213: Metadata processing is not available I read through a post on the Oracle forum and did what was suggested. I kicked off the job again and this time got a different error: ORA-39006: internal error ORA-39065: unexpected […]

Continue Reading

ORA-31623: a job is not attached to this session via the specified handle

ORA-31623: a job is not attached to this session via the specified handle

Oracle Version: 11.2.0.2 Patchset 10 Platform: Windows Server 2003 R2 The Problem I was attempting to execute a data pump import job which I had run numerous times before, but unfortunately this time around it didn’t seem to be working. I got the following error: ORA-31623: a job is not attached to this session via […]

Continue Reading

ORA-01704: string literal too long

While attempting to update a column in a table of data type CLOB, one of the business analysts received this error message: ORA-01704: string literal too long They were trying to update the table with a SQL statement and with a SQL statement you can only specify up to 4000 bytes. The way to get […]

Continue Reading

ORA-14400: inserted partition key does not map to any partition

The Problem Your Enterprise Manager becomes very slow and unresponsive when navigating around within the front end. It also becomes difficult to get to the performance screen for your instances. Firstly, look in the file emoms.log found in $ORACLE_OMS_HOME\sysman\log On Windows for me this was D:\oracle\oms10g\sysman\log\emoms.log In this file you should see the error ORA-14400: inserted partition key does not […]

Continue Reading

ORA-20005: object statistics are locked

When using data pump to import a set of tables and data into an Oracle 10.2.0.4 database I received the following error: ORA-20005: object statistics are locked (stattype = ALL) In order to fix the issue, I used DBMS_STATS.UNLOCK_TABLE_STATS on each table of interest before running the import command. The statement takes the arguments of […]

Continue Reading

Spool on in SQL Plus

Spool on in SQL Plus

Why? When you run a query which could potentially generate a large number of results, or just if you want a record/file of the results, you can use the SPOOL command. Spooling results from a SQL query to a file is very simple, and you can even append to an existing file in Oracle 10g […]

Continue Reading

ORA-30036: unable to extend segment by 4 in undo tablespace ‘UNDOTBS1’

One of our databases crashed recently because the disks were taken offline by mistake – fortunately, it was a development one! When I brought it back online and people started to use it, one of the developers got the following error message: ERROR at line 1: ORA-30036: unable to extend segment by 4 in undo […]

Continue Reading

Shrink the SYSAUX Tablespace in Oracle

The Problem My SYSAUX tablespace was growing large and I wanted to shrink it on a development environment. First of all I wanted to reduce how long the information was kept in the SYSUAX tablespace. There is a built in Oracle package which is used to modify the snapshot setting for the AWR repository. I […]

Continue Reading

Automatic Workload Repository (AWR)

Automatic Workload Repository (AWR)

In this post I would like to go over a really useful tool for anyone who is looking to performance tune their database, which is the Automatic Workload Repository (AWR). I’m going to cover: What the AWR is Why you would use it When you would use it How to generate AWR reports How to […]

Continue Reading

How to Restore Schema Statistics in Oracle

It’s a Monday morning and when you arrive into work and the  customers start using your application, you realise that the CPU load on the  box is very high. What’s going on? What jobs ran at the weekend? What’s  changed? One answer: you gathered fresh statistics at the weekend and some of  the explain plans […]

Continue Reading