콘텐츠로 이동

sch Document

Gathering (통계 수집)

sch Document

sch Document
Ai
Ai
- Index
- Prompt
  Prompt
  - 각종 프롬프트 모음
Aws
Aws
- AWS
- Amplify
  Amplify
  - Amplify
- Athena
  Athena
  - Athena
- Cdk
  Cdk
  - CDK
  - Example
    Example
    
    Example (JavaScript, TypeScript)
- Cli
  Cli
  - CLI
- Cloudformation
  Cloudformation
  - CloudFormation
- Dms
  Dms
  - DMS
  - Oracle
    Oracle
    
    Oracle DMS
  - Postgresql
    Postgresql
    
    PostgreSQL DMS
- Elb
  Elb
  - ELB
- Glue
  Glue
  - Glue
- Iam
  Iam
  - IAM
- Rds
  Rds
  - RDS
  - Aurora
    Aurora
    
    Aurora
    
    Info
    Info
    
    Aurora 구성 및 특징
  - Mysql
    Mysql
    
    RDS MySQL
    
    Create instance
    Create instance
    
    인스턴스 생성 방법
    
    Log
    Log
    
    Log
    
    Optimized writes
    Optimized writes
    
    Optimized Writes
  - Oracle
    Oracle
    
    RDS Oracle
    
    Administering
    Administering
    
    RDS에서의 권한 관리
    
    Create instance
    Create instance
    
    인스턴스 생성 방법
    
    Datapump
    Datapump
    
    Datapump
    
    Memory swap
    Memory swap
    
    Memory, Swap 문제
    
    Quotas
    Quotas
    
    RDS Oracle의 자원 할당량
    
    S3
    S3
    
    S3 관련 명령어
    
    S3 INTEGRATION
    
    Spatial
    Spatial
    
    Spatial
    
    Temporary tablespace
    Temporary tablespace
    
    Temporary Tablespace
    
    Timezone
    Timezone
    
    Timezone
  - Postgresql
    Postgresql
    
    RDS PostgreSQL
- S3
  S3
  - S3
- Snapshot
  Snapshot
  - Snapshot
- Ssm
  Ssm
  - Session Manager
Csharp
Csharp
- C#
- Array
  Array
  - Array
- Datatable
  Datatable
  - DataTable
- Datetime
  Datetime
  - DateTime
- Directory
  Directory
  - Directory
- Fileinfo
  Fileinfo
  - FileInfo
- Standard numeric format string
  Standard numeric format string
  - Standard Numeric Format String
- Stringreader
  Stringreader
  - StringReader
Etc
Etc
- etc
- Btree
  Btree
  - B Tree
- Char varchar
  Char varchar
  - CHAR와 VARCHAR의 차이
- Cidr
  Cidr
  - CIDR (Classless Inter-Domain Routing)
- Cpu scheduling
  Cpu scheduling
  - CPU Scheduling
- Eol
  Eol
  - End of Line
- Hash
  Hash
  - Hash
- Ip class
  Ip class
  - IP Class
- Isolation level
  Isolation level
  - Isolation Level (격리 수준)
- Keepalive
  Keepalive
  - Keepalive
- Nkf
  Nkf
  - nkf Network Kanji Filter (Shift JIS의 특수문자 처리)
- Ora2pg
  Ora2pg
  - ora2pg
- Regular expression
  Regular expression
  - Regular Expression
- Rest api
  Rest api
  - REST API
- Snapshot
  Snapshot
  - Snapshot
- Tcp flag
  Tcp flag
  - TCP Flag
Etcd
Etcd
- ETCD
Excel
Excel
- Excel
Flutter
Flutter
- Flutter
Git
Git
- git
- gitmessage.txt
Haproxy
Haproxy
- HAProxy
Js
Js
- JavaScript
Linux
Linux
- Linux
- Centos base.repo
  Centos base.repo
  - CentOS-Base.repo
- Hugepage
  Hugepage
  - HugePage
- Inode
  Inode
  - inode
- Thp
  Thp
  - Transparent HugePages
Mysql
Mysql
- MySQL
- Error
- Parameter
- Analyze
  Analyze
  - Analyze
- Cast
  Cast
  - Cast
- Cluster
  Cluster
  - Cluster
  - Innodb
    Innodb
    
    InnoDB Cluster
  - Ndb
    Ndb
    
    NDB Cluster
- Constraint
  Constraint
  - Constraint
- Data format
  Data format
  - Data Format
- Date format
  Date format
  - Date Format
- Double write buffer
  Double write buffer
  - Double Write Buffer
- Error
  Error
- Event scheduler
  Event scheduler
  - Event Scheduler
- Explain
  Explain
  - Explain
- Function
  Function
  - Function
- Gtid
  Gtid
  - GTID (Global Transaction Identifier)
- Hugepage
  Hugepage
  - Huge Page
