#DB20c
#OrclDB #Oracle #DB20c
Oracle Database 20c – The first CDB-only release
https://buff.ly/37F9lE7
November 25, 2024 at 3:40 AM
#OraTidbit #Db20c Initialization parameters AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL (Traditional auditing parameters) are deprecated in Oracle Database 20c.
November 25, 2024 at 3:40 AM
#OrclDB #DB20c Oracle Database 20c Technical Architecture
This interactive diagram shows the Oracle Database 20c technical architecture.
https://buff.ly/2VDuyfo
Oracle Database Technical Architecture
Documentation and tutorials for developers and business u...
buff.ly
November 25, 2024 at 3:40 AM
#OraTidbit #db20c Traditional auditing is deprecated in Database 20c. DBA Views deprecated include DBA_AUDIT_TRAIL, DBA_COMMON_AUDIT_TRAIL, DBA_FGA_AUDIT_TRAIL and so on.
November 25, 2024 at 3:33 AM
#OraTidbit #db20c Starting with Oracle Database 20c, an Oracle Database installation configures all Oracle Database homes in read-only mode by default (ORACLE_BASE_HOME and ORACLE_BASE_CONFIG are located separately from ORACLE_HOME).
November 25, 2024 at 3:33 AM
#OraTidbit #db20c The option to use Oracle Data Guard with a logical standby Database is deprecated in Database 20c. The logical standby feature and the DBA_LOGSTDBY and DBMS_LOGSTDBY SQL statements and V$LOGSTDBY views can be desupported in a future release.
November 25, 2024 at 3:33 AM
#OrclDB #DB20c Oracle 20c SQL Macros: a scalar example to join agility and performance
https://buff.ly/2Ib7Nri
Oracle 20c SQL Macros: a scalar example to join agility a...
By Franck Pachot . Let’s say you have a PEOPLE table with...
buff.ly
November 25, 2024 at 3:25 AM
#OraTidbit #db20c Starting in Oracle Database 20c, the IGNORECASE parameter for the orapwd file is desupported. All newly created password files are case-sensitive.
November 25, 2024 at 3:25 AM
#OraTidbit #db20c The result cache in an Active Data Guard standby database is utilized to cache results of queries that were run on the physical standby database. In the case of a role transition to primary, the standby database result cache will be preserved.
November 25, 2024 at 3:02 AM
#OraTidbit #db20c Starting with 20c, the USER_APPLICATION_ROLES data dictionary view provides a subset of roles that are available in DBA_APPLICATION_ROLES that only apply to the current user.
November 25, 2024 at 3:02 AM
#OraTidbit #db20c The SQL set operators support all keywords as defined in #ANSISQL. The new operator EXCEPT [ALL] is functionally equivalent to MINUS [ALL]. The operators MINUS and INTERSECT now support the keyword ALL.
November 25, 2024 at 2:55 AM
#OraTidbit #db20c Starting with Oracle Database 20c Oracle Data Pump can include and exclude objects in the same export or import operation.
November 25, 2024 at 2:55 AM
#OraTidbit #db20c Starting with Oracle Database 20c Oracle Data Pump can resume transportable tablespace export and import jobs that are stopped.
November 25, 2024 at 2:48 AM
#OraTidbit #db20c DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs. The infrastructure is implemented as a Linux-specific package that provides hierarchical containers, called nests.
November 25, 2024 at 2:48 AM
#OraTidbit #db20c The UNIFIED_AUDIT_SGA_QUEUE_SIZE initialization parameter is desupported in Oracle Database release 20c, version 20.2.
November 25, 2024 at 2:40 AM
#OraTidbit #DB20c The Data Guard Broker in 20c enables users to create and add a Far Sync instance to a Data Guard Broker configuration using a single command. Zero Data loss over a long distance can be achieved by using the Data Guard Far Sync standby instances.
November 25, 2024 at 2:32 AM
#OraTidbit #db20c Automatic zone maps are created and maintained for any user table without user intervention. Zone maps allow the pruning of blocks and partitions based on the predicates in the queries. Automatic zone maps improve the performance of any query automatically.
November 25, 2024 at 2:24 AM
#OraTidbit #db20c Oracle ASM Flex Disk Group supports Cloning a PDB in one CDB to a new PDB in a different CDB. This feature enables you to use Oracle ASM cloning for test and development cloning.
November 25, 2024 at 2:24 AM
#OraTidbit #db20c Oracle Data Guard Broker provides early detection of fast-start failover (FSFO) configuration issues and reports those misconfigurations allowing administrators to take action prior to a failover event.
November 25, 2024 at 2:16 AM
#OraTidbit #db20c Oracle Data Guard broker utilizes a standardized directory structure to store client-side files. Use the DG_ADMIN environment variable to specify the default location.
November 25, 2024 at 2:16 AM
#OraTidbit #db20c Two new #GoldenGate views, DBA_OGG_AUTO_CAPTURED_TABLES, and USER_OGG_AUTO_CAPTURED_TABLES, provide you with tools to query which tables are enabled for Oracle GoldenGate automatic capture.
November 25, 2024 at 2:16 AM
#OraTidbit #db20c #db19c Init parameter MAX_IDLE_BLOCKER_TIME specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated.
November 25, 2024 at 2:08 AM