Oracle Certification is among the most popular and most highly rated certifications worldwide. A lot of people write different exams and there are many many so far who have got certified. I am asked a question many times that how one should prepare for it and is it really worth to prepare for it as … [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…]
I am always in the favour of certifications. The reason for this is that certifications give one a confidence, a trust that he/she has done somethign good, some thing which really does prove that he/she is serious enough to be current with the ever changing technology. I don’t think that we should take the certification … [Read more…]
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 other similar ones would get updated when we create a table. The logic was that its just a definition so where else it would be going? Its correct too … [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…]
I have just configured a plugin to push the blog posts to come over Twitter! So if you are seeing this as a tweet , that plugin is plugged in correctly 🙂 .
Lot of times this question is asked that how one can be a good dba( I am looking forward to become one myself) and the answers are standard only like, train yourself constantly, look for new technologies and test/play with them, document your stuff, be proactive and so on. The answers depend upon from person … [Read more…]
Well, here comes one more blog of mine and this time, I hope its going to stay here. I have been shuffling things a lot and so far, I have not been able to fix upon the place where I shall write about the encouters of mine with Oracle database. There is surely another blog … [Read more…]