oracle 物理读突然增加的原因_为什么物理读的居高不下?

SQL> startup

ORACLE instance started.

Total System Global Area  534462464 bytes

Fixed Size                  2215064 bytes

Variable Size             289407848 bytes

Database Buffers          234881024 bytes

Redo Buffers                7958528 bytes

Database mounted.

Database opened.

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL> select segment_name,bytes/1024/1024 from dba_segments where segment_name='AA_1';

SEGMENT_NAME

--------------------------------------------------------------------------------

BYTES/1024/1024

---------------

AA_1

72

SQL> set autot on

SQL> select count(*) from aa_1;

COUNT(*)

----------

582496

Execution Plan

-------------------------------------------------------