Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Replay error

845641May 12 2012 — edited May 12 2012
Please help me experts
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

[oracle@localhost ~]$ wrc system/manager mode=calibrate replaydir=/u01/app/cap

Workload Replay Client: Release 11.2.0.1.0 - Production on Tue Jul 17 17:50:09 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


Report for Workload in: /u01/app/cap
-----------------------

Recommendation:
Consider using at least 1 clients divided among 1 CPU(s)
You will need at least 33 MB of memory per client process.
If your machine(s) cannot match that number, consider using more clients.

Workload Characteristics:
- max concurrency: 9 sessions
- total number of sessions: 15

Assumptions:
- 1 client process per 50 concurrent sessions
- 4 client process per CPU
- 256 KB of memory cache per concurrent session
- think time scale = 100
- connect time scale = 100
- synchronization = TRUE

[oracle@localhost ~]$ wrc system/manager mode=replay replaydir=/u01/app/cap

Workload Replay Client: Release 11.2.0.1.0 - Production on Tue Jul 17 17:50:31 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


Wait for the replay to start (17:50:31)
Replay started (17:50:41)
Errors in file :
ORA-15558: replay thread encountered unexpected error

_________________________________

Alert log does not show enough detailed information..

[oracle@localhost ~]$ tailf /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
space available in the underlying filesystem or ASM diskgroup.
Tue Jul 17 17:47:26 2012
alter database datafile 4 resize 400m
Completed: alter database datafile 4 resize 400m
Tue Jul 17 17:50:41 2012
DBMS_WORKLOAD_REPLAY.START_REPLAY(): Starting database replay at 07/17/2012 17:50:41
Tue Jul 17 17:51:23 2012
Starting background process SMCO
Tue Jul 17 17:51:23 2012
SMCO started with pid=20, OS id=25453
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2012
Added on May 12 2012
2 comments
874 views