You can call Java stored procedures from any PL/SQL block, subprogram, or package. Usually a Java class has to created which will in turn will be called in a PL/SQL block.
Errors and issues can arise in these Java stored classes/procedures because of restoration or migration or upgradation activities.
The information regarding the Java stored procedures can be obtained from the DBA_OBJECTS view.
You can use the below mentioned query for retrieving the information regarding Java classes.
Tag: Oracle 19c
What is auto-indexing in Oracle 19c?
In Oracle Database 19c, the Automatic Indexing feature automates the index management by allowing Oracle Database to automatically create, rebuild and drop indexes based on application workload. Oracle Database runs the automatic indexing process in the background, analyzes application workload, and creates new indexes and drops redundant and extra ones.
Continue reading “What is auto-indexing in Oracle 19c?”Comparison between various tools/techniques for Oracle database migration and upgradation
There are many ways and techniques to upgrade and migrate existing oracle databases to higher versions, ie 19c.
One can go ahead with transportable tablespaces, rman cloning, datapump,goldengate etc.
Oracle 19c Architectural components Part 2
System Global Area
The System Global Area (SGA) is the memory area that contains data and control information for one Oracle Database instance. All server and background processes share the SGA. When you start a database instance, the amount of memory allocated for the SGA is displayed. The SGA includes the following data structures:
Continue reading “Oracle 19c Architectural components Part 2”
Oracle 19c Architectural components Part 1
An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical files called data files, and can be a non-container database or a multitenant container database. An Oracle Database also uses several database system files during its operation.
Oracle 19c Features.
Oracle Database 19c, is the long term support release of the Oracle Database 12c and 18c family of products, offering customers Premier and Extended Support through to March 2023 and March 2026 respectively. It is available on Linux, Windows, Solaris, HP/UX and AIX platforms as well as the Oracle Cloud. Oracle Database 19c offers customers the best performance, scalability, reliability and security for all their operational and analytical workloads.
Installation and Upgrades
- RPM Based Installation install Oracle 19c Database using RPM method
- Simplified Image based installation of client as well
- Auto Upgrade Utility for Oracle Database
- Docker Container for Oracle 19c
- DryRun mode for GridSetup in clusterware Installation
I am a DBA 