Home » RDBMS Server » Server Administration » checkpoint doesn't work (Oracle 12C windows 7)
checkpoint doesn't work [message #660468] Fri, 17 February 2017 12:14 Go to next message
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.
Re: checkpoint doesn't work [message #660470 is a reply to message #660468] Fri, 17 February 2017 13:13 Go to previous messageGo to next message
John Watson
Messages: 7620
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.
Re: checkpoint doesn't work [message #660514 is a reply to message #660468] Mon, 20 February 2017 03:25 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
You might want to familiarise yourself with Oracle Database Concepts.
Re: checkpoint doesn't work [message #660516 is a reply to message #660514] Mon, 20 February 2017 03:41 Go to previous messageGo to next message
Roachcoach
Messages: 1571
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.
Re: checkpoint doesn't work [message #660518 is a reply to message #660516] Mon, 20 February 2017 03:52 Go to previous messageGo to next message
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.
Re: checkpoint doesn't work [message #660519 is a reply to message #660518] Mon, 20 February 2017 03:59 Go to previous message
John Watson
Messages: 7620
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.
Previous Topic: FRA Space Claim for Flashback Logs
Next Topic: Client setup
Goto Forum:
  


Current Time: Sun Oct 21 18:41:58 CDT 2018