Home » Infrastructure » Unix » ORA-01555 in HP-UX
ORA-01555 in HP-UX [message #157732] Sat, 04 February 2006 23:08 Go to next message
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
Re: ORA-01555 in HP-UX [message #158474 is a reply to message #157732] Sat, 11 February 2006 14:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://asktom.oracle.com

do a keyword search on ORA-01555
Re: ORA-01555 in HP-UX [message #158999 is a reply to message #157732] Wed, 15 February 2006 06:55 Go to previous message
cgk_js
Messages: 48
Registered: December 2005
Member
i have faced this error many time,
we need to trace the query running for the long time and
tune that query.
Previous Topic: Delete an oracle instance
Next Topic: Unix Shell
Goto Forum:
  


Current Time: Fri Mar 29 03:29:02 CDT 2024