Oracle SQL Developer Unit Testing Tuning and Other
![](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-1.jpg)
![Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features Kris Rice Senior Director Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features Kris Rice Senior Director](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-2.jpg)
![The following is intended to outline our general product direction. It is intended for The following is intended to outline our general product direction. It is intended for](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-3.jpg)
![Agenda • • • Unit Testing Integrated Modeling Trace Files Real-Time SQL Monitoring Refactoring Agenda • • • Unit Testing Integrated Modeling Trace Files Real-Time SQL Monitoring Refactoring](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-4.jpg)
![Oracle SQL Developer Today SQL & PL/SQL IDE Lightweight, graphical interface that simplifies and Oracle SQL Developer Today SQL & PL/SQL IDE Lightweight, graphical interface that simplifies and](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-5.jpg)
![Unit Testing – Overview • • • Tests Suites Reports Library Static and dynamic Unit Testing – Overview • • • Tests Suites Reports Library Static and dynamic](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-6.jpg)
![Unit Testing - Tests • Input/Return – Static or Dynamic Values • Startups/Tear. Down Unit Testing - Tests • Input/Return – Static or Dynamic Values • Startups/Tear. Down](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-7.jpg)
![Unit Testing - Suites • Startups/Tear. Down – Table Copy/Restore – Row Copy/Restore – Unit Testing - Suites • Startups/Tear. Down – Table Copy/Restore – Row Copy/Restore –](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-8.jpg)
![Unit Testing - Library • Stores reusable items – – Dynamic Values Startups Teardowns Unit Testing - Library • Stores reusable items – – Dynamic Values Startups Teardowns](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-9.jpg)
![Unit Testing - Reports • Includes Standard reports – Suites – Tests – Code Unit Testing - Reports • Includes Standard reports – Suites – Tests – Code](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-10.jpg)
![Unit Testing – Multi User • Use database users • Control – admin vs. Unit Testing – Multi User • Use database users • Control – admin vs.](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-11.jpg)
![Unit Testing – Running Suites/Tests • Inside SQL Developer simply change the Combo List Unit Testing – Running Suites/Tests • Inside SQL Developer simply change the Combo List](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-12.jpg)
![Integrated Data Modeling • • • Open existing models Drag and drop relational Design Integrated Data Modeling • • • Open existing models Drag and drop relational Design](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-13.jpg)
![Trace Files • • • Open trace files Search SQL Sort Options Filter recursive Trace Files • • • Open trace files Search SQL Sort Options Filter recursive](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-14.jpg)
![Real-Time SQL Monitoring • • Real time view of SQL Use /*+MONITOR*/ Drill to Real-Time SQL Monitoring • • Real time view of SQL Use /*+MONITOR*/ Drill to](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-15.jpg)
![Refactoring • Extract a procedure • Surround blocks with – For – While – Refactoring • Extract a procedure • Surround blocks with – For – While –](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-16.jpg)
![Remote Debugging Problem: Test a procedure being executed in a separate application • SQL Remote Debugging Problem: Test a procedure being executed in a separate application • SQL](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-17.jpg)
![Finding More Detail www. oracle. com/technology/products/database/sql_developer • SQL Developer on OTN • White papers, Finding More Detail www. oracle. com/technology/products/database/sql_developer • SQL Developer on OTN • White papers,](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-18.jpg)
![Summary • Unit Testing – Creating, Running, Reporting • Integrated Modeling – Drag and Summary • Unit Testing – Creating, Running, Reporting • Integrated Modeling – Drag and](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-19.jpg)
![For More Information search. oracle. com SQL Developer or www. oracle. com/technology/products/database/sql_developer For More Information search. oracle. com SQL Developer or www. oracle. com/technology/products/database/sql_developer](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-20.jpg)
![](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-21.jpg)
![](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-22.jpg)
- Slides: 22
![](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-1.jpg)
![Oracle SQL Developer Unit Testing Tuning and Other Advanced Features Kris Rice Senior Director Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features Kris Rice Senior Director](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-2.jpg)
Oracle SQL Developer: Unit Testing, Tuning and Other Advanced Features Kris Rice Senior Director of Development , Database Tools
![The following is intended to outline our general product direction It is intended for The following is intended to outline our general product direction. It is intended for](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-3.jpg)
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.
![Agenda Unit Testing Integrated Modeling Trace Files RealTime SQL Monitoring Refactoring Agenda • • • Unit Testing Integrated Modeling Trace Files Real-Time SQL Monitoring Refactoring](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-4.jpg)
Agenda • • • Unit Testing Integrated Modeling Trace Files Real-Time SQL Monitoring Refactoring Remote Debugging
![Oracle SQL Developer Today SQL PLSQL IDE Lightweight graphical interface that simplifies and Oracle SQL Developer Today SQL & PL/SQL IDE Lightweight, graphical interface that simplifies and](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-5.jpg)
Oracle SQL Developer Today SQL & PL/SQL IDE Lightweight, graphical interface that simplifies and enhances database development tasks © 2009 Oracle Corporation – Proprietary Migrations Data Modeler 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, My. SQL Logical, Relational and Physical database modeling serving Data Architects, DBA’s, Developers and Users Unit Testing Simplify the automation of SQL and PL/SQL unit testing and code coverage with performance reporting and trending
![Unit Testing Overview Tests Suites Reports Library Static and dynamic Unit Testing – Overview • • • Tests Suites Reports Library Static and dynamic](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-6.jpg)
Unit Testing – Overview • • • Tests Suites Reports Library Static and dynamic lookups Multi user repository based Code coverage Command line use Target any database
![Unit Testing Tests InputReturn Static or Dynamic Values StartupsTear Down Unit Testing - Tests • Input/Return – Static or Dynamic Values • Startups/Tear. Down](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-7.jpg)
Unit Testing - Tests • Input/Return – Static or Dynamic Values • Startups/Tear. Down – Table Copy/Restore – Row Copy/Restore – Custom • Code coverage • Success or failure testing • Validation – Custom
![Unit Testing Suites StartupsTear Down Table CopyRestore Row CopyRestore Unit Testing - Suites • Startups/Tear. Down – Table Copy/Restore – Row Copy/Restore –](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-8.jpg)
Unit Testing - Suites • Startups/Tear. Down – Table Copy/Restore – Row Copy/Restore – Custom • Code Coverage • Tests are run sequentially • Startup and teardowns for tests can be turned off
![Unit Testing Library Stores reusable items Dynamic Values Startups Teardowns Unit Testing - Library • Stores reusable items – – Dynamic Values Startups Teardowns](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-9.jpg)
Unit Testing - Library • Stores reusable items – – Dynamic Values Startups Teardowns Validations • Referenced or Copied to local tests
![Unit Testing Reports Includes Standard reports Suites Tests Code Unit Testing - Reports • Includes Standard reports – Suites – Tests – Code](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-10.jpg)
Unit Testing - Reports • Includes Standard reports – Suites – Tests – Code Coverage • Reports against the repository • Users can query the repository directly
![Unit Testing Multi User Use database users Control admin vs Unit Testing – Multi User • Use database users • Control – admin vs.](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-11.jpg)
Unit Testing – Multi User • Use database users • Control – admin vs. user • Managed with roles
![Unit Testing Running SuitesTests Inside SQL Developer simply change the Combo List Unit Testing – Running Suites/Tests • Inside SQL Developer simply change the Combo List](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-12.jpg)
Unit Testing – Running Suites/Tests • Inside SQL Developer simply change the Combo List • Command line by passing arguments • Results are stored in the repository
![Integrated Data Modeling Open existing models Drag and drop relational Design Integrated Data Modeling • • • Open existing models Drag and drop relational Design](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-13.jpg)
Integrated Data Modeling • • • Open existing models Drag and drop relational Design Rules Inspect all properties Thumbnail view Read only
![Trace Files Open trace files Search SQL Sort Options Filter recursive Trace Files • • • Open trace files Search SQL Sort Options Filter recursive](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-14.jpg)
Trace Files • • • Open trace files Search SQL Sort Options Filter recursive SQL Statistics of executions
![RealTime SQL Monitoring Real time view of SQL Use MONITOR Drill to Real-Time SQL Monitoring • • Real time view of SQL Use /*+MONITOR*/ Drill to](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-15.jpg)
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
![Refactoring Extract a procedure Surround blocks with For While Refactoring • Extract a procedure • Surround blocks with – For – While –](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-16.jpg)
Refactoring • Extract a procedure • Surround blocks with – For – While – Begin block • Variable renames • Extract anonymous PL/SQL blocks from APEX apps
![Remote Debugging Problem Test a procedure being executed in a separate application SQL Remote Debugging Problem: Test a procedure being executed in a separate application • SQL](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-17.jpg)
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=hostname; port=portnum – Execute procedure • SQL Developer – Debug
![Finding More Detail www oracle comtechnologyproductsdatabasesqldeveloper SQL Developer on OTN White papers Finding More Detail www. oracle. com/technology/products/database/sql_developer • SQL Developer on OTN • White papers,](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-18.jpg)
Finding More Detail www. 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_devel oper • SQL Developer Exchange • Share reports, snippets, code, and add feature requests • http: //sqldeveloper. oracle. com • Forums • SQL Developer forums. oracle. com/forums/forum. jspa? forum. ID=260
![Summary Unit Testing Creating Running Reporting Integrated Modeling Drag and Summary • Unit Testing – Creating, Running, Reporting • Integrated Modeling – Drag and](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-19.jpg)
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
![For More Information search oracle com SQL Developer or www oracle comtechnologyproductsdatabasesqldeveloper For More Information search. oracle. com SQL Developer or www. oracle. com/technology/products/database/sql_developer](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-20.jpg)
For More Information search. oracle. com SQL Developer or www. oracle. com/technology/products/database/sql_developer
![](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-21.jpg)
![](https://slidetodoc.com/presentation_image_h/f86b6337dbf0bd97ee297b11c616e4f8/image-22.jpg)
Sql developer real time sql monitor
오라클 설치방법
Performance tuning in oracle tutorial
Tipsfororacle
Oracle developer terdiri dari
Visual studio code oracle
Oracle developer forms
Ayewsldlmcc -site:youtube.com
Erwin data modeler
Sql developer modeler
Tunning de base de datos
Sql server 2005 performance
Frog sql
Jörg stryk
Functional testing vs unit testing
Difference between pl sql and mysql
Regexp_like in sql server
Oracle procedural language extensions to sql
Oracle pl/sql create table
Microsoft sql server migration assistant for oracle
Oracle big data appliance
Oracle sql command line
Oracle apex sql injection