https://docs.oracle.com/cd/F19136_01/vldbg/maintenance-partition-tables-indexes.html#GUID-676087FC-D6DC-4533-95FD-6DC941CE4753https://docs.oracle.com/cd/F19136_01/vldbg/maintenance-partition-tables-indexes.html#GUID-D413FE9E-7FFA-41E6-BA1B…

https://docs.oracle.com/cd/F19136_01/vldbg/partition-create-tables-indexes.html#GUID-52397EF9-EC3B-4E80-8211-77E683263530 sqlplus test/test@pdb11 CREATE TABLE par(pk INT CONSTRAINT par_pk PRIMARY KEY, i INT) PARTITION BY RANGE(i) INTERVAL …

https://docs.oracle.com/cd/F19136_01/sutil/oracle-sql-loader-express-mode.html#GUID-8C235861-2A8B-4196-9705-E6FFED0C0C99 sqlplus C##USER1/oracle@pdb11create table express(col1 number,col2 varchar2(100),col3 date); vim express.dat 123,aaa,2…

https://docs.oracle.com/cd/F19136_01/sutil/datapump-import-utility.html#GUID-64FB67BD-EB67-4F50-A4D2-5D34518E6BDB expdp c##user1/oracle@pdb11 directory=ORA_DIR dumpfile=tab2.dmp logfile=tab2.exp.log tables=tab2 REUSE_DUMPFILES=YES impdp c#…

https://docs.oracle.com/cd/F19136_01/sutil/oracle-data-pump-export-utility.html#GUID-A9C3C356-A6B4-45D0-9599-763F5B24E140 expdp c##user1/oracle@pdb11 directory=ORA_DIR dumpfile=tab1.dmp logfile=tab1.exp.log tables=tab1 ENCRYPTION_MODE=pass…

https://docs.oracle.com/cd/F19136_01/sutil/oracle-data-pump-export-utility.html#GUID-E4E45E81-5391-43BE-B27D-B763EF79A885 grant dba to c##user1 container=all; conn C##USER1/oracle@pdb11create directory ORA_DIR as '/home/oracle';grant all o…

https://docs.oracle.com/cd/F19136_01/sutil/oracle-data-pump-export-utility.html#GUID-079769D8-40F4-432F-88AD-E7264D7A2E2Dhttps://docs.oracle.com/cd/F19136_01/sutil/datapump-import-utility.html#GUID-E27D2DC9-A6D8-4F0B-AB72-6BF526B3AA18 PROD…

https://docs.oracle.com/cd/F19136_01/refrn/TEMP_UNDO_ENABLED.html#GUID-E2A01A84-2D63-401F-B64E-C96B18C5DCA6 sqlplus test/test@pdb11 show parameter TEMP_UNDO_ENABLEDALTER SYSTEM SET TEMP_UNDO_ENABLED = TRUE scope=both sid='*';

https://docs.oracle.com/cd/F19136_01/netrf/parameters-for-the-sqlnet.ora.html#GUID-2041545B-58D4-48DC-986F-DCC9D0DEC642 ※サーバー、クライアントの両方ともこのパラメータをONに設定している場合、接続に圧縮が使用されます。 cdhcd network/admin v…

https://docs.oracle.com/cd/F19136_01/tgsql/optimizer-statistics-concepts.html#GUID-60281E3A-8A64-4072-A7F6-719BF9D51260 デフォルトは'SESSION'です sqlplus test/test@pdb11 select DBMS_STATS.GET_PREFS ('GLOBAL_TEMP_TABLE_STATS') from dual; ex…

https://docs.oracle.com/cd/F19136_01/tgsql/managing-extended-statistics.html#GUID-E1F39134-24F1-4EF7-B614-82F9428CA762 CONNECT sh/sh@pdb11 DROP TABLE customers_test;CREATE TABLE customers_test AS SELECT * FROM CUSTOMERS;EXEC DBMS_STATS.GAT…

https://docs.oracle.com/cd/F19136_01/arpls/DBMS_SPD.html#GUID-E242EA74-6311-4A25-A92D-D47D374BC156 sqlplus test/test@pdb11 SELECT DBMS_SPD.GET_PREFS('SPD_RETENTION_WEEKS') FROM DUAL; BEGIN DBMS_SPD.SET_PREFS('SPD_RETENTION_WEEKS', '4');END…

https://docs.oracle.com/cd/F19136_01/tgsql/options-for-optimizer-statistics-gathering.html#GUID-67E635AA-F168-47D7-9DC9-CE8803464B6E sqlplus test/test@pdb11 BEGIN DBMS_SPD.FLUSH_SQL_PLAN_DIRECTIVE;END;/ SELECT TO_CHAR(d.DIRECTIVE_ID) dir_i…

https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-19E6FFB0-BC7A-4CDB-AE36-6D67C15C7332 CONNECT sys/oracle@pdb11 AS SYSDBA ALTER SYSTEM FLUSH SHARED_POOL;ALTER SYSTEM FLUSH BUFFER_CACHE; show parameter planALT…

