1 / 22

Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features

Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features. Kris Rice Senior Director of Development , Database Tools.

erwin
Download Presentation

Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features Kris Rice Senior Director of Development , Database Tools

  2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  3. Agenda • Unit Testing • Integrated Modeling • Trace Files • Real-Time SQL Monitoring • Refactoring • Remote Debugging

  4. Today Oracle SQL Developer SQL & PL/SQL IDE Migrations Data Modeler Unit Testing One-step migration of DB objects and data to Oracle. Translation of Sybase and SQL Server T-SQL to Oracle PL/SQL. Migrate from Access, MySQL Simplify the automation of SQL and PL/SQL unit testing and code coverage with performance reporting and trending Logical, Relational and Physical database modeling serving Data Architects, DBA’s, Developers and Users Lightweight, graphical interface that simplifies and enhances database development tasks © 2009 Oracle Corporation – Proprietary

  5. Unit Testing – Overview • Tests • Suites • Reports • Library • Static and dynamic lookups • Multi user repository based • Code coverage • Command line use • Target any database

  6. Unit Testing - Tests • Input/Return • Static or Dynamic Values • Startups/TearDown • Table Copy/Restore • Row Copy/Restore • Custom • Code coverage • Success or failure testing • Validation • Custom

  7. Unit Testing - Suites • Startups/TearDown • Table Copy/Restore • Row Copy/Restore • Custom • Code Coverage • Tests are run sequentially • Startup and teardowns for tests can be turned off

  8. Unit Testing - Library • Stores reusable items • Dynamic Values • Startups • Teardowns • Validations • Referenced or Copied to local tests

  9. Unit Testing - Reports • Includes Standard reports • Suites • Tests • Code Coverage • Reports against the repository • Users can query the repository directly

  10. Unit Testing – Multi User • Use database users • Control • admin vs. user • Managed with roles

  11. Unit Testing – Running Suites/Tests • Inside SQL Developer simply change the Combo List • Command line by passing arguments • Results are stored in the repository

  12. Integrated Data Modeling • Open existing models • Drag and drop relational • Design Rules • Inspect all properties • Thumbnail view • Read only

  13. Trace Files • Open trace files • Search SQL • Sort Options • Filter recursive SQL • Statistics of executions

  14. Real-Time SQL Monitoring • Real time view of SQL • Use /*+MONITOR*/ • Drill to view details • Visual indicators for current step • Queries over 5 seconds monitored • DBMS_SQLTUNE.REPORT_SQL_MONITOR

  15. Refactoring • Extract a procedure • Surround blocks with • For • While • Begin block • Variable renames • Extract anonymous PL/SQL blocks from APEX apps

  16. Remote Debugging Problem: Test a procedure being executed in a separate application • SQL Developer • Select Remote Debug • Set up remote debug detail; machine, port • Browse to procedure • Set a breakpoint • Remote session • execute DBMS_DEBUG_JDWP.CONNECT_TCP (‘127.0.0.1’, 4000) • OR • SET ORA_DEBUG_JDWP=host=hostname;port=portnum • Execute procedure • SQL Developer • Debug

  17. Finding More Detailwww.oracle.com/technology/products/database/sql_developer • SQL Developer on OTN • White papers,Oracle by Example (OBE) and online demos • Team Blogs: Blogs, Magazine Articles & Podcasts • www.oracle.com/technology/products/database/sql_developer • SQL Developer Exchange • Share reports, snippets, code, and add feature requests • http://sqldeveloper.oracle.com • Forums • SQL Developer forums.oracle.com/forums/forum.jspa?forumID=260

  18. Summary • Unit Testing • Creating, Running, Reporting • Integrated Modeling • Drag and Drop Relational models • Trace Files • File -> Open • Real-Time SQL Monitoring • Watch SQL as it runs • Refactoring • Convert APEX anonymous blocks into a Package

  19. For More Information search.oracle.com SQL Developer or www.oracle.com/technology/products/database/sql_developer

More Related