Tips & Tricks

Tosska SQL Tuning Expert (TSE™) for Oracle®

Can I use TSE™ to tune and test run DML statements?

Yes, you can tune DML statement such as Insert, Update and Delete statements. All update data will be rollback after ...
Read More

Do I have to install Oracle Client to connect a database?

No, you can use “Basic Type” option in the Connection Mode when you are creating a connection in Connection Manager ...
Read More

Do I use elapsed time or response time as my SELECT statement tuning objective?

Best elapsed time as the tuning objective for SELECT statement is normally useful for most situations, but for some online ...
Read More

How can I speed up the tuning process for long runtime SQL?

Yes, if you have an expected runtime of your SQL statement, you can use it as the termination time to ...
Read More

How many times should I test run each SQL alternative?

If your SQL’s runtime is short such as less than 10 seconds, the time of data cache from hard disc ...
Read More

I cannot find a better SQL in the current SQL alternatives, what should I do?

If you cannot find a SQL with satisfied performance in current SQL alternatives, you can increase the Intelligent Level to ...
Read More

What should I do if no better alternatives can be found for my SQL?

If you cannot find better alternatives at the current Intelligent Level, you can increase the Intelligent Level or disable the ...
Read More

 

Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®

Do I have to implement all indexes recommended by TSE Pro?

You can evaluate the efficiency of the recommended indexes to your SQL workload to select most effective indexes for your ...
Read More

Do I use elapsed time or response time as my SELECT statement tuning objective?

Best elapsed time as the tuning objective for SELECT statement is normally useful for most situations, but for some online ...
Read More

What kind of SQL workload should I capture for index recommendation?

You should capture the most representative SQL workload that created performance problem in your system. For example, if there was ...
Read More

What should I do if no better alternatives can be found for my SQL?

If you cannot find better alternatives at the current Intelligent Level, you can increase the Intelligent Level or disable the ...
Read More

 

Tosska In-Memory Maestro (TIM™) for Oracle®

Should I use only the biggest IM size recommendation from IM Advisor?

It all depends on how much physical memory you have, if your system memory configuration is tight, you should consider lower IM size solution with comparable improvement with biggest IM size solution.