When Oracle Instance is not running /u01/app/oracle/product> sysresv IPC Resources for ORACLE_SID “TEST″ : Shared Memory ID KEY No shared memory segments used Semaphores: ID KEY No semaphore resources used Oracle Instance not alive for sid “TEST″ When Oracle Instance is running /u01/app/oracle/product> sysresv IPC Resources for ORACLE_SID “TEST″ : Shared Memory: ID KEY 14437 […]
how to find the semaphore for the Database instance Read More »
Introduction approx_count_distinct is the new function included in 12c to estimate the distinct values in the column in a faster manner without deviating much from actual values. It returns approximate number of rows that contain distinct values of expression. approx_count_distinct Definition We know that it take considerable time to project desired output using traditional COUNT(DISTINCT)
approx_count_distinct : Oracle Database 12c Read More »
We have a Grid Infrastructure Oracle Restart configuration on one oracle database server and Now we want to change the host-name of the server. Here we will be seeing the steps required to perform it without any loss of the database. Configuration Old Host Name: techgo New Host name: techgo-new Stop all the services $<11.2
Oracle Restart Configuration: How to change Hostname Read More »
In this post , we will look at the different queries to retrieve the waitevent history of the Oracle session. History of wait events in a specific session from start can be found using below query set lines 120 trimspool on col event head “Waited for” format a30 col total_waits head “Total|Waits” format 999,999 col
How to find the waitevent History of the Oracle session Read More »
What is APPL_TOP snapshots? 1) It is record the current set of files and file versions in your APPL_TOP 2) Current view snapshots are created once and updated when appropriate to maintain a consistent view of the APPL_TOP content 3) Snapshots are current views of your system: they are created once, and then updated when appropriate
What is current view APPL_TOP snapshots Read More »
I will be presenting some solutions for oacore not coming up in R12 EBS version. What is OACORE First, let me give a brief idea about the oacore mechanism in R12 In R12 we have 3 groups of OC4J’s. oacore OC4J – Supports framework-based applicationsforms OC4J – Supports forms-based applicationsoafm OC4J – expands to Oracle
Step by Step resolution for the problem oacore not coming up in R12.0/R12.1 Read More »
