Amazon RDS for Oracle Supports Oracle SQLT Diagnostics Tool

Posted on: Oct 2, 2017

Amazon RDS for Oracle now supports Oracle SQLTXPLAIN (SQLT) 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 regional availability.