OraFAQ Forum: Server Administration » checkpoint doesn't work

Home » RDBMS Server » Server Administration » checkpoint doesn't work (Oracle 12C windows 7)

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

checkpoint doesn't work [message #660468]

Fri, 17 February 2017 12:14

scania113
Messages: 2
Registered: February 2017

Junior Member

hello,

I tried to test the checkpoint, so I set the value of the log_checkpoint_timeout parameter to 30 seconds, then I made a table update request, after waiting several minutes no changes were made to the table.
I then triggered a manual checkpoint by doing alter system chechpoint, still nothing on the table ....
And I would like to know if I forgot a step

thank you in advance.

Report message to a moderator

Re: checkpoint doesn't work [message #660470 is a reply to message #660468]

Fri, 17 February 2017 13:13

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Are you confusing a database checkpoint with a COMMIT? THere is no relationship between checkpointing and executing SQL.

Report message to a moderator

Re: checkpoint doesn't work [message #660514 is a reply to message #660468]

Mon, 20 February 2017 03:25

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You might want to familiarise yourself with Oracle Database Concepts.

Report message to a moderator

Re: checkpoint doesn't work [message #660516 is a reply to message #660514]

Mon, 20 February 2017 03:41

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

I would not touch that parameter with a barge pole especially if you're not sure what it controls.

Report message to a moderator

Re: checkpoint doesn't work [message #660518 is a reply to message #660516]

Mon, 20 February 2017 03:52

scania113
Messages: 2
Registered: February 2017

Junior Member

Thank you all for your reply.

When looking at the following definition on the link : http://www.orafaq.com/wiki/Checkpoint

It is clear that the checkpoint allows to save the modified blocks on the SGA to the data files.

So the checkpoint has virtually the same effect as a commit.

Report message to a moderator

Re: checkpoint doesn't work [message #660519 is a reply to message #660518]

Mon, 20 February 2017 03:59

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

The article to which you have linked does not mention COMMIT. I think you are under the impression that COMMIT forces a write to the datafiles? It doesn't. This is not a SQL Server, you know; Oracle uses much cleverer algorithms to ensure data integrity without compromising performance.

Ypou hasve to read that Concepts Guide gazzag suggested.

Report message to a moderator

Previous Topic:	FRA Space Claim for Flashback Logs
Next Topic:	Client setup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 04:11:05 CST 2024