There is a lot of change that release 12.1 or 12c has brought up. And it’s not in the more advanced new features that I am talking about but even in some areas about which, we have memorized a particular concept by heart from last many years. Once such change is what I am going … [Read more…]
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 them as well , not caring that it may happen that the things are not the way you know them or have read them anywhere! I had a similar … [Read more…]
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 would say, I did know what Select For Updat does , like it locks the rows and so on, but didn’t relate to the redo part. So when I … [Read more…]
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, run the query and see the table’s name. For example, if we are looking for the V$log’s fixed table name so I would do something like that , SQL> … [Read more…]
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 this few days ago when this question (http://forums.oracle.com/forums/thread.jspa?messageID=2713561�) came over OTN. Interestingly, what the OP mentioned was indeed true and I was not having a clue what’s going on. Like … [Read more…]