Database/Oracle (118) 썸네일형 리스트형 95 - [Oracle 19C] Monitoring Tablespace Space Usage - example DBMS_SERVER_ALERT.SET_THRESHOLD example show user; show con_name; /* USER is "PDB10_ADMIN" CON_NAME ------------------------------ PDB10 */ -- no auto extend option. CREATE TABLESPACE tbsalert DATAFILE '/u01/app/oracle/oradata/ORCL/PDB10/tbsalert.dbf' SIZE 50M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; /* TABLESPACE TBSALERT created. */ SELECT DBMS_METADATA.GET_DDL('TABLESPAC.. 94 - [Oracle 19C] Monitoring Tablespace Space Usage Monitoring Tablespace Space Usage The database server tracks space utilization while performing regular space management activities. This information is aggregated by the MMON process. An alert is triggered when the threshold for a tablespace has been reached or cleared. The DBMS_SERVER_ALERT package enables you to configure the Oracle Database server to issue an alert when a threshold for a spe.. 93 - [Oracle 19C] Basic compression Basic compression # Basic compression # With basic compression, the Oracle Database server compresses data at the time of performing bulk load using # operations such as direct loads or CREATE TABLE AS SELECT # Is recommended for bulk loading data warehouses show user; show con_name; /* USER is "PDB10_ADMIN" CON_NAME ------------------------------ PDB10 */ # Case 1 - no compression create table .. 92 - [Oracle 19C] Space-Saving Features (UNUSABLE index) Space-Saving Features (UNUSABLE index) show user; show con_name; /* USER is "PDB10_ADMIN" CON_NAME ------------------------------ PDB10 */ show parameter DEFERRED_SEGMENT_CREATION /* NAME TYPE VALUE ------------------------- ------- ----- deferred_segment_creation boolean TRUE */ create table employees ( emp_id number, fname varchar2(100), lname varchar2(100), constraint employees_pk primary key.. 91 - [Oracle 19C] Controlling DEFERRED_SEGMENT_CREATION Controlling DEFERRED_SEGMENT_CREATION show user; show con_name; /* USER is "PDB10_ADMIN" CON_NAME ------------------------------ PDB10 */ show parameter DEFERRED_SEGMENT_CREATION /* NAME TYPE VALUE ------------------------- ------- ----- deferred_segment_creation boolean TRUE */ # 'True' means the segment will be created for the table # 1 after you crate the table using DDL statement ( create ta.. 90 - [Oracle 19C] Types of Segments Managing Storage Space Types of Segments Managing Storage Space Types of Segments A segment is a set of extents allocated for a certain logical structure. The different types of segments include: Table and cluster Note: For a partitioned table, each partition has a data segment Index Note: For a partitioned index, each partition has an index segment. Undo Oracle Database maintains informatio.. 89 - [Oracle 19C] Availability and Optimization of Free Space in a Data Block Managing Storage Space Availability and Optimization of Free Space in a Data Block Managing Storage Space Availability and Optimization of Free Space in a Data Block Two types of statements can increase the free space of one or more data blocks: 1-DELETE statements 2-UPDATE statements that update existing values to smaller values The released space from these types of statements is available for.. 88 - [Oracle 19C] Managing Storage Space Managing Storage Space Space is automatically managed by the Oracle Database server. It generates alerts about potential problems and recommends possible solutions. Oracle Managed Files (OMF) No need to bother about the file names and storage requirements. Oracle provides a unique file name. Eliminates the need for the DBA to directly manage OS files. Allows operations to be specified .. 이전 1 2 3 4 5 6 7 ··· 15 다음
