ORA-01000: maximum open cursors exceeded

ORA-01000: maximum open cursors exceeded – It’s typical error encountered in Oracle database. It happens when too much cursors are opened on an oracle instance. Maximum number of opened cursors ...

Oracle 18c-RPM Based Installation

yum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm Loaded plugins: langpacks, ulninfo Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: ...

oracle 18c new features

Snapshot Carousel This is a repository for periodic point-in-time copies of a PDB. The Snapshot Carousel is ideally suited to development environments that typically require multiple copies of ...

oracle 18c-Private temporary tables

Oracle Database 18c introduces the concept of a private temporary table—a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup. In the ...

oracle 18c-Read-only Oracle Home

The new password file location enables you to mount one shared read-only Oracle Home on different systems, making deployment for complex architectures more reliable and simpler. In other words, a ...

Oracle 18c-Checklist for upgrade

Oracle 18c – Complete checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1.x.x to 18.x.x.x (Doc ID 2422161.1) Oracle DB 18c – Complete Checklist for ...

oracle 18c-Password file location

The default location for the Oracle Database 18c password file is now ORACLE_BASE instead of ORACLE_HOME/dbs. This change enables you to use Oracle Home as a static repository for database files. ...

oracle 18c-SQL Cancel

In past versions of Oracle whenever a database administrator needed to cancel a SQL query, the session that was running the SQL had to be killed. This meant the session had to be removed from the ...

Oracle Always Free cloud services

Databases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We need choose Always free while database ...

Start typing and press Enter to search