- Index
  Index
  - Index
- Insert into on duplicate key update
  Insert into on duplicate key update
  - INSERT INTO ~ ON DUPLICATE KEY UPDATE
- Install
  Install
  - Install
- Isolation level
  Isolation level
  - Isolation Level
- Load data
  Load data
  - Load Data
- Log
  Log
  - Log
  - Binary
    Binary
    
    binary log
  - General
    General
    
    general log
  - Relay
    Relay
    
    relay log
  - Slow query
    Slow query
    
    slow query
- Mysql
  Mysql
  - mysql
- Mysql shell
  Mysql shell
  - mysql shell
- Mysql shell dump
  Mysql shell dump
  - mysql shell dump
- Mysqlbinlog
  Mysqlbinlog
  - mysqlbinlog
- Mysqld
  Mysqld
  - mysqld
- Mysqldump
  Mysqldump
  - mysqldump
- Mysqldump pump dumper shell
  Mysqldump pump dumper shell
  - mysqldump, mysqlpump, mydumper, mysqlshell dump의 차이
- Parameter
  Parameter
- Partition
  Partition
  - Partition
- Persist
  Persist
  - Persist
- Procedure
  Procedure
  - Procedure
- Process
  Process
  - Process
- Profiling
  Profiling
  - Profiling
- Replication
  Replication
  - Duplication
  - Master replication
    Master replication
    
    Replication
  - Mha
    Mha
    
    Mysql High Availability
  - Semi sync replication
    Semi sync replication
    
    Semi-sync Replication
- Router
  Router
  - Router
- Schema
  Schema
  - Schema
- Spatial
  Spatial
  - Spatial
- Sql mode
  Sql mode
  - SQL Mode
- Table
  Table
  - Table
- Tablespace
  Tablespace
  - Tablespace
  - System
    System
    
    시스템 테이블스페이스
- Time zone
  Time zone
  - Time Zone
- User
  User
  - User
- View
  View
  - View
Oracle
Oracle
- Oracle
- Error
- Parameter
- favorite
  favorite
  - 상황별 자주 쓰는 SQL
- Active duplication
  Active duplication
  - Active Duplication
- Analyze
  Analyze
  - Analyze
  - Analyze와 DBMS_STATS의 차이
- Automated maintence task
  Automated maintence task
  - Automated Maintence Task
- Automatic memory management
  Automatic memory management
  - AMM (Automatic Memory Management)
- Automatic shared memory management
  Automatic shared memory management
  - ASMM (Automatic Shared Memory Management)
- Block
  Block
  - Block
- Cbo rbo
  Cbo rbo
  - CBO, RBO
- Compare features
  Compare features
  - Compare Features
- Compression
  Compression
  - Compression
- Constraint
  Constraint
  - Constraint
- Datapump
  Datapump
  - Datapump
- Db link
  Db link
  - DB Link
- Dimension
  Dimension
  - Dimension
- Direct path load
  Direct path load
  - Direct Path Load
- Enqueue
  Enqueue
  - Enqueue
- Error
  Error
  - 00054
  - 00059
  - 00439
  - 00900
  - 00911
  - 00932
  - 00955
  - 00959
  - 00972
  - 00988
  - 00997
  - 01008
  - 01013
  - 01017
  - 01153
  - 01418
  - 01438
  - 01476
  - 01502
  - 01549
  - 01555
  - 01652
  - 01654
  - 01658
  - 01688
  - 01779
  - 01790
  - 01795
  - 01861
  - 01922
  - 01940
  - 01950
  - 02019
  - 02082
  - 02287
  - 02429
  - 02437
  - 03214
  - 04031
  - 08180
  - 10631
  - 10636
  - 12014
  - 12162
  - 12537
  - 12545
  - 12703
  - 12719
  - 12838
  - 12899
  - 14047
  - 14086
  - 14400
  - 14451
  - 14511
  - 14701
  - 19573
  - 22835
  - 22858
  - 22868
  - 22998
  - 24344
  - 28000
  - 28040
  - 29851
  - 30036
  - 30052
  - 30926
  - 32463
  - 38029
  - 38104
  - 39809
  - 60100
  - 65096
  - LPX 00216
  - SP2 0591
  - SP2 0618
  - Expdpimpdp
- Explain
  Explain
  - Explain
- Export csv
  Export csv
  - Export csv
- Flashback
  Flashback
  - Flashback
- Gathering
  Gathering
  - Gathering (통계 수집) Gathering (통계 수집)
    목차
    
    시스템 통계 수집
    
    자동 통계 수집
    
    수동 통계 수집
    
    참고
- Hint
  Hint
  - Hint
- Hugepage
  Hugepage
  - HugePage
- Identity
  Identity
  - Identity
