All REST Endpoints

Data Dictionary
The operations from the Data Dictionary category.
Get a database link
Method: get
Path: /database/db_links/{owner},{db_link}
Get a partition
Method: get
Path: /database/objects/partitions/{table_owner},{table_name},{partition_name}
Get a procedure that is defined in package
Method: get
Path: /database/objects/packages/procedures/{object_id},{subprogram_id}
Get a specific column
Method: get
Path: /database/objects/columns/{owner},{table_name},{column_name}
Get a specific foreign keys
Method: get
Path: /database/objects/foreign_keys/{owner},{constraint_name}
Get a specific function
Method: get
Path: /database/objects/functions/{object_id}
Get a specific index
Method: get
Path: /database/objects/indexes/{owner},{index_name}
Get a specific object
Method: get
Path: /database/objects/{owner},{object_name},{object_type}
Get a specific table
Method: get
Path: /database/objects/tables/{owner},{table_name}
Get a synonym
Method: get
Path: /database/objects/synonyms/{owner},{synonym_name}
Get all arguments for functions and procedures
Method: get
Path: /database/objects/arguments/
Get all database links
Method: get
Path: /database/db_links/
Get all database objects
Method: get
Path: /database/objects/
Get all foreign keys
Method: get
Path: /database/objects/foreign_keys/
Get all functions
Method: get
Path: /database/objects/functions/
Get all indexes
Method: get
Path: /database/objects/indexes/
Get all materialized view logs
Method: get
Path: /database/objects/materialized_view_logs/
Get all object types
Method: get
Path: /database/objects/types/
Get all partitions in the database
Method: get
Path: /database/objects/partitions/
Get all procedures defined in package
Method: get
Path: /database/objects/packages/procedures/
Get all synonyms in the database
Method: get
Path: /database/objects/synonyms/
Get all table columns
Method: get
Path: /database/objects/columns/
Get all tables
Method: get
Path: /database/objects/tables/
Get an argument
Method: get
Path: /database/objects/arguments/{object_id},{subprogram_id},{argument_name}
Get an object type
Method: get
Path: /database/objects/types/{owner},{type_name}
Get information on a specific materialized view log
Method: get
Path: /database/objects/materialized_view_logs/{log_owner},{log_table}
Environment
The operations from the Environment category.
Create a new database in the default Oracle Home
Method: post
Path: /environment/databases/
Create a new database in the specified Oracle Home
Method: post
Path: /environment/homes/{homeName}/databases/
Create a new DBCA job in the default Oracle Home
Method: post
Path: /environment/dbca/jobs/
Create a new DBCA job in the Oracle Home
Method: post
Path: /environment/homes/{homeName}/dbca/jobs/
Delete the specified DBCA job in the default Oracle Home
Method: delete
Path: /environment/dbca/jobs/{jobId}/
Delete the specified DBCA job in the default Oracle Home
Method: delete
Path: /environment/homes/{homeName}/dbca/jobs/{jobId}/
Get a list of the databases defined in an Oracle Home
Method: get
Path: /environment/homes/{homeName}/databases/
Get a list of the databases defined in the default Oracle Home
Method: get
Path: /environment/databases/
Get a list of the DBCA database templates defined in an Oracle Home
Method: get
Path: /environment/homes/{homeName}/dbca/templates/
Get a list of the DBCA database templates defined in the default Oracle Home
Method: get
Path: /environment/dbca/templates/
Get a list of the DBCA jobs created through ORDS Database API in the default Oracle Home
Method: get
Path: /environment/dbca/jobs/
Get a list of the DBCA jobs created through ORDS Database API in the Oracle Home
Method: get
Path: /environment/homes/{homeName}/dbca/jobs/
Get a specific database defined in a specific Oracle Home
Method: get
Path: /environment/homes/{homeName}/databases/{databaseName}
Get a specific database defined in the default Oracle Home
Method: get
Path: /environment/databases/{databaseName}
Get a specific database template file in a specific Oracle Home
Method: get
Path: /environment/homes/{homeName}/dbca/templates/{filename}
Get a specific database template file in the default Oracle Home
Method: get
Path: /environment/dbca/templates/{filename}
Get a specified DBCA jobs created through ORDS Database API in the default Oracle Home
Method: get
Path: /environment/dbca/jobs/{jobId}/
Get a specified DBCA jobs created through ORDS Database API in the specified Oracle Home
Method: get
Path: /environment/homes/{homeName}/dbca/jobs/{jobId}/
Get database Oracle Homes
Method: get
Path: /environment/homes/
Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the default Oracle Home
Method: get
Path: /environment/dbca/jobs/{jobId}/log
Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the specified Oracle Home
Method: get
Path: /environment/homes/{homeName}/dbca/jobs/{jobId}/log
General
The operations from the General category.
Create a data pump job
Method: post
Path: /database/datapump/jobs/
Create an export data pump job
Method: post
Path: /database/datapump/export
Create an import data pump job
Method: post
Path: /database/datapump/import
Get a database component
Method: get
Path: /database/components/{comp_id}
Get a description of a specific local listener for this database
Method: get
Path: /database/connections/{host_name},{port},{service_name}
Get a description of all local listeners for this database
Method: get
Path: /database/connections/
Get a file for a specific data pump job
Method: get
Path: /database/datapump/jobs/{owner_name},{job_name}/{filename}
Get a specific data pump job
Method: get
Path: /database/datapump/jobs/{owner_name},{job_name}/
Get a specific database parameter
Method: get
Path: /database/parameters/{name}
Get a specific database user
Method: get
Path: /database/security/users/{username}
Get a tablespace
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/
Get a tablespace segment
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/segments/{segment_name}
Get all data pump jobs
Method: get
Path: /database/datapump/jobs/
Get all database components
Method: get
Path: /database/components/
Get all database parameters
Method: get
Path: /database/parameters/
Get all database users
Method: get
Path: /database/security/users/
Get all feature usage statistics
Method: get
Path: /database/feature_usage/
Get all tablespaces
Method: get
Path: /database/storage/tablespaces/
Get data file usage summary for a specific tablespace
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles_usage
Get data files for a tablespace
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles/
Get database status
Method: get
Path: /database/status
Get database version
Method: get
Path: /database/version
Get specific database Oracle Home
Method: get
Path: /environment/homes/{homeName}/
Get storage statistics
Method: get
Path: /database/storage/bytes
Get tablespace data file
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/
Get tablespace data file usage
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/datafiles/{file_id}/usage
Get tablespace segments
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/segments/
Get tablespace space usage history
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/history
Get tablespace temporary file
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/
Get tablespace temporary file usage
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/usage
Get temporary file usage summary for a specific tablespace
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles_usage
Get temporary files for a tablespace
Method: get
Path: /database/storage/tablespaces/{tablespace_name}/tempfiles/
Get usage statistic for a feature
Method: get
Path: /database/feature_usage/{dbid},{name}
Monitoring
The operations from the Monitoring category.
Get a session
Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/
Get a session lock that is blocking other sessions
Method: get
Path: /database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}
Get a specific lock that a session is waiting on
Method: get
Path: /database/monitoring/session_locks/waiting/{session_id},{lock_id1},{lock_id2}
Get a specific session lock record
Method: get
Path: /database/monitoring/session_locks/{session_id},{lock_id1},{lock_id2}
Get a specific session wait
Method: get
Path: /database/monitoring/session_waits/{sid},{seq_number}
Get a specific session wait class record
Method: get
Path: /database/monitoring/session_wait_classes/{sid},{serial_number},{wait_class_number}
Get all alerts
Method: get
Path: /database/monitoring/alerts/
Get all current sessions
Method: get
Path: /database/monitoring/sessions/
Get all locks held in the database
Method: get
Path: /database/monitoring/session_locks/
Get all locks that are blocking other sessions
Method: get
Path: /database/monitoring/session_locks/holding/
Get all locks that sessions are waiting on
Method: get
Path: /database/monitoring/session_locks/waiting/
Get all long running operations for a session
Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/long_running_operations
Get all session limits
Method: get
Path: /database/monitoring/session_limits
Get all session wait class records
Method: get
Path: /database/monitoring/session_wait_classes/
Get all session waits
Method: get
Path: /database/monitoring/session_waits/
Get all wait class metrics
Method: get
Path: /database/monitoring/wait_class_metrics
Get an alert record
Method: get
Path: /database/monitoring/alerts/{record_id}
Get count of alerts by message level
Method: get
Path: /database/monitoring/alerts_summaries/by_message_level
Get count of alerts by message type
Method: get
Path: /database/monitoring/alerts_summaries/by_message_type
Get count of different session types
Method: get
Path: /database/monitoring/session_summaries/by_type
Get count of recent alerts by message level
Method: get
Path: /database/monitoring/alerts_recent_summaries/by_message_level
Get count of recent alerts by message type
Method: get
Path: /database/monitoring/alerts_recent_summaries/by_message_type
Get current active process for a session
Method: get
Path: /database/monitoring/sessions/{sid},{serial_number}/process
Get time totals for all registered wait classes
Method: get
Path: /database/monitoring/wait_class_totals
Get wait time summary from recent active session history records
Method: get
Path: /database/monitoring/waits_recent
Open Service Broker
The operations from the Open Service Broker category.
Deprovision a service instance
Method: delete
Path: /openservicebroker/v2/service_instances/{instance_id}
Get the catalog of services that the service broker offers
Method: get
Path: /openservicebroker/v2/catalog
Provision a service instance
Method: put
Path: /openservicebroker/v2/service_instances/{instance_id}
Oracle APEX
The operations from the Oracle APEX category.
Get all workspaces
Method: get
Path: /apex/workspaces/
Get application statistics
Method: get
Path: /apex/statistics/application/{application_id}/
Get application statistics
Method: get
Path: /apex/statistics/workspace/{workspace_name}/
Get instance overview
Method: get
Path: /apex/statistics/overview
Get instance statistics
Method: get
Path: /apex/statistics/instance/
Performance
The operations from the Performance category.
Get a specified sampled session activity in the database
Method: get
Path: /database/performance/active_sessions_history/{sample_id},{session_id}
Get all sampled session activity in the database
Method: get
Path: /database/performance/active_sessions_history/
Get all SQL statements ordered by CPU time descending
Method: get
Path: /database/performance/top_sql_statements/
Get execution plan for an SQL Statement
Method: get
Path: /database/performance/sql_statements/{sql_id}/plan
Get historical statistics for a SQL statement
Method: get
Path: /database/performance/sql_statements/{sql_id}/history
Get information on a monitored statement
Method: get
Path: /database/performance/sql_statements/{sql_id}/monitor/{sql_exec_id},{sql_exec_start}/
Get monitoring statistics for a SQL Statement
Method: get
Path: /database/performance/sql_statements/{sql_id}/monitor/
Get parallel execution information for specific statement execution
Method: get
Path: /database/performance/sql_statements/{sql_id}/monitor/{sql_exec_id},{sql_exec_start}/parallelism
Get SQL statement
Method: get
Path: /database/performance/sql_statements/{sql_id}/text
Get SQL statistics for a specific session
Method: get
Path: /database/performance/active_sessions_history_waits/{sid},{seq_number}/active_sql
Get SQL statistics maximum values
Method: get
Path: /database/performance/top_sql_statements/maximums
Get statistics for a SQL statement
Method: get
Path: /database/performance/sql_statements/{sql_id}/
Get statistics for all SQL statements
Method: get
Path: /database/performance/sql_statements/
Get the last 10 wait events for each active session
Method: get
Path: /database/performance/active_sessions_history_waits/
Get the specified wait event for specific active session
Method: get
Path: /database/performance/active_sessions_history_waits/{sid},{seq_number}/
Pluggable Database Lifecycle Management
The operations from the Pluggable Database Lifecycle Management category.
Change the state of a PDB
Method: post
Path: /database/pdbs/{pdb_name}/status
Clone or Unplug operations for PDBs
Method: post
Path: /database/pdbs/{pdb_name}/
Create a PDB from PDB$SEED or XML
Method: post
Path: /database/pdbs/
Drop a PDB
Method: delete
Path: /database/pdbs/{pdb_name}/
Get a pluggable database
Method: get
Path: /database/pdbs/{pdb_name}/
Get all pluggable databases
Method: get
Path: /database/pdbs/
Return status information of a PDB
Method: get
Path: /database/pdbs/{pdb_name}/status
Reports
The operations from the Reports category.
Schemas
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/schemas/
Access Log
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/access_log/
Active Session Counts
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/active_session_counts/
Active Sessions
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/
Active Sessions
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/active_sessions/
Active SQL
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/active_sql/
Active SQL
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/active_sql/
Active SQL
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/active_sql/
Activity Log
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/activity_log/
Activity Summary
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/activity_summary/
Alert Log
Method: get
Path: /database/reports/data_dictionary/database_administration/alert_log/alert_log/
All Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/all_constraints/
All Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/all_constraints/
All Encrypted Columns
Method: get
Path: /database/reports/data_dictionary/security/encryption/all_encrypted_columns/
All Grants
Method: get
Path: /database/reports/data_dictionary/security/public_grants/all_grants/
All Indexes
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/indexes/all_indexes/
All Indexes
Method: get
Path: /database/reports/data_dictionary/table/indexes/all_indexes/
All Objects
Method: get
Path: /database/reports/data_dictionary/all_objects/all_objects/
All Parameters
Method: get
Path: /database/reports/data_dictionary/database_administration/database_parameters/all_parameters/
All Stream Rules
Method: get
Path: /database/reports/data_dictionary/streams/all_stream_rules/
All Table Comments
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/comments/all_table_comments/
All Table Comments
Method: get
Path: /database/reports/data_dictionary/table/comments/all_table_comments/
All Tables
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/all_tables/
All Tables in Encrypted TableSpaces and their Algorithm (uses dba tables)
Method: get
Path: /database/reports/data_dictionary/security/encryption/all_tables_in_encrypted_tablespaces_and_their_algorithm_uses_dba_tables/
All Triggers
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/triggers/all_triggers/
All Triggers
Method: get
Path: /database/reports/data_dictionary/table/triggers/all_triggers/
All Users
Method: get
Path: /database/reports/data_dictionary/database_administration/users/all_users/
Application
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/application/
Application
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/application/
Application
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/application/
Application Statistics
Method: get
Path: /database/reports/data_dictionary/application_express/application_statistics/
Applications
Method: get
Path: /database/reports/data_dictionary/application_express/applications/
Applications
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/applications/
ASH Rows Detail
Method: get
Path: /database/reports/data_dictionary/ash_and_awr/ash_rows_detail/
Audit Policies
Method: get
Path: /database/reports/data_dictionary/security/auditing/audit_policies/
Authentication
Method: get
Path: /database/reports/data_dictionary/application_express/applications/authentication/
Average Response Time by Page
Method: get
Path: /database/reports/data_dictionary/application_express/application_statistics/average_response_time_by_page/
Background Sessions
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/background_sessions/
Bind Variables
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/active_sessions/bind_variables/
Bind Variables
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_waits/bind_variables/
Blocking Locks by User
Method: get
Path: /database/reports/data_dictionary/database_administration/locks/blocking_locks_by_user/
Branches
Method: get
Path: /database/reports/data_dictionary/application_express/pages/branches/
Build Opt
Method: get
Path: /database/reports/data_dictionary/application_express/applications/build_opt/
Buttons
Method: get
Path: /database/reports/data_dictionary/application_express/pages/buttons/
Check Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/check_constraints/
Check Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/check_constraints/
Client
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/client/
Client
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/client/
Client
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/client/
Clusters
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/organization/clusters/clusters/
Clusters
Method: get
Path: /database/reports/data_dictionary/table/organization/clusters/clusters/
Collection Types
Method: get
Path: /database/reports/data_dictionary/all_objects/collection_types/
Column Comments
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/comments/column_comments/
Column Comments
Method: get
Path: /database/reports/data_dictionary/table/comments/column_comments/
Column Privileges
Method: get
Path: /database/reports/data_dictionary/security/grants_and_privileges/column_privileges/
Column UI Defaults
Method: get
Path: /database/reports/data_dictionary/application_express/ui_defaults/column_ui_defaults/
Columns
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/columns/columns/
Columns
Method: get
Path: /database/reports/data_dictionary/security/redaction/columns/
Columns
Method: get
Path: /database/reports/data_dictionary/table/columns/columns/
Computations
Method: get
Path: /database/reports/data_dictionary/application_express/applications/computations/
Computations
Method: get
Path: /database/reports/data_dictionary/application_express/pages/computations/
Contention
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/contention/
Contention
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/contention/
Contention
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/contention/
Count by Account Status
Method: get
Path: /database/reports/data_dictionary/database_administration/users/count_by_account_status/
Count by Default Tablespace
Method: get
Path: /database/reports/data_dictionary/database_administration/users/count_by_default_tablespace/
Count by Profile
Method: get
Path: /database/reports/data_dictionary/database_administration/users/count_by_profile/
Count by Temporary Tablespace
Method: get
Path: /database/reports/data_dictionary/database_administration/users/count_by_temporary_tablespace/
Counts by Grantor
Method: get
Path: /database/reports/data_dictionary/security/public_grants/counts_by_grantor/
Cursor Detail
Method: get
Path: /database/reports/data_dictionary/database_administration/cursors/cursor_detail/
Cursors by Session
Method: get
Path: /database/reports/data_dictionary/database_administration/cursors/cursors_by_session/
Daily ASH Statistics Chart
Method: get
Path: /database/reports/data_dictionary/ash_and_awr/daily_ash_statistics_chart/
Datafiles
Method: get
Path: /database/reports/data_dictionary/database_administration/storage/datafiles/
Datatype Occurrences
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/columns/datatype_occurrences/
Datatype Occurrences
Method: get
Path: /database/reports/data_dictionary/table/columns/datatype_occurrences/
Dependencies
Method: get
Path: /database/reports/data_dictionary/all_objects/dependencies/
Detailed Page Statistics
Method: get
Path: /database/reports/data_dictionary/application_express/application_statistics/detailed_page_statistics/
Dictionary View Columns
Method: get
Path: /database/reports/data_dictionary/data_dictionary/dictionary_view_columns/
Dictionary Views
Method: get
Path: /database/reports/data_dictionary/data_dictionary/dictionary_views/
Disabled Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/disabled_constraints/
Disabled Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/disabled_constraints/
Disabled Triggers
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/triggers/disabled_triggers/
Disabled Triggers
Method: get
Path: /database/reports/data_dictionary/table/triggers/disabled_triggers/
Dynamic memory
Method: get
Path: /database/reports/data_dictionary/database_administration/memory/dynamic_memory/
elapsed time history
Method: get
Path: /database/reports/data_dictionary/ash_and_awr/ash_rows_detail/elapsed_time_history/
Enabled Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/enabled_constraints/
Enabled Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/enabled_constraints/
Enabled Triggers
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/triggers/enabled_triggers/
Enabled Triggers
Method: get
Path: /database/reports/data_dictionary/table/triggers/enabled_triggers/
Encrypted Tablespaces (uses dba tables)
Method: get
Path: /database/reports/data_dictionary/security/encryption/encrypted_tablespaces_uses_dba_tables/
Events
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/wait_class_activity_for_last_hour/events/
Events In The Past X Minutes
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/events_in_the_past_x_minutes/
Events In Wait Class For Past 1 Hour
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/events_in_wait_class_for_past_1_hour/
Expired
Method: get
Path: /database/reports/data_dictionary/database_administration/users/expired/
Explain Plan
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/active_sessions/explain_plan/
Explain Plan
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/explain_plan/
Explain Plan
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/explain_plan/
Explain Plan
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_waits/explain_plan/
Files
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/files/
Foreign Key Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/foreign_key_constraints/
Foreign Key Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/foreign_key_constraints/
Free Space
Method: get
Path: /database/reports/data_dictionary/database_administration/storage/free_space/
Grant DML
Method: get
Path: /database/reports/data_dictionary/security/public_grants/grant_dml/
Grant EXECUTE
Method: get
Path: /database/reports/data_dictionary/security/public_grants/grant_execute/
Grant SELECT
Method: get
Path: /database/reports/data_dictionary/security/public_grants/grant_select/
Grantable
Method: get
Path: /database/reports/data_dictionary/security/public_grants/grantable/
Inactive Sessions
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/inactive_sessions/
Index Organized Tables
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/organization/index_organized/index_organized_tables/
Index Organized Tables
Method: get
Path: /database/reports/data_dictionary/table/organization/index_organized/index_organized_tables/
Indexes by Status
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/indexes/indexes_by_status/
Indexes by Status
Method: get
Path: /database/reports/data_dictionary/table/indexes/indexes_by_status/
Indexes by Type
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/indexes/indexes_by_type/
Indexes by Type
Method: get
Path: /database/reports/data_dictionary/table/indexes/indexes_by_type/
Invalid Objects
Method: get
Path: /database/reports/data_dictionary/all_objects/invalid_objects/
Items
Method: get
Path: /database/reports/data_dictionary/application_express/applications/items/
Items
Method: get
Path: /database/reports/data_dictionary/application_express/pages/items/
Largest Average Row Length
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/statistics/largest_average_row_length/
Largest Average Row Length
Method: get
Path: /database/reports/data_dictionary/table/statistics/largest_average_row_length/
Lists
Method: get
Path: /database/reports/data_dictionary/application_express/applications/lists/
Locked
Method: get
Path: /database/reports/data_dictionary/database_administration/users/locked/
Long Opsq
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/active_sessions/long_opsq/
Long Opsq
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/long_opsq/
Long Opsq
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/long_opsq/
LOV
Method: get
Path: /database/reports/data_dictionary/application_express/applications/lov/
Most Rows
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/statistics/most_rows/
Most Rows
Method: get
Path: /database/reports/data_dictionary/table/statistics/most_rows/
National Language Support Parameters
Method: get
Path: /database/reports/data_dictionary/about_your_database/national_language_support_parameters/
Nav Bars
Method: get
Path: /database/reports/data_dictionary/application_express/applications/nav_bars/
Non-Default Parameters
Method: get
Path: /database/reports/data_dictionary/database_administration/database_parameters/non_default_parameters/
Object Count by Type
Method: get
Path: /database/reports/data_dictionary/all_objects/object_count_by_type/
Object Count by Type
Method: get
Path: /database/reports/data_dictionary/database_administration/users/object_count_by_type/
Object Distribution
Method: get
Path: /database/reports/data_dictionary/all_objects/object_distribution/
Object Grants
Method: get
Path: /database/reports/data_dictionary/security/grants_and_privileges/object_grants/
Offline Tablespaces
Method: get
Path: /database/reports/data_dictionary/database_administration/storage/offline_tablespaces/
Page Views by Page
Method: get
Path: /database/reports/data_dictionary/application_express/application_statistics/page_views_by_page/
Pages
Method: get
Path: /database/reports/data_dictionary/application_express/applications/pages/
Pages
Method: get
Path: /database/reports/data_dictionary/application_express/pages/
Parent Tabs
Method: get
Path: /database/reports/data_dictionary/application_express/applications/parent_tabs/
Partitioned Tables
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/organization/partitioned/partitioned_tables/
Partitioned Tables
Method: get
Path: /database/reports/data_dictionary/table/organization/partitioned/partitioned_tables/
Policies
Method: get
Path: /database/reports/data_dictionary/security/policies/policies/
Policy
Method: get
Path: /database/reports/data_dictionary/security/redaction/policy/
Primary Key Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/primary_key_constraints/
Primary Key Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/primary_key_constraints/
Processes
Method: get
Path: /database/reports/data_dictionary/application_express/applications/processes/
Processes
Method: get
Path: /database/reports/data_dictionary/application_express/pages/processes/
Program Unit Arguments
Method: get
Path: /database/reports/data_dictionary/plsql/program_unit_arguments/
Public Database Links
Method: get
Path: /database/reports/data_dictionary/all_objects/public_database_links/
Public Synonyms
Method: get
Path: /database/reports/data_dictionary/all_objects/public_synonyms/
Recently Created
Method: get
Path: /database/reports/data_dictionary/database_administration/users/recently_created/
Regions
Method: get
Path: /database/reports/data_dictionary/application_express/pages/regions/
Relocate Details
Method: get
Path: /database/reports/data_dictionary/database_administration/pdb_relocate/relocate_details/
Role Privileges
Method: get
Path: /database/reports/data_dictionary/security/grants_and_privileges/role_privileges/
Schemas
Method: get
Path: /database/reports/data_dictionary/application_express/schemas/
Search Source Code
Method: get
Path: /database/reports/data_dictionary/plsql/search_source_code/
Segments For Past 1 Hour
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/segments_for_past_1_hour/
Server
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/server/
Server
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/server/
Server
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/server/
Session Counts by OS User
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/session_counts_by_os_user/
Session Counts by Status
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/session_counts_by_status/
Session CPU and Time Statistics
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/session_cpu_and_time_statistics/
Sessions
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/
Sessions by Module
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_by_module/
Sessions by Username
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_by_username/
Sessions with Rowsource
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/
Shortcuts
Method: get
Path: /database/reports/data_dictionary/application_express/applications/shortcuts/
Sql Elapsed Time History
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_waits/sql_elapsed_time_history/
sql from blocking session
Method: get
Path: /database/reports/data_dictionary/database_administration/locks/blocking_locks_by_user/sql_from_blocking_session/
sql from waiting session
Method: get
Path: /database/reports/data_dictionary/database_administration/locks/blocking_locks_by_user/sql_from_waiting_session/
Sql Plan
Method: get
Path: /database/reports/data_dictionary/ash_and_awr/ash_rows_detail/sql_plan/
SQL Text
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/active_sessions/sql_text/
SQL Text
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/events_in_the_past_x_minutes/sql_text/
SQL Text
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/wait_class_activity_for_last_hour/sql_text/
Statistics
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/statistics/statistics/
Statistics
Method: get
Path: /database/reports/data_dictionary/table/statistics/statistics/
System Privileges
Method: get
Path: /database/reports/data_dictionary/security/grants_and_privileges/system_privileges/
System Sessions
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/system_sessions/
Table Count by Tablespace
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/storage/table_count_by_tablespace/
Table Count by Tablespace
Method: get
Path: /database/reports/data_dictionary/table/storage/table_count_by_tablespace/
Tables by Tablespace
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/storage/tables_by_tablespace/
Tables by Tablespace
Method: get
Path: /database/reports/data_dictionary/table/storage/tables_by_tablespace/
Tables with Comments
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/comments/tables_with_comments/
Tables with Comments
Method: get
Path: /database/reports/data_dictionary/table/comments/tables_with_comments/
Tables with Unindexed Foreign Keys
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/quality_assurance/tables_with_unindexed_foreign_keys/
Tables with Unindexed Foreign Keys
Method: get
Path: /database/reports/data_dictionary/table/quality_assurance/tables_with_unindexed_foreign_keys/
Tables without Comments
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/comments/tables_without_comments/
Tables without Comments
Method: get
Path: /database/reports/data_dictionary/table/comments/tables_without_comments/
Tables without Indexes
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/quality_assurance/tables_without_indexes/
Tables without Indexes
Method: get
Path: /database/reports/data_dictionary/table/quality_assurance/tables_without_indexes/
Tables without Primary Keys
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/quality_assurance/tables_without_primary_keys/
Tables without Primary Keys
Method: get
Path: /database/reports/data_dictionary/table/quality_assurance/tables_without_primary_keys/
Tablespace Quotas
Method: get
Path: /database/reports/data_dictionary/database_administration/storage/tablespace_quotas/
Tablespace Segments
Method: get
Path: /database/reports/data_dictionary/database_administration/storage/tablespace_segments/
Tablespaces
Method: get
Path: /database/reports/data_dictionary/database_administration/storage/tablespaces/
Tabs
Method: get
Path: /database/reports/data_dictionary/application_express/applications/tabs/
Templates
Method: get
Path: /database/reports/data_dictionary/application_express/applications/templates/
Themes
Method: get
Path: /database/reports/data_dictionary/application_express/applications/themes/
Top segments
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/events_in_the_past_x_minutes/top_segments/
Top segments
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/wait_class_activity_for_last_hour/top_segments/
Top SQL by Buffer Gets
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_buffer_gets/
Top SQL by Buffer Gets/Rows Proc
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_buffer_gets/rows_proc/
Top SQL by CPU
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_cpu/
Top SQL by Disk Reads
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_disk_reads/
Top SQL by Executions
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_executions/
Top SQL by Waits
Method: get
Path: /database/reports/data_dictionary/database_administration/top_sql/top_sql_by_waits/
Trees
Method: get
Path: /database/reports/data_dictionary/application_express/applications/trees/
Trigger Summary
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/triggers/trigger_summary/
Trigger Summary
Method: get
Path: /database/reports/data_dictionary/table/triggers/trigger_summary/
Types
Method: get
Path: /database/reports/data_dictionary/application_express/applications/types/
UI Defaults
Method: get
Path: /database/reports/data_dictionary/application_express/ui_defaults/
Unique Constraints
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/constraints/unique_constraints/
Unique Constraints
Method: get
Path: /database/reports/data_dictionary/table/constraints/unique_constraints/
Unit Line Counts
Method: get
Path: /database/reports/data_dictionary/plsql/unit_line_counts/
Unusable Indexes
Method: get
Path: /database/reports/data_dictionary/database_administration/all_tables/indexes/unusable_indexes/
Unusable Indexes
Method: get
Path: /database/reports/data_dictionary/table/indexes/unusable_indexes/
User Summary
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/user_summary/
User Synonyms
Method: get
Path: /database/reports/data_dictionary/table/user_synonyms/
User Tables
Method: get
Path: /database/reports/data_dictionary/table/user_tables/
Validations
Method: get
Path: /database/reports/data_dictionary/application_express/pages/validations/
Version Banner
Method: get
Path: /database/reports/data_dictionary/about_your_database/version_banner/
Wait Class Activity for Last Hour
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/wait_class_activity_for_last_hour/
Waits
Method: get
Path: /database/reports/data_dictionary/application_express/active_sessions/waits/
Waits
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions/waits/
Waits
Method: get
Path: /database/reports/data_dictionary/database_administration/sessions/sessions_with_rowsource/waits/
Waits for past 1 hour
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/waits_for_past_1_hour/
Waits For Past 1 Hour In 1st RAC Instance
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/waits_for_past_1_hour_in_1st_rac_instance/
Waits For Past 1 Hour In 2nd RAC Instance
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/waits_for_past_1_hour_in_2nd_rac_instance/
Waits For Past 1 Hour In Nth RAC Instance
Method: get
Path: /database/reports/data_dictionary/database_administration/waits_and_events/waits_for_past_1_hour_in_nth_rac_instance/
Web Svr
Method: get
Path: /database/reports/data_dictionary/application_express/applications/web_svr/
With Objects
Method: get
Path: /database/reports/data_dictionary/database_administration/users/with_objects/
Without Objects
Method: get
Path: /database/reports/data_dictionary/database_administration/users/without_objects/
Workspace
Method: get
Path: /database/reports/data_dictionary/application_express/workspace/
XML Schemas
Method: get
Path: /database/reports/data_dictionary/xml/xml_schemas/
Your Encrypted Columns
Method: get
Path: /database/reports/data_dictionary/security/encryption/your_encrypted_columns/
Your Stream Rules
Method: get
Path: /database/reports/data_dictionary/streams/your_stream_rules/