пропозиції роботи
Kamil
Stawiarski
Oracle Certified
Master | Oracle ACE
Temat: Wirtualna Exadata!
Czołem Ludziska!Może zainteresuje Was taka mała ciekawostka, że na podstawie tego artykułu:
http://www.dbaleet.org/how_to_build_an_exadata_simulat...
Da się zbudować wirtualną Exadatę, do zabawy z narzędziami :)
Mnie się udało stworzyć 3 cele storage'owe (po 12 dysków każda) i dwa nod'y RAC'a zapięte w toto - czyli prawie że ćwiarteczka :)
[celladmin@cell1 ~]$ dcli -c cell1,cell2,cell3 cellcli -e list cell detail
cell1: name: cell1
cell1: bbuTempThreshold: 60
cell1: bbuChargeThreshold: 800
cell1: bmcType: absent
cell1: cellVersion: OSS_11.2.3.2.1_LINUX.X64_130109
cell1: cpuCount: 1
cell1: diagHistoryDays: 7
cell1: fanCount: 1/1
cell1: fanStatus: normal
cell1: flashCacheMode: WriteThrough
cell1: id: 7c3c8287-2ee3-471d-bac3-ce01c68a0f78
cell1: interconnectCount: 3
cell1: interconnect1: eth1
cell1: iormBoost: 0.0
cell1: ipaddress1: 10.0.0.1/24
cell1: kernelVersion: 2.6.18-308.el5
cell1: makeModel: Fake hardware
cell1: metricHistoryDays: 7
cell1: offloadEfficiency: 668.0
cell1: powerCount: 1/1
cell1: powerStatus: normal
cell1: releaseVersion: 11.2.3.2.1
cell1: releaseTrackingBug: 14522699
cell1: status: online
cell1: temperatureReading: 0.0
cell1: temperatureStatus: normal
cell1: upTime: 0 days, 1:37
cell1: cellsrvStatus: running
cell1: msStatus: running
cell1: rsStatus: running
cell2: name: cell2
cell2: bbuTempThreshold: 60
cell2: bbuChargeThreshold: 800
cell2: bmcType: absent
cell2: cellVersion: OSS_11.2.3.2.1_LINUX.X64_130109
cell2: cpuCount: 1
cell2: diagHistoryDays: 7
cell2: fanCount: 1/1
cell2: fanStatus: normal
cell2: flashCacheMode: WriteThrough
cell2: id: f3b5354b-26a3-4e45-b5ec-a9d0312ce384
cell2: interconnectCount: 3
cell2: interconnect1: eth1
cell2: iormBoost: 0.0
cell2: ipaddress1: 10.0.0.2/24
cell2: kernelVersion: 2.6.18-308.el5
cell2: makeModel: Fake hardware
cell2: metricHistoryDays: 7
cell2: offloadEfficiency: 669.5
cell2: powerCount: 1/1
cell2: powerStatus: normal
cell2: releaseVersion: 11.2.3.2.1
cell2: releaseTrackingBug: 14522699
cell2: status: online
cell2: temperatureReading: 0.0
cell2: temperatureStatus: normal
cell2: upTime: 0 days, 1:37
cell2: cellsrvStatus: running
cell2: msStatus: running
cell2: rsStatus: running
cell3: name: cell3
cell3: bbuTempThreshold: 60
cell3: bbuChargeThreshold: 800
cell3: bmcType: absent
cell3: cellVersion: OSS_11.2.3.2.1_LINUX.X64_130109
cell3: cpuCount: 1
cell3: diagHistoryDays: 7
cell3: fanCount: 1/1
cell3: fanStatus: normal
cell3: flashCacheMode: WriteThrough
cell3: id: 3bc83ca9-ca25-4127-b231-9097d7000807
cell3: interconnectCount: 3
cell3: interconnect1: eth1
cell3: iormBoost: 0.0
cell3: ipaddress1: 10.0.0.3/24
cell3: kernelVersion: 2.6.18-308.el5
cell3: makeModel: Fake hardware
cell3: metricHistoryDays: 7
cell3: offloadEfficiency: 723.2
cell3: powerCount: 1/1
cell3: powerStatus: normal
cell3: releaseVersion: 11.2.3.2.1
cell3: releaseTrackingBug: 14522699
cell3: status: online
cell3: temperatureReading: 0.0
cell3: temperatureStatus: normal
cell3: upTime: 0 days, 1:37
cell3: cellsrvStatus: running
cell3: msStatus: running
cell3: rsStatus: running
Dyski ładnie widoczne
SQL> ;
1 select failgroup, path
2* from v$asm_disk
SQL> /
FAILGROUP PATH
------------------------------ ----------------------------------------
CELL1 o/10.0.0.1/archive_CD_disk8_cell1
CELL1 o/10.0.0.1/data_CD_disk3_cell1
CELL1 o/10.0.0.1/data_CD_disk6_cell1
CELL1 o/10.0.0.1/data_CD_disk9_cell1
CELL1 o/10.0.0.1/archive_CD_disk6_cell1
CELL1 o/10.0.0.1/archive_CD_disk5_cell1
CELL1 o/10.0.0.1/data_CD_disk4_cell1
CELL1 o/10.0.0.1/archive_CD_disk11_cell1
CELL3 o/10.0.0.3/data_CD_disk8_cell3
CELL3 o/10.0.0.3/data_CD_disk9_cell3
CELL3 o/10.0.0.3/data_CD_disk12_cell3
FAILGROUP PATH
------------------------------ ----------------------------------------
CELL3 o/10.0.0.3/archive_CD_disk8_cell3
CELL3 o/10.0.0.3/data_CD_disk7_cell3
CELL3 o/10.0.0.3/data_CD_disk5_cell3
CELL3 o/10.0.0.3/archive_CD_disk10_cell3
CELL3 o/10.0.0.3/data_CD_disk4_cell3
CELL3 o/10.0.0.3/data_CD_disk11_cell3
CELL3 o/10.0.0.3/data_CD_disk6_cell3
CELL3 o/10.0.0.3/archive_CD_disk1_cell3
CELL3 o/10.0.0.3/data_CD_disk10_cell3
CELL3 o/10.0.0.3/archive_CD_disk12_cell3
CELL3 o/10.0.0.3/archive_CD_disk4_cell3
FAILGROUP PATH
------------------------------ ----------------------------------------
CELL3 o/10.0.0.3/data_CD_disk2_cell3
CELL3 o/10.0.0.3/archive_CD_disk7_cell3
CELL3 o/10.0.0.3/archive_CD_disk2_cell3
CELL3 o/10.0.0.3/data_CD_disk3_cell3
CELL3 o/10.0.0.3/data_CD_disk1_cell3
CELL3 o/10.0.0.3/archive_CD_disk5_cell3
CELL3 o/10.0.0.3/archive_CD_disk3_cell3
CELL3 o/10.0.0.3/archive_CD_disk9_cell3
CELL3 o/10.0.0.3/archive_CD_disk6_cell3
CELL3 o/10.0.0.3/archive_CD_disk11_cell3
CELL2 o/10.0.0.2/data_CD_disk4_cell2
FAILGROUP PATH
------------------------------ ----------------------------------------
CELL2 o/10.0.0.2/data_CD_disk6_cell2
CELL2 o/10.0.0.2/archive_CD_disk5_cell2
CELL2 o/10.0.0.2/archive_CD_disk1_cell2
CELL2 o/10.0.0.2/data_CD_disk2_cell2
(.....)
Diskmon działa :)
[oracle@rac2 ~]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE rac2 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE rac2
ora.crf
1 ONLINE ONLINE rac2
ora.crsd
1 ONLINE ONLINE rac2
ora.cssd
1 ONLINE ONLINE rac2
ora.cssdmonitor
1 ONLINE ONLINE rac2
ora.ctssd
1 ONLINE ONLINE rac2 OBSERVER
ora.diskmon
1 ONLINE ONLINE rac2
ora.evmd
1 ONLINE ONLINE rac2
ora.gipcd
1 ONLINE ONLINE rac2
ora.gpnpd
1 ONLINE ONLINE rac2
ora.mdnsd
1 ONLINE ONLINE rac2
I nawet full table scan'y symulują offload'a :)
SQL_ID a8khyspaz7x2d, child number 1
-------------------------------------
select count(*) from sales2 where amount_sold<=1000
Plan hash value: 2862189843
-------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 1240 (100)| |
| 1 | SORT AGGREGATE | | 1 | 5 | | |
|* 2 | TABLE ACCESS STORAGE FULL| SALES2 | 514K| 2510K| 1240 (2)| 00:00:15 |
-------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - storage("AMOUNT_SOLD"<=1000)
filter("AMOUNT_SOLD"<=1000)
cell smart table scan 339 126
cell smart file creation 40 284
No to bawcie się dobrze!
Pozdro!
Kamil.
