#oratidbit #db18c The ALTER DATABASE DICTIONARY statement can encrypt sensitive credential data in the http://SYS.LINK$ and SYS.SCHEDULER$_CREDENTIAL system tables.
November 27, 2024 at 3:49 PM
#oratidbit #db18c The ALTER DATABASE DICTIONARY statement can encrypt sensitive credential data in the http://SYS.LINK$ and SYS.SCHEDULER$_CREDENTIAL system tables.
#oratidbit #db18c A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs. A CDB fleet is a collection of CDBs and hosted PDBs that you can manage as one logical CDB.
November 28, 2024 at 8:39 AM
#oratidbit #db18c A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs. A CDB fleet is a collection of CDBs and hosted PDBs that you can manage as one logical CDB.
#oratidbit Passwords in database links are encrypted in #db18c. Oracle Data Pump handles the export and import of these passwords. Import operations from older versions and export operations to older versions can still be used.
November 26, 2024 at 4:28 AM
#oratidbit Passwords in database links are encrypted in #db18c. Oracle Data Pump handles the export and import of these passwords. Import operations from older versions and export operations to older versions can still be used.
November 29, 2024 at 5:03 PM
#orcldb #oraclecloud “Understanding the Oracle Database 18c Technical Architecture” - #db18c @oracledatabase available on @oraclecloud, @Oracle_SSC, @Infrastructure and @oracleexadata https://buff.ly/2FbqJ6O
November 29, 2024 at 1:38 AM
#orcldb #oraclecloud “Understanding the Oracle Database 18c Technical Architecture” - #db18c @oracledatabase available on @oraclecloud, @Oracle_SSC, @Infrastructure and @oracleexadata https://buff.ly/2FbqJ6O
#oratidbit #db18c Zero-Downtime Database Upgrade automates all of the steps required for a Database upgrade. It can minimize or even eliminate application downtime during the upgrade process.
November 29, 2024 at 1:38 AM
#oratidbit #db18c Zero-Downtime Database Upgrade automates all of the steps required for a Database upgrade. It can minimize or even eliminate application downtime during the upgrade process.
#oratidbit #db18c Passwords in database links are encrypted in 18c. Oracle Data Pump handles the export and import of these passwords. This prevents an intruder from decrypting an encrypted database link password.
November 29, 2024 at 1:38 AM
#oratidbit #db18c Passwords in database links are encrypted in 18c. Oracle Data Pump handles the export and import of these passwords. This prevents an intruder from decrypting an encrypted database link password.
#oratidbit #db18c A refreshable clone PDB is an incrementally updated copy of a master PDB. The new switchover feature enables a change of roles between master and clone PDBs for planned or unplanned switchver.
November 29, 2024 at 12:08 AM
#oratidbit #db18c A refreshable clone PDB is an incrementally updated copy of a master PDB. The new switchover feature enables a change of roles between master and clone PDBs for planned or unplanned switchver.
#oratidbit #db18c When you perform the export or import operation of a database, the unified audit trail is automatically included in the Data Pump dump files.
November 29, 2024 at 12:08 AM
#oratidbit #db18c When you perform the export or import operation of a database, the unified audit trail is automatically included in the Data Pump dump files.
#oratidbit #db18c ASM database cloning provides cloning of Multitenant databases (PDBs) by leveraging ASM redundancy. Flex Disk Groups can provide up to five redundant copies, one or more of the copies can be split off to provide a near instantaneous replica.
November 29, 2024 at 12:08 AM
#oratidbit #db18c ASM database cloning provides cloning of Multitenant databases (PDBs) by leveraging ASM redundancy. Flex Disk Groups can provide up to five redundant copies, one or more of the copies can be split off to provide a near instantaneous replica.
#oratidbit $db18c Drop a file group and its associated files (drop including content) using the CASCADE keyword with ALTER DISKGROUP ... DROP FILEGROUP SQL statement.
November 28, 2024 at 10:54 PM
#oratidbit $db18c Drop a file group and its associated files (drop including content) using the CASCADE keyword with ALTER DISKGROUP ... DROP FILEGROUP SQL statement.
#oratidbit #db18c SQL*Plus Feature: The SET LINESIZE command has a WINDOW option to automatically change the linesize and pagesize for the formatted output according to the width and height of the screen.
November 28, 2024 at 10:06 PM
#oratidbit #db18c SQL*Plus Feature: The SET LINESIZE command has a WINDOW option to automatically change the linesize and pagesize for the formatted output according to the width and height of the screen.
#oratidbit #db18c SQL*Plus Feature: SQL_ID option for the SET FEEDBACK command displays the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable _SQL_ID.
November 28, 2024 at 10:06 PM
#oratidbit #db18c SQL*Plus Feature: SQL_ID option for the SET FEEDBACK command displays the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable _SQL_ID.
#db18c #orcldb Oracle Database 18c : Now available on the #oraclecloud and Oracle Engineered Systems https://buff.ly/2FDEZ8T
fw_error_www
buff.ly
November 28, 2024 at 10:06 PM
#db18c #orcldb Oracle Database 18c : Now available on the #oraclecloud and Oracle Engineered Systems https://buff.ly/2FDEZ8T
Private Temporary Tables in Oracle Database 18c
Oracle 18c introduced the concept of a private temporary ...
buff.ly
November 28, 2024 at 10:06 PM
#oratidbit #db18c Instead of terminating a session, you can cancel a high-load SQL statement in a session. When you cancel a DML statement, the statement is rolled back. Usie the ALTER SYSTEM CANCEL SQL statement.
November 28, 2024 at 10:06 PM
#oratidbit #db18c Instead of terminating a session, you can cancel a high-load SQL statement in a session. When you cancel a DML statement, the statement is rolled back. Usie the ALTER SYSTEM CANCEL SQL statement.
#oratidbit #db18c An Oracle home can be read-only, thus preventing creation or modification of files inside the Oracle home directory ORACLE_HOME. A read-only Oracle home can be used as a software image that can be shared across multiple database servers.
November 28, 2024 at 9:22 PM
#oratidbit #db18c An Oracle home can be read-only, thus preventing creation or modification of files inside the Oracle home directory ORACLE_HOME. A read-only Oracle home can be used as a software image that can be shared across multiple database servers.
#oratidbit #db18c The default location for Oracle Database password file (ORAPWD) is ORACLE_BASE directory instead of ORACLE_HOME directory. This change supports read-only Oracle homes.
November 28, 2024 at 9:22 PM
#oratidbit #db18c The default location for Oracle Database password file (ORAPWD) is ORACLE_BASE directory instead of ORACLE_HOME directory. This change supports read-only Oracle homes.
#oratidbit #db18c When OPTIMIZER_IGNORE_HINTS parameter is set to TRUE, the optimizer ignores embedded hints.
November 28, 2024 at 8:30 PM
#oratidbit #db18c When OPTIMIZER_IGNORE_HINTS parameter is set to TRUE, the optimizer ignores embedded hints.
#oratidbit #db18c When OPTIMIZER_IGNORE_PARALLEL_HINTS parameter is set to TRUE, the optimizer ignores embedded parallel hints.
November 28, 2024 at 7:18 PM
#oratidbit #db18c When OPTIMIZER_IGNORE_PARALLEL_HINTS parameter is set to TRUE, the optimizer ignores embedded parallel hints.
#oratidbit #db18c To change the starting point of a sequence, use the RESTART clause to restart the sequence from the specified value. The new value specified must be between the MINVALUE and MAXVALUE parameter values.
November 28, 2024 at 7:18 PM
#oratidbit #db18c To change the starting point of a sequence, use the RESTART clause to restart the sequence from the specified value. The new value specified must be between the MINVALUE and MAXVALUE parameter values.
Oracle 18c - ALTER USER RENAME
Oracle Fusion Middleware, Weblogic, Oracle WebLogic Serve...
buff.ly
November 28, 2024 at 7:18 PM
#oratidbit #db18c Private temporary tables are temporary database objects that are automatically dropped at the end of a transaction or a session. A private temporary table is stored in memory and is visible only to the session that created it.
November 28, 2024 at 7:18 PM
#oratidbit #db18c Private temporary tables are temporary database objects that are automatically dropped at the end of a transaction or a session. A private temporary table is stored in memory and is visible only to the session that created it.
18c Read Only Oracle Home
By Franck Pachot . This is the big new feature of Oracle ...
buff.ly
November 28, 2024 at 6:18 PM