Oracle SQL Developer...for the DBA!

Oracle SQL Developer is much more than a GUI for SQL*Plus or a PL/SQL development environment. It also provides a full management portfolio of features for your Oracle Database.

This deck covers at a high level what we support for general administration, tuning, monitoring, security, storage, Data Pump, the Scheduler, and more.

Transcript

1. Master Product Manager Jeff.D.Smith@oracle.com @thatjeffsmith Oracle SQL Developer …for the DBA! Jeff Smith
2. SQL Developer Snapshot 2 Time Tested Launched in 2005 An Industry Standard 5M+ Oracle DBAs & Developers Always Improving Quarterly Releases 4
3. • No v20.1 (pandemic) • v20.2, all products - Early Summer! Roadmap / Direction • SQL Developer Web => more features • SQLcl => ‘fancier’ editor, Liquibase, OCI enhancements • SQL Developer => tweaks & bug fixes as needed 2020 News
4. • SQL editor • PL/SQL IDE • GUI for browsing and managing database objects • Ad Hoc reporting • Database Design & Data Modeling • Database Administration • 3rd Party RDBMS Migrations to Oracle • Deploy and Administer Oracle REST Data Services • REST Enablement of the Database • Command Line Interface Major Feature Areas
5. • Config • Multitenant • Sharding/DG • Status • Data Pump • Diagnostics Pack (AWR, ASH, ADDM) • SQL Monitoring • RMAN • Resource Manager • Storage • Security DBA Feature Categories
6. • Accessed from the View menu • Add Existing Connections • Now supports folders • Intended for HIGHLY privileged users Where to find these features
7. Database Configuration
8. Instance Viewer
9. SQL Developer Web
10. User Management in SDW
11. Data Pump
12. Data Pump via HTTPS (DB REST API) • Inputs • What directory? • What type of export? • How many threads? • What are we exporting? • Response • Links to get status/log
13. Data Pump – Export 2 Tables in Local Schema { "datapump_dir": "DATA_PUMP_DIR", "filter": "HOCKEY_STATS, UNTAPPD", "job_mode": "TABLE", "threads": 2 } POST BODY Response
14. Data Pump – Response Resource Links "links": [ …, { "rel": "related", "href": "http://.../database/datapump/jobs/HR,DATAPUMP_REST_EXPORT_20190105140710/EXPDAT-2019-05-01-14_07_11.LOG" }, { "rel": "self", "href": "http://.../database/datapump/jobs/HR,DATAPUMP_REST_EXPORT_20190105140710/" } ] Job Log File The Job and its metadata
15. Data Pump – GET the Log File
16. Data Pump – GET the Job Details
17. Data Pump – Download the DMP!
18. Performance
19. Automatic Workload Repository (AWR)
20. Resource Manager
21. Scheduler
22. Auditing! Configure Settings View Audit Trails 1. Logins 2. Privs 3. Objects 4. Statements Security
23. Storage
24. Oracle Multitenant Support Manage Pluggable Databases Application Containers We have REST APIs, too! Multitenant
25. Connected to a CDB
26. • SQL Monitor • Monitor Sessions • Database Diff • Side by side comparison • between source and target • Reports • Data Dictionary Views • Quality Assurance, Grants/Privileges, Sessions • User Defined – Customize and Share Reports What Else?
27. Modern CLI for Oracle (SQLcl) • 25 mb download, no Client required • Automatic formatting • SQL History • Tab completion • Built-in editor • New commands! • info • Liquibase • ddl • load
28. Planned 20.2 Features • DBMS_DEBUG support • Execution plan search • Better DDL generation • Load command • Formatter improvements
29. • SlideShare (2011-2019) /SpeakerDeck (2020-) • thatjeffsmith.com • @oraclesqldev @oraclesqlcl @oraclerest SQLDev on Other Resources