PL/SQL Developer 13.0

Oracleのデータとプログラムの負荷テストと並行性テストを行う新しいテストツールを追加
1月 08, 2019 - 13:06
新バージョン

特徴

  • New Load Tester tool
    • Perform stress tests and concurrency tests for your Oracle data and programs.
    • Find performance issues and locking issues with multi-user scenarios, and test the results of optimizations.
    • Define steps, sub steps and loops to perform specific SQL statements or PL/SQL blocks to mimic the behavior of users of a specific application. For each step you can define execution properties such as the SQL text, repeats, and delays, as well as variables to generate random data or to get data from previous steps.
    • Specify for how many concurrent threads these steps will be executed and which Oracle accounts should be used. The performance results can be viewed in real-time as text, bar chart, or line chart.
  • Editor Enhancements
    • After making a column selection with Alt-select, you can now type new text for the column. The newly typed text will be repeated on each line of the column selection.
    • You can now increase or decrease the editor font size by pressing Ctrl +/- on the numeric keypad.
    • The "Go to line" function now has an option to move relative from the start of the text, from the cursor position, or from SQL start position.
    • The editor now highlights corresponding value expressions when the cursor is in an insert column list. Previously this only worked when the cursor was in the insert values list.
    • The editor now highlights all table.column occurrences in a select statement when clicking on the table name in the statement.
    • Editor now highlights all field occurrences in a select statement when clicking on a field in the statement.
    • Function keys have been added for fold and unfold operations.
    • A new "Duplicate line" function key has been added.
    • A new "Editor: First Character on Line" function key has been added.
    • A new "Delete unindents" preference has been added. When enabled, pressing the Delete key will delete all tabs and spaces to the right of the cursor position.
  • Code Assistant Enhancements
    • A new "Filter method" option has been added. It can be set to "Contains" to display all items that contain the filter text, or it can be set to "Starts with" to display all items that start with the filter text (the previous behavior).
    • The Code Assistant will now show a directory listing after typing @ in the Command Window.
  • Find & Replace Enhancements
    • Support had been added for special characters (e.g. \t) and subexpressions (e.g. $1) in the replacement text when using regular expressions.
    • There is now a separate recall history for regular expressions.
    • There is now a syntax selection list for the find text and replacement text when using regular expressions.
  • SQL Window Enhancements
    • You can now enter a column filter for a result set to limit the visible columns based on the column name and data type, or include only mandatory columns or include only primary/unique/foreign key columns.
    • You can manually enter the filter expression (such as "owner, name" above, to show all columns with these 2 words in the name), or you can build a column filter by pressing the [...] button.
    • A "Compare to..." popup menu item has been added to compare the window contents to other file contents.
    • You can now update invisible columns in a result set.
    • The "Save Windows state" preference now also works for SQL Windows.
    • The vertical splitter position is now preserved if manually moved.
    • The EXCEL=filename and CSV=filename comment directives now also support %dd%, %mm% and %yyyy% as variables for the filename.
  • Program Window Enhancements
    • Preferences for PL/Scope identifiers "Default", "Public", "SQL" and "PL/SQL" added.
    • Preferences for PL/Scope statements "None", "All" and "Default" added.
    • Refactoring function keys have been added.
    • A "Save with trailing slash" preference has been added.
    • DBMS_Output is now retrieved when executing a PL/SQL Block.
  • Test Window Enhancements
    • The "Save Windows state" preference now also works for Test Windows.
    • The "Test" function now uses original case from the database source for generated function and procedure calls if "Use original case" Code Assistant preference is enabled.
    • A "Set Logpoint" item has been added to the margin popup menu to quickly define a breakpoint that only logs information.
    • A notification sound is now played when a long running debug step is finished.
  • Command Window Enhancements
    • CD and DIR commands have been added.
    • All commands now support environment variables.
    • SHOW ENVVAR and SET ENVVAR = commands added.
    • The Command Window now automatically shows the new connection information when the connection changes.
  • PL/SQL Beautifier Enhancements
    • The PL/SQL Beautifier now supports FETCH FIRST ROWS clause.
    • Using the PL/SQL Beautifier for a "create or replace view" command now implicitly formats the select statement of the view. Previously you had to explicitly mark the select statement.
    • The "Automatically Beautify" preference can now be enabled for all applicable window types. Previously this would only apply to the Program Window.
    • You can now invoke the PL/SQL Beautifier when marking SQL in the Session Window.
  • Table Definition Editor Enhancements
    • Support added for invisible columns (Oracle 12.1 and later).
  • Diagram Window Enhancements
    • When adding a table to a diagram, you now have the option to automatically add related tables.
    • An "Add related tables" option has been added to the table popup menu.
  • Window List Enhancements
    • Status icons have been added for the "Pinned" and "Auto refresh" status of a window:
    • Preference "Show status icons in the Window List" added.
  • Project Enhancements
    • A new "PL/SQL Beautifier Rules" option has been added, allowing specific rules for a project.
    • When creating a new project you now have option to add all windows or only Program Windows and SQL Windows.
  • Object Browser Enhancements
    • A "Test" function has been added to the popup menu for database links.
    • Object Browser Filter "where clause" and "order by clause" are now validated when pressing the "OK" button.
    • Right-clicking on a synonym and selecting "Query data" or "Edit data" will now use the synonym name in the generated query instead of the resolved table or view name.
    • You can now use a backslash as escape character for the filter text.
  • DBMS Scheduler Enhancements
    • Using the "Stop" popup menu item for a running job now provides a "Force" option.
  • DBMS Output Enhancements
    • The file name syntax now has additional variables for the date, for the Oracle username, Oracle database, as well as all environment variables.
    • A preview for the complete file path has been added.
    • A new "Include header in file" option has been added. When enabled an identification header will be inserted every time new output is written to the file.
    • A variable dropdown button has been added to quickly insert a variable into the file specification:
  • Connection Definition Enhancements
    • You can directly define a color indicator for a connection definition. The indicator color can be displayed on the main toolbar, as window background and in other places as defined with the "Connection Matches" preference.
    • You can define that a connection definition should be automatically connected when PL/SQL Developer starts.
    • You will get a warning message when making a duplicate connection definition.
    • Connection popup menu item "Add to Folder" now allows you to immediately select a folder.
  • General Window Enhancements
    • You can now increase or decrease the font size of a grid by pressing Ctrl +/- on the numeric keypad.
    • A "Read Only" popup menu has been added to view or change the read only status of the window and file.
    • The file open dialog now has a connection selector to open a file for a specific connection.
    • The compare functions now use an extension (.pcf) for the compared files, so that the extension can be assigned to a 3rd party difference viewer.
    • If the "Allow multiple connections" preference is disabled off, the the object owner is suppressed in the window title when connected as the object owner.
    • The "File saved" status line message is cleared after 10 seconds to restore the previous message.
    • The status line message now includes the timestamp when execution has finished.
  • Recovery Enhancements
    • The Crash Recovery form now provides an option to restore connections.
    • A new "Open Recovery" function has been added to the "File" ribbon tab to manually open a specific recovery set.
  • Multi Monitor Enhancements
    • If the primary and secondary display have different DPI settings, PL/SQL Developer will now scale to the DPI settings of the display on which it is opened.
    • If the PL/SQL Developer window is moved between displays with different DPI settings, it will dynamically scale to the the target display.
    • The PL/SQL Developer taskbar button will now be placed on the taskbar of the display where PL/SQL Developer is open, and on additional displays depending on the taskbar settings.
  • Other Enhancements
    • Performance has been significantly improved when using many connections.
    • The Oracle HTML Help function is now compatible with Oracle 12.2 and Oracle 18.0 documentation.
    • The configuration files "docking12.ini" (for the dockable tool layout) and "customtoolbars.ini" (for the custom toolbar configuration) can now be distributed as part of the default configuration for new users.
    • The Logon History limit has been increased from 100 to 999.
    • PL/SQL Developer can now collect anonymous usage statistics for product improvement.
    • Environment variable "PLSDIR" has been added for the "%APPDATA%\PLSQL Developer [version]" directory where all preferences and settings are stored.
New Load Tester added to PL/SQL Developer.

PL/SQL Developer

PL/SQLによる開発の時間と費用を節約

ご質問がありますか?

今すぐ Allround Automations ライセンススペシャリストとライブ チャット