0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

[Autonomous Database]サービス・コンソール(DBユーザでログイン)

Last updated at Posted at 2022-03-24

はじめに

  • 前回はこちら

  • サービス・コンソールはADBの性能監視・調査を行えるツールです。

  • 次のようなことが可能です

    • 特定SQLの性能確認
    • ボトルネック調査
    • インスタンス全体の稼働状況の可視化
  • 今回は、ADMINユーザ以外のDBユーザでサービス・コンソールにログインしてみます

手順

1)テスト用のDBユーザの作成

  • ADMINユーザでDB Actionsにログインし、「データベース・ユーザー」からテスト用ユーザを作成します。

  • 付与可能なロールをみたところ、サービス・コンソール関係のロールは次の4つだと思われます。

CONSOLE_ADMIN
CONSOLE_DEVELOPER
CONSOLE_MONITOR
CONSOLE_OPERATOR

※上記ロールについて、公式の詳細情報はありませんが、次のようなブログ情報はあります
Which Privileges Are Required to Use the ADWC Service Console?

  • 今回は次のようなユーザーを作成しました
ユーザー名 パスワード 付与したロール
SERVICE_MO Welcome#1Welcome#1 CONSOLE_MONITOR

補足

  • ADB内のDBユーザに付与可能なロール一覧(DB Actionsから確認)
ACCHK_READ
ADB_MONITOR
ADM_PARALLEL_EXECUTE_TASK
ADP$IMPL
ADPADMIN
ADPUSER
APEX_ADMINISTRATOR_READ_ROLE
APEX_ADMINISTRATOR_ROLE
APEX_GRANTS_FOR_NEW_USERS_ROLE
APPLICATION_TRACE_VIEWER
AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLE
AUDIT_ADMIN
AUDIT_VIEWR
AVTUNE_PKG_ROLE
BDSQL_ADMIN
BDSQL_USER
C##ADWC_ADMIN
C##ADWC_MONITOR
C##DNSREST_ADMIN
CAPTURE_ADMIN
CDB_DBA
CONNECT
CONSOLE_ADMIN
CONSOLE_DEVELOPER
CONSOLE_MONITOR
CONSOLE_OPERATOR
CTXAPP
DATAPATCH_ROLE
DATAPUMP_CLOUD_EXP
DATAPUMP_CLOUD_IMP
DATAPUMP_EXP_FULL_DATABASE
DATAPUMP_IMP_FULL_DATABASE
DBA
DBFS_ROLE
DBMS_MDX_INTERNAL
DCAT_SYNC
DS$ASSESSMENT_ROLE
DS$AUDIT_COLLECTION_ROLE
DS$AUDIT_SETTING_ROLE
DS$DATA_DISCOVERY_ROLE
DS$DATA_MASKING_ROLE
DV_ACCTMGR
DV_ADMIN
DV_DATAPUMP_NETWORK_LINK
DV_GOLDENGATE_ADMIN
DV_GOLDENGATE_REDO_ACCESS
DV_MONITOR
DV_OWNER
DV_PATCH_ADMIN
DV_POLICY_OWNER
DV_PUBLIC
DV_REALM_OWNER
DV_REALM_RESOURCE
DV_SECANALYST
DV_STREAMS_ADMIN
DV_XSTREAM_ADMIN
DWROLE
EM_EXPRESS_ALL
EM_EXPRESS_BASIC
EXECUTE_CATALOG_ROLE
EXP_FULL_DATABASE
EXTAPP
GATHER_SYSTEM_STATISTICS
GDS_CATALOG_SELECT
GGSYS_ROLE
GRAPH_DEVELOPER
GSM_POOLADMIN_ROLE
GSMADMIN_ROLE
GSMPOOTUSER_ROLE
GSMUSER_ROLE
HS_ADMIN_EXECUTE_ROLE
HS_ADMIN_ROLE
HS_ADMIN_SELECT_ROLE
IMP_FULL_DATABAES
LBAC_DBA
LINEAGE_AUTHOR
LOGSTDBY_ADMINISTRATOR
MAINTPLAN_APP
ODI_LINEAGE_ADMIN
ODI_LINEAGE_USER
OEM_ADVISOR
OEM_MONITOR
OML_DEVELOPER
OML_SYS_ADMIN
OPTIMIZER_PROCESSING_RATE
ORDS_ADMINISTRATOR_ROLE
ORDS_RUNTIME_ROLE
PDB_DBA
PROVISONER
PYQADMIN
REDCTX_ADMIN
RECOVERY_CATALOG_ONWER
RECOVERY_CATALOG_ONWER_VPD
RECOVERY_CATALOG_USER
RESOURCE
SCHEDULER_ADMIN
SELECT_CATALOG_ROLE
SODA_APP
SYSUMF_ROLE
XS_CACHE_ADMIN
XS_CONNECT
XS_NAMESPACE_ADMIN
XS_SESSION_ADMIN
  • ロールに付与されている権限(ADMINユーザーでADBにログインし確認した結果)
    • role_sys_privsビューからロール内の権限を確認してみましたが、CONSOLE_xxロールのものはありませんでした
