2025-01-01から1年間の記事一覧
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…
https://docs.oracle.com/cd/F19136_01/dbseg/introduction-to-auditing.html#GUID-AE3A5133-D90F-4447-822C-CF186247EDDChttps://docs.oracle.com/cd/F19136_01/upgrd/recommended-and-best-practices-complete-upgrading-oracle-database.html#GUID-21FE7F…
https://docs.oracle.com/cd/F19136_01/adfns/flashback.html#GUID-06AA782A-3F79-4235-86D5-2D136485F093 sql select supplemental_log_data_min,supplemental_log_data_pk,supplemental_log_data_fkfrom v$database; alter database add supplemental log …
https://docs.oracle.com/cd/F19136_01/sqlrf/ALTER-TABLE.html sqlplus test/test@pdb11 create table jisei_test(col1 number);select * from user_tab_cols where table_name = 'JISEI_TEST'; alter table JISEI_TEST add(PERIOD FOR emp_track_time);alt…
https://docs.oracle.com/cd/F19136_01/vldbg/control-validity-visibility-data.html#GUID-AF78C832-516A-4686-9DDF-CE12597F7723 sqlplus test/test@pdb11 SELECT employee_id FROM employees_temp; EXECUTE DBMS_FLASHBACK_ARCHIVE.enable_at_valid_time(…
period for句を使用して時間的な有効性データを参照 https://docs.oracle.com/cd/F19136_01/vldbg/control-validity-visibility-data.html#GUID-88C12A0B-2419-4872-A95B-163F80815CBD sqlplus test/test@pdb11 ALTER session set nls_date_format ='yyyy/mm…
https://docs.oracle.com/cd/F19136_01/sqlrf/ALTER-TABLE.html sqlplus test/test@pdb11 select * from user_tab_cols where table_name = 'ARCTEST01'; alter table ARCTEST01 NO ROW ARCHIVAL;
https://docs.oracle.com/cd/F19136_01/sqlrf/ALTER-TABLE.html sqlplus test/test@pdb11 create table ARCTEST01(col1 number); select * from user_tab_cols where table_name = 'ARCTEST01'; alter table ARCTEST01 ROW ARCHIVAL;
https://docs.oracle.com/cd/F19136_01/vldbg/control-validity-visibility-data.html#GUID-5A76B6CE-C96D-49EE-9A89-0A2CB993A933 ORA_ARCHIVE_STATE列を確認 ROW ARCHIVAL VISIBILITYセッションパラメータを設定し、非アクティブレコードも表示 sqlplus te…
https://docs.oracle.com/cd/F19136_01/arpls/DBMS_ILM_ADMIN.html sqlplus test/test@pdb11 exec DBMS_ILM_ADMIN.ENABLE_ILM;exec DBMS_ILM_ADMIN.DISABLE_ILM; select * from DBA_ILMPARAMETERS;
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-811423E6-3F43-4B95-AF9E-119AC71FB0D0 sqlplus test/test@pdb11 select * from DBA_ILMDATAMOVEMENTPOLICIES;select * from DBA_ILMOBJECTS;select * from DBA_ILMPOLICIES…
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-811423E6-3F43-4B95-AF9E-119AC71FB0D0 sqlplus test/test@pdb11 select * from DBA_ILMDATAMOVEMENTPOLICIES;select * from DBA_ILMOBJECTS;select * from DBA_ILMPOLICIES…
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-EFA918BC-3430-486B-B936-C3DAA41572F0 sqlplus test/test@pdb11 CREATE OR REPLACE FUNCTION my_custom_ado_rules (objn IN NUMBER) RETURN BOOLEANis beginreturn true;en…
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-1C87CC45-14E2-4AE0-849C-3324DF94A4EA sqlplus test/test@pdb11 select * from DBA_ILMPARAMETERS; BEGINDBMS_ILM_ADMIN.CUSTOMIZE_ILM(DBMS_ILM_ADMIN.TBS_PERCENT_USED, …
https://docs.oracle.com/cd/F19136_01/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9386F2877__CJAJEHJB 圧縮移動 sqlplus test/test@pdb11 select * from DBA_ILMDATAMOVEMENTPOLICIES;select * from DBA_ILMOBJECTS;select * from DBA_ILMPO…
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-DE4C9EB5-FBDC-4621-AA7B-17EBD11FBF27 テーブルに対して指定 表領域に対して指定 sqlplus test/test@pdb11 select * from DBA_ILMDATAMOVEMENTPOLICIES;select * from DBA_…
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-DE4C9EB5-FBDC-4621-AA7B-17EBD11FBF27 行レベルで変更なし30年後に拡張行圧縮をテーブルに対して指定 セグメントレベルで新規作成30月後に基本行圧縮をテーブルに対して指…
https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-FB83C140-B7E7-4EF8-959A-A990ECE20369 ヒート・マップを有効にすると、すべてのアクセスがインメモリー・アクティビティ・トラッキング・モジュールによって追跡されます。…
https://docs.oracle.com/cd/F19136_01/multi/overview-of-the-multitenant-architecture.html#GUID-19E279FC-9E50-4AE7-B852-1C6409066BC1 show con_name create role c##role1 container=all; select * from dba_roles order by role;
https://docs.oracle.com/cd/F19136_01/multi/overview-of-the-multitenant-architecture.html#GUID-3BB161DA-9CC0-4D61-A2C1-5D3662E0DECF show con_name create user c##user1 identified by oracle; grant dba to c##user1 container=all; select * from …
https://docs.oracle.com/cd/F19136_01/multi/administering-pdbs-with-sql-plus.html#GUID-322C5C03-4C48-40CD-8230-0BA5F16BF96B show pdbs; select * from DBA_PDB_SAVED_STATES; alter pluggable database all SAVE STATE;alter pluggable database all …
