Shrink a segment

Touch a good article from metalink Oracle 10g Segment shrink=Mandatory=Init.ora paramet

2022-06-02 Servers 我要分享

Shrink the table to eliminate empty blocks in the table

When you shrink a table, Oracle reorganizes the blocks with minimal storage space. The Delete operation usually does not lower the high water mark. When doing a full table scan, oracle scans blocks below the high water mark. A table may not have much data, but it takes a long time to execute.

2022-06-01 Database 我要分享

How to lower the high water level in the database

This article mainly shows you "how to reduce the high water level in the database". The content is simple and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn the article "how to reduce the high water level in the database". Method of lowering high water level 1. Mo

2022-05-31 Database 我要分享

Oracle shrinks the table, cleans up debris, and frees up space

Can be used to shrink segments, there are two ways to eliminate space debris: 1.alter table table_name move needs to note: 1) the move operation will lock the table. If it is a very small watch, you can make it online. If it is a large watch, you must pay attention to it. It will lock the watch for a long time.

2022-06-01 Database 我要分享

How to view object space usage by Oracle

This article mainly shows you "how to check the usage of object space by Oracle". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn the article "how to check the usage of object space by Oracle".

2022-05-31 Database 我要分享

What are the differences between before and after in mysql

This article mainly introduces the difference between before and after in mysql, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it. Trigger (trigger

2022-05-31 Database 我要分享

What is the knowledge of high water level in database tablespace

This article mainly explains "what is the knowledge of high water level in database table space". Interested friends may wish to take a look at it. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what is the knowledge of high water level in database tablespace"? For manual segment space management (

2022-05-31 Database 我要分享

The method of lowering the high water mark by Oracle

Oracle the method of lowering the high water mark the high water level (HIGH WARTER MARK,HWM) is like the water level stored in a reservoir and is used to describe how the middle section of the database is expanded. The high water level has an important influence on the scanning mode of the full meter. Delete a table when using DELETE

2022-06-01 Database 我要分享

Sorting and Analysis of oracle Table fragments

What this article shares with you is the collation and analysis of oracle table fragments. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. In the process of daily use, the database is constantly ins

2022-05-31 Database 我要分享

In-depth analysis of the ext2 file system

For a long time, I wanted to write an article about the ext family file system. When I was at work, I accidentally deleted a lot of files by rm-rf. I really wanted to have a data recovery software that could help me recover the data. Of course, to learn about data recovery, you must first learn about the file system. Most

2022-06-02 Servers 我要分享

How to migrate from BasicFile to SecureFile Storage (2)

SYS_IL0000072118C00005 $$INDEX PARTITION ASSM SYS_IL_P177 BASICFILESSYS_IL0000072118C00006 $$INDEX P

2022-06-01 Database 我要分享

What is SQL Line Migration and Line Link

This article introduces the knowledge of "what is SQL Line Migration and Line Link". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something! Row Migration and Row chain

2022-05-31 Database 我要分享

Free buffer waits of oracle waiting for event

1. When will free buffer waits happen? In a nutshell, this wait occurs when you need to look for available blocks in buffer cache but cannot find them. Reasons for finding available blocks include reading blocks into memory or constructing CR blocks. S

2022-06-01 Database 我要分享

What is the difference between alter table move and shrink space

This article will explain in detail what is the difference between alter table move and shrink space, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article. I.

2022-05-31 Database 我要分享

What's the difference between alter table move and alter table shrink space?

What is the difference between alter table move and alter table shrink space? I believe many inexperienced people don't know what to do about it. Therefore, this article summarizes the causes and solutions of the problems. Through this article, I hope you can solve this.

2022-05-31 Database 我要分享

What if there is a Space id in fsp header,but in the page header error in MYSQL?

This article will explain in detail what to do when there are Space id in fsp header,but in the page header errors in MYSQL. The editor thinks it is very practical, so I will share it with you for reference. I hope you will finish reading it.

2022-05-31 Database 我要分享

Control file and database initialization

The control file is the database brain, and the system tablespace is the heart of the database SQL > alter session set events' immediate trace name controlf level 8 databases

2022-06-01 Database 我要分享

What is the execution order of static code blocks, code blocks, constructors, and common methods in parent and subclasses

This article mainly explains "what is the execution order of static code blocks, code blocks, construction methods and common methods in parent and subclasses". The explanation in this article is simple and clear and easy to learn and understand. next, please follow the editor's train of thought to study and learn "in parent and subclass, Jing."

2022-06-03 Development 我要分享

Detailed explanation of Oracle High Water level Line (HWM)

HWM: high water mark, the dividing line between available space and used space, marking the use of segment space. All oracle segments (segments, here, for ease of understanding, it is recommended to use segment as a synonym for tables) have an upper limit to hold data within the segment.

2022-06-01 Database 我要分享

How to view data file blocks and types in MYSQL

This article introduces you how to view data file blocks and types in MYSQL, the content is very detailed, interested friends can refer to, hope to be helpful to you. By studying Master Jiang's INNODB storage engine, we obtained the identification bits of the block format, and saw that there are

2022-05-31 Database 我要分享