Subscribe to Posts by Email

Subscriber Count

    696

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

Administration: Change of Varchar2 to 32K

Oracle has made a few changes to the database to allow organizations to reduce the cost of migrating to Oracle 12c.  One of these changes is with the size limits that have been placed on the VARCHAR2, NVARCHAR2 and RAW data types.  In past versions of Oracle database the maximum size for these data types […]

Quick referenc of Index coalesce and rebuild

Hello,

If some one asks you about difference between Rebuild and coalesce indexes, here is the short list of the same.

Rebuild Index Coalesce Index Quickly moves index to another tablespace Cannot move index to another tablespace Higher costs: requires more disk space Lower costs: does not require more disk space Creates new tree, shrinks […]

12c is out now in oracle site too

Here you go,

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

I love to see the documentation first.

Started downloading

12c database available for download

Linux version 12.1.0.1 is available for download at edelivery.oracle.com

Does index unusable drops the storage segment?

Answer 10g No, 11gR2 Yes

10g:-

SQL> select * from v$version;

BANNER ——————————————————- Oracle Database 11g Release 10.2.0.5.0 – Production PL/SQL Release 10.2.0.5.0 – Production CORE    10.2.0.5.0      Production TNS for 32-bit Windows: Version 10.2.0.5.0 – Production NLSRTL Version 10.2.0.5.0 – Production

SQL> create table test as select rownum id, ‘TEST’ name from […]

11g Archive backups

Have you ever heard of archive backups in 11g, if not here it is,

Normally to make sure that database can be brought up from a particular backupset rman will retain all archived redo logs as well which are necessary.

This happens because rman also considers the option that you may want to consider […]

11g: Restore point preserve?

In 11g there are two major enhancements to restore points

1. Create restore point as of scn, until 10g you can create a restore point with current scn only

SQL> create restore point p1 as of scn 19393930;

2. Preserve the restore points

SQL> create restore point p1 preserve;

The second point above need […]

12c database architecture

Got this architecture diagram from the internet for 12c database

 

Source:-

Some explanation according to my understanding:-

1) Oracle SGA is shared between multiple databases called Pluggable databases (PDB)

2) A root database called container database which holds all the Oracle dictionary globally (CDB) shareable across PDB’s

3) Listener registers both CDB instance […]

Archive missing ? Recover standby using roll forward standby with incremental backup

Here is the step by step document for recovering the standby if archive is missing and not recoverable, using a feature called rollforward standby using incremental backup introduced in 10g.

1) After recovery in step above login to sqlplus and get the current scn from standby database;

SQL> col CURRENT_SCN format 999999999999

SQL> select current_scn […]

SQL_ID missing in dba_hist_sqlstat? Why

We have got into a trouble today with dba_hist_sqlstat when we are working on a performance issue.

This performance issue is about a statement that running very slow compared to its previous run of 20 mins. Thats another story.

As this story continues yesterday and today, we found our sql statement comfortably in v$sql […]