Tag: Oracle

AWS RDS: Read Oracle Traces from SQL*Plus

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…

Read More >

PL/SQL Generalized Invocation

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…

Read More >

ORA-12537: TNS:connection closed – When Nothing Else Works!

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]$…

Read More >

DML by Unique Index Supposedly Affecting Many Rows

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…

Read More >

Five Best Practices for Setting Dispatchers on Shared Connections

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…

Read More >

Loading “Views” from One Database to Another

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…

Read More >

Make Database Security Patching Consistent

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…

Read More >

Watch Out When Running Out of Disk Space With InnoDB Group Replication Cluster

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…

Read More >

Select vs Assign – How To Assign PL/SQL Variables

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

Read More >

How to Make Oracle Use the Correct Index

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

Read More >
Page 5 of 169« First Page...34567...10...Last Page »