Tagged: DBA Toggle Comment Threads | Keyboard Shortcuts

  • Sachin Thapa 15:00 on April 12, 2016 Permalink | Reply
    Tags: , , DBA, index, indexes, , rebuild   

    Know when to rebuild indexes 


    An Oracle server index is a schema object that can speed up the retrieval of rows by using a pointer.

    You can create indexes on one or more columns of a table to speed SQL statement execution on that table. If you do not have an index on the column, then a full table scan occurs.

    (More …)

  • Sachin Thapa 07:38 on May 10, 2015 Permalink | Reply
    Tags: , , DBA,   

    Search for duplicate SQL 

    Script for searching duplicate SQL

    (More …)

  • Sachin Thapa 07:20 on May 10, 2015 Permalink | Reply
    Tags: , , DBA, ,   

    Script for space usage of data files 

    Script Description: Reports the space usage of data files.

    (More …)

  • Sachin Thapa 07:16 on May 10, 2015 Permalink | Reply
    Tags: , , DBA, ,   

    DB size report 

    To find out DB size report use below script

    (More …)

  • Sachin Thapa 18:24 on May 7, 2015 Permalink | Reply
    Tags: DBA,   

    Useful DBA Scripts 

    We will start posting useful scripts for DBAs from Monday Onwards !!

    Happy Sharing!


  • Sachin Thapa 17:13 on February 13, 2015 Permalink | Reply
    Tags: DBA, ,   

    GoldenGate – Installation (Oracle 11g on Linux) 

    This example will illustrate the installation of Oracle GoldenGate on an RHEL 5 platform. We had in an earlier post discussed the architecture and various components of a GoldenGate environment.

    GoldenGate software is also available on OTN but for our platform we need to download the required software from the Oracle E delivery Website

    Select the Product Pack “Oracle Fusion Middleware” and the platform Linux X86-64.

    Then select “Oracle GoldenGate on Oracle Media Pack for Linux x86-64″ and since we are installing this for an Oracle 11g database, we download “Oracle GoldenGate V10.4.0.x for Oracle 11g 64bit on RedHat 5.0″

    (More …)

  • Sachin Thapa 17:05 on February 13, 2015 Permalink | Reply
    Tags: , DBA, ,   

    GoldenGate – Concepts and Architecture 

    GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the exchange and manipulation of data at the transactional level between a variety of database platforms like Oracle, DB2, SQL Server, Ingres, MySQL etc.

    It can support a number of different business requirements like:

    • Business Continuity and High Availablity
    • Data migrations and upgrades
    • Decision Support Systems and Data Warehousing
    • Data integration and consolidation (More …)
  • Sachin Thapa 12:36 on February 8, 2015 Permalink | Reply
    Tags: , DBA, ,   

    Guess Who’s Back? The Return of Optional Downtime in Oracle EBS 12.2.4 

    It’s back, as if it never left! I’m referring to “downtime”, brought back in ORACLE EBS 12.2.4 ! The Oracle EBS community are like the hardcore Star Wars fans – they loudly say what they think on every forum and to every live microphone. And they clearly missed patching downtime.

    Oracle EBS 12.2.4

    I think they were right and here’s why.

    No Downtime Isn’t the Perfect Bride

    Online patching is great for many reasons: no loss of business time, no need to work nights and weekends during the downtime window, and more. But, the no downtime has some downsides – it takes up a lot more disk space and adds extra steps and time to the patching cycle; IT managers need to create a Patch Edition in the database, apply the patch to the Patch Edition, perform a clean-up process at the end of the cycle, and more.

    For non-production environments (i.e. development, testing) there’s (More …)

  • Sachin Thapa 12:31 on February 8, 2015 Permalink | Reply
    Tags: , DBA, ,   

    ADOP (R12.2 Online Patching) 

    Online patching is the most important new feature in Oracle EBS 12.2. It is the ability to patch a running system without having to take the system down for a significant period of time while the patches are applied. Even you can apply Maintenance Pack 12.2.2 or 12.2.3 or 12.2.4 once you install or upgrade to R12.2.0 base.

    • It will enable R12.2 PATCH Environment.
    • Dependancy on opatches. All Opatches must be applied before enabling ADOP.
    • Missing Opatches will be reported by EBS DB CodeLevel Checker script.
    • All AD_ZD packages should be valid before enabling them (More …)
  • Sachin Thapa 12:06 on November 22, 2014 Permalink | Reply
    Tags: , , DBA, , , Oracle Installation   

    Oracle Installation with screenshots 

    Oracle is very simple to install, it can be installed on a number of different operating systems. Basically when on installing on to a Unix server a number of pre-install steps must be taken before you install Oracle.

    The minimum disk and memory requirements are 1.5-2GB of disk space and at least 256MB RAM, however for more serious applications you would need a lot more than this (8GB – 32GB are not uncommon).

    As with any software you should consult the documentation for best practices and to get the best performance out of the software, Oracle is no different in that a good installation plan is required before you attempt to install and configure Oracle, however i will not explain how to do this, it would be best left to the Oracle documentation, which i highly recommend you read, especially the installation documentation and with each different Oracle version different settings are required.

    What i will attempt to cover is how to install Oracle on a very basic system using mostly the default setting which is ideal if you are just starting out as a junior Oracle DBA, i will not explain how to setup Windows or VMware there is plenty of documentation on the web.

    Oracle Flexible Architecture

    Oracle recommends a disk layout methodology which is called the Oracle Flexible Architecture (OFA), it helps to layout the directory structure so that multiple versions of oracle can run in harmony and to define a standard so that Oracle support can help more efficiently. These are only recommendations and you do not have to follow them, however the OFA was designed to minimize disk contention, to set a standard layout and to improve overall database performance. (More …)

Compose new post
Next post/Next comment
Previous post/Previous comment
Show/Hide comments
Go to top
Go to login
Show/Hide help
shift + esc