Blocks , Extents, Segments in Oracle Database : Back to Basics
On popular demand from our newbie DBA readers, I am starting Oracle Database Back to Basics series where I am […]
Uncategorized
January 2008
Uncategorized
Oracle Data Mining and Oracle SOA Suite Job
We are looking for part time/full time consultants in following domain, if you have necessary skills please forward your CV to email
Uncategorized
Autoconfig in Oracle Apps 11i / R12 / 12i
In Oracle Applications 11i & R12 (12i) all the configuration parameters are captured in two context files: Application context file
oem
Enterprise Manager – iAS Console : Changes in 10.1.3
Application Server Control : is application used to maintain Oracle Application Server. Using Application Server Control, you can – Start/Stop Services
Uncategorized
ORADEBUG – Oracle Utility
oradebug iutility s especially useful when things go very bad for example Database hangs,Due to ORA-00600 error your database is
patching
Oracle PATCHING : adpatch , Maintenance Mode
Patch is a program to fix a particular problem or enhance/add a particular feature in existing program/product/software. In Oracle to
Uncategorized
Performance – Transfering Stats 11i
Source: Oracle Documentations It is possible to transfer statistics between servers allowing consistent execution plans between servers with varying amounts
scripts
Collection of Queries/Scripts
1)How to check if the partitions of a table are set to LOGGING select partition_name, logging from dba_tab_partitions where table_name=’WF_LOCAL_ROLES’;
Uncategorized
Tables Used by Purge Concurrent Request Concurrent Program
Source: Oracle Documentations Log and Output files retention policy can be controlled by you at o/s level. Once you decide
scripts, workflow
Collection of Workflow Administration Scripts and/or Concurrent Program
Workflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and/or Concurrent Program. 1. FNDWFPR For