| ORA-01555 in HP-UX [message #157732] |
Sat, 04 February 2006 23:08  |
kevler
Messages: 1
Registered: February 2006
|
Junior Member |
|
|
Node type :HP 9000 PA-RISC
Severity :warning
Message :alert_HCMPRD.log ORA-01555 caused by SQL statement below (Query Duration=36090 sec, SCN: 0x0000.327f1379):
Msg Group :Ora_Admin
Application :Oracle
Object :alert_HCMPRD.log
Event type :NoCMA
Instance name :<$option(dbname)>
Instruction :Probable Cause:
There can be several possible causes:
(1) Not enough Rollback Segments
Rollback data is not available, therefore a query may not be
able to reconstruct the snapshot of the blocks it is reading.
When there are are lots of transactions that are writing data
and then committing or rolling back, then it is possible that
rollback data can be overwritten, if the rollback segments are
too small for the volume and size of changes being made.
(2) Not enough Rollback Segments (Precompiler)
Rollback data is not available, therefore a query may not be
able to reconstruct the snapshot of the blocks it is reading.
This can happen when a program does not CLOSE a cursor after
repeated FETCH or UPDATE statements, or when a FETCH is executed
after a COMMIT. Available rollback segments will be filled and
then earlier records will start to be overwritten.
(3) Not enough Checkpoints (Trusted Oracle)
This error can occur when the time interval between checkpoints
in a secondary database is too short. In this case rollback segments
may be overwritten.
Suggested Action:
(1) Not enough Rollback Segments
Increase the number and size of available rollback segments
(2) Not enough Rollback Segments (Precompiler)
Ensure that cursors are being CLOSED where necessary. If necessary,
increase the number and size of rollback segments. A good estimate
of the amount of rollback data that your program will create can be
obtained as follows:
- set the current transaction to a rollback segment in single
user mode
- query V$ROLLSTAT before and after the transaction
- the difference in V$ROLLSTAT provides the number of bytes of
rollback data written by a transaction
- estimate the number of transactions to be executed in a loop
(3) Not enough Checkpoints (Trusted Oracle)
Decrease the value of the LOG_CHECKPOINT_TIMEOUT initialization parameter
p/s please tell me ..what i should do to resolve this problem ..i try seek and google ..but i found nothing
cheers
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
