Frequently Asked Questions

General

Some users may encounter the error "Submission rejected, token invalid" when trying to download software from our website. If you ...
Read More
Welcome to the world of Tosska ! We are happy that you have decided to partner with us to let ...
Read More
Tosska understands that nothing is more convincing than doing a trial of the product in your own environment. Therefore Tosska ...
Read More
You are welcome to submit your support requests / bug reports to us by sending emails to support@tosska.com or by ...
Read More

Tosska SQL Tuning Expert (TSE™) for Oracle®

Can I replace the variables of a SQL with literals for SQL tuning?

No, due to the Oracle SQL optimizer will treat variables and hardcoded literals in different ways. For example; Select * ...
Read More

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 have to tune the SQL statement again to get the best SQL alternative’s text after I have purchased a license?

No, the best SQL alternative text will be displayed immediately after you input a valid license into TSE™ ...
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

There are some SQL alternatives generated by TSE™ with row count mismatched error during test run?

Yes, it is possible that some SQL alternatives generated by TSE™ may have row count mismatched error. The problem is ...
Read More

Tosska SQL Tuning Expert (TSE™) for Oracle® – System Requirements

Before installing Tosska SQL Tuning Expert (TSE™) for Oracle®, please make sure your system meets the following minimum hardware and ...
Read More

Tosska SQL Tuning Expert (TSE™) for Oracle® Free Download Limitations

Tosska SQL Tuning Expert (TSE™) for Oracle® Free Download version has the following Limitations: If you use TSE™ without a ...
Read More

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

We don’t recommend to use those functions at the same time on the same database, since they might interfering with ...
Read More
Yes, it is the purpose that IM Advisor is designed not only solve your existing performance problems with current inmemory ...
Read More
Unless your production database are free to run IM Advisor for a period of time, we don't recommend user to ...
Read More
Yes, it is still worth it to tune your SQL with IM SQL Tuning even all the tables are already ...
Read More
It all depends on how much physical memory you have, if your system memory configuration is tight, you should consider ...
Read More
Before installing Tosska In-Memory Maestro (TIM™) for Oracle®, please make sure your system meets the following minimum hardware and software ...
Read More
Please note the following limitations when using this trial: IM SQL Tuning Auto Scenario can generate at most 10 auto ...
Read More
If you know when the bottleneck of your system is, you can use AWR to retrieve SQL workload from the ...
Read More
If you have one or more than one of the following questions in mind with the new Oracle® In-memory features, ...
Read More