整理一篇关于11g smart flash cache 的文章,vmcd

我们来做一下演示 采用FusionIO SLC 160G

[oracle@db-41 ~]$ ls -l /dev/fioa 
brw-r----- 1 oracle oinstall 252, 0 Jul 17 14:26 /dev/fioa


[root@db-41 dev]# fio-status

Found 1 ioDrive in this system
Fusion-io driver version: 2.3.1 build 123

Adapter: ioDrive
	Fusion-io ioDrive 160GB, Product Number:VRG5T SN:479912
	External Power: NOT connected
	PCIE Power limit threshold: 24.75W
	Sufficient power available: Unknown
	Connected ioDimm module:
	  fct0:	Fusion-io ioDrive 160GB, Product Number:VRG5T SN:479912

fct0	Attached as 'fioa' (block device)
	Fusion-io ioDrive 160GB, Product Number:VRG5T SN:479912
	Located in slot 0 Upper of ioDrive SN:479912
	PCI:08:00.0, Slot Number:1
	Firmware v5.0.6, rev 101583
	160.00 GBytes block device size, 203 GBytes physical device size
	Sufficient power available: Unknown
	Internal temperature: 43.3 degC, max 44.8 degC
	Media status: Healthy; Reserves: 100.00%, warn at 10.00%
	


SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 30 11:13:32 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter sga;

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

SQL> alter system set db_flash_cache_size=150G scope=spfile;

System altered.

SQL> alter system set db_flash_cache_file='/dev/fioa' scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 7.1085E+10 bytes
Fixed Size		    2235608 bytes
Variable Size		 8053064488 bytes
Database Buffers	 6.2814E+10 bytes
Redo Buffers		  215855104 bytes
Database mounted.
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel


SQL> startup
ORACLE instance started.

Total System Global Area 7.1085E+10 bytes
Fixed Size		    2235608 bytes
Variable Size		 8053064488 bytes
Database Buffers	 6.2814E+10 bytes
Redo Buffers		  215855104 bytes
Database mounted.
Database opened.
SQL> show parameter flash_cache

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file		     string	 /dev/fioa
db_flash_cache_size		     big integer 149G
SQL> alter system set  db_flash_cache_size=150G scope=spfilel
  2  

SQL> alter system set  db_flash_cache_size=150G scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 7.1085E+10 bytes
Fixed Size		    2235608 bytes
Variable Size		 8053064488 bytes
Database Buffers	 6.2814E+10 bytes
Redo Buffers		  215855104 bytes
Database mounted.
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel


ORA-27042: not enough space on raw partition to fullfill request
Additional information: 3


modify db_flash_cache_size to 149G


SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 30 11:04:10 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 7.1085E+10 bytes
Fixed Size		    2235608 bytes
Variable Size		 8053064488 bytes
Database Buffers	 6.2814E+10 bytes
Redo Buffers		  215855104 bytes
Database mounted.
Database opened.
SQL> show parameter flash_cache

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file		     string	 /dev/fioa
db_flash_cache_size		     big integer 149G

SQL> select 149/68 from dual;

    149/68
----------
2.19117647