Tag: Oracle

Today’s post is another dealing with AWS services. Let’s say you need to read trace files from RDS — how would you do it? Here’s an example of how to list and read those files based on the directories from…

Did you know PL/SQL generalized invocation has been available since 11g? The generalized invocation allows a subtype to invoke a method of a parent type (a supertype) using the following syntax: (SELF AS supertype_name).method_name Yes, this is the concept of…

When you’re sure all the TNS listener (SID_LIST_LISTENER in this case) services and db_domain are fine, but you still face the ORA-12537: TNS:connection closed error when trying to remotely access an open database, what can you do next? [[email protected] admin]$…

This blog post is based on a real customer case, and illustrates how v$sql reports execution statistics for certain DML types of operations (I purposely have not named which DML types … yet). These reports can be misleading when troubleshooting…

In this post I’d like to present five best practices/tips for setting dispatchers for database shared connections: 1. Set local_listener on both instances of the database alter system set LOCAL_LISTENER=”(address=(protocol=tcp)(port=1521)(host=yourhost))” scope=both sid=’instance_name’; Ref: Shared Server: Dispatchers Are Not Registered With…

Loading “views” from one database to another seems to be a simple request, right?  Let’s go to the regular cases/simple answers: Use DBMS_METDATA.GET_DDL to get the view code: DBMS_METADATA.get_ddl (‘VIEW’, <VIEW_NAME>, <OWNER>) Use datapump with include=VIEW, or even specifying the…

Oracle EBS (E-Business Suite) customers have always been left a little behind by technological innovations happening at Oracle. Since 18c, Oracle Database has offered a new feature called Read-Only Oracle home (OH). However I haven’t noticed much traction for this…

Oracle MySQL Community Edition comes with a native, virtually synchronous, clustering solution called InnoDB Cluster. This clustering solution uses a technology under the hood called Group Replication. This technology is very similar to Galera Cluster, although where Galera relies on…

When writing PL/SQL, should you use ‘select from dual’ to assign variable values? The answer may surprise you.

Learn a simple method to make Oracle use the index required for a SQL Query.