SQL Developer Web

SQL Developer Web is a single page web application delivered via ORDS. This resource page is for SQL Developer Web, if you want to learn more about ORDS, look up and click the link for that.

SQLDev Web (Docs) is available automatically in the Oracle Cloud for Autonomous Database subscribers (presented as Database Actions), but it’s also available for any customer who has ORDS configured for their databases. Some features in SQLDev Web may not be available in the Autonomous Database.

Getting Started

To start using SQL Developer Web, you need to first install and configure ORDS.

I take you through an install, enabling access, and building your first Web Service.

Features

SQL Developer Web offers quite a few features across development, administration, and performance optimization. What you can do is based on your database user’s privileges. So if you login as a developer vs an administrator account, you’ll see different screens become available.

This image has an empty alt attribute; its file name is sqldev-web-home-1024x505.png
Features are presented as cards on the home page.

Development

SQL – the SQL Worksheet allows you to load data, create and edit database objects, run queries and scripts, do explain plans & autotraces, capture DBMS_OUTPUT, and much more.

This image has an empty alt attribute; its file name is image-23.png
SELECT * FROM…

Data Modeler – visualize your existing schema into rich relational diagrams and data dictionary reports.

This image has an empty alt attribute; its file name is web-modeler-1024x561.png
Pretty pictures!

REST – develop and secure your RESTful Web Services (new for version 20.3).

OAUTH2 Client management

JSON – work with your JSON Collections and Documents (new for version 20.3).

Query, browse, edit, delete, & add JSON documents.

APEX – launch Oracle Application Express.

Administration

Database Users – create and edit database users, reset their Oracle passwords, REST enable them, and more.

This image has an empty alt attribute; its file name is image-10-1024x451.png
Who’s password is about to expire?

Monitoring

Performance Hub – ASH Analytics and SQL Monitoring. Requires a 19c database and their Diagnostic and Tuning packs.

SQL Monitoring – don’t have 19c? We have a SQL Monitoring page, but it still requires the Diagnostic and Tuning packs.

Instance Viewer – what’s happening, right now, in your database? Activity charts and drill down reports around waits, sessions, SQL, I/O, storage and more.

Logins – see the audit trail for logins

This image has an empty alt attribute; its file name is image-24.png
Who’s getting in, and more importantly, who’s trying to but failing?

Alerts – browse the database alert logs

This image has an empty alt attribute; its file name is image-25.png
Something has happened that you need to know about.

Sessions – see who is logged in, what they’re doing, and their execution plans

This image has an empty alt attribute; its file name is image-26.png
Who’s doing what, and what issues are they running into?

Storage – tablespaces and datafiles, how much storage is being used, and for what?

This image has an empty alt attribute; its file name is image-27.png
Drill down into a tablespace for details, or toggle to just seeing all the datafiles.

Slides

Screenshots of ALL the features in SQL Developer Web (or mostly)

1 Comment

  1. Avatar

    Can I get this data’s on your blog in a pdf ? I want to always go through it and build on with it. Nice article,keep it up jeff.

Write A Comment