Here is how to list all of the Oracle 1. AQ Time Managers to start. Maximum number of seconds of redos the standby could. Directory in which auditing files are to reside. Syslog facility and level. Setting for AWR Snapshot Time Offset. Core Size for Background Processes. Detached process dump directory. Automate Microsoft Outlook From Vb Script Editor on this page. BACKUP Tape IO slaves. BITMAP MERGE. blanktrimming. This document contains system and platformspecific information for Oracle Fusion Middleware products. This document is intended for use in conjunction with the. What caused the ORA00054 resource busy and acquire with NOWAIT specified or timeout expired error Find out if it was caused by a table lock or. About Creating an Oracle Database. After you plan your database using some of the guidelines presented in this section, you can create the database with a graphical. Number of database blockslatches in keep buffer pool. Number of database blockslatches in recycle buffer. Cell packet compaction strategy. SQL processing offload of encrypted data to. Additional cell offload parameters. Oracle Select For Update Lock Timeout' title='Oracle Select For Update Lock Timeout' />Cell offload explain plan display. SQL processing offload to cells. Set the offload group name. TRUE startup in cluster database mode. SGA. structures. clusterinterconnects. RAC use. commitlogging. Bias this node has toward not preparing in a. Database will be completely compatible with this. Core dump directory. CPUs for this instance. DML statements. cursorbindcapturedestination. Allowed destination for captured bind variables. Size of cache for 1. K buffers. db2kcachesize. Size of cache for 2. K buffers. db3. 2kcachesize. Size of cache for 3. K buffers. db4kcachesize. Size of cache for 4. K buffers. db8kcachesize. Size of cache for 8. K buffers. dbbigtablecachepercenttarget. Big table cache target size in percentage. Number of database blocks cached in memory. Size of database block in bytes. Buffer cache sizing advisory. Size of DEFAULT buffer pool for standard block size. CREATE DATABASE. dbfilemultiblockreadcount. IO. dbfilenameconvert. Maximum Flashback Database log retention time in. Size of KEEP buffer pool for standard block size. CREATE DATABASE. dbrecoveryfiledest. Size of RECYCLE buffer pool for standard block size. Sets defaults for other parameters that control. Database Unique Name. Track nologging SCN in controlfile. DBWR IO slaves. ddllocktimeout. Data Guard broker DMON process. Use asynch IO for random access devices. Max number of d. NFS asynch IO requests queued per. EnablesDisables internal conversions during DST. Enable Pluggable Database. FAL client. falserver. FAL server list. faststartiotarget. Upper bound on recovery reads. MTTR target in seconds. Network Adapters for File IO. IO operations on filesystem files. SYSDATE value. gcsserverprocesses. Global Application Context Pool Size in Bytes. ILM Heatmap Tracking. SGA starting address high order 3. DD updates in HS agent. Java VM JIT enabled. Java sessionspace. Java. sessionspace. RDBMSs LDAP access option. OID usage parameter. Lock entire SGA in physical memory. Establish EXPEDITE attribute default value. ARCH processes. logarchiveminsucceeddest. SGA initialization. Establish archivelog operation tracing level. Maximum time interval between checkpoints in seconds. Maximum size in bytes of dump file. VARCHAR2, NVARCHAR2, and RAW. SQL. memorymaxtarget. Max size for Memory Target. Target size of Oracle SGA and PGA memory. NLS calendar system name. NLS comparison. nlscurrency. NLS local currency symbol. NLS Oracle date format. NLS date language name. Dual currency symbol. NLS ISO currency territory name. NLS language name. NLS raise an exception instead of allowing implicit. NLS numeric characters. NLS linguistic definition name. NLS territory name. Non CDB Compatible. SQL plan baselines for. Usage of invisible indexes TRUEFALSE. Control whether to use optimizer pending statistics. SQL plan baselines for captured sql statements. MANUALLIMITEDAUTOADAPTIVE. DOP by IO bandwidth. TRUE startup in parallel server mode. OPS SGA. structures. CPU. pdbfilenameconvert. PDB file name convert patterns and. PLSQL. pgaaggregatelimit. PGA memory consumed by the. Target size for the aggregate PGA memory consumed by. PLSQL source code identifier. PLSQL ccflags. plsqlcodetype. PLSQL code type. PLSQL debug. PLSQL optimize level. PLSQL version 2. PLSQL compiler warnings settings. Name of the processor group that this instance should. RDBMSs Distinguished Name. TRUE delay opening of read only files until first. Data Guard transport user when using password file. Replication parallel. Resource Manager CPU allocation. TTC protocol error continue action. TTC protocol error action. Number of cursors to cache in a session. SGA size. sgatarget. Target size of SGA. Core Size for Shadow Processes. SGA starting address low order 3. TRUE. smtpoutserver. SQL trace. sqltunecategory. Category qualifier for applying hintsets. Use asynch IO requests for tape devices. Redo thread to mount. Threaded Execution Mode. SMU mode if TRUE, else in RBU mode. Size of Unified audit SGA Queue. Use dedicated connection broker. Enable indirect data buffers very large SGA on. Use large pages if available. TRUEFALSEONLY. User process dump directory. SQL working areas MANUALAUTO. XML DB events enabled.