- Index
  Index
  - Index
  - Bitmap index
    Bitmap index
    
    Bitmap
  - Oracle text index
    Oracle text index
    
    Oracle Text
    
    Oracle Text에 대한 자세한 설명
    
    Oracle Text 인덱스와 % 의 성능 비교
- Install oracle client
  Install oracle client
  - Install Oracle Client
- Latch
  Latch
- Literal sql
  Literal sql
  - Literal SQL
- Lob
  Lob
  - LOB (Large Objects)
- Log
  Log
  - Log
  - Archive
    Archive
    
    Archive
  - Supplemental
    Supplemental
    
    Supplemeltal Log
  - Trace
    Trace
    
    Trace
- Merge into
  Merge into
  - Merge Into
- Nls parameter
  Nls parameter
  - NLS Parameter
- Parameter
  Parameter
  - db_block_%
  - db_file_multiblock_read_count
  - db_writer_processes
  - dbwr_io_slaves
  - pool_size
  - sec_case_sensitive_logon
  - sec_case_sensitive_logon
  - session_cached_cursors
  - sort_area_size
  - Pfile spfile
    Pfile spfile
    
    PFILE, SPFILE
- Parsing
  Parsing
  - Parsing
- Partition
  Partition
  - Partition
- Patch
  Patch
  - Patch
- Pct
  Pct
  - PCT
- Process
  Process
  - Process
- Query rewrite
  Query rewrite
  - Query Rewrite
- Regular expression
  Regular expression
  - Regular Expression
- Report
  Report
  - Report
  - Ash
    Ash
    
    ash Report
  - Awr
    Awr
    
    awr Report
  - Statspack
    Statspack
    
    Statspack
- Row level lock
  Row level lock
  - Row Level Lock
- Sequence
  Sequence
  - Sequence
- Session
  Session
  - Session
- Shrink
  Shrink
  - Shrink
- Sqlldr
  Sqlldr
  - SQL Loader
- Sqlplus
  Sqlplus
  - SQL Plus
- Synonym
  Synonym
  - Synonym
- Table
  Table
  - Table
  - Temporary table
    Temporary table
    
    Temporary Table
- Tablespace
  Tablespace
- Trigger
  Trigger
  - Trigger
- User
  User
  - User
- View
  View
  - View
  - Materialized view
    Materialized view
    
    Materialized View
- With
  With
  - With
Postgresql
Postgresql
- PostgreSQL
- Parameter
- Cluster
  Cluster
  - PostgresSQL HA 구성 (Cluster)
  - Patroni
    Patroni
    
    Patroni
  - Pgbackrest
    Pgbackrest
    
    pgbackrest
- Database
  Database
  - Database
- Extension
  Extension
  - Extension
  - Dblink
    Dblink
    
    dblink
  - Oracle fdw
    Oracle fdw
    
    oracle_fdw
- Install
  Install
  - Install
- Pg ctl
  Pg ctl
  - pg_ctl
- Pgbadger
  Pgbadger
  - PGBADGER
- Pgbench
  Pgbench
  - pgbench
- Psql
  Psql
  - psql
- Schema
  Schema
  - Schema
- Sequence
  Sequence
  - Sequence
- Serial
  Serial
  - Serial
- Server
  Server
  - Server
- Session
  Session
  - Session
- Timezone
  Timezone
  - Timezone
- User
  User
  - User
- User mapping
  User mapping
  - User Mapping
Python
Python
- python
- Error
- Breakpoint
  Breakpoint
  - Breakpoint
- Datetime
  Datetime
  - Datetime
- Error
  Error
- Json
  Json
  - Json
- Time
  Time
  - Time
Shell
Shell
- Shell
- Crontab
  Crontab
  - crontab
- Export
  Export
  - export
- Find
  Find
  - find
- Grep
  Grep
  - grep
- Head
  Head
  - head
- Iconv
  Iconv
  - iconv
- Iostat
  Iostat
  - iostat
- Sar
  Sar
  - sar
- Sleep
  Sleep
  - sleep
- Sudo
  Sudo
  - sudo
- Tail
  Tail
  - tail
- Timedatectl
  Timedatectl
  - timedatectl
- Top
  Top
  - top
- User
  User
  - user
- Vi
  Vi
  - vi
- Vnc
  Vnc
  - VNC
Terraform
Terraform
- Terraform
- Module
  Module
  - Terraform Module
Uipath
Uipath
- UiPath (C#)
Vue
Vue
- Vue
- Error
  Error
  - Error
- Quasar
  Quasar
  - Quasar
Windows
Windows
- Windows
- Ps
  Ps
  - Power Shell
- Rdp
  Rdp
  - RDP (Remote Desktop Protocol)
- Wsl
  Wsl
  - WSL (Windows Subsystem for Linux)

Gathering (통계 수집)

시스템 통계 수집

정기적으로 이루어져야 함
기존 실행 계획을 무효화하지 않음

자동 통계 수집

수동 통계 수집

참고

ANALYZE