search
HomeDatabaseMysql TutorialOracle是如何进行全表扫描实验

从下列实验可以看出全表扫描是根据extent/block顺序去取数据, 第一次实验有

从下列实验可以看出全表扫描是根据extent/block顺序去取数据, 第一次实验有'db file scattered read'等待事件,,第二次实验已经把数据加载到databuffer中,所以没有等待实验。

SQL> create table test as select * from dba_objects;
SQL> select extent_id, file_id, block_id, blocks
  2    from dba_extents
  3  where segment_name = 'TEST'
  4  order by 1;
 EXTENT_ID    FILE_ID  BLOCK_ID    BLOCKS
---------- ---------- ---------- ----------
        0          6      83849          8
        1          6      83857          8
        2          6      83865          8
        3          6      83873          8
        4          6      83881          8
        5          6      83889          8
        6          6      83897          8
        7          6      83905          8
        8          6      83913          8
        9          6      83921          8
        10          6      83929          8
        11          6      83937          8
        12          6      83945          8
        13          6    100409          8
        14          6    100417          8
        15          6    117121          8
        16          6      83977        128
        17          6      84105        128
        18          6      84233        128
        19          6      84361        128
        20          6      84489        128
SQL> show parameter db_file_multiblock_read_count
 
NAME                                TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count        integer    16
 
SQL> alter session set events 'immediate trace name flush_cache level 1';
SQL> alter session set events '10046 trace name context forever,level 12';

第一次实验:
SQL> select count(1) from test;
  COUNT(1)
----------
    51255
 
第一次实验查看10046文件:

ARSING IN CURSOR #5 len=27 dep=0 uid=61 oct=3 lid=61 tim=3414138868 hv=1143379599 ad='302eb520'
select count(1) from test
END OF STMT
PARSE #5:c=46875,e=236549,p=330,cr=59,cu=0,mis=1,r=0,dep=0,og=1,tim=3414138867
BINDS #5:
EXEC #5:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3414139031
WAIT #5: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=95737 tim=3414139067
WAIT #5: nam='SQL*Net message from client' ela= 211 driver id=1413697536 #bytes=1 p3=0 obj#=95737 tim=3414139327
WAIT #5: nam='db file scattered read' ela= 4594 file#=6 block#=83852 blocks=5 obj#=95737 tim=3414143992
WAIT #5: nam='db file scattered read' ela= 424 file#=6 block#=83857blocks=4 obj#=95737 tim=3414144545
WAIT #5: nam='db file scattered read' ela= 161 file#=6 block#=83862 blocks=3 obj#=95737 tim=3414144820
WAIT #5: nam='db file scattered read' ela= 288 file#=6 block#=83866 blocks=7 obj#=95737 tim=3414145211
WAIT #5: nam='db file scattered read' ela= 314 file#=6 block#=83873 blocks=8 obj#=95737 tim=3414145670
WAIT #5: nam='db file scattered read' ela= 404 file#=6 block#=83882 blocks=7 obj#=95737 tim=3414146232
WAIT #5: nam='db file scattered read' ela= 156 file#=6 block#=83889 blocks=3 obj#=95737 tim=3414146536
WAIT #5: nam='db file scattered read' ela= 195 file#=6 block#=83893 blocks=4 obj#=95737 tim=3414146840
WAIT #5: nam='db file scattered read' ela= 280 file#=6 block#=83898 blocks=7 obj#=95737 tim=3414147226
WAIT #5: nam='db file scattered read' ela= 1438 file#=6 block#=83905 blocks=8 obj#=95737 tim=3414148811
WAIT #5: nam='db file scattered read' ela= 340 file#=6 block#=83914 blocks=7 obj#=95737 tim=3414149308
WAIT #5: nam='db file scattered read' ela= 365 file#=6 block#=83921 blocks=8 obj#=95737 tim=3414149813
WAIT #5: nam='db file scattered read' ela= 285 file#=6 block#=83930 blocks=6 obj#=95737 tim=3414150250
WAIT #5: nam='db file scattered read' ela= 128 file#=6 block#=83937 blocks=2 obj#=95737 tim=3414150515
WAIT #5: nam='db file scattered read' ela= 219 file#=6 block#=83940 blocks=5 obj#=95737 tim=3414150826
WAIT #5: nam='db file scattered read' ela= 343 file#=6 block#=83946 blocks=7 obj#=95737 tim=3414151317
WAIT #5: nam='db file scattered read' ela= 382 file#=6 block#=100409 blocks=5 obj#=95737 tim=3414151838
WAIT #5: nam='db file scattered read' ela= 187 file#=6 block#=100415 blocks=2 obj#=95737 tim=3414152147
WAIT #5: nam='db file scattered read' ela= 190 file#=6 block#=100418 blocks=2 obj#=95737 tim=3414152418
WAIT #5: nam='db file scattered read' ela= 249 file#=6 block#=100421 blocks=4 obj#=95737 tim=3414152745

