Oracle Software Install using AutoUpgrade on a Brand New VM!
#OracleDB #DB19c #AIDB26 #AutoUpgrade
bijoos.com/oraclenotes/...
#OracleDB #DB19c #AIDB26 #AutoUpgrade
bijoos.com/oraclenotes/...
Oracle Software Install using AutoUpgrade on a Brand New VM! – OracleNotes
OracleNotes
bijoos.com
November 7, 2025 at 3:05 PM
Oracle Software Install using AutoUpgrade on a Brand New VM!
#OracleDB #DB19c #AIDB26 #AutoUpgrade
bijoos.com/oraclenotes/...
#OracleDB #DB19c #AIDB26 #AutoUpgrade
bijoos.com/oraclenotes/...
#db19c #orcldb Oracle 19c is available in LiveSQL – Upgrade your Database - NOW! https://buff.ly/2stInxl
November 26, 2024 at 4:12 PM
#db19c #orcldb Oracle 19c is available in LiveSQL – Upgrade your Database - NOW! https://buff.ly/2stInxl
Hint Reports
Nigel Bayliss has posted a note about a frequently reques...
buff.ly
November 26, 2024 at 3:58 PM
#DB19c Oracle 19c Released : How does that make you feel? | The ORACLE-BASE Blog https://buff.ly/2Ws4Cl4
Oracle 19c Released : How does that make you feel? | The ...
Back in 2017 I wrote a post about the move to the yearly ...
buff.ly
November 26, 2024 at 3:48 PM
#DB19c Oracle 19c Released : How does that make you feel? | The ORACLE-BASE Blog https://buff.ly/2Ws4Cl4
#oratidbit #db19c contains a keenly awaited fix to the optimizer costing for for ANSI fetch first/offset queries. Now they can take advantage of an index scan + stopkey as per the older style order by/rownum syntax. https://buff.ly/2MMtb7K
November 26, 2024 at 2:33 PM
#oratidbit #db19c contains a keenly awaited fix to the optimizer costing for for ANSI fetch first/offset queries. Now they can take advantage of an index scan + stopkey as per the older style order by/rownum syntax. https://buff.ly/2MMtb7K
#oratidbit The LISTAGG aggregate function in #db19c supports duplicate elimination by using the DISTINCT keyword. With the new DISTINCT keyword, duplicate values can be removed from the specified expression before concatenation into a single string. https://buff.ly/2RzwCUR
November 26, 2024 at 1:47 PM
#oratidbit The LISTAGG aggregate function in #db19c supports duplicate elimination by using the DISTINCT keyword. With the new DISTINCT keyword, duplicate values can be removed from the specified expression before concatenation into a single string. https://buff.ly/2RzwCUR
November 26, 2024 at 1:18 PM
#oratidbit #db19c Most of the Oracle Database supplied user accounts, except SYS and sample schemas are schema only accounts in 19c, these accounts are created without passwords. This prevents malicious users from logging into these accounts.
November 26, 2024 at 11:52 AM
#oratidbit #db19c Most of the Oracle Database supplied user accounts, except SYS and sample schemas are schema only accounts in 19c, these accounts are created without passwords. This prevents malicious users from logging into these accounts.
#oratidbit In #db19c you can configure quarantine for execution plans for SQL statements that are terminated by the Resource Manager due to their excessive consumption of system resources, such as CPU and I/O. The quarantined execution plans are not allowed to run again.
November 26, 2024 at 10:44 AM
#oratidbit In #db19c you can configure quarantine for execution plans for SQL statements that are terminated by the Resource Manager due to their excessive consumption of system resources, such as CPU and I/O. The quarantined execution plans are not allowed to run again.
#oratidbit #db19c The automatic indexing feature automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle database based on changes in the application workload.
November 26, 2024 at 9:46 AM
#oratidbit #db19c The automatic indexing feature automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle database based on changes in the application workload.
#oratidbit #db19c. A hybrid partitioned table is a partitioned table in which some partitions reside in the database and some partitions reside outside the database in external files, such as operating system files or Hadoop Distributed File System (HDFS) files.
November 26, 2024 at 9:46 AM
#oratidbit #db19c. A hybrid partitioned table is a partitioned table in which some partitions reside in the database and some partitions reside outside the database in external files, such as operating system files or Hadoop Distributed File System (HDFS) files.
#orcldb #db19c Automatic indexing automatically creates, rebuilds, and drops indexes in a database based on the changes in application workload, thus improving database performance. https://buff.ly/2Gs9m5a
Database Administrator’s Guide
buff.ly
November 26, 2024 at 8:56 AM
#orcldb #db19c Automatic indexing automatically creates, rebuilds, and drops indexes in a database based on the changes in application workload, thus improving database performance. https://buff.ly/2Gs9m5a
#oratidbit #db19c The new SQL Repair Advisor function DBMS_SQLDIAG.SQL_DIAGNOSE_AND_REPAIR creates a diagnostic task, executes it, and accepts SQL patch recommendation for a SQL statement that is generating a critical error.
November 26, 2024 at 8:56 AM
#oratidbit #db19c The new SQL Repair Advisor function DBMS_SQLDIAG.SQL_DIAGNOSE_AND_REPAIR creates a diagnostic task, executes it, and accepts SQL patch recommendation for a SQL statement that is generating a critical error.
#oratidbit #db19c The script catpcat.sql runs the scripts catalog.sql and catproc.sql with parallel processes, thus improving the performance of building the data dictionary manually.
November 26, 2024 at 8:06 AM
#oratidbit #db19c The script catpcat.sql runs the scripts catalog.sql and catproc.sql with parallel processes, thus improving the performance of building the data dictionary manually.
#orcldb #db19c “You can run DML operations on Active Data Guard standby databases. This enables you to run read-mostly applications, which occasionally execute DMLs, on the standby database.” https://buff.ly/2S1Emuh
Concepts and Administration
This chapter discusses the various ways that physical and...
buff.ly
November 26, 2024 at 8:06 AM
#orcldb #db19c “You can run DML operations on Active Data Guard standby databases. This enables you to run read-mostly applications, which occasionally execute DMLs, on the standby database.” https://buff.ly/2S1Emuh
November 26, 2024 at 8:06 AM
#orcldb #db19c Installing and running Oracle Database 19.2.0.0 on Oracle Linux 7 - DBA - Rodrigo Jorge - Oracle Tips and Guides https://buff.ly/2TPBEK1
Installing and running Oracle Database 19.2.0.0 on Oracle...
In this article I will describe how to install and run th...
buff.ly
November 26, 2024 at 8:06 AM
#orcldb #db19c Installing and running Oracle Database 19.2.0.0 on Oracle Linux 7 - DBA - Rodrigo Jorge - Oracle Tips and Guides https://buff.ly/2TPBEK1
Automatic Indexing in 19c
One of the most impressive new features of Oracle Databas...
buff.ly
November 26, 2024 at 7:07 AM
#oratidbit The #db19c view DBA_REGISTRY_BACKPORTS shows the bugs that have been fixed by the patches applied to the database. Only the bug fixes that have modified the data dictionary are displayed in this view.
November 26, 2024 at 7:07 AM
#oratidbit The #db19c view DBA_REGISTRY_BACKPORTS shows the bugs that have been fixed by the patches applied to the database. Only the bug fixes that have modified the data dictionary are displayed in this view.
#oratidbit #db19c The LISTAGG aggregate function supports duplicate elimination by using the new DISTINCT keyword.
November 26, 2024 at 7:07 AM
#oratidbit #db19c The LISTAGG aggregate function supports duplicate elimination by using the new DISTINCT keyword.
#oratidbit #db19c The standby database is flashed back automatically when Flashback Database is performed on the primary. If you do not want the standby to automatically follow the primary, either keep the standby database in OPEN mode or stop the MRP process on the standby.
November 26, 2024 at 6:17 AM
#oratidbit #db19c The standby database is flashed back automatically when Flashback Database is performed on the primary. If you do not want the standby to automatically follow the primary, either keep the standby database in OPEN mode or stop the MRP process on the standby.
#oratidbit #db19c The ALTER SYSTEM clause FLUSH PASSWORDFILE_METADATA_CACHE refreshes the metadata cache with the latest details of the database password file. The latest details of the database password file can be retrieved by querying the V$PASSWORDFILE_INFO view.
November 26, 2024 at 6:17 AM
#oratidbit #db19c The ALTER SYSTEM clause FLUSH PASSWORDFILE_METADATA_CACHE refreshes the metadata cache with the latest details of the database password file. The latest details of the database password file can be retrieved by querying the V$PASSWORDFILE_INFO view.
#oratidbit #db19c You can tune the Oracle Data Guard automatic outage resolution using DATA_GUARD_MAX_IO_TIME and DATA_GUARD_MAX_LONGIO_TIME parameters.
November 26, 2024 at 5:42 AM
#oratidbit #db19c You can tune the Oracle Data Guard automatic outage resolution using DATA_GUARD_MAX_IO_TIME and DATA_GUARD_MAX_LONGIO_TIME parameters.