#DB20c
#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 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
#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