Subscriber Count

    457

Subscribe2

Pages

ANZ Free Webinar Tour – Second Wave registrations

Hello All,

The Second wave of APACOUC – IAOUG ANZ Webinars registrations open now and you have more exciting presentations to come.

And I am presenting topic Devops for Databases which details about Devops Principles to databases, why they are hard to implement, creating your own framework, strategy, approach, tools that needed for each approach […]

Quick Question : Finding Transactions on a Table

Folks! this subject line may sound silly, but most of us really think how for a moment.

Business Requirement is some want to add a column to high volatile table, So they want to understand, Does it cause issue as its high volatile and access by Website? What is the best time to add a […]

Script for Staleness Percent for each table

Ever, interested in looking for statistics staleness for each table including how much percent they stale are. The following query helps you to get you the details.

This query filter out the staleness for those tables which having more than or equal to 10%, you can adjust accordingly.

However, you will need to […]

Statistics Comparison – Handy Scripts

If you are working a production support DBA and very often you will need to check the statistics of the table and how much change what changed in each columns etc. I have figured out two ways for it and seems very useful.

Option 1:- 11gR1 has a package to show differences and comparison of […]

Flushing PGA (Private Global Area)

Does any knows about flushing the PGA?

Actually it can, not quite sure of release memory or not as it depends on high water mark (as like you try to shrink the datafile and it fails) similarly the following procedure also may not work if a memory chunk sitting at the edge of high water […]

ORA-12547: TNS: lost contact on DBCA in 12c with OEL 7 (UEK)

While running dbca we are receiving the ora-12547 and we could not able to create database using DBCA anymore.

After googling and metalink search found many notes which does not resolve the issue, the reasons can be multifold

Environments- SID, PATH, LD_LIBRARY_PATH – Not resolved Permission on oracle executable to 6751 – Not resolved Package […]

Upgrading 11gr2 to 12c using Transient logical standby – Rolling upgrade

Well, this is fairly an old topic but explored lately by me. Very big post click on read more to scroll down to full page.

Ah, I was trying to explore the upgrade from 11gr2 to 12c but not traditional way, and go these two excellent white papers.

http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-transientlogicalrollingu-1-131927.pdf

http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-upgrades-made-easy-131972.pdf

The high level overview of […]

Current_SCN how it populates?

My friend has asked this question today as he got the same in one his interview…

The common answer we give is from any base table as v$database (current_scn) is populated by any base table.

However the base table is $KCCDI under column DICUR_SCN is current SCN. you can find this by querying the v$database […]

Flashback : Guaranteed vs normal restore point

The key difference

Guaranteed restore point does not need explicitly flashback on, where in the normal restore point does Guaranteed restore point requires less I/O as compared to the normal restore point due to the fact that flashback log maintains only one copy of block image before it get modified. where in the normal […]

Quick Question: Finding fragmentation of a table having clob.

A user has posted me "how to find the fragmentation for a table that contains CLOB", ironically all the queries and other stuff will lead to confusion or no more useful.

Honestly, to answer this question I have searched many things to clear up, only Jonathan has a clear cut demonstration and answer for […]