Complete about Oracle Parallelism?
Following initialization parameters are required for parallelism setup in database.
Parallel Queries and Parallel jobs execution
1. Select query with parallelism example:
Select /*+ parallel (a,32) */ * from dba_segments a;
32 is degreee here(Numbers of parallel processes)
Gather statistics of a table using parallelism Example
exec FND_STATS.GATHER_TABLE_STATS (ownname => '&owner', tabname => '&table_name', percent => 20 ,degree => 30 , granularity => 'ALL', cascade => TRUE);
Comple objects in the database with parallelism Example
Table used to know number of parallel processes running are
v$px_session - Standard
gv$px_session - For RAC
Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA - Supply Planning Work Area What is Oracle ADF? Orac...
R12.2. Services Start and Stop Procedure All components - Application (Middle Tier) START $INST_TOP/admin/scripts adstrtal.s...
Enabling TLS in Oracle Apps R12.2 Here we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...
Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well ...