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
- Data Guard
- Add a configuration
- Add a database
- Alter a configuration property
- Convert, enable, disable, or set the role of a database
- Delete the current database from the broker
- Delete the Data Guard instance
- Enable or disable a configuration
- Get a database Data Guard property
- Get the current broker configuration
- Get the current broker configuration database
- Get the current broker configuration databases
- Get the current broker configuration properties
- Get the current broker database instances information
- Get the database Data Guard properties
- Get the specified broker configuration property
- Remove the configuration
- Set the value of a database Data Guard property
- 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