Techgoeasy

How to use Distributed AD to decrease the patching time in Oracle EBS

1)Distributed AD offers improved scalability, performance, and resource utilization by allowing workers of the same AD session to be started on additional middle tier systems. 2)AD has always utilized a Parallel Jobs System, where multiple AD workers start and are assigned jobs. Information for the Jobs System is stored in the oracle database, and workers …

How to use Distributed AD to decrease the patching time in Oracle EBS Read More »

ASM best practice to add disk

Oracle, Oracle Database

Here are ASM best practices to add disks which should be always used to manipulate the ASM disks (1) First check the newly added disk is visible in ASM disks select header_status,path from v$asm_disk where path= ‘<path>’; It should show the candidate (2) Create a new temporary diskgroup using those disks CREATE DISKGROUP TEST_DISK EXTERNAL REDUNDANCY …

ASM best practice to add disk Read More »

how to find the semaphore for the Database instance

Oracle, Oracle Database

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 »

approx_count_distinct : Oracle Database 12c

Oracle, Oracle Sql

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 »

Oracle Restart Configuration: How to change Hostname

Oracle, Oracle Database

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 »

How to find the waitevent History of the Oracle session

Oracle, Oracle Database

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 »