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
- Data Pump
- Data Tools
- Creates Cloud Storage Link
- Creates credentials
- Creates data load jobs
- Creates Live Table Feed
- Delete a Cloud Storage Link
- Delete a credential
- Delete data load job
- Delete Live Table Feed
- Gets Cloud Storage Links
- Gets credentials
- Gets data load jobs
- Gets Live Table Feed notification key
- Gets Live Table Feeds
- Gets progress of data load job
- Gets specific Cloud Storage Link
- Gets specific credential
- Gets specific data load job
- Gets specific Live Table Feed
- Modify Live Table Feed
- Surveys input data
- Triggers data load for Live Table Feed
- 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
- 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 specific database parameter
- Get a specific database user
- Get a tablespace
- Get a tablespace segment
- 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
- Oracle Transactional Event Queues
- Create a Consumer Group
- Create a new Transactional Event Queue Topic
- Create Consumer Instance
- Delete a Consumer Group
- Delete Consumer Instance
- Delete the Transactional Event Queue Topic with the specified topic_name
- Describe the specified Transactional Event Queue Topic Partition
- Describe Transactional Event Queue Topic Partition specified in Cluster
- Describe Transactional Event Queue Topic Partitions
- Describes Transactional Event Queue Topic in Cluster
- Fetch messages for the specified Consumer
- Get a Consumer Group
- Get all Transactional Event Queue Topics in the schema
- Get Consumer Groups in Cluster
- Get consumer lag for Transactional Event Queue Topic Partition
- Get Consumer last Commit Offsets
- Get description of a particular Transactional Event Queue Topic.
- Get lag summary for Consumer Groups in Cluster
- Get Transactional Event Queue Topic Partition Offsets
- Lags/Offsets of consumers in the Consumer group
- List Partitions for a Transactional Event Queue Topic in Cluster
- List Transactional Event Queue Topics that belong to the specified database cluster
- Produce a message to the Transactional Event Queue Topic specified by topic_name
- Produce messages in the specified Transactional Event Queue Topic Partition
- Seek to End of Partitions for Consumer Group
- Seek to specified Transactional Event Queue Topic partition offsets for Consumer Group
- Seek to start of Partitions for Consumer Group
- Subscribed list of Transactional Event Queue Topics
- 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
- Change the state of a PDB
- Clone or Unplug operations for PDBs
- Create a PDB from PDB$SEED or XML
- Drop a PDB
- Get a pluggable database
- Get all pluggable databases
- Return status information of a PDB
- The list of all snapshots taken for thee specified pluggable databases (PDBs)
- The snapshots of all pluggable databases (PDBs) in the Container Database
- The specific snapshot taken of the specific pluggable databases (PDBs)
- Pluggable Database Snapshot Carousel
- Configure automatic PDB snapshots.
- Create snapshot of the current pluggable databases, the name will be generated
- Create snapshot of the current pluggable databases, the name will be {snapshotName}
- Delete the specified snapshot
- get all snapshots of the current pluggable databases
- Get snapshot mode in current PDB
- Get specific snapshot based on the name in current PDB