Home » RDBMS Server » Server Administration » Checkpoint Start Time & End Time
Checkpoint Start Time & End Time [message #201039] Thu, 02 November 2006 05:46 Go to next message
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
Re: Checkpoint Start Time & End Time [message #201060 is a reply to message #201039] Thu, 02 November 2006 07:09 Go to previous messageGo to next message
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.
Re: Checkpoint Start Time & End Time [message #201065 is a reply to message #201060] Thu, 02 November 2006 07:17 Go to previous messageGo to next message
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
Re: Checkpoint Start Time & End Time [message #201073 is a reply to message #201065] Thu, 02 November 2006 07:30 Go to previous messageGo to next message
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 Go to previous message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Even if you don't force it shows you only one date/time.

Regards,
qA
Previous Topic: utl_encode package body location on server
Next Topic: CUSTOMIZED AUDITING
Goto Forum:
  


Current Time: Fri Dec 09 07:59:19 CST 2016

Total time taken to generate the page: 0.04907 seconds