OraFAQ Forum: Server Administration » Checkpoint Start Time & End Time

Home » RDBMS Server » Server Administration » Checkpoint Start Time & End Time

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

Checkpoint Start Time & End Time [message #201039]

Thu, 02 November 2006 05:46

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi All,
I was told that set log_checkpoints_to_alert=true in the parameter file would record checkpoint start time & end time.

I have set log_checkpoints_to_alert=true in the init.ora

sql>show parameter log_checkpoints_to_alert;
NAME                       TYPE        VALUE
--------------------- ----------- ------------------------------
log_checkpoints_to_alert  boolean     TRUE

sql>host

$cd $ORACLE_HOME/admin/*/bdump

$>alert_SID.log

$exit

sql>alter system checkpoint;

sql>exit

$cat alert_SID.log

Thu Nov  2 16:13:15 2006
Beginning global checkpoint up to RBA [0x6ff.954d.10], SCN: 0x0000.5ab341b8
Completed checkpoint up to RBA [0x6ff.2.10], SCN: 0x0000.5ab31432
Completed checkpoint up to RBA [0x6ff.954d.10], SCN: 0x0000.5ab341b8

The above alert_SID.log does not show the start time & end time of the checkpoint.

Do I need to set any other parameters other than this log_checkpoints_to_alert ?

Thanks in advance.
qA

Report message to a moderator

Re: Checkpoint Start Time & End Time [message #201060 is a reply to message #201039]

Thu, 02 November 2006 07:09

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

Senior Member

SQL> alter system set log_checkpoints_to_alert  = true;

System altered.

SQL> alter system checkpoint;

System altered.

Alertsid.log file contents.

[B]Thu Nov 02 17:04:33 2006[/B]
ALTER SYSTEM SET log_checkpoints_to_alert=TRUE SCOPE=BOTH;
[B]Thu Nov 02 17:04:52 2006[/B]
Beginning global checkpoint up to RBA [0x2b.259.10], SCN: 1807832
Completed checkpoint up to RBA [0x2b.259.10], SCN: 1807832

When parameter value is false.

SQL> alter system set log_checkpoints_to_alert  = false;

System altered.

SQL> alter system checkpoint;

System altered.

Alertsid.log file contents
Thu Nov 02 17:07:31 2006
ALTER SYSTEM SET log_checkpoints_to_alert=FALSE SCOPE=BOTH;

hope this helps.
Mohammad Taj.

Report message to a moderator

Re: Checkpoint Start Time & End Time [message #201065 is a reply to message #201060]

Thu, 02 November 2006 07:17

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi Mohammad,
Thanks for the update. I could see the difference in both the cases. But the alert log does not show the start time & end time of the checkpoint.

I could see two date/time values in your alert log. I don't think they pertains to checkpoint start time and checkpoint end time.

[B]Thu Nov 02 17:04:33 2006[/B]
ALTER SYSTEM SET log_checkpoints_to_alert=TRUE SCOPE=BOTH;
[B]Thu Nov 02 17:04:52 2006[/B]
Beginning global checkpoint up to RBA [0x2b.259.10], SCN: 1807832
Completed checkpoint up to RBA [0x2b.259.10], SCN: 1807832

Regards,
qA

Report message to a moderator

Re: Checkpoint Start Time & End Time [message #201073 is a reply to message #201065]

Thu, 02 November 2006 07:30

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

Senior Member

Thu Nov 02 17:04:33 2006
ALTER SYSTEM SET log_checkpoints_to_alert=TRUE SCOPE=BOTH;[/i]
Above first time indicate :"alter system set log_check...setting":

*********************
Thu Nov 02 17:04:52 2006
Beginning global checkpoint up to RBA [0x2b.259.10], SCN: 1807832
Completed checkpoint up to RBA [0x2b.259.10], SCN: 1807832

And above 2nd time is Checkpoint start and end timing.
i am not sure but i am force to oracle for checkpoint that there is not activity on my database. Bcoz of this it will show only one value.

Hope this Helps
Mohammad Taj.

[Updated on: Thu, 02 November 2006 07:31]

Report message to a moderator

Re: Checkpoint Start Time & End Time [message #201074 is a reply to message #201073]

Thu, 02 November 2006 07:37

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Even if you don't force it shows you only one date/time.

Regards,
qA

Report message to a moderator

Previous Topic:	utl_encode package body location on server
Next Topic:	CUSTOMIZED AUDITING

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:26:38 CDT 2024