KeepTool 16.0.0

Agora você pode habilitar o Oracle Rest Data Services (ORDS) para os seus esquemas.
Setembro 21, 2023
Nova versão

Recursos

  • Improved KeepTool appearance.
    • The new Light Style rendering option allows you to display all supported controls without double or thick borders, extra outlines, and other visual noise. Light Style enables extra cell and header paddings, as well as lightweight borders in a control.
  • You can now establish secure direct TCP/IP connections. In expanded view, the connect dialog now allows you to select a secure connection type:
    • Direct TCP/IP connection - The connect dialog establishes a regular direct TCP/IP connection without enhanced security.
    • Direct SSL connection - This is the recommended type in case a secure connection is needed.
    • Direct SSH connection.
  • A new page for Oracle Rest Data Services (ORDS) has been added. You will find the appropriate button on the "Additional" sheet. On the bottom of the page is an always-visible data grid for ORDS schemas. Here you can enable ORDS for your schema. The main area contains the following tabs:
    • Overview ORDS Modules.
    • ORDS Templates.
    • ORDS Handlers.
    • ORDS Privileges and associated mappings, roles and modules.
    • ORDS Roles and associated roles and web service mappings.
    • ORDS Objects and members.
    • ORDS Clients.
    • ORDS Approvals.
  • SQL page
    • The last file change timestamp is now displayed in the header.
    • Recently changed SQL files are now highlighted in green. As time goes by, the green tone fades to the regular white background in three steps.
    • The tree view now displays a slightly changed icon for the currently selected item. It shows a pen in-front of the document symbol.
    • For large SQL scripts (+10K lines), the "Execute Script" menu item now allows you to optionally disable visual feedback and dbms_output logging in order to boost script execution performance.
  • Tables page
    • Added a new submenu item 'Copy to clipboard | truncate statement' on the tables overview grid. Similar to the already existing submenu items, it copies a TRUNCATE statement to the clipboard.
    • The modal dialog "Truncate table" now has a new "cascade" option.
    • On the Constraints tab, both menu items "Enable constraint" and "Disable constraint" have been enabled for multi-select.
    • There are two new context menu items for indexes. Both are enabled for multi-select:
      • Make Unusable - Makes the index unusable. You may consider dropping indexes or at least switching them unusable before inserting mass data.
      • Rebuild Online - Reverses the unusable operation.
  • Data Content
    • Create INSERT script now creates bulk INSERT ALL statements. You can now change the number of records collected into one statement in the settings dialog. You can also set bulk size to "1" to enforce the creation of traditional non-bulk statements.
    • INSERT scripts are now split in multiple files if the size exceeds a value that can be changed in the settings dialog.
    • INSERT scripts can now use direct path operations, if the appropriate checkbox in the settings dialog has been enabled. It adds the /*+append*/ hint to INSERT statements and a COMMIT after each.
    • Script file writing performance has been improved by using buffered streaming technology.
    • The new dialog "Flat detail data browser" is now available from the context menu of the data contents grid.
  • Both Data Content and SQL query result grids, as well as record views, now show data type icons next to each field caption.
  • The PL/SQL call interface now lists procedure and function names in mixed case as defined in the source code rather than upper case as queried from the ALL_ARGUMENTS data dictionary view.
  • Synonyms page
    • Added new menu items "Compile" an "Rename".
    • The existing "Properties" menu item now drops and re-creates the synonym with changed properties.
  • Scheduler detail information is now displayed below the master grid rather than in-place.
  • The database link properties dialog now gives you more space for entering data.
  • Added a new "Flags" tab on the settings dialog which allows you to customize the captions of the color tags.
  • Tablespaces page
    • Data file grids on both tablespaces and database pages now display a percentile usage of the auto-extensible range, similar to the display on the tablespace overview grid.
    • Both detail grids are now displayed below the datafiles grid, separated by a slider. Besides some SQL optimization, this results in a better overall performance.
    • The "add datafile" dialog now comes up with new default values:
      • The filename is a copy of the currently selected datafile including '_new' suffix.
      • Both 'initial' and 'next' size parameters are derived from the 'next' size of the currently selected datafile.
      • 'Max' size is assumed to be unlimited.
    • Sizes are displayed in GByte, if the size represents an integer Gigabyte value.
    • The DDL for tablespace creation now contains the 'MAXSIZE UNLIMITED' clause if the size equals the actual maximum datafile size of your database.
  • You can now see tablespace quota on three Hora pages in different contexts: Tablespaces | Utilization by User and Users | Tablespace utilization and Schema | Summary. The display has been improved and unified as follows:
    • Quota and current usage are displayed together in one grid. The tab caption is now "Utilization by User" or "Tablespace utilization" respectively.
    • Unlimited quota is displayed as 'UNLIMITED' rather than the internal dictionary representation of '-1'.
    • There is a new checkbox that indicates if the user has been granted the UNLIMITED TABLESPACE system privilege that allows bypassing any restrictions given by quota.
    • The Schema - Summary page now displays tablespace utilization and, if available, quota.
  • CDB page
    • Added a new option to open a PDB in restricted mode,
    • The Create PDB dialog has got two new optional parameters:
      • PDB max size.
      • Path prefix.
  • The database page now displays the time zone file version from v$timestamp_file in a prominent place.
  • SGA page
    • Now shows component size info from V$SGA_INFO rather than V$SGA. For backward compatibility, the prior information is still available on the last "deprecated" tab.
    • Unit of measurement has been changed to MBytes.
  • The 'Default Roles' dialog on the user's page now evaluates SYS.USER$.DEFROLE and displays the result in a radio group with items NONE, ALL, and selection.
KeepTool 16.0.0
KeepTool Enterprise

KeepTool Enterprise

Ferramentas intuitivas de banco de dados Oracle.

Solicite orçamento Comprar agora

Tem alguma pergunta?

Chat ao vivo com nossos especialistas de licenciamento de KeepTool.