On popular demand from our newbie DBA readers, I am starting Oracle Database Back to Basics series where I am going to cover basic concepts and Architecture of Oracle Database (9i, 10g, 11g)
Today’s post is dedicated to logical storage component of Oracle Database i.e. Data Blocks, Extents and Segment
A. Data Blocks is smallest logical unit […]

Popularity: 17% [?]

continue reading.....

We are looking for part time/full time consultants in following domain, if you have necessary skills please forward your CV to email id cv @ focusthread.com   ( cv  at focusThread dot com)
- Oracle Data Mining : Consultant with minimum three years experience on Oracle 9i/10g Data Mining feature
- Oracle SOA Suite : Developers/Administrators with exposure to BPEL, ESB, […]

Popularity: 9% [?]

continue reading.....

In Oracle Applications 11i & R12 (12i) all the configuration parameters are captured in two context files:
Application context file called the <CONTEXT_NAME>.xml contains the configuration information for the application tier & is located in $APPl_TOP/admin for each node of application tier.
Database context file called the <CONTEXT_NAME>.xml contains the configuration information for the database tier & […]

Popularity: 17% [?]

continue reading.....

Application Server Control : is application used to maintain Oracle Application Server. Using Application Server Control, you can 
- Start/Stop Services of Oracle Application Server (OC4J, HTTP, Web Cache, OID, SSO..)
- Configure components of OAS (Oracle Application Server)
- Manage/edit users credentials, configuration file, port number
- Monitor performance & Usages …

Start/Stop Application Server Control :

Prior to Oracle Application Server […]

Popularity: 17% [?]

continue reading.....

 oradebug iutility s especially useful when  things go very bad for example Database hangs,Due to ORA-00600 error your database is crashing frequently, Database just not responding (stop). With oradebug you can see very close view database engine. Oracle Customer support use the utility mainly to debug these issues. You should have sysdba privilege to run this […]

Popularity: 13% [?]

continue reading.....

Patch is a program to fix a particular problem or enhance/add a particular feature in existing program/product/software.
In Oracle to apply database patch we use ‘opatch‘ ($ORACLE_HOME/OPatch) where as in order to apply applications patch we use ad utility ‘adpatch‘ ($AD_TOP/bin).
For Basic Apps patches terminology & other related details please refer to the following links:
http://onlineappsdba.com/index.php/2006/08/10/oracle-apps-patch-basics/
http://onlineappsdba.com/index.php/2006/08/11/oracle-apps-patch-basics-ii/
 Before going […]

Popularity: 17% [?]

continue reading.....

Source: Oracle Documentations
It is possible to transfer statistics between servers allowing consistent execution plans between servers with varying amounts of data. First the statistics must be collected into a statistics table. In the following examples the statistics for the APPSCHEMA user are collected into a new table, STATS_TABLE, which is owned by DBASCHEMA:
  SQL> EXEC […]

Popularity: 9% [?]

continue reading.....