New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

ORA-00600: internal error code, arguments: [13030], [20],

Learnt new thing today, thanks to my colleague Gagan.

Alert log showing this error, whilst checking the trace shows an update statement into a table which is capturing the sid,serial# from gv$session.

So then why ora-600, As per metalink note:- Ora-00600 [13030], [20] During Update Statement Using V$ tables [ID 1400439.1]

For updates we use […]

March 12th, 2013 | Tags: | Category: Internals | 5 comments - (Comments are closed)

Resolving Library cache: mutex X

According to notes 9282521.8 and 9239863.8 describing the patches, the enhancements should be used: When there is true contention on a specific library cache object….

For example:- A package that is so hot (heavily accessed ) in library cache will be contended and the sessions appear to be waited on Library Cache: mutex X.

There […]

February 14th, 2013 | Tags: , , | Category: Internals | 3 comments - (Comments are closed)

Buffer states: How many consistent read (cr) clones in buffer cache, verified.

We all know to maintain the consistency of the buffers and its integrity oracle has to clone the current copy of the buffer to consistent read and change the latest one. There are different buffer states in x$bh column out of all our interest to this post is only to cr and xcur.

First lets […]

January 14th, 2013 | Tags: , , | Category: Internals | 2 comments - (Comments are closed)

Oracle SCN: Many SCN’s ? Explained here!

How many types of SCN, well the better question would be how many places the SCN is stored.

Well, there are not MANY types of SCN which are there actually but stored many places with different names and different purposes.

The SCN will be only one number, a incremented value of every 3?(5 seconds […]

January 8th, 2013 | Tags: , | Category: Internals | One comment - (Comments are closed)

Internals: Control File Records

What kind of records that control file maintains in Oracle database?

Lets have a look.

SQL> oradebug setmypid Statement processed. SQL> oradebug unlimit; Statement processed. SQL> alter session set events ‘immediate trace name controlf level 9’; Session altered. SQL> oradebug tracefile_name; /home/oracle/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_ora_1238.trc SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit […]

November 10th, 2012 | Tags: | Category: Internals | Comments are closed