OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » solaris 10 (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

solaris 10 [message #341730]

Wed, 20 August 2008 02:19

dirish
Messages: 232
Registered: November 2006

Senior Member

Mon Aug 18 18:11:58 2008
Thread 1 advanced to log sequence 29916
Current log# 2 seq# 29916 mem# 0: /ora10db/oradata/ora10g/redo02.log
Mon Aug 18 18:12:14 2008
Thread 1 cannot allocate new log, sequenCheckpoint not complete Current log# 2 seq# 29916 mem# 0: /ora10db/oradata/ora10g/redo02.log
Mon Aug 18 18:12:25 2008
Thread 1 advanced to log sequence 29917
Current log# 1 seq# 29917 mem# 0: /ora10db/oradata/ora10g/redo01.log
Mon Aug 18 20:28:41 2008
Starting background process EMN0
EMN0 started with pid=22, OS id=24166

Report message to a moderator

Re: solaris 10 [message #341738 is a reply to message #341730]

Wed, 20 August 2008 02:28

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Mon Aug 11 15:30:14 2008
Setting recovery target incarnation to 1
Mon Aug 11 15:30:14 2008
Successful mount of redo thread 1, with mount id 1538524864
Mon Aug 11 15:30:14 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 11 15:30:14 2008
alter database open
Mon Aug 11 15:30:15 2008
Thread 1 opened at log sequence 580
Current log# 4 seq# 580 mem# 0: C:\ORACLE\BASES\MIKA\RL_G4_1.RDO
Current log# 4 seq# 580 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G4_2.RDO
Successful open of redo thread 1
Mon Aug 11 15:30:15 2008
SMON: enabling cache recovery
Mon Aug 11 15:30:17 2008
Successfully onlined Undo Tablespace 1.
Mon Aug 11 15:30:17 2008
SMON: enabling tx recovery
Mon Aug 11 15:30:17 2008
Database Characterset is WE8MSWIN1252
Opening with Resource Manager plan: SYSTEM_PLAN
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=2320
Mon Aug 11 15:30:24 2008
ORA-942 signalled during: alter database open...
Mon Aug 11 15:30:26 2008
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 11 22:00:08 2008
Thread 1 advanced to log sequence 581 (LGWR switch)
Current log# 1 seq# 581 mem# 0: C:\ORACLE\BASES\MIKA\RL_G1_1.RDO
Current log# 1 seq# 581 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G1_2.RDO
Tue Aug 12 02:29:36 2008
Thread 1 advanced to log sequence 582 (LGWR switch)
Current log# 2 seq# 582 mem# 0: C:\ORACLE\BASES\MIKA\RL_G2_1.RDO
Current log# 2 seq# 582 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G2_2.RDO
Tue Aug 12 07:00:37 2008
Thread 1 advanced to log sequence 583 (LGWR switch)
Current log# 3 seq# 583 mem# 0: C:\ORACLE\BASES\MIKA\RL_G3_1.RDO
Current log# 3 seq# 583 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G3_2.RDO
Tue Aug 12 16:08:18 2008
Thread 1 advanced to log sequence 584 (LGWR switch)
Current log# 4 seq# 584 mem# 0: C:\ORACLE\BASES\MIKA\RL_G4_1.RDO
Current log# 4 seq# 584 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G4_2.RDO
Wed Aug 13 02:00:55 2008
Thread 1 advanced to log sequence 585 (LGWR switch)
Current log# 1 seq# 585 mem# 0: C:\ORACLE\BASES\MIKA\RL_G1_1.RDO
Current log# 1 seq# 585 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G1_2.RDO

Report message to a moderator

Re: solaris 10 [message #341739 is a reply to message #341738]

Wed, 20 August 2008 02:32

dirish
Messages: 232
Registered: November 2006

Senior Member

I got this error in my alert.log

Do you have any idea why i got this error?

Report message to a moderator

Re: solaris 10 [message #341743 is a reply to message #341739]

Wed, 20 August 2008 02:52

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you know why I got mine?

Regards
Michel

Report message to a moderator

Re: solaris 10 [message #341755 is a reply to message #341739]

Wed, 20 August 2008 03:48

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Now do you understand what michal trying to say?

Report message to a moderator

Re: solaris 10 [message #341779 is a reply to message #341738]

Wed, 20 August 2008 05:11

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi,
Some really useful answers already posted.

Have you done any changes to the database or the application that uses the database.

regards

Alan

Report message to a moderator

Re: solaris 10 [message #341796 is a reply to message #341779]

Wed, 20 August 2008 06:09

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Some really useful answers already posted

And you add one more.

Regards
Michel

Report message to a moderator

Re: solaris 10 [message #341848 is a reply to message #341739]

Wed, 20 August 2008 09:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I got this error in my alert.log
What error?

Report message to a moderator

Re: solaris 10 [message #341882 is a reply to message #341848]

Wed, 20 August 2008 12:40

alanm
Messages: 284
Registered: March 2005

Senior Member

ora-942

Report message to a moderator

Re: solaris 10 [message #341886 is a reply to message #341882]

Wed, 20 August 2008 12:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

alanm wrote:
>> ora-942
Must be some black magic stuff as I am not seeing that from OP's posting.

That is from Michel's post, which is to make the point that there is nothing useful to start with in OP's post.

Report message to a moderator

Previous Topic:	Performance tunning
Next Topic:	Performance Issues After Migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:58:48 CST 2024