HOW AUTOMATIC STORAGE MANAGEMENT WORKS

Last updated on December 21st, 2015 at 06:16 amHOW AUTOMATIC STORAGE MANAGEMENT WORKS Automatic Storage Management has a special-purpose Oracle instance, called the ASM instance, dedicated to managing disk group activity. The ASM instance manages and communicates the map as to where each file extent resides. It also controls the process of rebalancing the placement of the extents when the storage allocation is changed. As … Continue reading HOW AUTOMATIC STORAGE MANAGEMENT WORKS »

how to use XMLImporter and FndXdfCmp

Last updated on December 21st, 2015 at 05:52 amXMLImporter and FndXdfCmp are the implement utilities in Oracle Ebusiness Suite for implementating new schema defination and changes Here are the steps on how to use XMLImporter and FndXdfCmp XMLImporter java -classpath “${CLASSPATH}” oracle.jrad.tools.xml.importer.XMLImporter $APPL_TOP/ahl/12.0.0/mds/prd/webui/WorkorderDetailsRN.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exam.daytonoh.ncr.com)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=TEST)))” -userId “1” -rootPackage /oracle/apps/ahl -rootdir $APPL_TOP/ahl/12.0.0/mds FndXdfCmp adjava “-mx128m” “-nojit” “oracle.apps.fnd.odf2.FndXdfCmp” “apps” “apps” “apps” “apps” “thin” “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exam.daytonoh.ncr.com)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=TEST)))” … Continue reading how to use XMLImporter and FndXdfCmp »

Timezone settings

Last updated on December 21st, 2015 at 06:15 amI am presenting here the some of the good information on timezone settings How to find the latest DST patch applied SQL> select * from v$timezone_file; FILENAME VERSION ———— ———- timezlrg.dat 4 This select gives all TimeStamp with Time Zone (TSTZ) columns in your database: select c.owner || ‘.’ || c.table_name || ‘(‘ || c.column_name || ‘) … Continue reading Timezone settings »

How to find table where statistics are locked

Last updated on December 21st, 2015 at 06:17 amYou can use the below query on How to find table where statistics are locked select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null; Now once we find out the objects,we can use below queries to unlock them exec dbms_stats.unlock_schema_stats(‘schema_owner’); exec dbms_stats.unlock_table_stats(‘table_owner’,’table_name’);

How to migrate the schema from one database to another database

Last updated on December 21st, 2015 at 05:50 amHere ,I will give u Detailed steps for Schema Migration using exp/imp,pipe,gz between two databases How to migrate the schema from one database to another database The below steps need to be done on the Source Database Metadata about schema 1. SQL> select owner,sum(bytes)/1024/1024 from dba_segments where owner in (‘EXAMPLE_SCH’) group by owner; 2. SQL> select tablespace_name,sum(bytes)/1024/1024 … Continue reading How to migrate the schema from one database to another database »

ora-20001 in Gather schema stats on 11g(FND_HISTOGRAM_COLS)

Last updated on December 21st, 2015 at 06:14 am“Gather Schema Statistics” program reported following errors in request log files : Error #1: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #2: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #3: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** … Continue reading ora-20001 in Gather schema stats on 11g(FND_HISTOGRAM_COLS) »

How to find which sid is doing full table scan

Last updated on December 21st, 2015 at 05:42 amMany times the performance of the database will be slow.We need to first find out  if any big table full table scan is going on. We can use below query to find out what all the sid are doing full tables scan column user_process heading “Name |SID” format a20; column long_scans heading “Long Scans” format 999,999,999; column … Continue reading How to find which sid is doing full table scan »

Oracle Wait Events That Everyone Should Know Part -III

Last updated on July 29th, 2016 at 02:19 amThis is part III in series of Oracle Wait Events That Everyone Should Know First two parts link are Oracle Wait Events That Everyone Should Know Part -I Oracle Wait Events That Everyone Should Know Part -II Lets get going with the Third part db file scattered read The process has issued an I/O request to read … Continue reading Oracle Wait Events That Everyone Should Know Part -III »

Oracle Wait Events That Everyone Should Know Part -1

Last updated on July 28th, 2016 at 05:59 pmThis is part I in series of Oracle Wait Events That Everyone Should Know Here are some of the Common Oracle wait events that everyone should Know. Wait events You can find which event session is waiting for it by following query select event from V$session_wait where sid=&1 I am trying to explain few common Oracle wait … Continue reading Oracle Wait Events That Everyone Should Know Part -1 »

MWA information for 11i and R12

Last updated on September 19th, 2015 at 07:19 amMobile Warehousing Application is a important components of Oracle Ebuisness Suite and it is used in warehouse to scan items.In this section , i am sharing the information for MWA MWA  information for 11i and R12 MWA Configuration file  for 11i Configuration file is used to set server related properties. Setup mwa.cfg file as follows: 1. Locate … Continue reading MWA information for 11i and R12 »

What is Oracle Clusterware?

Last updated on November 28th, 2015 at 12:28 pmThe Oracle Clusterware was introduced in 10.1 (initially called CRS ) and is the product that lies under RAC. Oracle Clusterware provides different services to RAC including: – Group Services – Node Monitor – Locking services – HA Resource management – Event framework, etc Components.Several components are needed to have CRS running on Unix machine. Here is … Continue reading What is Oracle Clusterware? »