Oracle

  1. Home
  2. Oracle
    3. (
  3. Page 12
    4. )
by Team Ajara

Query Performance issue n solution with profile

Pinning the plan hash value in Oracle Database to resolve performance issue. Overview of the issue Query was running slow in Datawarehouse database .Resolved by creating sqlprofile using coe_xfr_sql_profile.sql script.
by Team Ajara

Oracle DB Performance Issue n solution with sqltrpt

Oracle Query Performance issue and solved by accepting sql profile.   Overview of the issue Oracle Query from application running was slower than the previous execution. DB version is 12.1.0.2.0
by Team Ajara

Checklist for Successful Implementation of DB Change

Checklists for Oracle Database change requests(CRs).   Pre-Implementation Checks 1)       OS/Database/schema valid Backups to be taken before the activity  Check if OS/Database/schema valid Backups have been taken (Y / N)
by Team Ajara

Flashback RAC database to restore point

Flashback RAC database to restore point. While doing flashback RAC DB we will start one instance in mount and another instance will be in shutdown state. High Level Steps 1)select
by Team Ajara

How to add new disks in ASM Diskgroup

Adding new Disks in ASM DiskGroup   Get the LUN #/ name from the Unix/storage team,and follow the below steps. Step 1 :List the mapper details # cd /dev/mapper/ #
by Team Ajara

Distributed Relational Database Architecture setup

Distributed Relational Database Architecture(DRDA) setup.   1.Download the software from oracle support. : LINUX.X64_193000_gateways.zip oracle@AppsServer:/u00 $ ls -ltr -rwxrwxrwx 1 oracle dba 1007154302 Apr 1 06:37 LINUX.X64_193000_gateways.zip 2. Unzip the
by Team Ajara

Script to get DDL of the Database Links

Script to get DDL of the Database Links.   To get DDL of all the DB links in the database SELECT ‘alter session set CURRENT_SCHEMA=’||U.NAME||’;’ ||CHR(10)|| ‘CREATE ‘ || DECODE
by Team Ajara

Disable Oracle database on RAC nodes

Disable Oracle database on RAC nodes One database with two instances were there  on two nodes in the full RACK Exadata(8 compute nodes). Want to disable the database as per
by Team Ajara

ORA-12850: Could not allocate slaves on instances

ORA-12850: Could not allocate slaves on all specified  instances : 2 needed , 0(Zero) allocated   Cause There is a new feature in 12C called “Automatic Report Capturing Feature”. As