Table of Contents
Get Started
Tasks
- Data Dictionary
- Get a database link
- Get a partition
- Get a procedure that is defined in package
- Get a specific column
- Get a specific foreign keys
- Get a specific function
- Get a specific index
- Get a specific object
- Get a specific table
- Get a synonym
- Get all arguments for functions and procedures
- Get all database links
- Get all database objects
- Get all foreign keys
- Get all functions
- Get all indexes
- Get all materialized view logs
- Get all object types
- Get all partitions in the database
- Get all procedures defined in package
- Get all synonyms in the database
- Get all table columns
- Get all tables
- Get an argument
- Get an object type
- Get information on a specific materialized view log
- Environment
- Create a new database in the default Oracle Home
- Create a new database in the specified Oracle Home
- Create a new DBCA job in the default Oracle Home
- Create a new DBCA job in the Oracle Home
- Delete the specified DBCA job in the default Oracle Home
- Delete the specified DBCA job in the default Oracle Home
- Get a list of the databases defined in an Oracle Home
- Get a list of the databases defined in the default Oracle Home
- Get a list of the DBCA database templates defined in an Oracle Home
- Get a list of the DBCA database templates defined in the default Oracle Home
- Get a list of the DBCA jobs created through ORDS Database API in the default Oracle Home
- Get a list of the DBCA jobs created through ORDS Database API in the Oracle Home
- Get a specific database defined in a specific Oracle Home
- Get a specific database defined in the default Oracle Home
- Get a specific database template file in a specific Oracle Home
- Get a specific database template file in the default Oracle Home
- Get a specified DBCA jobs created through ORDS Database API in the default Oracle Home
- Get a specified DBCA jobs created through ORDS Database API in the specified Oracle Home
- Get database Oracle Homes
- Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the default Oracle Home
- Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the specified Oracle Home
- General
- Create a data pump job
- Create an export data pump job
- Create an import data pump job
- Get a database component
- Get a description of a specific local listener for this database
- Get a description of all local listeners for this database
- Get a file for a specific data pump job
- Get a specific data pump job
- Get a specific database parameter
- Get a specific database user
- Get a tablespace
- Get a tablespace segment
- Get all data pump jobs
- Get all database components
- Get all database parameters
- Get all database users
- Get all feature usage statistics
- Get all tablespaces
- Get data file usage summary for a specific tablespace
- Get data files for a tablespace
- Get database status
- Get database version
- Get specific database Oracle Home
- Get storage statistics
- Get tablespace data file
- Get tablespace data file usage
- Get tablespace segments
- Get tablespace space usage history
- Get tablespace temporary file
- Get tablespace temporary file usage
- Get temporary file usage summary for a specific tablespace
- Get temporary files for a tablespace
- Get usage statistic for a feature
- Monitoring
- Get a session
- Get a session lock that is blocking other sessions
- Get a specific lock that a session is waiting on
- Get a specific session lock record
- Get a specific session wait
- Get a specific session wait class record
- Get all alerts
- Get all current sessions
- Get all locks held in the database
- Get all locks that are blocking other sessions
- Get all locks that sessions are waiting on
- Get all long running operations for a session
- Get all session limits
- Get all session wait class records
- Get all session waits
- Get all wait class metrics
- Get an alert record
- Get count of alerts by message level
- Get count of alerts by message type
- Get count of different session types
- Get count of recent alerts by message level
- Get count of recent alerts by message type
- Get current active process for a session
- Get time totals for all registered wait classes
- Get wait time summary from recent active session history records
- Open Service Broker
- Oracle APEX
- Performance
- Get a specified sampled session activity in the database
- Get all sampled session activity in the database
- Get all SQL statements ordered by CPU time descending
- Get execution plan for an SQL Statement
- Get historical statistics for a SQL statement
- Get information on a monitored statement
- Get monitoring statistics for a SQL Statement
- Get parallel execution information for specific statement execution
- Get SQL statement
- Get SQL statistics for a specific session
- Get SQL statistics maximum values
- Get statistics for a SQL statement
- Get statistics for all SQL statements
- Get the last 10 wait events for each active session
- Get the specified wait event for specific active session
- Pluggable Database Lifecycle Management
- Reports
- Schemas
- Access Log
- Active Session Counts
- Active Sessions
- Active Sessions
- Active SQL
- Active SQL
- Active SQL
- Activity Log
- Activity Summary
- Alert Log
- All Constraints
- All Constraints
- All Encrypted Columns
- All Grants
- All Indexes
- All Indexes
- All Objects
- All Parameters
- All Stream Rules
- All Table Comments
- All Table Comments
- All Tables
- All Tables in Encrypted TableSpaces and their Algorithm (uses dba tables)
- All Triggers
- All Triggers
- All Users
- Application
- Application
- Application
- Application Statistics
- Applications
- Applications
- ASH Rows Detail
- Audit Policies
- Authentication
- Average Response Time by Page
- Background Sessions
- Bind Variables
- Bind Variables
- Blocking Locks by User
- Branches
- Build Opt
- Buttons
- Check Constraints
- Check Constraints
- Client
- Client
- Client
- Clusters
- Clusters
- Collection Types
- Column Comments
- Column Comments
- Column Privileges
- Column UI Defaults
- Columns
- Columns
- Columns
- Computations
- Computations
- Contention
- Contention
- Contention
- Count by Account Status
- Count by Default Tablespace
- Count by Profile
- Count by Temporary Tablespace
- Counts by Grantor
- Cursor Detail
- Cursors by Session
- Daily ASH Statistics Chart
- Datafiles
- Datatype Occurrences
- Datatype Occurrences
- Dependencies
- Detailed Page Statistics
- Dictionary View Columns
- Dictionary Views
- Disabled Constraints
- Disabled Constraints
- Disabled Triggers
- Disabled Triggers
- Dynamic memory
- elapsed time history
- Enabled Constraints
- Enabled Constraints
- Enabled Triggers
- Enabled Triggers
- Encrypted Tablespaces (uses dba tables)
- Events
- Events In The Past X Minutes
- Events In Wait Class For Past 1 Hour
- Expired
- Explain Plan
- Explain Plan
- Explain Plan
- Explain Plan
- Files
- Foreign Key Constraints
- Foreign Key Constraints
- Free Space
- Grant DML
- Grant EXECUTE
- Grant SELECT
- Grantable
- Inactive Sessions
- Index Organized Tables
- Index Organized Tables
- Indexes by Status
- Indexes by Status
- Indexes by Type
- Indexes by Type
- Invalid Objects
- Items
- Items
- Largest Average Row Length
- Largest Average Row Length
- Lists
- Locked
- Long Opsq
- Long Opsq
- Long Opsq
- LOV
- Most Rows
- Most Rows
- National Language Support Parameters
- Nav Bars
- Non-Default Parameters
- Object Count by Type
- Object Count by Type
- Object Distribution
- Object Grants
- Offline Tablespaces
- Page Views by Page
- Pages
- Pages
- Parent Tabs
- Partitioned Tables
- Partitioned Tables
- Policies
- Policy
- Primary Key Constraints
- Primary Key Constraints
- Processes
- Processes
- Program Unit Arguments
- Public Database Links
- Public Synonyms
- Recently Created
- Regions
- Relocate Details
- Role Privileges
- Schemas
- Search Source Code
- Segments For Past 1 Hour
- Server
- Server
- Server
- Session Counts by OS User
- Session Counts by Status
- Session CPU and Time Statistics
- Sessions
- Sessions by Module
- Sessions by Username
- Sessions with Rowsource
- Shortcuts
- Sql Elapsed Time History
- sql from blocking session
- sql from waiting session
- Sql Plan
- SQL Text
- SQL Text
- SQL Text
- Statistics
- Statistics
- System Privileges
- System Sessions
- Table Count by Tablespace
- Table Count by Tablespace
- Tables by Tablespace
- Tables by Tablespace
- Tables with Comments
- Tables with Comments
- Tables with Unindexed Foreign Keys
- Tables with Unindexed Foreign Keys
- Tables without Comments
- Tables without Comments
- Tables without Indexes
- Tables without Indexes
- Tables without Primary Keys
- Tables without Primary Keys
- Tablespace Quotas
- Tablespace Segments
- Tablespaces
- Tabs
- Templates
- Themes
- Top segments
- Top segments
- Top SQL by Buffer Gets
- Top SQL by Buffer Gets/Rows Proc
- Top SQL by CPU
- Top SQL by Disk Reads
- Top SQL by Executions
- Top SQL by Waits
- Trees
- Trigger Summary
- Trigger Summary
- Types
- UI Defaults
- Unique Constraints
- Unique Constraints
- Unit Line Counts
- Unusable Indexes
- Unusable Indexes
- User Summary
- User Synonyms
- User Tables
- Validations
- Version Banner
- Wait Class Activity for Last Hour
- Waits
- Waits
- Waits
- Waits for past 1 hour
- Waits For Past 1 Hour In 1st RAC Instance
- Waits For Past 1 Hour In 2nd RAC Instance
- Waits For Past 1 Hour In Nth RAC Instance
- Web Svr
- With Objects
- Without Objects
- Workspace
- XML Schemas
- Your Encrypted Columns
- Your Stream Rules