SELECT ROLE,PRIVILEGE FROM role_sys_privs ORDER BY role;

ROLE                        PRIVILEGE
__________________________ ____________________________________
ADPUSER	                      ALTER SESSION
ADPUSER	                      CREATE ANALYTIC VIEW
ADPUSER	                      CREATE ATTRIBUTE DIMENSION
ADPUSER	                      CREATE HIERARCHY
ADPUSER	                      CREATE JOB
ADPUSER	                      CREATE MATERIALIZED VIEW
ADPUSER	                      CREATE MINING MODEL
ADPUSER	                      CREATE PROCEDURE
ADPUSER	                      CREATE SEQUENCE
ADPUSER	                      CREATE SESSION
ADPUSER	                      CREATE SYNONYM
ADPUSER	                      CREATE TABLE
ADPUSER	                      CREATE TRIGGER
ADPUSER	                      CREATE TYPE
ADPUSER	                      CREATE VIEW
AQ_ADMINISTRATOR_ROLE	      CREATE EVALUATION CONTEXT
AQ_ADMINISTRATOR_ROLE	      CREATE RULE
AQ_ADMINISTRATOR_ROLE	      CREATE RULE SET
AQ_ADMINISTRATOR_ROLE	      DEQUEUE ANY QUEUE
AQ_ADMINISTRATOR_ROLE	      ENQUEUE ANY QUEUE
AQ_ADMINISTRATOR_ROLE	      MANAGE ANY QUEUE
AUDIT_ADMIN	                  AUDIT ANY
AUDIT_ADMIN	                  AUDIT SYSTEM
CONNECT	                      CREATE SESSION
CONNECT	                      SET CONTAINER
CTXAPP	                      CREATE SEQUENCE
DATAPUMP_CLOUD_EXP	          ADMINISTER RESOURCE MANAGER
DATAPUMP_CLOUD_EXP	          ADMINISTER SQL MANAGEMENT OBJECT
DATAPUMP_CLOUD_EXP	          ANALYZE ANY
DATAPUMP_CLOUD_EXP	          CREATE SESSION
DATAPUMP_CLOUD_EXP	          CREATE TABLE
DATAPUMP_CLOUD_EXP	          EXECUTE ANY PROCEDURE
DATAPUMP_CLOUD_EXP	          EXECUTE ANY TYPE
DATAPUMP_CLOUD_EXP	          FLASHBACK ANY TABLE
DATAPUMP_CLOUD_EXP	          READ ANY FILE GROUP
DATAPUMP_CLOUD_EXP	          RESUMABLE
DATAPUMP_CLOUD_EXP	          SELECT ANY SEQUENCE
DATAPUMP_CLOUD_EXP	          SELECT ANY TABLE
DATAPUMP_CLOUD_IMP	          ADMINISTER DATABASE TRIGGER
DATAPUMP_CLOUD_IMP	          ADMINISTER RESOURCE MANAGER
DATAPUMP_CLOUD_IMP	          ADMINISTER SQL MANAGEMENT OBJECT
DATAPUMP_CLOUD_IMP	          ALTER ANY PROCEDURE
DATAPUMP_CLOUD_IMP	          ALTER ANY TABLE
DATAPUMP_CLOUD_IMP	          ALTER ANY TRIGGER
DATAPUMP_CLOUD_IMP	          ALTER ANY TYPE
DATAPUMP_CLOUD_IMP	          ALTER DATABASE
DATAPUMP_CLOUD_IMP	          ALTER PROFILE
DATAPUMP_CLOUD_IMP	          ALTER RESOURCE COST
DATAPUMP_CLOUD_IMP	          ALTER TABLESPACE
DATAPUMP_CLOUD_IMP       	  ALTER USER
DATAPUMP_CLOUD_IMP	          ANALYZE ANY
DATAPUMP_CLOUD_IMP	          AUDIT ANY
DATAPUMP_CLOUD_IMP	          AUDIT SYSTEM
DATAPUMP_CLOUD_IMP	          BECOME USER
DATAPUMP_CLOUD_IMP	          COMMENT ANY TABLE
DATAPUMP_CLOUD_IMP	          CREATE ANY CLUSTER
DATAPUMP_CLOUD_IMP	          CREATE ANY CONTEXT
DATAPUMP_CLOUD_IMP	          CREATE ANY DIMENSION
DATAPUMP_CLOUD_IMP	          CREATE ANY INDEX
DATAPUMP_CLOUD_IMP	          CREATE ANY INDEXTYPE
DATAPUMP_CLOUD_IMP	          CREATE ANY MATERIALIZED VIEW
DATAPUMP_CLOUD_IMP	          CREATE ANY OPERATOR
DATAPUMP_CLOUD_IMP	          CREATE ANY PROCEDURE
DATAPUMP_CLOUD_IMP	          CREATE ANY SEQUENCE
DATAPUMP_CLOUD_IMP	          CREATE ANY SQL PROFILE
DATAPUMP_CLOUD_IMP	          CREATE ANY SYNONYM
DATAPUMP_CLOUD_IMP	          CREATE ANY TABLE
DATAPUMP_CLOUD_IMP	          CREATE ANY TRIGGER
DATAPUMP_CLOUD_IMP	          CREATE ANY TYPE
DATAPUMP_CLOUD_IMP	          CREATE ANY VIEW
DATAPUMP_CLOUD_IMP	          CREATE PROFILE
DATAPUMP_CLOUD_IMP	          CREATE PUBLIC SYNONYM
DATAPUMP_CLOUD_IMP	          CREATE ROLE
DATAPUMP_CLOUD_IMP	          CREATE ROLLBACK SEGMENT
DATAPUMP_CLOUD_IMP	          CREATE SESSION
DATAPUMP_CLOUD_IMP	          CREATE TABLESPACE
DATAPUMP_CLOUD_IMP	          CREATE USER
DATAPUMP_CLOUD_IMP	          DELETE ANY TABLE
DATAPUMP_CLOUD_IMP	          DROP ANY CLUSTER
DATAPUMP_CLOUD_IMP	          DROP ANY CONTEXT
DATAPUMP_CLOUD_IMP	          DROP ANY DIMENSION
DATAPUMP_CLOUD_IMP	          DROP ANY INDEX
DATAPUMP_CLOUD_IMP	          DROP ANY INDEXTYPE
DATAPUMP_CLOUD_IMP	          DROP ANY LIBRARY
DATAPUMP_CLOUD_IMP	          DROP ANY MATERIALIZED VIEW
DATAPUMP_CLOUD_IMP	          DROP ANY OPERATOR
DATAPUMP_CLOUD_IMP	          DROP ANY OUTLINE
DATAPUMP_CLOUD_IMP	          DROP ANY PROCEDURE
DATAPUMP_CLOUD_IMP	          DROP ANY ROLE
DATAPUMP_CLOUD_IMP	          DROP ANY SEQUENCE
DATAPUMP_CLOUD_IMP	          DROP ANY SQL PROFILE
DATAPUMP_CLOUD_IMP	          DROP ANY SYNONYM
DATAPUMP_CLOUD_IMP	          DROP ANY TABLE
DATAPUMP_CLOUD_IMP	          DROP ANY TRIGGER
DATAPUMP_CLOUD_IMP	          DROP ANY TYPE
DATAPUMP_CLOUD_IMP	          DROP ANY VIEW
DATAPUMP_CLOUD_IMP	          DROP PROFILE
DATAPUMP_CLOUD_IMP	          DROP PUBLIC SYNONYM
DATAPUMP_CLOUD_IMP	          DROP ROLLBACK SEGMENT
DATAPUMP_CLOUD_IMP	          DROP TABLESPACE
DATAPUMP_CLOUD_IMP	          DROP USER
DATAPUMP_CLOUD_IMP	          EXECUTE ANY OPERATOR
DATAPUMP_CLOUD_IMP	          EXECUTE ANY PROCEDURE
DATAPUMP_CLOUD_IMP	          EXECUTE ANY TYPE
DATAPUMP_CLOUD_IMP	          GLOBAL QUERY REWRITE
DATAPUMP_CLOUD_IMP	          GRANT ANY OBJECT PRIVILEGE
DATAPUMP_CLOUD_IMP	          GRANT ANY ROLE
DATAPUMP_CLOUD_IMP	          INSERT ANY TABLE
DATAPUMP_CLOUD_IMP	          RESUMABLE
DATAPUMP_CLOUD_IMP	          SELECT ANY TABLE
DATAPUMP_CLOUD_IMP	          UPDATE ANY TABLE
DS$ASSESSMENT_ROLE	          CREATE SESSION
DS$AUDIT_COLLECTION_ROLE	  CREATE SESSION
DS$AUDIT_SETTING_ROLE	      CREATE SESSION
DS$DATA_DISCOVERY_ROLE	      CREATE PROCEDURE
DS$DATA_DISCOVERY_ROLE	      CREATE SESSION
DS$DATA_DISCOVERY_ROLE	      READ ANY TABLE
DS$DATA_MASKING_ROLE	      ALTER ANY INDEX
DS$DATA_MASKING_ROLE	      ALTER ANY TABLE
DS$DATA_MASKING_ROLE	      ALTER ANY TRIGGER
DS$DATA_MASKING_ROLE	      ANALYZE ANY
DS$DATA_MASKING_ROLE	      COMMENT ANY TABLE
DS$DATA_MASKING_ROLE	      CREATE ANY CONTEXT
DS$DATA_MASKING_ROLE	      CREATE ANY INDEX
DS$DATA_MASKING_ROLE	      CREATE ANY PROCEDURE
DS$DATA_MASKING_ROLE	      CREATE ANY TABLE
DS$DATA_MASKING_ROLE	      CREATE ANY TRIGGER
DS$DATA_MASKING_ROLE	      CREATE SESSION
DS$DATA_MASKING_ROLE	      CREATE TYPE
DS$DATA_MASKING_ROLE	      DROP ANY CONTEXT
DS$DATA_MASKING_ROLE	      DROP ANY INDEX
DS$DATA_MASKING_ROLE	      DROP ANY PROCEDURE
DS$DATA_MASKING_ROLE	      DROP ANY TABLE
DS$DATA_MASKING_ROLE	      DROP ANY TRIGGER
DS$DATA_MASKING_ROLE	      EXECUTE ANY PROCEDURE
DS$DATA_MASKING_ROLE	      INSERT ANY TABLE
DS$DATA_MASKING_ROLE	      LOCK ANY TABLE
DS$DATA_MASKING_ROLE	      SELECT ANY TABLE
DS$DATA_MASKING_ROLE	      UPDATE ANY TABLE
DV_ACCTMGR	                  ALTER PROFILE
DV_ACCTMGR	                  ALTER USER
DV_ACCTMGR	                  CREATE PROFILE
DV_ACCTMGR	                  CREATE SESSION
DV_ACCTMGR	                  CREATE USER
DV_ACCTMGR	                  DROP PROFILE
DV_ACCTMGR	                  DROP USER
DWROLE	                      ALTER SESSION
DWROLE	                      CREATE ANALYTIC VIEW
DWROLE	                      CREATE ATTRIBUTE DIMENSION
DWROLE	                      CREATE HIERARCHY
DWROLE	                      CREATE JOB
DWROLE	                      CREATE MATERIALIZED VIEW
DWROLE	                      CREATE MINING MODEL
DWROLE	                      CREATE PROCEDURE
DWROLE	                      CREATE SEQUENCE
DWROLE	                      CREATE SESSION
DWROLE	                      CREATE SYNONYM
DWROLE	                      CREATE TABLE
DWROLE	                      CREATE TRIGGER
DWROLE	                      CREATE TYPE
DWROLE	                      CREATE VIEW
OML_SYS_ADMIN	              ALTER USER
OML_SYS_ADMIN	              CREATE USER
OML_SYS_ADMIN	              DROP USER
PDB_DBA	                      ADMINISTER ANY SQL TUNING SET
PDB_DBA	                      ADMINISTER DATABASE TRIGGER
PDB_DBA	                      ADMINISTER RESOURCE MANAGER
PDB_DBA	                      ADMINISTER SQL MANAGEMENT OBJECT
PDB_DBA	                      ADMINISTER SQL TUNING SET
PDB_DBA                       ADVISOR
PDB_DBA	                      ALTER ANY ANALYTIC VIEW
PDB_DBA	                      ALTER ANY ASSEMBLY
PDB_DBA	                      ALTER ANY ATTRIBUTE DIMENSION
PDB_DBA	                      ALTER ANY CLUSTER
PDB_DBA	                      ALTER ANY CUBE
PDB_DBA	                      ALTER ANY CUBE BUILD PROCESS
PDB_DBA	                      ALTER ANY CUBE DIMENSION
PDB_DBA	                      ALTER ANY DIMENSION
PDB_DBA	                      ALTER ANY EDITION
PDB_DBA	                      ALTER ANY EVALUATION CONTEXT
PDB_DBA	                      ALTER ANY HIERARCHY
PDB_DBA	                      ALTER ANY INDEX
PDB_DBA	                      ALTER ANY INDEXTYPE
PDB_DBA	                      ALTER ANY LIBRARY
PDB_DBA	                      ALTER ANY MATERIALIZED VIEW
PDB_DBA	                      ALTER ANY MEASURE FOLDER
PDB_DBA	                      ALTER ANY MINING MODEL
PDB_DBA	                      ALTER ANY OPERATOR
PDB_DBA	                      ALTER ANY OUTLINE
PDB_DBA	                      ALTER ANY PROCEDURE
PDB_DBA	                      ALTER ANY ROLE
PDB_DBA	                      ALTER ANY RULE
PDB_DBA	                      ALTER ANY RULE SET
PDB_DBA	                      ALTER ANY SEQUENCE
PDB_DBA	                      ALTER ANY SQL PROFILE
PDB_DBA	                      ALTER ANY SQL TRANSLATION PROFILE
PDB_DBA	                      ALTER ANY TABLE
PDB_DBA	                      ALTER ANY TRIGGER
PDB_DBA	                      ALTER ANY TYPE
PDB_DBA	                      ALTER DATABASE
PDB_DBA	                      ALTER LOCKDOWN PROFILE
PDB_DBA	                      ALTER PROFILE
PDB_DBA	                      ALTER RESOURCE COST
PDB_DBA	                      ALTER ROLLBACK SEGMENT
PDB_DBA	                      ALTER SESSION
PDB_DBA	                      ALTER SYSTEM
PDB_DBA	                      ALTER TABLESPACE
PDB_DBA	                      ALTER USER
PDB_DBA	                      ANALYZE ANY
PDB_DBA	                      ANALYZE ANY DICTIONARY
PDB_DBA	                      AUDIT ANY
PDB_DBA	                      AUDIT SYSTEM
PDB_DBA	                      BECOME USER
PDB_DBA	                      CHANGE NOTIFICATION
PDB_DBA	                      COMMENT ANY MINING MODEL
PDB_DBA	                      COMMENT ANY TABLE
PDB_DBA	                      CREATE ANALYTIC VIEW
PDB_DBA	                      CREATE ANY ANALYTIC VIEW
PDB_DBA	                      CREATE ANY ASSEMBLY
PDB_DBA	                      CREATE ANY ATTRIBUTE DIMENSION
PDB_DBA	                      CREATE ANY CLUSTER
PDB_DBA	                      CREATE ANY CONTEXT
PDB_DBA	                      CREATE ANY CUBE
PDB_DBA	                      CREATE ANY CUBE BUILD PROCESS
PDB_DBA	                      CREATE ANY CUBE DIMENSION
PDB_DBA	                      CREATE ANY DIMENSION
PDB_DBA	                      CREATE ANY DIRECTORY
PDB_DBA	                      CREATE ANY DIRECTORY
PDB_DBA	                      CREATE ANY EDITION
PDB_DBA	                      CREATE ANY EVALUATION CONTEXT
PDB_DBA	                      CREATE ANY HIERARCHY
PDB_DBA	                      CREATE ANY INDEX
PDB_DBA	                      CREATE ANY INDEXTYPE
PDB_DBA	                      CREATE ANY JOB
PDB_DBA	                      CREATE ANY MATERIALIZED VIEW
PDB_DBA	                      CREATE ANY MEASURE FOLDER
PDB_DBA	                      CREATE ANY MINING MODEL
PDB_DBA	                      CREATE ANY OPERATOR
PDB_DBA	                      CREATE ANY OUTLINE
PDB_DBA	                      CREATE ANY PROCEDURE
PDB_DBA	                      CREATE ANY RULE
PDB_DBA	                      CREATE ANY RULE SET
PDB_DBA	                      CREATE ANY SEQUENCE
PDB_DBA	                      CREATE ANY SQL PROFILE
PDB_DBA	                      CREATE ANY SQL TRANSLATION PROFILE
PDB_DBA	                      CREATE ANY SYNONYM
PDB_DBA	                      CREATE ANY TABLE
PDB_DBA	                      CREATE ANY TRIGGER
PDB_DBA	                      CREATE ANY TYPE
PDB_DBA	                      CREATE ANY VIEW
PDB_DBA	                      CREATE ASSEMBLY
PDB_DBA	                      CREATE ATTRIBUTE DIMENSION
PDB_DBA	                      CREATE CLUSTER
PDB_DBA	                      CREATE CUBE
PDB_DBA	                      CREATE CUBE BUILD PROCESS
PDB_DBA	                      CREATE CUBE DIMENSION
PDB_DBA	                      CREATE DATABASE LINK
PDB_DBA	                      CREATE DIMENSION
PDB_DBA	                      CREATE EVALUATION CONTEXT
PDB_DBA	                      CREATE HIERARCHY
PDB_DBA	                      CREATE INDEXTYPE
PDB_DBA	                      CREATE JOB
PDB_DBA	                      CREATE LOCKDOWN PROFILE
PDB_DBA	                      CREATE MATERIALIZED VIEW
PDB_DBA	                      CREATE MEASURE FOLDER
PDB_DBA	                      CREATE MINING MODEL
PDB_DBA	                      CREATE OPERATOR
PDB_DBA	                      CREATE PLUGGABLE DATABASE
PDB_DBA	                      CREATE PROCEDURE
PDB_DBA	                      CREATE PROFILE
PDB_DBA	                      CREATE PUBLIC DATABASE LINK
PDB_DBA	                      CREATE PUBLIC SYNONYM
PDB_DBA	                      CREATE ROLE
PDB_DBA	                      CREATE ROLLBACK SEGMENT
PDB_DBA	                      CREATE RULE
PDB_DBA	                      CREATE RULE SET
PDB_DBA	                      CREATE SEQUENCE
PDB_DBA	                      CREATE SESSION
PDB_DBA	                      CREATE SQL TRANSLATION PROFILE
PDB_DBA	                      CREATE SYNONYM
PDB_DBA	                      CREATE TABLE
PDB_DBA	                      CREATE TABLESPACE
PDB_DBA	                      CREATE TRIGGER
PDB_DBA	                      CREATE TYPE
PDB_DBA	                      CREATE USER
PDB_DBA	                      CREATE VIEW
PDB_DBA	                      DEBUG ANY PROCEDURE
PDB_DBA	                      DEBUG CONNECT ANY
PDB_DBA	                      DEBUG CONNECT SESSION
PDB_DBA	                      DELETE ANY CUBE DIMENSION
PDB_DBA	                      DELETE ANY MEASURE FOLDER
PDB_DBA	                      DELETE ANY TABLE
PDB_DBA	                      DROP ANY ANALYTIC VIEW
PDB_DBA	                      DROP ANY ASSEMBLY
PDB_DBA	                      DROP ANY ATTRIBUTE DIMENSION
PDB_DBA	                      DROP ANY CLUSTER
PDB_DBA	                      DROP ANY CONTEXT
PDB_DBA	                      DROP ANY CUBE
PDB_DBA	                      DROP ANY CUBE BUILD PROCESS
PDB_DBA	                      DROP ANY CUBE DIMENSION
PDB_DBA	                      DROP ANY DIMENSION
PDB_DBA	                      DROP ANY DIRECTORY
PDB_DBA	                      DROP ANY DIRECTORY
PDB_DBA	                      DROP ANY EDITION
PDB_DBA	                      DROP ANY EVALUATION CONTEXT
PDB_DBA	                      DROP ANY HIERARCHY
PDB_DBA	                      DROP ANY INDEX
PDB_DBA	                      DROP ANY INDEXTYPE
PDB_DBA	                      DROP ANY LIBRARY
PDB_DBA	                      DROP ANY MATERIALIZED VIEW
PDB_DBA	                      DROP ANY MEASURE FOLDER
PDB_DBA	                      DROP ANY MINING MODEL
PDB_DBA	                      DROP ANY OPERATOR
PDB_DBA	                      DROP ANY OUTLINE
PDB_DBA	                      DROP ANY PROCEDURE
PDB_DBA	                      DROP ANY ROLE
PDB_DBA	                      DROP ANY RULE
PDB_DBA	                      DROP ANY RULE SET
PDB_DBA	                      DROP ANY SEQUENCE
PDB_DBA	                      DROP ANY SQL PROFILE
PDB_DBA	                      DROP ANY SQL TRANSLATION PROFILE
PDB_DBA	                      DROP ANY SYNONYM
PDB_DBA	                      DROP ANY TABLE
PDB_DBA	                      DROP ANY TRIGGER
PDB_DBA	                      DROP ANY TYPE
PDB_DBA	                      DROP ANY VIEW
PDB_DBA	                      DROP LOCKDOWN PROFILE
PDB_DBA	                      DROP PROFILE
PDB_DBA	                      DROP PUBLIC DATABASE LINK
PDB_DBA	                      DROP PUBLIC SYNONYM
PDB_DBA	                      DROP ROLLBACK SEGMENT
PDB_DBA	                      DROP TABLESPACE
PDB_DBA	                      DROP USER
PDB_DBA	                      EXECUTE ANY ASSEMBLY
PDB_DBA	                      EXECUTE ANY EVALUATION CONTEXT
PDB_DBA	                      EXECUTE ANY INDEXTYPE
PDB_DBA	                      EXECUTE ANY LIBRARY
PDB_DBA	                      EXECUTE ANY OPERATOR
PDB_DBA	                      EXECUTE ANY PROCEDURE
PDB_DBA	                      EXECUTE ANY RULE
PDB_DBA	                      EXECUTE ANY RULE SET
PDB_DBA	                      EXECUTE ANY TYPE
PDB_DBA	                      EXECUTE ASSEMBLY
PDB_DBA	                      FLASHBACK ANY TABLE
PDB_DBA	                      FORCE ANY TRANSACTION
PDB_DBA	                      GLOBAL QUERY REWRITE
PDB_DBA	                      GRANT ANY OBJECT PRIVILEGE
PDB_DBA	                      GRANT ANY ROLE
PDB_DBA	                      INSERT ANY CUBE DIMENSION
PDB_DBA	                      INSERT ANY MEASURE FOLDER
PDB_DBA	                      INSERT ANY TABLE
PDB_DBA	                      LOCK ANY TABLE
PDB_DBA	                      MANAGE SCHEDULER
PDB_DBA	                      MANAGE TABLESPACE
PDB_DBA	                      MERGE ANY VIEW
PDB_DBA	                      ON COMMIT REFRESH
PDB_DBA	                      PURGE DBA_RECYCLEBIN
PDB_DBA	                      QUERY REWRITE
PDB_DBA	                      READ ANY FILE GROUP
PDB_DBA	                      READ ANY TABLE
PDB_DBA	                      REDEFINE ANY TABLE
PDB_DBA	                      RESTRICTED SESSION
PDB_DBA	                      RESUMABLE
PDB_DBA	                      SELECT ANY CUBE
PDB_DBA	                      SELECT ANY CUBE BUILD PROCESS
PDB_DBA	                      SELECT ANY CUBE DIMENSION
PDB_DBA	                      SELECT ANY DICTIONARY
PDB_DBA	                      SELECT ANY MEASURE FOLDER
PDB_DBA	                      SELECT ANY MINING MODEL
PDB_DBA	                      SELECT ANY SEQUENCE
PDB_DBA	                      SELECT ANY TABLE
PDB_DBA	                      SELECT ANY TRANSACTION
PDB_DBA	                      UNDER ANY TABLE
PDB_DBA	                      UNDER ANY TYPE
PDB_DBA	                      UNDER ANY VIEW
PDB_DBA	                      UPDATE ANY CUBE
PDB_DBA	                      UPDATE ANY CUBE BUILD PROCESS
PDB_DBA	                      UPDATE ANY CUBE DIMENSION
PDB_DBA	                      UPDATE ANY TABLE
RESOURCE	                  CREATE CLUSTER
RESOURCE	                  CREATE INDEXTYPE
RESOURCE	                  CREATE OPERATOR
RESOURCE	                  CREATE PROCEDURE
RESOURCE	                  CREATE SEQUENCE
RESOURCE	                  CREATE TABLE
RESOURCE	                  CREATE TRIGGER
RESOURCE	                  CREATE TYPE
XS_CONNECT	                  CREATE SESSION

