Toad for Oracle 2024 R2 Edition v24.2.275.4664 (x86 / x64)

Toad for Oracle is a database development and management toolset that reduces the time and effort developers and DBAs spend on daily tasks. Save time and reduce risks with the leading Oracle database development and optimization software tool, as ranked by IDC.

Only Toad empowers you to:

• Implement consistent and repeatable processes, supporting agile DB development.
• Accelerate application delivery, while minimizing risks associated with database changes.
• Ensure functional accuracy and scalability with automated testing.
• Quickly pinpoint and resolve database performance inefficiencies.
• Automate SQL optimization.
• Automate and schedule complex or routine database tasks.

Simplified database development
Design, build, edit, debug and manage projects with Toad Data Modeler, and built-in Database Browser, SQL Editor, Debugger and Project Manager.

Code quality assurance
Collaborate with team members and standardize code formatting while preserving code integrity and preventing overwrites with included Team Coding and version control.

Automated code testing
Automate the creation and execution of functional code tests to ensure application quality and enable faster delivery of quality code with Code Tester.

Automated code analysis
Automate code reviews using industry best practices and predefined and/or customizable rulesets in categories such as readability, correctness, program structure, naming conventions and maintainability, with Code Analysis.

Automated performance optimization
Pinpoint database bottlenecks with Spotlight database diagnostics and resolve issues quickly or validate SQL, PL/SQL and indexes to ensure high performance through the only automated SQL tuning toolset, SQL Optimizer.

Database performance testing
Conduct performance and scalability testing as well as industry-standard benchmark testing in pre-production with Benchmark Factory tool to ensure any database changes made will scale under user and transaction load.

Database health and stability
Assess your database’s health and generate reports on over 200 aspects of database performance, configuration, schemas and security vulnerabilities with Toad DB Admin Module’s Database Health Checks.

Team collaboration
Share code, scripts, artifacts, standards and best practices with the team or across the development organization through integration with Toad Intelligence Central application.

Risk mitigation and automation
Automate complex, frequent or repetitive tasks and processes including schema compares, script execution, administration (users and permissions), report generation, SQL optimization and more with Toad Automation Designer and its Toad Apps to save an enormous amount of time and reduce the risk of manual errors.

What's new in Toad for Oracle 2024 R2 Edition v24.2.275.4664

Product Version
Toad for Oracle now uses a product version corresponding to the year of release, e.g 2024 R2 for the second release in 2024.

Toad for Oracle Subscription Editions
All Subscription Editions are available in an 'AI Enabled' version, which includes everything in the standard edition plus the AIExplain feature to assist with code comprehension.

Oracle 23ai Support

• SQL Firewall (Database menu | Administer | SQL Firewall) Note: Requires DB Admin module
• Tablespace Shrink
• Logical Partition Tracking
• Open pluggable databases in hybrid read-only mode
• Hybrid partitioned tables with interval and auto list partitioning
• Rename LOBs without moving them
• Concurrent refreshes in materialized views
• Read-only users
• Enable/disable dictionary protection
• Individual columns in Unified Audit Policies
• VECTOR datatypes
• VECTOR indexes
• Staging tables
• Create Tablespace window defaults to 'bigfile'

Accessibility

• Improved keyboard navigation in Toad Options.
• Data Grid context menu activates with F10.
• Editor caret width is configurable (Toad Options | Editor | Display).
• Editor shortcut to toggle focus between dock panel and edit area (F6) is now customizable (Toad Options | Toolbars/Menus | Shortcuts).
• A new 'Focus Toolbars' feature has been added to the Window menu, enabling you to highlight and interact with a specific toolbar. You can navigate through toolbar buttons using the TAB key and activate them with ENTER. This feature can also be accessed via the customizable shortcut Ctrl+` (Toad Options | Toolbars/Menus | Shortcuts).
• A 'Docked Panels' feature has been added to the Window menu, allowing you to highlight a specific docked panel.
• Improved keyboard navigation in the 'Add Multiple Logins' and 'Edit Login' windows available from the database login window.

Schema Browser

• The roles filter now includes an option to exclude roles managed by Oracle.
• The 'Drop Index' confirmation dialog includes an option to drop any constraints that would otherwise prevent the index from being dropped, avoiding the ORA-02429 error. If selected, both the constraint and the index will be dropped.
• Custom queries and filters can be saved globally for a specific table name (Toad Options | Schema Browser | Data).
• The 'Data' tab filter utilizes the date format set in the options (Toad Options | Data Grids | Data).
• The base and log tables for Materialized View Logs are displayed on the 'Info' tab.
• Introduced the option to enable or disable Unified Audit Policies.
• Introduced icons to indicate whether Unified Audit Policies are enabled.

Editor

• Advanced options have been added to control editor rendering, enhancing appearance on high-DPI displays (Toad Options | Editor | Behavior).
• Shift + Right-clicking on a database object name displays the Schema Browser context menu.
• An option has been added to collapse all regions at any level when using 'Fold All' (Toad Options | Editor | Behavior).
• Single Record View displays the table name.

Connections

• An option has been added to disconnect after a specified period of inactivity (Toad Options | Oracle | Connections).
• A connection timeout option has been added to abandon slow connection attempts (Toad Options | Oracle | Connections). Applies to clientless connections only.

Data Grids

• Improved appearance on high-DPI displays.
• Rearranged the context menu to make the most frequently used feature easier to access.

Describe Window

• Introduced a refresh button.

SGA Trace/Optimization

• Renamed to 'Shared Pool Browser.'
• Individual statements can be purged from the shared pool.

Connection Colors

• Introduced a 'Suggest' feature to recommend a color based on user-defined rules.

Session Browser

• Introduced 'Styles' to the context menu of the 'Sessions' tab grid.

Font Dialog

• The font chooser dialog can be filtered and will retain your recent selections.

Create Constraint

• A warning is displayed if you are about to create a circular foreign key constraint.

Automation Designer

• Enhanced the placement of actions when double-clicking in the palette.

Code Insight

• An option has been added to filter by 'Contains text' or 'Starts with text' (Toad Options | Editor | Code Assist).

DB Health Scan

• Informational and statistical items no longer contribute to the pass/fail status.
• Failures are now reported as the count of failed checks instead of the total number of failures.

Compare Schemas

• 'ALTER TYPE' is utilized, when feasible, to synchronize types and prevent errors associated with 'CREATE OR REPLACE TYPE' when dependencies are present.

Compare Databases

• Introduced a preview panel.

Manage User Settings

• Introduced the ability to restore individual settings from backup.

Workspaces

• Introduced a 'Cancel' button to halt workspace loading.

Master-Detail Browser

• Added "Current Schema" option to make configuration files portable across different schemas with the same tables.

Project Manager

• A filter has been added to refine nodes.

Explain Plan

• Additional 'Copy to Clipboard' actions have been added to copy content as an image or XML.

Team Coding

• Introduced a 'Locked By' field in both the Schema Browser and the Editor.
• Introduced an option to designate either the operating system username or the database login username as the lock user.

utPLSQL

• Introduced support for utPLSQL 3.14.

This release includes:

• Toad for Oracle 2024 R2 Edition v24.2.275.4664
• Spotlight on Oracle v11.0.0.21
• SQL Optimizer for Oracle v10.0.0.238 Enterprise
• Benchmark Factory for Databases v9.0.0.288
• Toad Data Modeler v7.3.0