2024-12-01から1ヶ月間の記事一覧
https://docs.oracle.com/cd/F19136_01/tgdba/automatic-performance-diagnostics.html#GUID-EA83D5B3-F4F0-4B4A-9597-19BBA22E55B9 select * from dba_hist_snapshot order by snap_id; variable v varchar2(100); BEGINDBMS_ADDM.ANALYZE_INST ( task_name…
https://docs.oracle.com/cd/F19136_01/tgdba/analyzing-sampled-data.html#GUID-04DEE928-D1F7-43E8-A74E-F8C8B9CB046B @$ORACLE_HOME/rdbms/admin/ashrpt.sql
https://docs.oracle.com/cd/F19136_01/tgdba/comparing-database-performance-over-time.html#GUID-BF18F170-8363-471F-ADAE-C561B56A581E BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();END;/ @$ORACLE_HOME/rdbms/admin/awrddrpt.sql
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-4B5CB76B-7A8E-4A31-8850-1BB77B13EEE2 BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();END;/ @$ORACLE_HOME/rdbms/admin/awrrpt.sql
スナップショット取得間隔 2時間 保存期間 ３１日 取得するSQL数 ２００ https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-62D01B30-2687-4821-A651-DC0E4AAC3B01 BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETT…
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-B5DB2422-951F-4D00-A473-AB6739ECC88B select * from dba_hist_baseline;select * from dba_hist_baseline_template; alter session set nls_date_format='yyyy-mm-dd…
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-B5DB2422-951F-4D00-A473-AB6739ECC88B ※単一ベースラインテンプレート→将来の固定ベースライン select * from v$database;select * from DBA_HIST_BASELINE_TEMPLATE;…
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-44811EF8-D082-487F-8EEC-DA6E78700E68 select * from dba_hist_snapshot order by snap_id; BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE (start_snap_id => 157,…
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-C6401C10-F958-4339-99C2-3320BDAB4CEA select * from v$database; select * from DBA_HIST_BASELINE_METADATA; BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_BASELINE_WIND…
https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs https://qiita.com/hiro-wa/items/4aeb1c7346714d6b5e53https://dev.classmethod.jp/articles/snowflake-terraform-try/ export SNOWFLAKE_USER=1111111111export SNOWFLAKE_…
https://www.alibabacloud.com/help/en/rds/apsaradb-rds-for-mysql/change-the-specifications-of-an-apsaradb-rds-for-mysql-instance -- 1. VPC、VSwitch作成 cat <<-'EOF' > variables.tf locals { availability_zone = "ap-northeast-1a"} EOF cat <<-'…
https://www.alibabacloud.com/help/ja/ecs/user-guide/overview-of-instance-configuration-changes -- 1. VPC、VSwitch作成 cat <<-'EOF' > variables.tf locals { availability_zone1 = "ap-northeast-1a"} EOF cat <<-'EOF' > main.tf terraform { requi…
https://docs.oracle.com/cd/F19136_01/arpls/DBMS_SPM.html#GUID-0E915A6D-F783-4BE6-9E5A-C2B756666341 SELECT SQL_HANDLE, PLAN_NAME, ENABLED, ACCEPTED, FIXED ,origin, created, SQL_TEXTFROM DBA_SQL_PLAN_BASELINESorder by CREATED; declaren numbe…
https://docs.oracle.com/cd/F19136_01/arpls/DBMS_SPM.html#GUID-0E915A6D-F783-4BE6-9E5A-C2B756666341 SELECT SQL_HANDLE, PLAN_NAME, ENABLED, ACCEPTED, FIXED ,origin, created, SQL_TEXTFROM DBA_SQL_PLAN_BASELINESorder by CREATED; declaren numbe…
https://learn.microsoft.com/ja-jp/azure/mysql/flexible-server/how-to-manage-server-cli https://learn.microsoft.com/ja-jp/azure/mysql/flexible-server/concepts-service-tiers-storage -- 1. Azureログイン az login --use-device-codeaz account sh…
https://learn.microsoft.com/ja-jp/azure/virtual-machines/sizes/resize-vm -- 1. Azureログイン az login --use-device-codeaz account show az version az configure --list-defaultsaz configure --defaults location=japaneastaz configure --list-def…
https://docs.oracle.com/cd/F19136_01/arpls/DBMS_SPM.html#GUID-7C052FDA-4F12-4B20-8967-0010CC1C3E24 SELECT SQL_HANDLE, PLAN_NAME, ENABLED, ACCEPTED, FIXED ,origin, created, SQL_TEXTFROM DBA_SQL_PLAN_BASELINESwhere sql_text like 'select coun…
ディスク領域使用量２０％ 消去方針３０週 https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-DE976D2B-DBAD-498F-B933-D16B06CA9D2A beginDBMS_SPM.CONFIGURE ( 'space_budget_percent',20);end;/ beginDBMS_SPM.CONFIGUR…
https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-BA19EA4E-AFEF-4677-B08F-854DE59ED932 variable n numberbegin:n := DBMS_SPM.DROP_SQL_PLAN_BASELINE ( sql_handle => 'SQL_a2468e835b8e4aa8');end;/ variable n numb…
https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-C7C5AEF7-5833-4780-81CF-C40CE6B43571 select max(prod_id) from sh.sales;select sql_id from v$sql where sql_text like 'select max(prod_id) from sh.sales%'; DECL…
https://cloud.google.com/sql/docs/mysql/instance-settingshttps://cloud.google.com/sql/pricing https://cloud.google.com/vpc/docs/configure-private-services-access -- 1. プロジェクト作成 gcloud initgcloud auth list gcloud --version gcloud pr…
https://cloud.google.com/compute/docs/instances/changing-machine-type-of-stopped-instance -- 1. プロジェクト作成 gcloud initgcloud auth list gcloud --version gcloud projects create project01-9999999 \--name="project01" gcloud config listgc…
https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-tuning-sets.html#GUID-5F6C1400-AD6F-4BEB-A0D8-12AADA127ADD https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-tuning-sets.html#GUID-4E5240CD-B021-4728-89A9-95F5B81CBC59https://do…
https://docs.oracle.com/cd/F19136_01/tgsql/overview-of-sql-plan-management.html#GUID-5A1E6CF4-70E5-4C26-A67B-EFDBB93EC621 show parameter baselinealter system set optimizer_capture_sql_plan_baselines=true; alter system set optimizer_capture…
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-result-cache.html#GUID-443C9B44-738B-420F-B6D2-25EBBD950119 select /*+ result_cache */ count(*) from sh.tokei; alter session set result_cache_mode=force;select count(*) from test.range;alte…
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-result-cache.html#GUID-E26C1BB2-F2A3-4FFD-93B0-B8A791017289 EXECUTE DBMS_RESULT_CACHE.flush; select * from V$RESULT_CACHE_OBJECTS;
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-result-cache.html#GUID-E26C1BB2-F2A3-4FFD-93B0-B8A791017289 SET SERVEROUTPUT ONEXECUTE DBMS_RESULT_CACHE.MEMORY_REPORT
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-result-cache.html#GUID-21CAA1E7-9E46-4442-9F3E-CE09EEF60D92 show parameter resultalter system set CLIENT_RESULT_CACHE_SIZE = 42768 scope=spfile;alter system set CLIENT_RESULT_CACHE_LAG = 20…
https://docs.oracle.com/cd/F19136_01/lnpls/plsql-subprograms.html#GUID-0F00DAC5-8F3D-426F-BBA4-86424CD7BD75 CREATE OR REPLACE FUNCTION fibonacci (n NUMBER) RETURN NUMBER RESULT_CACHE AUTHID DEFINERISBEGIN IF (n =0) OR (n =1) THEN RETURN 1;…
https://docs.oracle.com/cd/F19136_01/tgdba/tuning-result-cache.html#GUID-E26C1BB2-F2A3-4FFD-93B0-B8A791017289 show parameter result alter system set result_cache_mode = force;alter system set result_cache_max_size = 10M;alter system set re…