Statement
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
C程序用于找到一个数的最大质因子C程序用于找到一个数的最大质因子Aug 27, 2023 am 10:09 AM

PrimeFactor−Innumbertheory,theprimefactorsofapositiveintegeraretheprimenumbersthatdividethatintegerexactly.Theprocessoffindingthesenumbersiscalledintegerfactorization,orprimefactorization.Example−Primefactorsof288are:288=2x2x2x2x2

全球数字虚拟币交易平台排行榜前十(2025权威排名)全球数字虚拟币交易平台排行榜前十(2025权威排名)Mar 06, 2025 pm 04:36 PM

2025年全球数字虚拟币交易平台竞争激烈,本文根据交易量、安全性、用户体验等指标,权威发布2025年全球十大数字虚拟币交易平台排行榜。OKX凭借强大的技术实力和全球化运营策略居首,Binance以高流动性和低费用紧随其后。Gate.io、Coinbase、Kraken等平台凭借各自优势稳居前列。榜单涵盖Huobi、KuCoin、Bitfinex、Crypto.com和Gemini等交易平台,各有特色,但投资需谨慎。选择平台需考虑安全性、流动性、费用、用户体验、币种选择及监管合规性等因素,理性投资

币圈十大交易所2025年最新 数字货币app排行榜前十币圈十大交易所2025年最新 数字货币app排行榜前十Feb 27, 2025 pm 06:33 PM

虚拟货币十大交易平台排行榜(2025年最新): 币安:全球龙头,高流动性,监管受关注。 OKX:庞大用户基数,支持多种币种,提供杠杆交易。 Gate.io:资深交易所,多种法币支付方式,提供多种交易对和投资产品。 Bitget:衍生品交易所,高流动性,低费用。 火币:老牌交易所,支持多种币种和交易对。 Coinbase:美国知名交易所,受监管严格。 Phemex等等。

十大数字货币交易平台 数字货币交易平台top10榜单最新十大数字货币交易平台 数字货币交易平台top10榜单最新Mar 17, 2025 pm 05:57 PM

十大数字货币交易平台:1. OKX,2. Binance,3. Gate.io,4. Huobi Global,5. Kraken,6. Coinbase,7. KuCoin,8. Bitfinex,9. Crypto.com,10. Gemini,这些交易所各具特色,用户可根据安全性、费用、币种选择、用户界面和客户支持等因素选择适合自己的平台。

数字货币app十大交易平台 炒币正规平台app推荐数字货币app十大交易平台 炒币正规平台app推荐Mar 07, 2025 pm 06:51 PM

本文推荐十个数字货币交易App:1. OKX;2. Binance;3. Gate.io;4. Huobi Global;5. Kraken;6. Coinbase;7. KuCoin;8. Crypto.com;9. Bitfinex;10. Poloniex。选择平台需考虑安全性、流动性、交易费用、币种选择、用户界面、客服支持及法规合规性等因素,谨慎评估风险,切勿盲目跟风。

靠谱的数字货币平台有哪些 十大正规数字货币交易平台2025靠谱的数字货币平台有哪些 十大正规数字货币交易平台2025Mar 17, 2025 pm 05:45 PM

靠谱的数字货币平台包括:1. OKX,2. Binance,3. Gate.io,4. Huobi Global,5. Kraken,6. Coinbase,7. KuCoin,8. Bitfinex,9. Crypto.com,10. Gemini,这些交易所各具特色,用户可根据安全性、费用、币种选择、用户界面和客户支持等因素选择适合自己的平台。

十大数字货币app交易平台 top10虚拟货币app2025排行榜十大数字货币app交易平台 top10虚拟货币app2025排行榜Mar 13, 2025 pm 07:00 PM

十大虚拟币交易平台排名依次为:1. OKX;2. Binance;3. Gate.io;4. Huobi Global;5. Kraken;6. Coinbase;7. KuCoin;8. Crypto.com;9. Bitfinex;10. Gemini。 排名基于平台流动性、币种选择、安全性、用户体验、手续费及合规性等因素综合考量,但仅供参考,投资需谨慎,风险自担。

十大数字货币交易app排行榜top10推荐十大数字货币交易app排行榜top10推荐Feb 17, 2025 pm 03:18 PM

随着数字货币市场的繁荣,本文列出了十大数字货币交易 App 排行榜,以帮助投资者选择可靠且易用的平台。排行榜包括币安、Coinbase、Gemini、Kraken、FTX、Huobi、OKX、Bitfinex、Crypto.com 和 Gate.io。这些 App 提供了广泛的交易对、安全可靠的平台、低交易费用和高流动性等优势。投资者应根据安全、用户友好性、交易费用、流动性、支持的币种和客户服务等因素,选择最符合他们需求的 App。

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment