If you have done any play with the latest release of Oracle database 12c, you must have come across the concept of Common and Local users....
Continue reading...internals
Checkpoint Count/SCN, What It Is ….
A question came on this thread at the OTN forums asking that what is the “Checkpoint SCN” and “Checkpoint Count” and followed by another question that...
Continue reading...Size, Yes Its Different
Some times, there is an assumption about things. And as with assumption always, its mostly not true. Still, we do believe on those assumptions and spread...
Continue reading...Redo & Undo, Partners In Crime Talked About Yet Again….
Anyone who does know about Oracle db and its working even the slightest bit would have heard about these two words for sure, Redo and Undo!...
Continue reading...Select For Update A DML, Yes It Is….
Okay, if you think that what the heck, this guy didn’t know this much even, well, its true. I didn’t know or to save myself, I...
Continue reading...Fixed Table Definitions, A New Learning….
Whenever I used to find out the info of any fixed table(x$) I used to do this by a workaround. I used to set the trace,...
Continue reading...Create Table Creating Dirty Buffers….
I always thought that the creation of table is a mere data dictionary update. I mean to say that the data dictionary , dba_tables, OBJ$ and...
Continue reading...A New Learning, IMU & Private Redo Strand….
There are very few things that I know but there are tons of things which I don’t know. I came across one more such thing like...
Continue reading...
Recent Comments