Tosska SQL Maestro Lite (TSMLite) is an ultimate SQL Tuning solution that can optimize SQL statements and recommend indexes for any database systems.
SQL Tuning Module
This module helps user to tune a SQL statement and generate a better SQL alternative with performance. With our newly invented Real Balance Search algorithm, our engine can solve very complex SQL statement without bias to certain branches of a SQL syntax. Our SQL solution support the following solutions.
SQL Text Replace
SQL Plan Baselines
SQL Translator Substitute
Index Advisor Module
It is a workload based index advisor embedded with our proprietary AI engine to quickly recommend a set of indexes for a given SQL workload, the recommended indexes can further improve existing SQL statements no matter indexes are manually built already. Our Index Advisor are smart enough to review exist indexes configuration to recommend new indexes, indexes to drop or indexes replacement solutions. SQL workload statements are easy to capture from Oracle AWR or SGA without extra effort by developers or DBAs.
Welcome to the world of Tosska ! We are happy that you have decided to partner with us to let us help you with our Tosska solutions.
Please select the product (and choose the options, if any) that you want and add it to your shopping cart. When you have finished shopping with us, go to the shopping cart to do your final review and make sure they are what you want and then select ‘proceed to checkout’. In the checkout page, please fill in the Order details. Please double check and make sure that your email address is correct as this will be where we will be sending you the Tosska Product Link for download (if applicable) and Product License Key.
When you have finished fill in the required information, press ‘continue to payment’ to finish the remaining buying process. You will then be directed to the PayPal payment page. Follow the instructions online and we will then process your payment online.
Upon successful processing of your payment, you will receive an email that contains your order details as well as a link to download the Tosska Product of your choice, if applicable. Please note that this link will allow a maximum of 3 downloads (in case your download is not successful and need to retry) and will expire in 30 days. A separate email will also be sent to you separately that contains the License Key that is unique to this order. You will need this License Key in order to install and run the Tosska Product properly. Please note that the information contained in these two emails is strictly confidential and you should not release it to anyone else. Please keep them in a secure and safe place.
Enjoy using your Tosska product and welcome to the Tosska family !
Tosska In-memory Maestro (TIM™) for Oracle® automates the In-memory SQL optimization process and provide In-memory objects recommendations for a given SQL workload with our proprietary artificial intelligent engine. It also provides user friendly In-memory simulation function for user to virtually evaluate their in-memory table objects for one SQL or a given SQL workload without actually populating those table objects.
Key features of TIM™ includes the IM SQL Tuning module that optimizes SQL statement within In-memory environment with uncompromised performance tuning ability, the IM Advisor which uses Tosska’s proprietary artificial intelligent engine to provide unparalleled In-memory objects recommendations for a given SQL workload from AWR or SGA. With TIM™’s IM Simulator, users can do virtual In-memory objects simulation for a given SQL workload without actually populating the selected table objects. TIM™ also provide tools to make your life easier in managing your IM environment. IM Objects Manager is a graphical tool to help user to manage In-memory objects with just point and click while IM Configuration is a tool that helps user to review a database current In-memory setting and to enable or setup a new In-memory configuration.
Connecting and Configuring
To start using TIM™, users have to set up a connection with the targeted database using the Connection Manager. Users can then use the IM Configuration tool to review a database current In-memory status, usage in different size pools and setting as displayed in the In-Memory Usage Panel, and to enable or setup a new In-memory configuration using the In-Memory Option Panel.
IM SQL Tunning
For mission critical SQL statements, users may want to tune their SQL with Oracle In-memory feature to the best performance. TIM™ provides an innovative function to help user to evaluate and tune a SQL with relevant table objects hypothetically populating into in-memory or depopulating from in-memory. A proprietary artificial intelligent engine is embedded to thoroughly explore most combinations of table candidates that manual SQL tuning cannot achieve, it is especially helpful for complicated SQL statement tuning with many tables join.
IM SQL Tuning modules provides a SQL Text Panel for users to input or paste a SQL statement in this panel for tuning. Using User Scenario function, user can simulate the scenario of a SQL statement that if certain tables are putting into in-memory or removing from in-memory with specific retrieval operations and review what impact to the SQL’s execution plan.
Alternatively TIM™ provides the Auto Scenario option where users can press this button to try most in-memory objects combinations of the SQL statement with necessary hints application, unique execution plan scenarios will be displayed for bench-marking.
Users can select one or multiple scenarios to test run with the Test Run Options provided in TIM™ to actually execute scenarios for bench-marking. With the Compare SQL Scenarios function, users can review two SQL statements/scenarios side by side, the SQL text, execution plan and statistics are displayed for easy comparison. Any discrepancy in execution plans will also be highlighted.
Due to the in-memory size limitation, user must be very careful to select what tables to populate into in-memory and work best for a given SQL Workload. A SQL workload is a set of SQL statements captured from Oracle AWR or SGA at a specific time, there may be up to thousands of SQL statements that are accessing more than hundreds of tables. So, how to select tables to populate into in-memory within a given memory size is always a difficult problem. Furthermore, user may want to know that if there any solutions that can provide comparable solutions with less memory requirement for a given workload.
A maximum memory size is given by user; TIM™ can recommend solutions with less In-memory requirement.
With Tosska’s proprietary artificial intelligent engine, the IM Advisor is able to find the best recommendation of IM objects within a certain quota or time period for SQL workload from AWR or SGA. The recommended IM objects will have the best impact to the given workload. It means user can use this module to improve performance for a specific time slot SQL workload from AWR or current SQL workload from SGA.
When a new advisor session is created, user will be asked to extract SQL from SGA or AWR to compose a SQL workload for recommendation of IM objects. Once the extract SQL is finished, the IM Advisor screen will be displayed, the number of SQL captured and valid SQL with successful explain plan will also be displayed. You can review the details of SQL by clicking the hyperlink SQL Details anytime on this screen.
The IM Simulator is used to simulate how a number of virtually selected in-memory table objects that impacts a SQL workload captured from SGA or AWR. User can use the module to improve database performance for specific hours of a day; for example if a user want to improve the peak hours performance of a day, the user can capture the SQL workload from SGA by that time or extract the SQL from AWR within that time slots. A list of SQL relative tables will be displayed for the user to carry out impact simulation. User can select any tables and virtually put them into in-memory to see the impact to the captured SQL workload.
IM Objects Manager
TIM™ provides this handy tool for users to manage their IM objects by altering it into In-memory with various types of option or bring it down from their In-memory in “All Objects” page. An IM objects occupancy map on top is also be displayed for users to understand the objects’ size and distribution easily. Users also can use the “In-memory Objects” page to review those objects already put into In-memory.
Tosska understands that nothing is more convincing than doing a trial of the product in your own environment. Therefore Tosska provides trials of all Tosska products free of charge for 30 days.
Just pick the product you want to do the trial and you will be presented with the Trial Key Request Form (limitations of the Trial Product as compared to the live product will also be listed for your information).
All you need to do is to fill in your email address, make sure the email address is correct and press the submit button. Then the download of the Free Trial will start immediately. A separate email that contains the Free Trial Key will be sent to you at the email address you entered. You will need this Free Trial Key when installing the Trial Product. It’s that simple !
You are welcome to submit your support requests / bug reports to us by sending emails to firstname.lastname@example.org or by filling in the Support Request Form. However, before submitting such request, we recommend you to do the followings :
Make sure to first read the FAQ page and the documentations included with the product.
Make sure you can reproduce the problem with the latest version of the Product.
When submitting a support request / bug report :
Please select the correct product version and fill in the correct license no.
Use ‘Short Description’ to highlight the issue you are reporting.
If you are reporting a bug, please include the description of the problem, the steps to reproduce the problem and what was the expected result in the ‘Details’ section. If possible, please also include any data creation script and SQLs used. Or else, describe the services that you need.
If you get an unexpected exception error when using the product, the exception windows will be shown automatically. You can click the ‘Create Support Bundle’ option to generate the Support Bundle. Or alternatively, you can go to the menu on the top right hand corner and select ‘Support Bundle’ anytime to generate the Support Bundle. Then send the Support Bundle to us as an attachment via email to email@example.com.