Downloaded 278 times
Uploaded byJeff Smith
Oracle SQL Developer for the DBA
The document provides an overview of Oracle SQL Developer, highlighting its features as a database IDE with over 4 million users, cross-platform support, and functionalities for data modeling and database administration. It details the application's history, performance enhancements, and tools for managing databases, user roles, storage, and migration to the Oracle Cloud. Additionally, it mentions security features, resource management, auditing, and the ability to translate SQL from various sources.
Oracle SQL Developer for the DBA
- 1. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Oracle SQL Developer For the DBA Jeff Smith Jeff.d.smith@oracle.com || @thatjeffsmith Senior Principal Product Manager Database Development Tools Group Oracle Confidential – Internal/Restricted/Highly Restricted
- 2. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Oracle SQL Developer Overview Database IDE 4 Million+ Users Worldwide Windows, OS X, *NIX Third Party Database Migrations Data Modeling, Design Oracle REST Data Services (ORDS) Interface
- 3. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Version 1.1 – 2006 Version 1.2 - 2007 Version 1.5 - 2008 Version 2.1 - 2009 Version 3.0 - 2011 Version 3.1/3.2 - 2012 Version 4.0 - 2013 Version 4.0.3 – 2014 Version 4.1 - Production History of Database Administration Features
- 4. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | 1. Manage Database Where We Started
- 5. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Where We Started 2. Reports
- 6. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • Accessed from the View menu • Add Existing Connections • Intended for HIGHLY privileged users Where We Are Now The DBA Panel, debuted in v3.1
- 7. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Database Configuration See AND Change Stuff
- 8. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Database Status Just the basics
- 9. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Database Status Refreshing reports is boring, can’t you do something better?
- 10. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | No: agents DB objects alerts history $$$ Database Status DB Instance
- 11. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • No SYS • Will show currently executing jobs Data Pump Wizards for Export & Import
- 12. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Data Pump Current Job Running
- 13. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Data Pump – Scheduled Jobs In the Connections Tree
- 14. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Performance Added in version 4.0
- 15. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | The Blog Post Performance Let’s Do Some Demo
- 16. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | “This will create the database jobs and server directory and scripts required to kick off RMAN backup and recovery operations initiated from SQL Developer.” • Requires a Scheduler Credential RMAN – Kick off Backup & Recovery Actions from the Client Configuring RMAN Actions
- 17. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | When I hit ‘Apply’ a new ‘SQLDEV_JOB_XXXXXX.sh’ script is written to the server and EXECUTED. The work will get logged to a file of the same name (with a .LOG suffix), and you’ll see a ‘BUSY’ throbber widget in SQL Developer telling you the job is running. When it’s finished you can check the log directly in SQL Developer. RMAN Actions What we put on the server
- 18. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Resource Managers Prevent users from hogging all the resources
- 19. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Scheduler Admin stuff, like defining Windows
- 20. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • Auditing! • Configure Settings • View Audit Trails 1. Logins 2. Privs 3. Objects 4. Statements Security Users, roles, passwords – all that stuff, but ALSO:
- 21. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Storage Tablespaces, temp, archive logs…
- 22. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • Oracle Multitenant Support – Manage Pluggable Databases • Data Redaction – Manage Redaction Policy • SQL Translation Framework – Translating non-Oracle SQL to SQL Database 12c Feature Support
- 23. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • Container Database management • Accessed via the DBA panel • Available in version 3.2.20.09 and higher Multitenant
- 24. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | ALTER PLUGGABLE DATABASE PDB2_CLONE UNPLUG INTO ‘PDB2_CLONE.XML’; DROP PLUGGABLE DATABASE PDB2_CLONE KEEP DATAFILES; Plugging stuff…
- 25. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Copy/Move up to Oracle Cloud Service • Packs up PDB • Chunks it up to our Database Public Cloud Service • View Progress as it goes up • Automatically Plugged in & Started Up • Connect immediately (setup SSH Tunnel)
- 26. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Redaction One policy per table
- 27. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | SQL Translation Framework Install translator from SQL Developer
- 28. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | SQL Translation Framework Manage Translations via the Profile
- 29. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • Tune your application SQL w/o changing the source code? What else could this be used for? Substitute SQL when it comes in from the application
- 30. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • Real Time SQL Monitoring • 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 Database Administration Other stuff not in the DBA Panel
- 31. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | Wait! One more thing… Something that’s not GUI?
- 32. Copyright © 2014Oracle and/or its affiliates. All rights reserved. | • SQL Developer on OTN – www.oracle.com/sqldeveloper • Feature Exchange – sqldeveloper.oracle.com • Forums – https://forums.oracle.com/forums/forum.jspa?forumID=260 • Oracle Learning Library – www.oracle.com/oll SQL Developer Resources
- 33. Copyright © 2014Oracle and/or its affiliates. All rights reserved. |
Editor's Notes
- #2 To customize this slide with your own picture: Right-click the slide area and choose Format Background from the pop-up menu. From the Fill menu, click Picture and texture fill. Under Insert from: click File. Locate your new picture and click Insert. To Replace the LOGO on this sample slide: Right-click the sample LOGO and choose Change Picture. Navigate to the location where the new logo is stored, select desired logo file and click on the Open button to replace the sample logo.