Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Oracle SQL Developer...for the DBA!

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.

0ed10d1154c696886ca483fe827cb299?s=128

thatjeffsmith

May 23, 2020
Tweet

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