Blogs

Common ORA errors

Below are some ORA-ERROR which every DBA face:

1. ORA-00600/ORA-07445
Clause: Most likely it is related to bug
Solution: go to metalink and apply patch set.

2. ORA-03113
Clause: It is generic error means lots of reason behind this.
Solution: Depends on condition but best way to search on google/forms.

3. ORA-04031
Clause: Mis-configuration of SGA, insufficient memory
Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory

Script to find Oracle database performance

articles: 

This single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical I/O, logical I/O, memory and CPU processes), Top CPU usage by users, etc.

vamsi kasina's picture

R12 - GL / XLA / FAH - Reporting Currencies

articles: 

There are three levels of reporting currencies.
Subledger, Journal and Balance.

The data will be create for those ledgers, when the following processes have been run.
Create Accounting - Journals will be created in SLA.
Transfer to GL & Journal Import - Journals will be created in GL.
Post to GL - Balances will be created / updated in GL.

11.2.0.3 Database Certified with E-Business Suite

Oracle 11.2.0.3, the second patch set for the 11gR2 database, is now certified with with E-Business Suite and is available for download in 32 and 64-bit.

You can download it from only your meta link account credential.

Patch No: 10404530

Oracle E-Business Suite Release 11i

Prerequisites

* 11.5.10.2 + ATG PF.H RUP 6 and higher

Certified Platforms

Java SE 7 OCA Training Guide

articles: 

EPractize Labs Software, an emerging global provider for Java Certification Preparation released world’s first exam study guide (Training Lab) for Oracle Certified Associate, Java SE 7 Programmer certification. Download your FREE copy today and empower your preparation.

Oracle offers variety of Java Certifications for all Java Editions (Java SE, Java EE and Java ME). Oracle Certified Associate, Java SE 7 Programmer certification provides basic knowledge required to develop a Java application.

What is EPractize Labs Java SE 7 OCA Training Lab?

Reference partitioning and partitionwise joins

articles: 

Why do you sometimes not get partitionwise joins? Because the optimizer isn't clever enough. Reference partitioning has many benefits, one of which is that the optimizer understands it. You will always get a partitionwise join if your tables are reference partitioned.

Java EE 6 EJB OCE Certification Training Lab

articles: 

Oracle offers variety of Java Certifications for all Java Editions (Java SE, Java EE and Java ME). Oracle Certified Expert, Java Platform, Enterprise Edition 6 Enterprise JavaBeans Developer (Formerly Sun Certified EJB Developer for the Java EE6 Platform (SCEJBD 6)) certification provides knowledge required to develop Java EE 6 Enterprise applications using EJB.

What exam I need to pass to achieve OCE for Java EE 6 EJB Developer Certification?

David Lozano Lucas's picture

Progress status of an index rebuild or creation, or other long operations.

articles: 

When we launch a long operation, such as a RMAN backup or rebuild of a large index, we can come to despair of not having an estimate of the time it may take. We can even come to think that is doing nothing.

For the progress of a long operation we can query the view V$SESSION_LONGOPS, first obtaining the process ID from V$SESSION. In the case of DBA, we know exactly which user is rebuilding the index, so we can simplify it into a single query.

Constraints and performance: you want as many constraints as possible

articles: 

Several times I have had to deal with people who do not want to define constraints. I have never understood why they don't, because my experience is that the more constraints you can define, the better Oracle will perform. If anyone knows where the idea that not defining constraints is a Good Thing comes from, I would be interested to know.

Following are two very simple examples of constraints allowing the optimizer to develop better plans.

Partition Exchange by Example

One of the great features about partitioning, and most specifically range-based partitioning, is the ability to load data quickly and easily with minimal impact on the current users using:

alter table call exchange partition data_2007 with table call_temp;

Pages

Subscribe to RSS - blogs