2024-12-01から1ヶ月間の記事一覧
https://docs.oracle.com/cd/F19136_01/tgsql/gathering-optimizer-statistics.html#GUID-E5731E8E-3382-4E6A-9986-2508721631E3 作業負荷統計 EXECUTE DBMS_STATS.GATHER_SYSTEM_STATS( gathering_mode => 'START' );EXECUTE DBMS_STATS.GATHER_SYSTEM_STAT…
https://docs.oracle.com/cd/F19136_01/tgsql/transporting-optimizer-statistics.html#GUID-B24DB1B4-ECA4-4F8B-9948-E1456FAF1819 orcl⇒PROD1 -- orcl beginDBMS_STATS.CREATE_STAT_TABLE ( 'sh', 'stattab');end;/ beginDBMS_STATS.export_table_stats ( …
https://docs.oracle.com/cd/F19136_01/tgsql/managing-historical-optimizer-statistics.html#GUID-D3050CB5-C0FA-4BD7-B7FF-88566437D461 begindbms_stats.restore_table_stats('sh','tokei',as_of_timestamp =>to_timestamp('20241205 01:00:11','yyyymmd…
https://docs.oracle.com/cd/F19136_01/tgsql/controlling-the-use-of-optimizer-statistics.html#GUID-6D85C813-5FBF-4655-ACE5-1E50DB4F8E60 begindbms_stats.lock_table_stats('sh','tokei');end;/ select * from dba_tab_statistics where table_name = …
https://docs.oracle.com/cd/F19136_01/tgsql/options-for-optimizer-statistics-gathering.html#GUID-F1C666DC-5450-4F92-83AA-607327DB5FD8 show parameter dynamicalter system set optimizer_dynamic_sampling=3;
https://docs.oracle.com/cd/F19136_01/arpls/DBMS_STATS.html#GUID-CA6A56B9-0540-45E9-B1D7-D78769B7714C begindbms_stats.gather_table_stats('sh','tokei',no_invalidate =>true);end;/
https://docs.oracle.com/cd/F19136_01/tgsql/managing-historical-optimizer-statistics.html#GUID-DEEE6740-F601-4B77-B4D3-AF03F5883456 select DBMS_STATS.GET_STATS_HISTORY_RETENTION from dual; beginDBMS_STATS.ALTER_STATS_HISTORY_RETENTION ( 366…
https://docs.oracle.com/cd/F19136_01/tgsql/controlling-the-use-of-optimizer-statistics.html#GUID-8FF503A2-5E50-4054-AC3A-5672343BDFE3 https://docs.oracle.com/cd/F19136_01/tgsql/options-for-optimizer-statistics-gathering.html#GUID-4FDDBCB2-…
https://docs.oracle.com/cd/F19136_01/tgsql/managing-extended-statistics.html#GUID-FC50E35E-AF6A-4ECD-919D-8E020011DAB6 begindbms_stats.gather_table_stats('sh','tokei',method_opt =>'for columns(col1+col4) size 254');end;/ select * from dba_…
https://docs.oracle.com/cd/F19136_01/tgsql/managing-extended-statistics.html#GUID-CE34B506-94B6-4346-8AB6-6B17BC52B782 begindbms_stats.gather_table_stats('sh','tokei',method_opt =>'for columns(col2,col3) size 254');end;/ select * from dba_…
https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html -- 1. VPC、サブネット作成 cat <<-'EOF' > main.tf provider "aws" { region = "ap-northeast-1"} resource "aws_vpc" "vpc01" { cidr_block = "10.0.0.…
https://dev.classmethod.jp/articles/change-instance-type-on-ec2/https://docs.aws.amazon.com/ja_jp/AWSEC2/latest/UserGuide/ec2-instance-resize.html -- 1. VPC、サブネット作成 cat <<-'EOF' > main.tf provider "aws" { region = "ap-northeast-1"}…
https://docs.oracle.com/cd/F19136_01/arpls/DBMS_STATS.html#GUID-CA6A56B9-0540-45E9-B1D7-D78769B7714Chttps://docs.oracle.com/cd/F19136_01/tgsql/histograms.html conn test/test create table sh.tokei(col1 number, col2 date, col3 varchar2(10), …
https://docs.oracle.com/cd/F19136_01/dbseg/using-oracle-vpd-to-control-data-access.html#GUID-52A959FA-E021-4C3A-B532-0C6289BDD50F --手順1: ユーザー・アカウントとサンプル表の作成conn / as sysdba GRANT CREATE SESSION, CREATE ANY CONTEXT, CRE…
https://docs.oracle.com/ja-jp/iaas/Content/Compute/References/computeshapes.htm -- 1. terraformによるVPC構築 cat <<-'EOF' > variables.tf locals { tenancy_ocid = "ocid1.tenancy.oc1..1111111111111111111111111111111111111111111111111111111111…
https://www.oracle.com/jp/database/base-database-service/pricing/ https://speakerdeck.com/oracle4engineer/basedb-tech-detail ENTERPRISE_EDITION19.22VM.Standard.A1.FlexLVM1cpu -> 2cpu -> 12cpu -- 1. terraformによるVPC構築 cat <<-'EOF' > var…
https://docs.oracle.com/cd/F19136_01/dbseg/using-application-contexts-to-retrieve-user-information.html#GUID-BF276A5E-BC14-4B49-A02A-2EC984325805 --手順1: ユーザー・アカウントの作成GRANT CREATE SESSION, CREATE ANY CONTEXT, CREATE PROCEDURE…
https://docs.oracle.com/cd/F19136_01/dbseg/using-application-contexts-to-retrieve-user-information.html#GUID-6F6FE37D-8D2D-4D0E-A5AA-C96D958F8BD5 --手順1: ユーザー・アカウントの作成GRANT CREATE SESSION, CREATE ANY CONTEXT, CREATE PROCEDURE…
https://oracle-japan.github.io/ocitutorials/adb/adb303-datapump/ sqlplusとimpdpはCentOS 7から実行 -- 1. コンパートメント作成 oci iam compartment create \--compartment-id ocid1.tenancy.oc1..11111111111111111111111111111111111111111111111111…