Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

How to find optimizer underscore parameter

Last updated on November 23rd, 2015 at 03:31 pmHow to find optimizer underscore parameter SELECT x.ksppinm name, y.ksppstvl VALUE, ksppstcmnt update_comment FROM x$ksppi x, x$ksppcv y WHERE x.inst_id = userenv(‘Instance’) AND y.inst_id = userenv(‘Instance’) AND x.indx = y.indx AND x.ksppinm LIKE ‘%optim%%’; How to find background process information select nm, max(description) descript from (select regexp_replace( name,'[0-9a-z]’,’#’) nm, description from v$bgprocess) group by nm order by … Continue reading How to find optimizer underscore parameter »

Various Joins Method in Oracle

Last updated on September 15th, 2016 at 05:24 amPerformance is key for OLTP system and we should have good information about Joins Method in Oracle to increase performance for sql queries Here are the  Joins Method in Oracle available in Oracle database Nested Loops -For each row in the first row source access all the rows from the second row source. -Best for OLTP type transactions … Continue reading Various Joins Method in Oracle »

Optimizer Mode

Last updated on November 23rd, 2015 at 03:34 pmSet in the Init.Ora Can be changed via ALTER SESSION CHOOSE, FIRST_ROWS, ALL_ROWS = cost based optimization RULE = rule based optimization Optimizer_Mode = Rule Original optimizer developed by prior to 7 Applications prior to 11i must run as RULE to be supported Documentation has warned of its removal uses strict rules for determining the execution path … Continue reading Optimizer Mode »

How FNDFS (Oracle Report Review agent) works in EBS environment

Last updated on September 1st, 2016 at 04:50 amExplaining how FNDFS working 1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ 2) The file name and nodename are selected from the database. Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes WHERE concurrent_process_id = :process_id; 4. … Continue reading How FNDFS (Oracle Report Review agent) works in EBS environment »

What is Oracle Database Lite 10g

Last updated on September 15th, 2016 at 05:30 amOracle Database Lite 10g extends the power of grid computing to a mobile workforce with a complete, integrated, secure database for building, deploying, and managing mobile applications for a broad range of mobile devices. Oracle Database Lite 10g enables persistent access to critical information and applications without requiring continuous connectivity to back-end enterprise systems. As a result, … Continue reading What is Oracle Database Lite 10g »

Output post Processor(OPP)

Last updated on April 14th, 2017 at 03:25 pmThe Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the … Continue reading Output post Processor(OPP) »

Oracle DBA: Hanganalyze and system state dump

Last updated on August 31st, 2016 at 01:11 pmMany times Oracle database get hangs due to locks or latching issue and Nobody can login to the system. It becomes critical and  And Usually we do shutdown abort to immediately resolve the issue. But  it is good to take system state dump/hanganalyze  at 1 min interval to analyze the locking or latching  issue afterwards before doing … Continue reading Oracle DBA: Hanganalyze and system state dump »

how to perform relink in Oracle

Last updated on August 31st, 2016 at 01:30 pmSometimes Oracle components may start giving strange issues like coredump  or the Operating system is patched, In these cases it is always recommended to try oracle relink to resolve the issues.A Oracle relink is also necessary whenever you install a new release or a patchset or when there is a patch or upgrade to the OS environment. Oracle … Continue reading how to perform relink in Oracle »

Oracle DBA: How to schedule jobs in Oracle Database

Last updated on August 31st, 2016 at 05:09 pmWe often wants to run pre-defined jobs at different schedule. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for the scheduling of pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs don’t execute … Continue reading Oracle DBA: How to schedule jobs in Oracle Database »

Core file for oracle concurrent manager

Last updated on August 25th, 2016 at 04:01 amOracle concurrent managers consists of many executable and we often faced various issues with it.When an executable ends with a segmentation fault or signal 11, a core file for oracle concurrent manager  should be created. If you are not finding that a core file is created, then the ulimit may be set to 0 for core files … Continue reading Core file for oracle concurrent manager »

Concurrent Manager troubleshooting part 1

Last updated on November 23rd, 2015 at 03:40 pmConcurrent Manager troubleshooting part 1 If a PL/SQL Concurrent Program can’t write to an external file, you will receive an error message similar to: MSG-00102: Error Message :ORA-20100: File o0000071.tmp creation for FND_FILE failed. You will find more information on the cause of the error in request log. ORA-06512: at “APPS.FND_FILE”, line 378 ORA-06512: at “APPS.FND_FILE”, line … Continue reading Concurrent Manager troubleshooting part 1 »

11g Alert log new features

Last updated on November 28th, 2015 at 11:58 am11g Alert log new features Beginning with Release 11g of Oracle Database, the alert log is written as both an XML-formatted file and as a text file, as in earlier releases.Both these log files are stored inside the ADR home.The ADR root directory is known as ADR BASE.The Automatic Diagnostic Repository (ADR) is a directory structure that … Continue reading 11g Alert log new features »