| Posts About Oracle Database Error ORA-08179 |
| bobw: | just this past week I started to get ORA-08176 during a 9.2.0.6 database export.
The database has been running this export for a few years now with out issue.
So far I have increased the UNOD and max file size of the undo tablespace file,
but still get this error.
How can I tell if a discreet transaction
or a direct load is running in the database at the time the export is running?
|
|
| DBA: | Open PLSQL and give the following command.
show parameters undo
Could you tell us your undo_retention value ?
|
|
| bobw: | undo_management string AUTO
undo_retention integer 4500 ------IT WAS 3600 yesterday
undo_suppress_errors boolean FALSE
undo_tablespace string undotbs
fast_start_parallel_rollback string LOW
max_rollback_segments integer 30
rollback_segments string
transactions_per_rollback_segment integer 5
-rwxrwx--- 1 oracle dba 8388616192 Jan 13 09:01 undots01.dbf
--------------------------- The max file size can grow to 9gig
Now I just ran the export off the normal scheduled time and it completed with out the error (?)
|
|
| DBA: | UNDOTBS is created as an undo tablespace ?
All other values are looking as it should be.
To be sure look with
select TABLESPACE_NAME, CONTENTS from dba_tablespaces
|
|
| bobw: | Since this is a 9i database, I was wondering if when tablespace are coaleased,
indexes are rebuilt and statistics are run duing the same time window,
if this causes a problem?
UNDOTBS UNDO
|
|