简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

用Delete与Truncate清除表数据对高水位的影响

WBOY
Release： 2016-06-07 16:44:30
Original
1384 people have browsed it

众所周知，Oracle段都有一个在段内容纳数据块的上限，我们把这个上限称为High Water Mark（HWM）。这个HWM是一个标记，用来说明

从block_id字段的值可以发现，当在表中插入数据后，分配给表的block从128开始一直到1152，并且，开始的1-16个extent会以8个块（8*8=64K）为分配单位，而到了第17个extent之后，，则以128个块（8*128=1M）为分配单位，目前ZLM1表共分配了24个extent

Related labels：
truncate
source：php.cn
Previous article：Oracle执行SQL查询语句的步骤 Next article：MySQL版本升级实录
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
TailwindCSS's truncated classes are not used - causing a lot of horizontal scrolling I'm having trouble using the Tailwindstruncate class: https://tailwindcss.com/docs/text-ov...
From 2024-03-30 18:26:21
0
1
297
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！