Oracle数据库实验笔记(5)

PL/SQL 过程已成功完成。

SQL> select sql_redo from v$logmnr_contents where lower(sql_redo) like '%update%' and seg_name='EMP';

SQL_REDO

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

update \EAAAAAgAAA';

update \AEAAAAAgAAB';

update \AEAAAAAgAAC';

update \AEAAAAAgAAD';

SQL_REDO

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

update \AEAAAAAgAAE';

update \AEAAAAAgAAF';

update \AEAAAAAgAAG';

update \

SQL_REDO

-------------------------------------------------------------------------------- AEAAAAAgAAH';

update \AEAAAAAgAAI';

update \AEAAAAAgAAJ';

update \AEAAAAAgAAK';

SQL_REDO

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

update \EAAAAAgAAL';

update \AEAAAAAgAAM';

update \AEAAAAAgAAN';

已选择14行。

SQL> select sql_undo from v$logmnr_contents where lower(sql_redo) like '%update%' and seg_name='EMP';

SQL_UNDO

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

update \EAAAAAgAAA';

update \AEAAAAAgAAB';

update \AEAAAAAgAAC';

update \AEAAAAAgAAD';

SQL_UNDO

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

update \AEAAAAAgAAE';

update \AEAAAAAgAAF';

update \AEAAAAAgAAG';

update \

SQL_UNDO

-------------------------------------------------------------------------------- AEAAAAAgAAH';

update \AEAAAAAgAAI';

update \AEAAAAAgAAJ';

update \AEAAAAAgAAK';

SQL_UNDO

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

update \EAAAAAgAAL';

update \AEAAAAAgAAM';

update \AEAAAAAgAAN';

已选择14行。 SQL>

SGA

SQL> show parameter sga

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 276M sga_target big integer 200M

SQL> alter system set sga_target=300M; alter system set sga_target=300M *

第 1 行出现错误:

ORA-02097: 无法修改参数, 因为指定的值无效 ORA-00823: 指定的 sga_target 的值大于 sga_max_size

SQL> alter system set sga_max_size=200M; alter system set sga_max_size=200M * 第 1 行出现错误:

ORA-02095: 无法修改指定的初始化参数

SQL> alter system set sga_max_size=200M scope=spfile;

系统已更改。

SQL> startup force ORACLE 例程已经启动。

Total System Global Area 230686720 bytes Fixed Size 1248236 bytes Variable Size 75498516 bytes Database Buffers 146800640 bytes Redo Buffers 7139328 bytes 数据库装载完毕。 数据库已经打开。 SQL> show parameter sga

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 220M sga_target big integer 220M SQL> alter system set sga_target=250M; alter system set sga_target=250M *

第 1 行出现错误:

ORA-02097: 无法修改参数, 因为指定的值无效 ORA-00823: 指定的 sga_target 的值大于 sga_max_size

SQL> alter system set sga_max_size=200M scope=spfile;

系统已更改。

SQL> startup force ORACLE 例程已经启动。

Total System Global Area 230686720 bytes Fixed Size 1248236 bytes Variable Size 75498516 bytes Database Buffers 146800640 bytes Redo Buffers 7139328 bytes 数据库装载完毕。 数据库已经打开。 SQL> show parameter sga

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 220M sga_target big integer 220M SQL> alter system set sga_max_size=300M scope=spfile;

系统已更改。

SQL> startup force ORACLE 例程已经启动。

Total System Global Area 314572800 bytes Fixed Size 1248768 bytes Variable Size 159384064 bytes Database Buffers 146800640 bytes Redo Buffers 7139328 bytes 数据库装载完毕。 数据库已经打开。 SQL> show parameter sga

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M