Jan 2, 2020
Check SQL Query performance with different session parameters
Check SQL Query performance with different session parameters
Check SQL Query performance with different session parameters
The Step third will test the SQL queries with all instance or session parameter for testing the SQL queries in one go. which will let you know which parameter changes will help SQL queries to run better in your environment.
1. Save the SQL Query in Q.SQL file
2. Login with user of the schema from which SQL query object exists SQLPLUS…
View On WordPress