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 […]
Read MoreWe 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 […]
Read MoreIn 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 […]
Read MoreApplication 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 […]
Read Moreoradebug 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 […]
Read MorePatch 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 […]
Read MoreSource: 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> […]
Read More1)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’; 2)How to Correct Session Cookie Name. a)select session_cookie_name from icx_parameters; b)update icx_parameters set session_cookie_name = ‘<hostname_sid>’; c)select session_cookie_name from icx_parameters; 3) How to find database SID from a Concurrent request. column process heading “FNDLIBR PID” […]
Read MoreSource: Oracle Documentations Log and Output files retention policy can be controlled by you at o/s level. Once you decide the retention policy for these logs and output files, the Purge Concurrent Request Concurrent Program or the Manager Data Concurrent Program will act, based on the information located in the database tables to determine which […]
Read MoreWorkflow Scripts: Source Oracle Documentations The below are the collection of Workflow Administration Scripts and/or Concurrent Program. 1. FNDWFPR For Oracle Workflow embedded in Oracle Applications, use the standard concurrent program FNDWFPR ”Purge Obsolete Workflow Runtime Data” to purge old data from the Oracle Workflow runtime tables regularly. Navigate to the Submit Requests form in […]
Read More