Posted On: Oct 4, 2018

Amazon RDS for Oracle now supports Oracle SQLTXPLAIN (SQLT) version 12.2.180331 through the use of the SQLT option. You can improve SQL query performance by using the Oracle EXPLAIN PLAN statement, and looking at diagnostic information on the execution plan of a SQL statement.

The Oracle SQLT utility produces a report that includes execution plans, statistics, optimizer parameters and other information that can be used to tune a SQL statement for optimal performance. For more details on using the SQLT option, please refer to the Amazon RDS for Oracle Documentation.

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. See Amazon RDS for Oracle Database Pricing for complete regional availability information.