Database Reference
In-Depth Information
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB1 READ WRITE
SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE IMMEDIATE;
Pluggable database altered.
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB1 MOUNTED
SQL>
Evaluate the Impact of Parameter
Value Changes
In this section, we will discuss initialization parameters that influence the behavior of the
multitenant environment. Where appropriate, we present the range of valid values, the default
values, and any potential impact on the CDB and PDBs. Where relevant, we also discuss the
impact on non-CDBs.
Initialization parameters that have an impact on the behavior of CDBs and PDBs are
listed in alphabetic order in the following sections.
AUDIT_FILE_DEST
When the
AUDIT_TRAIL
initialization parameter is set to
os
,
xml
, or "
xml, extended
",
the
AUDIT_FILE_DEST
parameter indicates the operating system directory where the
audit trail is written. The audit records will be written in XML format if
AUDIT_TRAIL
is set to
xml
or "
xml, extended
". If the
AUDIT_SYS_OPERATIONS
initialization parameter
is set to
TRUE
, audit records for users connected as
SYSDBA
or
SYSOPER
are written to
AUDIT_FILE_DEST
.
In a CDB, the scope of the settings for
AUDIT_FILE_DEST
is the CDB. The audit
trail is provided per PDB in a CDB, but
AUDIT_FILE_DEST
is not configurable for indi-
vidual PDBs.
Search WWH ::
Custom Search