https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-A94CFA49-910A-4237-A7BB-39BFA94E227E sql COL PARAMETER_NAME FORMAT a30COL VALUE FORMAT a10SELECT PARAMETER_NAME, PARAMETER_VALUE AS "VALUE"FROM DBA_ADVISOR_PA…

https://docs.oracle.com/cd/F19136_01/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-B3FED12D-DA2A-4A19-9C45-93FC32690822https://docs.oracle.com/cd/F19136_01/admin/managing-resources-with-oracle-database-resource-manag…

{13 リソースマネージャ}CDBリソースプランの作成と有効化 https://docs.oracle.com/cd/F19136_01/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-CD7B6826-3F4D-450B-9081-69F7BAC3EBF1 exec DBMS_RESOURCE_MANAGER.CREATE_PENDING…

https://docs.oracle.com/cd/F19136_01/refrn/ENABLE_DDL_LOGGING.html#GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE show parameter ENABLE_DDL_LOGGINGalter system set ENABLE_DDL_LOGGING = true scope=both sid='*'; sqlplus test/test@pdb11 show param…

https://docs.oracle.com/cd/F19136_01/tgsql/monitoring-database-operations.html#GUID-C941CE9D-97E1-42F8-91ED-4949B2B710BF sqlplus test/test@pdb11 -- 単純データベース操作 SELECT /*+ MONITOR */ /* HOGE */ SYSDATE FROM DUAL;SELECT /*+ MONITOR …

https://docs.oracle.com/cd/F19136_01/admin/managing-data-files-and-temp-files.html#GUID-E4CA8427-D8AE-45AC-A209-554D555758DE sqlplus test/test@pdb11 select * from dba_data_files; ALTER DATABASE MOVE DATAFILE '/oradata/orcl/pdb11/system01.d…

https://docs.oracle.com/cd/E82638_01/asoag/configuring-oracle-data-redaction-policies.html git clone https://github.com/oracle-samples/db-sample-schemas.gitcd db-sample-schemas sqlplus test/test@pdb11@./customer_orders/co_install.sql@./hum…

https://docs.oracle.com/cd/F19136_01/dbseg/performing-privilege-analysis-identify-privilege-use.html#GUID-403B206F-71B5-481E-8FF7-6FEBA2DE1D75 sqlplus test/test@pdb11 select * from DBA_PRIV_CAPTURES; EXEC DBMS_PRIVILEGE_CAPTURE.DROP_CAPTURE…

https://docs.oracle.com/cd/F19136_01/dbseg/performing-privilege-analysis-identify-privilege-use.html#GUID-09B5E21E-5C5B-4171-B6D7-32DDF7EA1222 sqlplus test/test@pdb11 select * from DBA_PRIV_CAPTURES; EXEC DBMS_PRIVILEGE_CAPTURE.DISABLE_CAP…

https://docs.oracle.com/cd/F19136_01/dbseg/performing-privilege-analysis-identify-privilege-use.html#GUID-C4A9E2B3-0051-4190-BD23-1F24052B352C sqlplus test/test@pdb11 select * from DBA_PRIV_CAPTURES; EXEC DBMS_PRIVILEGE_CAPTURE.ENABLE_CAPT…

https://docs.oracle.com/cd/F19136_01/dbseg/performing-privilege-analysis-identify-privilege-use.html#GUID-442371F1-541D-4A1E-BCBF-180C0D88517D sqlplus test/test@pdb11 select * from DBA_PRIV_CAPTURES; データベース分析 BEGIN DBMS_PRIVILEGE_C…

https://docs.oracle.com/cd/F19136_01/dbseg/administering-the-audit-trail.html#GUID-B9D2B078-2567-4002-A906-E293DE94549E sqlplus test/test@pdb11 select count(*) from UNIFIED_AUDIT_TRAIL; BEGIN DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP( AUD…

https://docs.oracle.com/cd/F19136_01/dbseg/configuring-audit-policies.html#GUID-A178CF26-EF6F-41B6-BB08-1DF444722B2F sqlplus test/test@pdb11 select * from AUDIT_UNIFIED_ENABLED_POLICIES;select * from AUDIT_UNIFIED_POLICIES where POLICY_NAM…

https://docs.oracle.com/cd/F19136_01/dbseg/configuring-audit-policies.html#GUID-526A09B1-0782-47BA-BDF3-17E61E546174https://docs.oracle.com/cd/F19136_01/dbseg/configuring-audit-policies.html#GUID-1577CCEB-2AFD-417C-9238-9DFF13149766 sqlplu…

https://docs.oracle.com/cd/F19136_01/dbseg/configuring-audit-policies.html#GUID-5E618BEF-A197-4A9F-B856-5D2941DFB4E5 システム権限の監査 オブジェクトアクションの監査 ロールの監査 sqlplus test/test@pdb11 select * from AUDIT_UNIFIED_ENABLED_P…

https://docs.oracle.com/cd/F19136_01/dbseg/administering-the-audit-trail.html#GUID-80D9305C-29F6-4F3B-BDDB-371F619B08D8 SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; SHUTDOWN IMMEDIATE cd $ORACLE_HOME/rdbms/libmake -f in…