Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Pocket guide Initialization Parameters ---------------------------------------------------------------------------- audit ?ledest u app oracle admin ORCL adump Sets the path to which audit ?les are written audittrail FALSE Enables TRUE or disables FALSE w

Initialization Parameters ---------------------------------------------------------------------------- audit ?ledest u app oracle admin ORCL adump Sets the path to which audit ?les are written audittrail FALSE Enables TRUE or disables FALSE writing of rows to the audit table backgrounddumpdest u app oracle admin ORCL bdump Directory in which to write debugging trace ?les for the background processes LGWR DBWn and so on control ?les u oradata ORCL controlORCL ctl u oradata ORCL controlORCL ctl Full path to database control ?les coredumpdest u app oracle admin ORCL cdumpn Directory in which to write core dumps in an error situation dbblockbu ?ers Sets the size of the database bu ?er cache in memory In x the default bu ?er cache size is calculated to be as many bu ?ers as will ?t in MB dbblocksize Size of each database bu ?er Oracle recommends that you set the parameter to a minimum of kilobytes This parameter takes e ?ect only at the time the database is created dbdomain mycompany com Speci ?es the extension components of a global database name consisting of valid identi ?ers separated by periods db ?les Number of database ?les that can be open when the database is running db ?lemultiblockreadcount Number of blocks read into the bu ?er cache at once when performing a sequential scan d b name ORCL The name of this database enqueueresources Sets the number of resources that can be locked by the operating system lock manager globalnames TRUE Enables TRUE or disables FALSE db link name checking javapoolsize minimum for i logarchivedest u oraarch ORCL arch Directory location the ?rst part of the name of each archive log that will be written logarchiveformat s log Sets format for archived logs logarchivestart TRUE Enables TRUE or Disables FALSE archiving logbu ?er Number of bytes allocated to redo log bu ?er in the SGA Max K or K CPUCOUNT logcheckpointinterval Number of new redo log ?le blocks needed to trigger a checkpoint Values to UNLIMITED maxdump ?lesize Limits the physical size of the trace ?le to the speci ?ed number of operating system blocks or UNLIMITED maxenabledroles Maximum number of roles per user maxrollbacksegments Maximum number of rollback segments that can be kept online simultaneously by one instance mtsdispatchers ? tcp ? Number type of dispatcher processes to be created when database or database instance starts up mtsmaxdispatchers Maximum number of dispatchers that can run simultaneously mtsmaxservers Maximum number of server processors that can run simultaneously mtsservers Number of servers with which to start opencursors Maximum number of cursors that a user session can have open at any one time parallelmaxservers Maximum number of servers that are allowed to exist concurrently Set the value to maximum number of PQO users their maximum degree of parallelism pgaaggregatetarget m speci ?es the target aggregate PGA memory available processes Max number of simultaneous connections allowed to the instance queryrewriteenabled FALSE enable or disable query rewriting ex materialized views function indexes rollbacksegments r r r r Indicates all of the private rollback segments