Posted on

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

Before installing Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®, please make sure your system meets the following minimum hardware and software requirements:
 

CPU 1.8 GHz Processor
Memory 2 GB of RAM minimum, 4 GB of RAM recommended
Hard Disk Space 200 MB of disk space for 32-bit installation
400 MB of disk space for 64-bit installation
Operating System Microsoft Windows® 7 32-bit and 64-bit
Microsoft Windows® 10 32-bit and 64-bit
.NET Framework Microsoft .NET Framework 4.5
Database Client Oracle® 9i Client
Oracle® 10G Client
Oracle® 11G Client
Oracle® 12c Client
Oracle® client is not required when Basic Type is used for Connection Mode
Database Server Oracle database 11.2 or higher version (11.2, 12.1 and 12.2)
Posted on

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 software requirements:
 

CPU 1.8 GHz Processor
Memory 2 GB of RAM minimum, 4 GB of RAM recommended
Hard Disk Space 200 MB of disk space for 32-bit installation
400 MB of disk space for 64-bit installation
Operating System Microsoft Windows® 7 32-bit and 64-bit
Microsoft Windows® 10 32-bit and 64-bit
.NET Framework Microsoft .NET Framework 4.5
Database Client Oracle® 9i Client
Oracle® 10G Client
Oracle® 11G Client
Oracle® 12c Client
Oracle® client is not required when Basic Type is used for Connection Mode
Database Server Oracle® database 11G, 12C
Posted on

Tosska SQL Maestro Lite (TSMLite™) – At a Glance

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.

Management Modules

  • SQL Baselines Manager
  • SQL Translator Manager