2)サービス・コンソールにログイン

OCIコンソールからサービス・コンソールを起動します

a1.png

ADMINユーザーでログインしているので、サインアウトします
a2.png

テスト用DBユーザーでサインインします
a3.png
マニュアルにもある通り、サービス・コンソールのURLをブックマークしておけば直接移動可能です。

  • マニュアルより

ノート:Oracle Cloud Infrastructureコンソールにログインしなくても、サービス・コンソールURLをブックマークしてそのURLに直接移動できます。 ログアウトしてブックマークを使用する場合、サービス・コンソールを表示するには、ADMINのユーザー名とパスワードを入力し、「サインイン」をクリックする必要があります。 ADMINユーザーのパスワードを変更する必要がある場合は、「Autonomous DatabaseでのADMINパスワードの設定」を参照してください。

テスト用DBユーザーでサインインできました

  • 概要

    • 記憶域
      • 合計および使用済み記憶域容量を表示
      • 30分ごとにリフレッシュ
      • 使用中の記憶域は次のようなADB内の記憶域
        • 全てのDBオブジェクト
        • ユーザーがファイル・システムに格納したファイル
        • 一次表領域で使用される記憶域
    • CPU使用率(%)
      • 平均CPU使用率の履歴を表示
    • 割当済みOCPUの数
      • 割り当てられたOCPU数の実際の数を表示
    • 実行中のSQL文
      • 実行中のSQL文の平均数の履歴を表示
    • SQL文のレスポンス時間(秒)
      • SQL文の平均レスポンス時間の履歴を表示
  • パフォーマンス・データの保存期間(デフォルト:30日間

  • CPU使用率、実行中のSQL文および平均SQLレスポンス時間は過去8日間(デフォルト)のデータが表示される

  • 保存期間の変更方法:DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS()で自動ワークロード・リポジトリ保存設定を変更

    • 保存期間を長くすると、パフォーマンス・データのストレージ使用量は増加する

a4.png

  • アクティビティ

    • モニター
      • データベース・アクティビティ
        • CPUを使用しているか、待機イベントを待機しているDB内のセッション数の平均数を表示
      • 実行中の文
        • 各コンシューマ・グループで実行中のSQL文の平均数を表示
      • CPU使用率(%)
        • 各コンシューマ・グループのCPU使用率
      • キューされた文
        • 各コンシューマグループでキューされたSQL文の平均数
    • モニター対象SQL
      • SQLモニタリングのレポートのダウンロードが可能
  • パフォーマンス・データの保存期間(デフォルト:30日間

  • 期間ビューのグラフには過去8日間のデータが表示

  • 保存期間の変更方法:DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS()で自動ワークロード・リポジトリ保存設定を変更

    • 保存期間を長くすると、パフォーマンス・データのストレージ使用量は増加する

a5.png

参考

0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?