{"id":2512,"date":"2018-01-28T22:14:18","date_gmt":"2018-01-28T13:14:18","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2512"},"modified":"2018-01-28T22:15:43","modified_gmt":"2018-01-28T13:15:43","slug":"exadata-cell_offlload_processing","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2512","title":{"rendered":"[EXADATA] Cell_Offlload_Processing"},"content":{"rendered":"

 <\/p>\n

 <\/p>\n

cell offload processing \uc5d0 \ub300\ud55c \uc774\ud574\uc640 \uac80\uc99d\uc744 \uc704\ud574\uc11c \uc544\ub798\uc758 \uc2dc\ub098\ub9ac\uc624\uc744 \uc2e4\uc2b5\ud569\ub2c8\ub2e4.<\/p>\n

\uc774\ubc88 \uc2e4\uc2b5\uc740 \ub09c\uc774\ub3c4\uac00 \ub192\uc740 \uc2e4\uc2b5 \uc785\ub2c8\ub2e4.<\/p>\n

\u00b7 Demonstrate Smart File creation for Creating Tablespaces<\/p>\n

\u00b7 Demonstrate Smart Scan processing for Table Scans<\/p>\n

\u00b7 Demonstrate Smart Scans in Index Fast Full Scan<\/p>\n

\u00b7 Demonstrate Smart Scans in Bitmap Index Scan<\/p>\n

\u00b7 Demonstrate Exadata Cell failure<\/p>\n

\u00b7 Shutdown the Lab Environment<\/p>\n

Tablespaces <\/u><\/i><\/b>\uc0dd\uc131\uc744<\/u><\/i><\/b> <\/u><\/i><\/b>\ud1b5\ud574<\/u><\/i><\/b> <\/u><\/i><\/b>Smart File creation <\/u><\/i><\/b>\uac80\uc99d<\/u><\/i><\/b><\/u><\/i><\/b><\/p>\n

Exadata \uc758 \uc8fc\uc694 \ud2b9\uc7a5\uc810\uc778 Smart File creation\uc740 file \uc0dd\uc131\uc744 cell offloading \uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654 \ud569\ub2c8\ub2e4. \uc544\ub798\uc758 \uc2e4\uc2b5\uc744 \ud1b5\ud574\uc11c \uadf8 \ub0b4\uc6a9\uc744 \uc774\ud574\ud558\uace0 \uac80\uc99d\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.\uc544\ub798\uc758 \uc2e4\uc2b5\uc740 lab_user <\/b>DB \uc0ac\uc6a9\uc790 \uacc4\uc815\uc73c\ub85c \uc9c4\ud589 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
1.<\/td>\nv$sysstat<\/b> <\/b>\ubdf0 \ud14c\uc774\ube14\uc744 \ud1b5\ud574 \ud604\uc7ac <\/b>cell physical io bytes saved during smart file creation<\/b> <\/b>\uac12\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ud1b5\uacc4 \uc815\ubcf4\ub294 Smart File creation \uc744 \uc0ac\uc6a9\ud558\ub294 \ub3d9\uc548 \ubc1c\uc0dd\ud55c IO bytes \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n\n
SQL> <\/b>select name, value from v$sysstat where name = ‘cell physical IO bytes saved during optimized file creation’;<\/b><\/p>\n

 <\/p>\n

NAME VALUE<\/b><\/p>\n

—————————————————————- ———-<\/b><\/p>\n

cell physical IO bytes saved during optimized file creation <\/b> <\/b>0<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

2.<\/td>\ncell_offload_processing <\/b>\ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc744 TRUE <\/b>\ub85c \uc124\uc815\ud55c \uc774\ud6c4 <\/b>tablespace \uc0dd\uc131 \uba85\ub839\uc5b4\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4. cell_offload_processing<\/b> <\/b>\ud30c\ub77c\ubbf8\ud130\ub294 smart processing <\/b>\uc744 \uc704\ud574\uc11c Exadata <\/b>\uc5d0\uc11c \uace0\ub824 \ub418\uc5b4\uc57c \ud558\ub294 \ud30c\ub77c\ubbf8\ud130 \uc785\ub2c8\ub2e4. tablsepace \uc0dd\uc131 \uc774\ud6c4 cell physical io bytes <\/b>\uc758 \ubcc0\uacbd\ub41c \uac12\uc744 \ud655\uc778 \ud569\ub2c8\ub2e4. \ubcc0\uacbd\ub41c \uac12\uc744 \ube44\uad50\ud558\uba74, Exadata Cell \uc758 offloading \uc744 \ud1b5\ud574\uc11c \uc5bb\uc744 \uc218 \uc788\ub294 \uc774\uc810 \ub4f1\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n\n
SQL> <\/b>alter session set cell_offload_processing = TRUE;<\/b><\/p>\n

 <\/p>\n

Session altered.<\/b><\/p>\n

 <\/p>\n

SQL> <\/b>create tablespace smart_file_tbs datafile ‘+DATA’ size 100M;<\/b><\/b><\/p>\n

 <\/p>\n

Tablespace created.<\/b><\/p>\n

 <\/p>\n

SQL> <\/b>select name, value from v$sysstat where name = ‘cell physical IO bytes saved during optimized file creation’;<\/b><\/b><\/p>\n

 <\/p>\n

NAME VALUE<\/b><\/p>\n

—————————————————————- ———-<\/b><\/p>\n

cell physical IO bytes saved during optimized file creation 838860800<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

3.<\/td>\n\uc774\ubc88\uc5d0\ub294 <\/a><\/a>cell_offload_processing<\/b> \ud30c\ub77c\ubbf8\ud130\uc744 turn-off \ub85c \ubcc0\uacbd\ud558\uace0, \u201c_cell_fast_file_create\u201d<\/b> \ud30c\ub77c\ubbf8\ud130\uc744 FALSE\ub85c \uc124\uc815\ud55c \uc774\ud6c4 tablespace \uc0ad\uc81c \ud6c4 \uc0dd\uc131 \uba85\ub839\uc744 \ub2e4\uc2dc \uc218\ud589\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 smart file <\/b>\uc0dd\uc131 \ud6c4 <\/b>cell physical <\/b>IO<\/b> bytes <\/b>\uac12\uc744 \ud655\uc778\ud558\uc5ec \uc704\uc758 \uacb0\uacfc\uac12\uacfc \ube44\uad50\ud569\ub2c8\ub2e4. \uc774\uac83\uc744 \ud1b5\ud574 <\/b>cell_offload_processing<\/b> <\/b>\ud30c\ub77c\ubbf8\ud130\uc744 turn-off \uc2dc\ud0a4\uba74 smart file creation \uc758 \uc774\uc810\uc774 \uc804\ud600 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/b><\/p>\n\n\n\n
SQL> <\/b>alter session set “_cell_fast_file_create” = FALSE;<\/b><\/p>\n

 <\/p>\n

Session altered.<\/b><\/p>\n

 <\/p>\n

SQL> <\/b>drop tablespace smart_file_tbs including contents;<\/b><\/b><\/p>\n

 <\/p>\n

Tablespace dropped.<\/b><\/p>\n

 <\/p>\n

SQL> <\/b>create tablespace smart_file_tbs datafile ‘+DATA’ size 100M;<\/b><\/p>\n

 <\/p>\n

Tablespace created.<\/b><\/p>\n

 <\/p>\n

SQL> <\/b>select name, value from v$sysstat where name = ‘cell physical IO bytes saved during optimized file creation’;<\/b><\/b><\/p>\n

 <\/p>\n

NAME VALUE<\/b><\/p>\n

—————————————————————- ———-<\/b><\/p>\n

cell physical IO bytes saved during optimized file creation 838860800<\/b><\/p>\n

 <\/p>\n

SQL> <\/b>drop tablespace smart_file_tbs;<\/b><\/b><\/p>\n

 <\/p>\n

Tablespace dropped.<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\ud6a8\uc728\uc801\uc778<\/u><\/i><\/b> <\/u><\/i><\/b>Table Scans <\/u><\/i><\/b>\uc704\ud55c<\/u><\/i><\/b> <\/u><\/i><\/b>Smart Scan Processing <\/u><\/i><\/b> <\/u><\/i><\/b>\uac80\uc99d<\/u><\/i><\/b> <\/u><\/i><\/b><\/u><\/i><\/b><\/p>\n

 <\/p>\n

v$sql \ubdf0\ud14c\uc774\ube14\uc744 \ud1b5\ud574\uc11c \uc544\ub798\uc758 \ud1b5\uacc4 \uc815\ubcf4\uc744 \ud655\uc778 \ud569\ub2c8\ub2e4.<\/h6>\n
    \n
  • IO_INTERCONNECT_BYTES:<\/b> query \uc744 \uc704\ud574 \ud1b5\uc2e0\ud55c IO \uac12\uc5d0 \ub300\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4. \uc774 \uac12\uc744 \ud1b5\ud574\uc11c block IO \uc640 smart IO \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4 .<\/li>\n
  • IO_DISK_BYTES:<\/b> query\uc744 \uc704\ud574 cell \uc758 IO \uc131\ub2a5\uc5d0 \ub300\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4. \uc774 \uac12\uc744 \ud1b5\ud574\uc11c cell IO \uc131\ub2a5\uc5d0 \ub300\ud55c block IO \uc640 smart IO \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4 .<\/li>\n
  • IO_CELL_OFFLOAD_ELIGIBLE_BYTES:<\/b> query\uc744 \uc704\ud574 cell\uc758 smart scan \uc744 \uc704\ud574 offload \ub41c IO \uac12\uc5d0 \ub300\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4. Cell Offload Processiong \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc744 \uc54c \uc218 \uc788\ub294 \uc544\uc8fc \uc911\uc694\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n
    $sysstat \ubdf0\ud14c\uc774\ube14\uc744 \ud1b5\ud574\uc11c \uc544\ub798\uc758 \ud1b5\uacc4 \uc815\ubcf4\uc744 \ud655\uc778 \ud569\ub2c8\ub2e4.<\/h6>\n
      \n
    • cell physical IO interconnect bytes:<\/b> \uc778\uc2a4\ud134\uc2a4 \uc11c\ube44\uc2a4 \uc774\ud6c4\ubd80\ud130 \ubaa8\ub4e0 Cell \ub85c\ubd80\ud130 \uc11c\ube44\uc2a4\ub41c IO\uc758 \ud1b5\uacc4 \uc9c0\ud45c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774 \uc774 \uac12\uc744 \ud1b5\ud574\uc11c block IO \uc640 smart IO \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4 .<\/li>\n<\/ul>\n
        \n
      • physical IO disk bytes:<\/b> \uc778\uc2a4\ud134\uc2a4 \uc11c\ube44\uc2a4 \uc774\ud6c4 cell \uc758 IO \uc131\ub2a5\uc5d0 \ub300\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4. \uc774 \uac12\uc744 \ud1b5\ud574\uc11c cell IO \uc131\ub2a5\uc5d0 \ub300\ud55c block IO \uc640 smart IO \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4 .<\/li>\n<\/ul>\n
          \n
        • cell physical IO bytes eligible for predicate offload:<\/b> \uc778\uc2a4\ud134\uc2a4 \uc11c\ube44\uc2a4 \uc774\ud6c4 \uc704\ud574 cell\uc758 smart scan \uc744 \uc704\ud574 offload \ub41c IO \uac12\uc5d0 \ub300\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4. Cell Offload Processiong \uc5d0 \ub300\ud55c \ud1b5\uacc4\uc744 \uc54c \uc218 \uc788\ub294 \uc544\uc8fc \uc911\uc694\ud55c \uc9c0\ud45c \uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n

           <\/p>\n

          lab_user <\/b>\ub85c \uc811\uc18d\ud574\uc11c \uc544\ub798\uc758 \ub2e8\uacc4\uc744 \uc21c\ucc28\uc801\uc73c\ub85c \uc218\ud589 \ud569\ub2c8\ub2e4.<\/p>\n

           <\/p>\n\n\n\n
          1.<\/td>\n\uc774\ubc88 \ub2e8\uacc4\uc5d0\uc11c\ub294 \uba87\uac00\uc9c0 Query \uc744 \uc218\ud589\ud568\uc744 \ud1b5\ud574\uc11c lab_table \uc5d0 block I\/O \uc744 \uc0dd\uc131 \uc2dc\ud0b5\ub2c8\ub2e4. I\/O \uc744 \ubc1c\uc0dd\ud558\ub294 Query\uc758 \uc870\uac74\uc744 \uac04\uc81c\uc801\uc73c\ub85c \uc815\uc758\ud558\uae30 \uc704\ud574\uc11c \uc544\ub798\uc758 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \ubcc0\uacbd \ud569\ub2c8\ub2e4. \ud30c\ub77c\ubbf8\ud130 offload_processing<\/b> \uac12\uc744 FALSE <\/b>\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4. offload processing \uc744 \uc0ac\uc6a9\ud558\uc9c0 \ubabb\ud558\ub3c4\ub85d \ubcc0\uacbd\ud588\uae30 \ub54c\ubb38\uc5d0 Exadata cell \uc5d0\uc11c predicate filtering \uc774 \uc218\ud589\ub418\uc9c0 \ubabb\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

          count(*)<\/b> query \uc744 \uc218\ud589\ud574\uc11c Exadata cell \uc758 I\/O \uc0ac\uc6a9 \ud1b5\uacc4\uc5d0 \ub300\ud55c \uac12\uc744 \ud655\uc778 \ud569\ub2c8\ub2e4. \ud1b5\uacc4 \uc815\ubcf4\uc758 \uac12\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c v$sql_text<\/b> \ubdf0\ud14c\uc774\ube14\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          SQL> <\/b>show parameter cell;<\/b><\/b><\/p>\n

           <\/p>\n

          NAME TYPE VALUE<\/b><\/p>\n

          ———————————— ———– ——————————<\/b><\/p>\n

          _cell_fast_file_create boolean FALSE<\/b><\/p>\n

          cell_offload_compaction string ADAPTIVE<\/b><\/p>\n

          cell_offload_parameters string<\/b><\/p>\n

          cell_offload_plan_display string AUTO<\/b><\/p>\n

          cell_offload_processing boolean TRUE<\/b><\/p>\n

          cell_partition_large_extents string DEFAULT<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>alter session set cell_offload_processing = FALSE;<\/b><\/p>\n

           <\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select count(*) from lab_table where object_id>-10;<\/b><\/p>\n

           <\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select sql_text, sql_id, io_cell_offload_eligible_bytes, io_interconnect_bytes, io_disk_bytes from v$sql where sql_text like ‘select count(*) from lab_table where object_id>-10’;<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          SQL_TEXT<\/b><\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          SQL_ID IO_CELL_OFFLOAD_ELIGIBLE_BYTES IO_INTERCONNECT_BYTES IO_DISK_BYTES<\/b><\/p>\n

          ————- —————————— ——————— ————-<\/b><\/p>\n

          select count(*) from lab_table where object_id>-10<\/b><\/p>\n

          cjgs05a0400y5 0 128065536 128065536<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          io_cell_offload_eligible_bytes<\/b> \uac12\uc774 0 \uc778 \uac83\uc744 \ud655\uc778 \ud568\uc73c\ub85c\uc368, \uc704 SQL\uc744 \ud1b5\ud574\uc11c block IO\uac00<\/p>\n

          Exadata Cell \uc5d0\uc11c predicate filtering \uc5c6\uc774 \uc218\ud589 \ub418\uc5b4\uc84c\ub2e4\ub294 \uac83\uc744 \uc774\ud574 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n

          2.<\/td>\n\uc774\ubc88 \ub2e8\uacc4\uc5d0\uc11c\ub294 \uba87\uac00\uc9c0 Query \uc744 \uc218\ud589\ud568\uc73c\ub85c lab_table \uc5d0\uc11c predicate I\/Os ( \ub610\ub294 Smart I\/Os) \uac00 \ubc1c\uc0dd\ud558\ub3c4\ub85d \ud655\uc778 \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc774\uc744 \uc704\ud574\uc11c \ud30c\ub77c\ubbf8\ud130 cell_offload_processing<\/b> <\/i> <\/i><\/b>\uac12\uc744 TRUE<\/b> \ub85c \uc870\uc815\ud574\uc11c \uc9c4\ud589 \ud569\ub2c8\ub2e4. \uc774 \ud30c\ub77c\ubbf8\ud130 \uac12\uc774 TRUE \ud558 \ud560\uc9c0\ub77c\ub3c4, \ubaa8\ub4e0 Query \uac00 predicate I\/Os ( \ub610\ub294 Smart I\/Os) \uc744 \ud558\uac8c \ub418\ub294 \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4.<\/p>\n

          \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0 \uc9c1\uc811 Exadata Cell \uc744 \uc77d\uc5b4\uc11c \uac15\uc81c\uc801\uc73c\ub85c \ubb34\uc870\uac74 predicate I\/Os ( \ub610\ub294 Smart I\/Os) \uc744 \uc218\ud589\ud558\ub3c4\ub85d \uba87\uac00\uc9c0 \ud30c\ub77c\ubbf8\ud130\uc744 \ucd94\uac00\uc801\uc73c\ub85c \ubcc0\uacbd \ud574\uc57c\ud569\ub2c8\ub2e4. \uc989 \ubcd1\ub82c Query\uac00 \uc218\ud589\ub418\uc9c0 \uc54a\uc544\uc11c \uc9c1\uc811 Exadata Cell \uc744 \uc77d\uc9c0 \uc54a\uc744\ub54c\uc5d0\ub3c4 \uac15\uc81c\uc801\uc73c\ub85c Exadata Cell \uc744 \uc77d\ub3c4\ub85d \ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c \ud30c\ub77c\ubbf8\ud130 \u201c_serial_direct_read\u201d<\/b> \uac12\uc744 TRUE \ub85c \ubcc0\uacbd \ud569\ub2c8\ub2e4.\uc704 \uc870\uac74\uc5d0\uc11c\ub294 \ubcd1\ub82c Query \uac00 \uc218\ud589\ub418\uc9c0 \uc54a\uc744 \ub54c\uc5d0\ub3c4 buffer cache \uc744 \uac70\uc9c0\uce58 \uc54a\uace0 Exadata Cell \uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\uc744 \uc77d\uc5b4 \uc624\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

          \uc544\ub798 SQL \uc758 \uc2e4\ud589\uacc4\ud68d\uc744 \ud1b5\ud574\uc11c \uc704\uc758 \uc608\uc0c1 \uacb0\uacfc\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 Predicate clause \ubd80\ubd84\uc740 Exadata Cell Offload Processing \uc5d0 \ub300\ud55c \uc2e4\ud589\uacc4\ud68d \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
          SQL> <\/b>alter session set cell_offload_processing=TRUE;<\/b><\/b><\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>alter session set “_serial_direct_read”=TRUE;<\/b><\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>set autotrace on<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select count(*) from lab_table where object_id>-9;<\/b><\/p>\n

           <\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          Execution Plan<\/b><\/p>\n

          ———————————————————-<\/b><\/p>\n

          Plan hash value: 2189604569<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          ——–<\/b><\/p>\n

           <\/p>\n

          | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Ti<\/b><\/p>\n

          me |<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          ——–<\/b><\/p>\n

           <\/p>\n

          | 0 | SELECT STATEMENT | | 1 | 13 | 5815 (1)| 00<\/b><\/p>\n

          :01:10 |<\/b><\/p>\n

           <\/p>\n

          | 1 | SORT AGGREGATE | | 1 | 13 | |<\/b><\/p>\n

          |<\/b><\/p>\n

           <\/p>\n

          |* 2 | TABLE ACCESS STORAGE FULL| LAB_TABLE | 1347K| 16M| 5815 (1)| 00<\/b><\/p>\n

          :01:10 |<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          ——–<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Predicate Information (identified by operation id):<\/b><\/p>\n

          —————————————————<\/b><\/p>\n

           <\/p>\n

          2 – storage(“OBJECT_ID”>(-9))<\/b><\/p>\n

          filter(“OBJECT_ID”>(-9))<\/b><\/p>\n

           <\/p>\n

          Note<\/b><\/p>\n

          —–<\/b><\/p>\n

          – dynamic sampling used for this statement<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Statistics<\/b><\/p>\n

          ———————————————————-<\/b><\/p>\n

          298 recursive calls<\/b><\/p>\n

          0 db block gets<\/b><\/p>\n

          21424 consistent gets<\/b><\/p>\n

          21325 physical reads<\/b><\/p>\n

          0 redo size<\/b><\/p>\n

          421 bytes sent via SQL*Net to client<\/b><\/p>\n

          420 bytes received via SQL*Net from client<\/b><\/p>\n

          2 SQL*Net roundtrips to\/from client<\/b><\/p>\n

          5 sorts (memory)<\/b><\/p>\n

          0 sorts (disk)<\/b><\/p>\n

          1 rows processed<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>set autotrace off<\/b><\/p>\n

          SQL> <\/b>select sql_text, sql_id, io_cell_offload_eligible_bytes, io_interconnect_bytes, io_disk_bytes from v$sql where sql_text = ‘select count(*) from lab_table where object_id>-9’<\/b>;<\/b><\/p>\n

           <\/p>\n

          SQL_TEXT<\/b><\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          SQL_ID IO_CELL_OFFLOAD_ELIGIBLE_BYTES IO_INTERCONNECT_BYTES IO_DISK_BYTES<\/b><\/p>\n

          ————- —————————— ——————— ————-<\/b><\/p>\n

          select count(*) from lab_table where object_id>-9<\/b><\/p>\n

          84uhhywhqd17n 174776320 16583304 174776320<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

           <\/p>\n

           <\/p>\n

           <\/p>\n

           <\/p>\n

           <\/p>\n

          Index Fast Full Scan<\/u><\/i><\/b> <\/u><\/i><\/b>\uc744<\/u><\/i><\/b> <\/u><\/i><\/b>\ud1b5\ud55c<\/u><\/i><\/b> Smart Scans <\/u><\/i><\/b>\uac80\uc99d<\/u><\/i><\/b><\/u><\/i><\/b><\/p>\n

          lab_user<\/b>\ub85c \uc811\uc18d\ud574\uc11c \uc544\ub798\uc758 \ub2e8\uacc4\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4.<\/p>\n

           <\/p>\n\n\n\n
          1.<\/td>\n\uc6b0\uc120 l<\/b>ab_table<\/b> <\/b>\uc5d0 <\/b>lab_table_index<\/b> <\/b>\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          SQL> <\/b>create index lab_table_index on lab_table (object_id, owner);<\/b><\/b><\/p>\n

           <\/p>\n

          Index created.<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          2.<\/td>\nlab_table<\/b> \uc5d0 Index Fast Full Scan \uc744 \ud560 \uc218 \uc788\ub3c4\ub85d Hint \uc744 \uc8fc\uc5b4\uc11c \uc544\ub798\uc758 SQL\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4. cell offload processing <\/b>\uc774 \uc218\ud589\ub418\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c \uc544\ub798\uc640 \uac19\uc774 2\uac1c \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc744 \uc870\uc815 \ud569\ub2c8\ub2e4. \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud558\uba74 storage \uc640 filter clause \ubd80\ubd84\uc5d0\uc11c Index Fast Full Scan \uc774 Cell Offload Processing \uc744 \uc218\ud589 \ud55c \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
          SQL> <\/b>alter session set cell_offload_processing = TRUE;<\/b><\/p>\n

           <\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>alter session set “_serial_direct_read” = TRUE;<\/b><\/p>\n

           <\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>set autotrace on<\/b><\/p>\n

          SQL> <\/b>select \/*+INDEX_FFS(lab_table lab_table_index) *\/ count(*) from lab_table where owner = ‘EXADATA’;<\/b><\/p>\n

           <\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          0<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Execution Plan<\/b><\/p>\n

          ———————————————————-<\/b><\/p>\n

          Plan hash value: 734070628<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          —————–<\/b><\/p>\n

           <\/p>\n

          | Id | Operation | Name | Rows | Bytes | Cost (<\/b><\/p>\n

          %CPU)| Time |<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          —————–<\/b><\/p>\n

           <\/p>\n

          | 0 | SELECT STATEMENT | | 1 | 17 | 1222<\/b><\/p>\n

          (2)| 00:00:15 |<\/b><\/p>\n

           <\/p>\n

          | 1 | SORT AGGREGATE | | 1 | 17 |<\/b><\/p>\n

          | |<\/b><\/p>\n

           <\/p>\n

          |* 2 | INDEX STORAGE FAST FULL SCAN| LAB_TABLE_INDEX | 235 | 3995 | 1222<\/b><\/p>\n

          (2)| 00:00:15 |<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          —————–<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Predicate Information (identified by operation id):<\/b><\/p>\n

          —————————————————<\/b><\/p>\n

           <\/p>\n

          2 – storage(“OWNER”=’EXADATA’)<\/b><\/p>\n

          filter(“OWNER”=’EXADATA’)<\/b><\/p>\n

           <\/p>\n

          Note<\/b><\/p>\n

          —–<\/b><\/p>\n

          – dynamic sampling used for this statement<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Statistics<\/b><\/p>\n

          ———————————————————-<\/b><\/p>\n

          5 recursive calls<\/b><\/b><\/p>\n

          0 db block gets<\/b><\/p>\n

          4440 consistent gets<\/b><\/p>\n

          4361 physical reads<\/b><\/p>\n

          0 redo size<\/b><\/p>\n

          417 bytes sent via SQL*Net to client<\/b><\/p>\n

          420 bytes received via SQL*Net from client<\/b><\/p>\n

          2 SQL*Net roundtrips to\/from client<\/b><\/p>\n

          0 sorts (memory)<\/b><\/p>\n

          0 sorts (disk)<\/b><\/p>\n

          1 rows processed<\/b><\/p>\n

           <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Bitmap Index Scan<\/u><\/i><\/b> <\/u><\/i><\/b>\uc744<\/u><\/i><\/b> <\/u><\/i><\/b>\ud1b5\ud55c<\/u><\/i><\/b> Smart Scans <\/u><\/i><\/b>\uac80\uc99d<\/u><\/i><\/b><\/u><\/i><\/b><\/p>\n

          lab_user <\/b>\ub85c \uc811\uc18d\ud574\uc11c \uc544\ub798\uc758 \ub2e8\uacc4\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
          1.<\/td>\nlab_table<\/b>\uc5d0<\/b> <\/b>bitmap index lab_table_bitmap<\/b> \uc744 \uc0dd\uc131 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          SQL> <\/b>create bitmap index lab_table_bitmap on lab_table (owner);<\/b><\/b><\/p>\n

           <\/p>\n

          Index created.<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          2.<\/td>\nlab_table<\/b> \uc5d0 Index Fast Full Scan \uc744 \ud560 \uc218 \uc788\ub3c4\ub85d Hint \uc744 \uc8fc\uc5b4\uc11c \uc544\ub798\uc758 SQL\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4. cell offload processing <\/b>\uc774 \uc218\ud589\ub418\ub3c4\ub85d \ud558\uae30 \uc704\ud574\uc11c \uc544\ub798\uc640 \uac19\uc774 2\uac1c \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc744 \uc870\uc815 \ud569\ub2c8\ub2e4. \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud558\uba74 storage \uc640 filter clause \ubd80\ubd84\uc5d0\uc11c lab_table_bitmap<\/b> \uc774 Cell Offload Processing \uc744 \uc218\ud589 \ud55c \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
          SQL> <\/b>alter session set cell_offload_processing = TRUE;<\/b><\/p>\n

           <\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>alter session set “_serial_direct_read” = TRUE;<\/b><\/p>\n

           <\/p>\n

          Session altered.<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>set autotrace on<\/b><\/p>\n

          SQL> <\/b>select \/*+INDEX_FFS(lab_table lab_table_bitmap)*\/ count(*) from lab_table where owner = ‘SYS’;<\/b><\/p>\n

           <\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          626682<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Execution Plan<\/b><\/p>\n

          ———————————————————-<\/b><\/p>\n

          Plan hash value: 1529707086<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          ——————<\/b><\/p>\n

           <\/p>\n

          | Id | Operation | Name | Rows | Bytes | Cost<\/b><\/p>\n

          (%CPU)| Time |<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          ——————<\/b><\/p>\n

           <\/p>\n

          | 0 | SELECT STATEMENT | | 1 | 17 | 953<\/b><\/p>\n

          (2)| 00:00:12 |<\/b><\/p>\n

           <\/p>\n

          | 1 | SORT AGGREGATE | | 1 | 17 |<\/b><\/p>\n

          | |<\/b><\/p>\n

           <\/p>\n

          |* 2 | INDEX STORAGE FAST FULL SCAN| LAB_TABLE_BITMAP | 563K| 9353K| 953<\/b><\/p>\n

          (2)| 00:00:12 |<\/b><\/p>\n

           <\/p>\n

          ——————————————————————————–<\/b><\/p>\n

          ——————<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Predicate Information (identified by operation id):<\/b><\/p>\n

          —————————————————<\/b><\/p>\n

           <\/p>\n

          2 – storage(“OWNER”=’SYS’)<\/b><\/p>\n

          filter(“OWNER”=’SYS’)<\/b><\/p>\n

           <\/p>\n

          Note<\/b><\/p>\n

          —–<\/b><\/p>\n

          – dynamic sampling used for this statement<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Statistics<\/b><\/p>\n

          ———————————————————-<\/b><\/p>\n

          9 recursive calls<\/b><\/p>\n

          0 db block gets<\/b><\/p>\n

          3475 consistent gets<\/b><\/p>\n

          3393 physical reads<\/b><\/p>\n

          0 redo size<\/b><\/p>\n

          420 bytes sent via SQL*Net to client<\/b><\/p>\n

          420 bytes received via SQL*Net from client<\/b><\/p>\n

          2 SQL*Net roundtrips to\/from client<\/b><\/p>\n

          0 sorts (memory)<\/b><\/p>\n

          0 sorts (disk)<\/b><\/p>\n

          1 rows processed<\/b><\/p>\n

           <\/p>\n

          SQL> exit;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Exadata Cell Failure<\/u><\/i><\/b> <\/u><\/i><\/b>\uc5d0<\/u><\/i><\/b> <\/u><\/i><\/b>\ub300\ud55c<\/u><\/i><\/b> <\/u><\/i><\/b>\uac80\uc99d<\/u><\/i><\/b><\/u><\/i><\/b><\/p>\n

          \uc544\ub798\uc758 \uac80\uc99d\uc744 \uc704\ud55c \uc2e4\uc2b5\uc740 2\uac1c\uc758 Exadata Cell \ud658\uacbd\uc77c \uacbd\uc6b0\uc5d0\ub9cc \uac00\ub2a5\ud569\ub2c8\ub2e4.
          \n(Exadata Cell1, Exadata Cell2)<\/p>\n\n\n\n
          1.<\/td>\nlab_user<\/b> \ub85c sqlplus \uc5d0 \uc811\uc18d\ud574 \uc544\ub798\uc758 SQL \uc744 \uc218\ud589 \ud569\ub2c8\ub2e4. \uc544\ub798\uc758 SQL \uc774 \uc5f0\uc18d\uc801\uc73c\ub85c \uc218\ud589 \ub418\uace0 \uc788\uc744\ub54c 2\ubc88\uc9f8 \ub2e8\uacc4\uc744 \ub3d9\uc2dc\uc5d0 \uc2e4\ud589 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          select count(*) from lab_table;<\/b><\/p>\n

          select count(*) from lab_table;<\/b><\/p>\n

          select count(*) from lab_table;<\/b><\/p>\n

          select count(*) from lab_table;<\/b><\/p>\n

          select count(*) from lab_table;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          2.<\/td>\nPuTTY(SSH) \uc744 \ud1b5\ud574 root \uacc4\uc815Exadata Cell \uc5d0 \uc811\uc18d\ud574\uc11c init0 \uba85\ub839\uc5b4\ub85c \uc2dc\uc2a4\ud15c\uc744 \uac15\uc81c\uc801\uc73c\ub85c shutdown \uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          login as: <\/b>root<\/b><\/b><\/p>\n

          root@192.168.204.201’s password:<\/b><\/p>\n

          Last login: Tue Feb 10 20:02:07 2009<\/b><\/p>\n

          [root@ExadataCell1 ~]# <\/b>init 0<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          3.<\/td>\n1\ubc88\uc9f8\uc758 sqlplus session \uc744 \ud1b5\ud55c SQL \uc218\ud589\uc774 \uc5f0\uc18d\uc801\uc73c\ub85c \uc218\ud589\ub418\uace0 \uc788\uc74c\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 ASM \uc774 Normal Redundancy \uc758 \uc18d\uc131\uc73c\ub85c DISK GROUP \uc744 \uc0dd\uc131\ud558\uc600\uae30 \ub54c\ubb38\uc5d0 Exadata Cell1 \uc774 Failure \uc2dc\uc5d0\ub3c4 Exadata Cell1\uc758 ASM Failure Group \uc744 \ud1b5\ud574\uc11c \uc5f0\uc18d\uc801\uc73c\ub85c \uc11c\ube44\uc2a4 \ub418\uace0 \uc788\uc74c\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n
          SQL> <\/b>select count(*) from lab_table;<\/b><\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select count(*) from lab_table;<\/b><\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select count(*) from lab_table;<\/b><\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select count(*) from lab_table;<\/b><\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>select count(*) from lab_table;<\/b><\/p>\n

          COUNT(*)<\/b><\/p>\n

          ———-<\/b><\/p>\n

          1442154<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>exit;<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Lab <\/u><\/i><\/b>\uc2e4\uc2b5<\/u><\/i><\/b> <\/u><\/i><\/b>\ud658\uacbd<\/u><\/i><\/b> Shutdown <\/u><\/i><\/b><\/u><\/i><\/b><\/p>\n

          \uc544\ub798 \ub2e8\uacc4\ubcc4 \uc218\ud589\uc744 \ud1b5\ud574\uc11c Lab \uc2e4\uc2b5 \ud658\uacbd\uc744 shutdown \uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n
          1.<\/td>\nDatabase server VM (Server1<\/b>) \uc5d0 oracle \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud574\uc11c \uc544\ub798\uc758 \uba85\ub839\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          [oracle@server1 ~]$ <\/b>export ORACLE_SID=ora11g<\/b><\/b><\/p>\n

          [oracle@server1 ~]$ <\/b>sqlplus \/ as sysdba<\/b><\/b><\/p>\n

           <\/p>\n

          SQL*Plus: Release 11.1.0.7.0 – Production on Tue Feb 10 07:57:15 2009<\/b><\/p>\n

           <\/p>\n

          Copyright (c) 1982, 2008, Oracle. All rights reserved.<\/b><\/p>\n

           <\/p>\n

           <\/p>\n

          Connected to:<\/b><\/p>\n

          Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production<\/b><\/p>\n

          With the Partitioning, OLAP and Data Mining options<\/b><\/p>\n

           <\/p>\n

          SQL> shutdown immediate;<\/b><\/p>\n

          Database closed.<\/b><\/p>\n

          Database dismounted.<\/b><\/p>\n

          ORACLE instance shut down.<\/b><\/p>\n

          SQL> <\/b>exit;<\/b><\/p>\n

          Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production<\/b><\/p>\n

          With the Partitioning, OLAP and Data Mining options<\/b><\/p>\n

          [oracle@server1 ~]$ <\/b>export ORACLE_SID=+ASM<\/b><\/p>\n

          [oracle@server1 ~]$ <\/b>sqlplus \/ as sysasm<\/b><\/p>\n

           <\/p>\n

          SQL*Plus: Release 11.1.0.7.0 – Production on Tue Feb 10 07:57:46 2009<\/b><\/p>\n

           <\/p>\n

          Copyright (c) 1982, 2008, Oracle. All rights reserved.<\/b><\/p>\n

           <\/p>\n

          Connected to:<\/b><\/p>\n

          Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production<\/b><\/p>\n

          With the Partitioning, OLAP and Data Mining options<\/b><\/p>\n

           <\/p>\n

          SQL> <\/b>shutdown immediate;<\/b><\/b><\/p>\n

          ASM diskgroups dismounted<\/b><\/p>\n

          ASM instance shutdown<\/b><\/p>\n

          SQL> <\/b>exit;<\/b><\/p>\n

          Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production<\/b><\/p>\n

          With the Partitioning, OLAP and Data Mining options<\/b><\/p>\n

          [oracle@server1 ~]$ lsnrctl stop<\/b><\/p>\n

           <\/p>\n

          LSNRCTL for Linux: Version 11.1.0.7.0 – Production on 10-FEB-2009 07:58:01<\/b><\/p>\n

           <\/p>\n

          Copyright (c) 1991, 2008, Oracle. All rights reserved.<\/b><\/p>\n

           <\/p>\n

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))<\/b><\/p>\n

          The command completed successfully<\/b><\/p>\n

          [oracle@server1 ~]$ <\/b>exit<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          2.<\/td>\nDatabase server VM (Server1<\/b>) \uc5d0 root \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud574\uc11c \uc544\ub798\uc758 \uba85\ub839\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n\n
          login as: <\/b>root<\/b><\/p>\n

          root@192.168.204.200’s password:<\/b><\/p>\n

          Last login: Tue Feb 10 20:02:07 2009<\/b><\/p>\n

          [root@Server1 ~]<\/b># <\/b>shutdown \u2013h now<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          3.<\/td>\nOn the Exadata Cell1 VM (ExadataCell1<\/b>) \uc5d0 root \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud574\uc11c \uc544\ub798\uc758 \uba85\ub839\uc744 \uc218\ud589\ud569\ub2c8\ub2e4<\/p>\n\n\n\n\n\n
          login as: <\/b>root<\/b><\/p>\n

          root@192.168.204.201’s password:<\/b><\/p>\n

          Last login: Tue Feb 10 20:02:07 2009<\/b><\/p>\n

          [root@ExadataCell1 ~]<\/b># <\/b>shutdown \u2013h now<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n

          <\/td>\n<\/td>\n<\/tr>\n
          4.<\/td>\nOn the Exadata Cell2 VM (ExadataCell2<\/b>) \uc5d0 root \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud574\uc11c \uc544\ub798\uc758 \uba85\ub839\uc744 \uc218\ud589\ud569\ub2c8\ub2e4<\/p>\n\n\n\n
          login as: <\/b>root<\/b><\/p>\n

          root@192.168.204.202’s password:<\/b><\/p>\n

          Last login: Tue Feb 10 20:02:07 2009<\/b><\/p>\n

          [root@ExadataCell2 ~]<\/b># <\/b>shutdown \u2013h now<\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

              cell offload processing \uc5d0 \ub300\ud55c \uc774\ud574\uc640 \uac80\uc99d\uc744 \uc704\ud574\uc11c \uc544\ub798\uc758 \uc2dc\ub098\ub9ac\uc624\uc744 \uc2e4\uc2b5\ud569\ub2c8\ub2e4. \uc774\ubc88 \uc2e4\uc2b5\uc740 \ub09c\uc774\ub3c4\uac00 \ub192\uc740 \uc2e4\uc2b5 \uc785\ub2c8\ub2e4. \u00b7 Demonstrate Smart File creation for Creating Tablespaces \u00b7 Demonstrate Smart Scan processing for Table Scans \u00b7 Demonstrate Smart Scans in Index Fast Full Scan \u00b7 Demonstrate Smart Scans in Bitmap Index Scan \u00b7 Demonstrate Exadata […]<\/p>\n","protected":false},"author":1,"featured_media":2510,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[405],"tags":[842,27,382,385],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/introducing_the_new_exadata.png?fit=600%2C400","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2512"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2512"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2512\/revisions"}],"predecessor-version":[{"id":2514,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2512\/revisions\/2514"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2510"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2512"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}