EnterpriseDB Advanced Server’s enterprise-class, cross-platform developer and DBA console now includes EDB*Plus, a command-line terminal interface that emulates Oracle’s SQL*Plus. Like SQL*Plus, EDB*Plus allows users to run SQL and PL/SQL commands interactively. Oracle users accustomed to SQL*Plus will find EDB*Plus immediately familiar. In addition, EnterpriseDB’s new EDB*Loader emulates Oracle’s SQL*Loader and provides even deeper compatibility.
EnterpriseDB Advanced Server 8.3 adds several new features that enhance the database’s ability to run, unchanged, applications written for Oracle. For example, there are more than 20 new Oracle-compatible system views, Oracle-compatible packages now support comments, and ROWNUM can now be used in sub-queries and views. In addition, EnterpriseDB’s new bulk binding feature, which allows collections of SQL statements to be collected and run together to improve performance, further improves Oracle compatibility.
Other updates to the new software include:
- A DBA monitoring console that provides real-time charting for CPU and memory usage, disk I/O, and cache hit ratios across multiple EnterpriseDB databases
- Support for embedded hints, which can alter program execution
- Transaction error recovery support, which enables implicit statement-level transactions
- Updateable cursors
- Definer/invoker rights to provide controlled access to database objects
