{"id":1614,"date":"2018-01-23T18:56:32","date_gmt":"2018-01-23T09:56:32","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1614"},"modified":"2018-01-25T22:48:47","modified_gmt":"2018-01-25T13:48:47","slug":"oracle-12c%ec%9d%98-in-memory-%ea%b8%b0%eb%8a%a5-%ed%85%8c%ec%8a%a4%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1614","title":{"rendered":"Oracle 12c\uc758 In-Memory \uae30\ub2a5 \ud14c\uc2a4\ud2b8"},"content":{"rendered":"

\uc720\ub2c8\uc6d0\uc544\uc774\uc564\uc528 DB\uae30\uc220\ud300 \uc758 \ubc15\uc6a9\uc11d \uc218\uc11d \uc785\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

\uc624\ub298\uc740 Oracle 12c\uc758 In-Memory \uae30\ub2a5 \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

\uba3c\uc800 \ud14c\uc2a4\ud2b8 \ud560 \ud14c\uc774\ube14 \uc815\ubcf4\uc785\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

=======================<\/span>
\n<\/span><\/span><\/p>\n

====== TABLE SIZE =====<\/span>
\n<\/span><\/span><\/p>\n

=======================<\/span>
\n<\/span><\/span><\/p>\n

OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SEGMENT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0PARTITION_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SEGMENT_TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TABLESPACE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TSIZE<\/span>
\n<\/span><\/span><\/p>\n

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

BILLING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERINFO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TABLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0BILLING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.31<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0*************************\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0———-<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.31<\/span>
\n<\/span><\/span><\/p>\n

***************\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0———-<\/span>
\n<\/span><\/span><\/p>\n

sum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.31<\/span>
\n<\/span><\/span><\/p>\n

INDEX_OWNER<\/span>
\n<\/span><\/span><\/p>\n

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

INDEX_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0COLUMN_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0COLUMN_POSITION<\/span>
\n<\/span><\/span><\/p>\n

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

BILLING<\/span>
\n<\/span><\/span><\/p>\n

IDX_USERINFO_EMAIL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0EMAIL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

IDX_USERINFO_MOBILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MOBILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

IDX_USERINFO_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

IDX_USERINFO_REGDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0REGDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

IDX_USERINFO_USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

UDX_USERINFO_ACCOUNTNUM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ACCOUNTNUM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

UDX_USERINFO_DUPID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0GROUPNUM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0CP_FLAG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03<\/span>
\n<\/span><\/span><\/p>\n

9 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Full Table Scan \ud558\ub294 \ucffc\ub9ac\ub97c \uc218\ud589 \ud569\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

14:07:05 SQL>\u00a0\u00a0alter system flush\u00a0\u00a0BUFFER_CACHE ;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>
\n<\/span><\/span><\/p>\n

System altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.17<\/span>
\n<\/span><\/span><\/p>\n

14:07:09 SQL> alter system flush\u00a0\u00a0BUFFER_POOL ALL ;<\/span>
\n<\/span><\/span><\/p>\n

System altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.12<\/span>
\n<\/span><\/span><\/p>\n

14:07:23 SQL>\u00a0\u00a0select SEX,sms_send,count(1) from userinfo where regdate < to_date(‘2012\/07\/24 00:00:00′,’YYYY\/MM\/DD HH24:MI:SS’) group by sex,sms_send ;<\/span>
\n<\/span><\/span><\/p>\n

S S\u00a0\u00a0\u00a0COUNT(1)<\/span>
\n<\/span><\/span><\/p>\n

– – ———-<\/span>
\n<\/span><\/span><\/p>\n

2 N\u00a0\u00a0\u00a0\u00a02064953<\/span>
\n<\/span><\/span><\/p>\n

1 N\u00a0\u00a0\u00a0\u00a04654692<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:05.98<\/span>
\n<\/span><\/span><\/p>\n

\uc218\ud589 \ucffc\ub9ac\uc758 PLAN \uacfc STATISTIC \uc815\ubcf4\ub97c \ud655\uc778 \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

PLAN_TABLE_OUTPUT<\/span>
\n<\/span><\/span><\/p>\n

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

SQL_ID\u00a0\u00a08u2yphb2spzbd, child number 0<\/span>
\n<\/span><\/span><\/p>\n

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

select SEX,sms_send,count(1) from userinfo where regdate <<\/span>
\n<\/span><\/span><\/p>\n

to_date(‘2012\/07\/24 00:00:00′,’YYYY\/MM\/DD HH24:MI:SS’) group by<\/span>
\n<\/span><\/span><\/p>\n

sex,sms_send<\/span>
\n<\/span><\/span><\/p>\n

Plan hash value: 2500223777<\/span>
\n<\/span><\/span><\/p>\n

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

| Id\u00a0\u00a0| Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Name\u00a0\u00a0\u00a0\u00a0\u00a0| Starts | E-Rows | A-Rows |\u00a0\u00a0\u00a0A-Time\u00a0\u00a0\u00a0| Buffers | Reads\u00a0\u00a0|\u00a0\u00a0OMem |\u00a0\u00a01Mem | Used-Mem |<\/span>
\n<\/span><\/span><\/p>\n

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

|\u00a0\u00a0\u00a00 | SELECT STATEMENT\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 |00:00:05.86 |\u00a0\u00a0\u00a0\u00a0\u00a0165K|\u00a0\u00a0\u00a0\u00a0165K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a01 |\u00a0\u00a0HASH GROUP BY\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 |00:00:05.86 |\u00a0\u00a0\u00a0\u00a0\u00a0165K|\u00a0\u00a0\u00a0\u00a0165K|\u00a0\u00a01520K|\u00a0\u00a01520K|\u00a0\u00a0618K (0)|<\/span>
\n<\/span><\/span><\/p>\n

|*\u00a0\u00a02 |\u00a0\u00a0\u00a0TABLE ACCESS FULL| USERINFO |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a07644K|\u00a0\u00a0\u00a06719K|00:00:05.01 |\u00a0\u00a0\u00a0\u00a0\u00a0165K|\u00a0\u00a0\u00a0\u00a0165K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/span>
\n<\/span><\/span><\/p>\n

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

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

—————————————————<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a02 – filter(“REGDATE”<TO_DATE(‘ 2012-07-24 00:00:00’, ‘syyyy-mm-dd hh24:mi:ss’))<\/span>
\n<\/span><\/span><\/p>\n

21 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

no rows selected<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0elapsed\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0disk\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0query\u00a0\u00a0\u00a0\u00a0current\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rows<\/span>
\n<\/span><\/span><\/p>\n

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

\u00a0\u00a05.859295\u00a0\u00a0\u00a0\u00a0\u00a0165883\u00a0\u00a0\u00a0\u00a0\u00a0165890\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Row Row_Source_Operation<\/strong><\/span>
\n<\/span><\/span><\/p>\n

——— ————————————————————————————————————————<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 SELECT STATEMENT\u00a0\u00a0\u00a0(cr=165890 pr=165883 pw=0 time=5859295)<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02\u00a0\u00a0HASH GROUP BY\u00a0\u00a0(cr=165890 pr=165883 pw=0 time=5859295)<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a06719645\u00a0\u00a0\u00a0TABLE ACCESS FULL USERINFO (cr=165890 pr=165883 pw=0 time=5013518)<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\uc774\ubc88\uc5d0\ub294 IN_MEMORY \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 \uc601\uc5ed\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

[oracle@unioda1 ~]$ sqlplus “\/as sysdba”<\/span>
\n<\/span><\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 24 10:28:41 2017<\/span>
\n<\/span><\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle.\u00a0\u00a0All rights reserved.<\/span>
\n<\/span><\/span><\/p>\n

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

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span>
\n<\/span><\/span><\/p>\n

With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics<\/span>
\n<\/span><\/span><\/p>\n

and Real Application Testing options<\/span>
\n<\/span><\/span><\/p>\n

SQL> show parameter inmemory<\/span>
\n<\/span><\/span><\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUE<\/span>
\n<\/span><\/span><\/p>\n

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

inmemory_clause_default\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string<\/span>
\n<\/span><\/span><\/p>\n

inmemory_force\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0DEFAULT<\/span>
\n<\/span><\/span><\/p>\n

inmemory_max_populate_servers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0integer\u00a0\u00a0\u00a0\u00a0\u00a00<\/span>
\n<\/span><\/span><\/p>\n

inmemory_query\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ENABLE<\/span>
\n<\/span><\/span><\/p>\n

inmemory_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0big integer 0<\/span>
\n<\/span><\/span><\/p>\n

inmemory_trickle_repopulate_servers_ integer\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

percent<\/span>
\n<\/span><\/span><\/p>\n

optimizer_inmemory_aware\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0boolean\u00a0\u00a0\u00a0\u00a0\u00a0TRUE<\/span>
\n<\/span><\/span><\/p>\n

SQL> set lines 100<\/span>
\n<\/span><\/span><\/p>\n

SQL> col name for a40<\/span>
\n<\/span><\/span><\/p>\n

SQL> col value for 999999999999999<\/span>
\n<\/span><\/span><\/p>\n

SQL> select name,value from v$sga;<\/span>
\n<\/span><\/span><\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUE<\/span>
\n<\/span><\/span><\/p>\n

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

Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02944952<\/span>
\n<\/span><\/span><\/p>\n

Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02315255880<\/span>
\n<\/span><\/span><\/p>\n

Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06241124352<\/span>
\n<\/span><\/span><\/p>\n

Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a030609408<\/span>
\n<\/span><\/span><\/p>\n

SQL> alter system set inmemory_size=2g scope=spfile sid=’*’ ;<\/span>
\n<\/span><\/span><\/p>\n

System altered.<\/span>
\n<\/span><\/span><\/p>\n

SQL> alter system set inmemory_clause_default = “memcompress for query high”<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a02\u00a0\u00a0scope=both sid=’*’ ;<\/span>
\n<\/span><\/span><\/p>\n

System altered.<\/span>
\n<\/span><\/span><\/p>\n

SQL> exit<\/span>
\n<\/span><\/span><\/p>\n

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span>
\n<\/span><\/span><\/p>\n

With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics<\/span>
\n<\/span><\/span><\/p>\n

and Real Application Testing options<\/span>
\n<\/span><\/span><\/p>\n

DB \ub97c \uc7ac\uae30\ub3d9 \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

[oracle@unioda1 ~]$ srvctl stop database -d uniodadb<\/span>
\n<\/span><\/span><\/p>\n

[oracle@unioda1 ~]$ srvctl start database -d uniodadb<\/span>
\n<\/span><\/span><\/p>\n

\uc601\uc5ed\uc774 \uc7a1\ud614\ub294\uc9c0 \ud655\uc778 \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

[oracle@unioda1 ~]$ sqlplus “\/as sysdba”<\/span>
\n<\/span><\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 24 10:36:43 2017<\/span>
\n<\/span><\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle.\u00a0\u00a0All rights reserved.<\/span>
\n<\/span><\/span><\/p>\n

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

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span>
\n<\/span><\/span><\/p>\n

With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics<\/span>
\n<\/span><\/span><\/p>\n

and Real Application Testing options<\/span>
\n<\/span><\/span><\/p>\n

SQL> show parameter inmemory<\/span>
\n<\/span><\/span><\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUE<\/span>
\n<\/span><\/span><\/p>\n

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

inmemory_clause_default\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0memcompress for query high<\/span>
\n<\/span><\/span><\/p>\n

inmemory_force\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0DEFAULT<\/span>
\n<\/span><\/span><\/p>\n

inmemory_max_populate_servers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0integer\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

inmemory_query\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ENABLE<\/span>
\n<\/span><\/span><\/p>\n

inmemory_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0big integer 2G<\/span>
\n<\/span><\/span><\/p>\n

inmemory_trickle_repopulate_servers_ integer\u00a0\u00a0\u00a0\u00a0\u00a01<\/span>
\n<\/span><\/span><\/p>\n

percent<\/span>
\n<\/span><\/span><\/p>\n

optimizer_inmemory_aware\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0boolean\u00a0\u00a0\u00a0\u00a0\u00a0TRUE<\/span>
\n<\/span><\/span><\/p>\n

SQL> set lines 100<\/span>
\n<\/span><\/span><\/p>\n

SQL> col name for a40<\/span>
\n<\/span><\/span><\/p>\n

SQL> col value for 999999999999999<\/span>
\n<\/span><\/span><\/p>\n

SQL> select name,value from v$sga;<\/span>
\n<\/span><\/span><\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0VALUE<\/span>
\n<\/span><\/span><\/p>\n

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

Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02944952<\/span>
\n<\/span><\/span><\/p>\n

Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01744830536<\/span>
\n<\/span><\/span><\/p>\n

Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04664066048<\/span>
\n<\/span><\/span><\/p>\n

Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a030609408<\/span>
\n<\/span><\/span><\/p>\n

In-Memory Area\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02147483648<\/span>
\n<\/span><\/span><\/p>\n

\uc774\uc81c \ub300\uc0c1 \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uc744 In-Memory \uc601\uc5ed\uc73c\ub85c \uc62e\uae30\ub294 \uc791\uc5c5\uc744 \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

13:59:32 SQL>\u00a0\u00a0alter system flush\u00a0\u00a0BUFFER_CACHE ;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>
\n<\/span><\/span><\/p>\n

System altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.44<\/span>
\n<\/span><\/span><\/p>\n

14:00:04 SQL>\u00a0\u00a0alter system flush\u00a0\u00a0BUFFER_POOL ALL ;<\/span>
\n<\/span><\/span><\/p>\n

System altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.11<\/span>
\n<\/span><\/span><\/p>\n

14:00:11 SQL> alter table userinfo inmemory memcompress for query high priority high;<\/span>
\n<\/span><\/span><\/p>\n

Table altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.40<\/span>
\n<\/span><\/span><\/p>\n

14:00:24 SQL> conn \/as sysdba<\/span>
\n<\/span><\/span><\/p>\n

Connected.<\/span>
\n<\/span><\/span><\/p>\n

14:00:28 SQL> execute dbms_inmemory.populate(‘BILLING’,’USERINFO’) ;<\/span>
\n<\/span><\/span><\/p>\n

PL\/SQL procedure successfully completed.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.27<\/span>
\n<\/span><\/span><\/p>\n

In-Memory \uc601\uc5ed\uc73c\ub85c \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uc774 \uc798 \uc62e\uaca8 \uc84c\ub294\uc9c0 \uc870\ud68c \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

14:04:32 SQL> select owner, segment_name, bytes, inmemory_size, populate_status,<\/span>
\n<\/span><\/span><\/p>\n

14:05:11\u00a0\u00a0\u00a02\u00a0\u00a0bytes_not_populated<\/span>
\n<\/span><\/span><\/p>\n

14:05:11\u00a0\u00a0\u00a03\u00a0\u00a0from v$im_segments<\/span>
\n<\/span><\/span><\/p>\n

14:05:11\u00a0\u00a0\u00a04\u00a0\u00a0where segment_name=’USERINFO’ ;<\/span>
\n<\/span><\/span><\/p>\n

OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SEGMENT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0BYTES INMEMORY_SIZE POPULATE_ BYTES_NOT_POPULATED<\/span>
\n<\/span><\/span><\/p>\n

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

BILLING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERINFO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01409286144\u00a0\u00a0\u00a0\u00a0\u00a0624558080 COMPLETED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0507396096<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.11<\/span>
\n<\/span><\/span><\/p>\n

14:05:36 SQL> select a.object_name,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a02\u00a0\u00a0b.inmemory_priority,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a03\u00a0\u00a0b.populate_status,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a04\u00a0\u00a0to_char(c.createtime,’mm\/dd\/yyyy hh24:mi:ss.ff2′) start_pop,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a05\u00a0\u00a0to_char(max(d.timestamp),’mm\/dd\/yyyy hh24:mi:ss.ff2′) finish_pop<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a06\u00a0\u00a0from dba_objects a,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a07\u00a0\u00a0v$im_segments b,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a08\u00a0\u00a0v$im_segments_detail c,<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a0\u00a09\u00a0\u00a0v$im_header d<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a010\u00a0\u00a0where object_name in (‘USERINFO’)<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a011\u00a0\u00a0and a.object_name = b.segment_name<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a012\u00a0\u00a0and a.object_type = ‘TABLE’<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a013\u00a0\u00a0and a.object_id = c.baseobj<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a014\u00a0\u00a0and c.dataobj = d.objd<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a015\u00a0\u00a0group by a.object_name, b.inmemory_priority, b.populate_status,c.createtime<\/span>
\n<\/span><\/span><\/p>\n

14:05:43\u00a0\u00a016\u00a0\u00a0\u00a0order by finish_pop;<\/span>
\n<\/span><\/span><\/p>\n

OBJECT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0INMEMORY POPULATE_ START_POP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0FINISH_POP<\/span>
\n<\/span><\/span><\/p>\n

————— ——– ——— ———————- ———————-<\/span>
\n<\/span><\/span><\/p>\n

USERINFO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0HIGH\u00a0\u00a0\u00a0\u00a0\u00a0COMPLETED 10\/24\/2017 14:04:39.24 10\/24\/2017 14:05:21.81<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.01<\/span>
\n<\/span><\/span><\/p>\n

14:05:44 SQL><\/span>
\n<\/span><\/span><\/p>\n

\uc798 \uc62e\uaca8 \uc84c\ub294\uc9c0 \ud655\uc778 \ud6c4 \uac19\uc740 \ucffc\ub9ac\ub97c \ub2e4\uc2dc \uc218\ud589 \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

14:06:17 SQL>\u00a0\u00a0select SEX,sms_send,count(1) from userinfo where regdate < to_date(‘2012\/07\/24 00:00:00′,’YYYY\/MM\/DD HH24:MI:SS’) group by sex,sms_send ;<\/span>
\n<\/span><\/span><\/p>\n

S S\u00a0\u00a0\u00a0COUNT(1)<\/span>
\n<\/span><\/span><\/p>\n

– – ———-<\/span>
\n<\/span><\/span><\/p>\n

2 N\u00a0\u00a0\u00a0\u00a02064953<\/span>
\n<\/span><\/span><\/p>\n

1 N\u00a0\u00a0\u00a0\u00a04654692<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:05.65<\/span>
\n<\/span><\/span><\/p>\n

PLAN_TABLE_OUTPUT<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

SQL_ID\u00a0\u00a08u2yphb2spzbd, child number 0<\/span>
\n<\/span><\/span><\/p>\n

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

select SEX,sms_send,count(1) from userinfo where regdate <<\/span>
\n<\/span><\/span><\/p>\n

to_date(‘2012\/07\/24 00:00:00′,’YYYY\/MM\/DD HH24:MI:SS’) group by<\/span>
\n<\/span><\/span><\/p>\n

sex,sms_send<\/span>
\n<\/span><\/span><\/p>\n

Plan hash value: 2500223777<\/span>
\n<\/span><\/span><\/p>\n

————————————————————————————————————————————–<\/strong><\/span>
\n<\/span><\/span><\/p>\n

| Id\u00a0\u00a0| Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Name\u00a0\u00a0\u00a0\u00a0\u00a0| Starts | E-Rows | A-Rows |\u00a0\u00a0\u00a0A-Time\u00a0\u00a0\u00a0| Buffers | Reads\u00a0\u00a0|\u00a0\u00a0OMem |\u00a0\u00a01Mem | Used-Mem |<\/strong><\/span>
\n<\/span><\/span><\/p>\n

————————————————————————————————————————————–<\/strong><\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a00 | SELECT STATEMENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 |00:00:05.58 |\u00a0\u00a0\u00a063221 |\u00a0\u00a063218 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/strong><\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a01 |\u00a0\u00a0HASH GROUP BY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 |00:00:05.58 |\u00a0\u00a0\u00a063221 |\u00a0\u00a063218 |\u00a0\u00a01520K|\u00a0\u00a01520K|\u00a0\u00a0610K (0)|<\/strong><\/span>
\n<\/span><\/span><\/p>\n

|*\u00a0\u00a02 |\u00a0\u00a0\u00a0TABLE ACCESS INMEMORY FULL<\/span>| USERINFO |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a07644K|\u00a0\u00a0\u00a06719K|00:00:04.66 |\u00a0\u00a0\u00a063221 |\u00a0\u00a063218 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/strong><\/span>
\n<\/span><\/span><\/p>\n

————————————————————————————————————————————–<\/strong><\/span>
\n<\/span><\/span><\/p>\n

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

—————————————————<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a02 – inmemory(“REGDATE”<TO_DATE(‘ 2012-07-24 00:00:00’, ‘syyyy-mm-dd hh24:mi:ss’))<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0filter(“REGDATE”<TO_DATE(‘ 2012-07-24 00:00:00’, ‘syyyy-mm-dd hh24:mi:ss’))<\/span>
\n<\/span><\/span><\/p>\n

22 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

no rows selected<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0elapsed\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0disk\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0query\u00a0\u00a0\u00a0\u00a0current\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rows<\/strong><\/span>
\n<\/span><\/span><\/p>\n

———- ———- ———- ———- ———-<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a05.576106<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a063218\u00a0\u00a0\u00a0\u00a0\u00a0\u00a063221\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Row Row_Source_Operation<\/strong><\/span>
\n<\/span><\/span><\/p>\n

——— ————————————————————————————————————————<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 SELECT STATEMENT\u00a0\u00a0\u00a0(cr=63221 pr=63218 pw=0 time=5576106)<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02\u00a0\u00a0HASH GROUP BY\u00a0\u00a0(cr=63221 pr=63218 pw=0 time=5576106)<\/strong><\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a06719645\u00a0\u00a0\u00a0TABLE ACCESS<\/span><\/strong>
\nINMEMORY<\/strong><\/span>
\nFULL<\/strong><\/span>
\nUSERINFO (cr=63221 pr=63218 pw=0 time=4661101)<\/strong><\/span>
\n<\/span><\/span><\/p>\n

SQL><\/span>
\n<\/span><\/span><\/p>\n

\uac19\uc740 \ucffc\ub9ac\uc758 \ud50c\ub79c\uc774\u00a0TABLE ACCESS FULL \uc5d0\uc11c\u00a0TABLE ACCESS INMEMORY FULL<\/span><\/strong>
\n\uc73c\ub85c \ubcc0\uacbd \ub418\uc5c8\uace0,<\/strong><\/span>
\n<\/span><\/span><\/p>\n

elapsed \uc218\ud589 \uc2dc\uac04\uc774\u00a05.859295 \uc5d0\uc11c\u00a05.576106 \uc73c\ub85c \ub2e8\ucd95 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/strong><\/span>
\n<\/span><\/span><\/p>\n

\ub610 \ub2e4\ub978 \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. userinfo \ud14c\uc774\ube14 \ub300\uc2e0 TRANSACTIONS \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

17:18:21 SQL> select to_char(REGDATE,’YYYY’) as Year , sum(CASHAMOUNT) from TRANSACTIONS group by to_char(REGDATE,’YYYY’) ;<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:09.07<\/span>
\n<\/span><\/span><\/p>\n

\uc218\ud589 \ud6c4 \ud50c\ub79c \uc815\ubcf4 \uc785\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

PLAN_TABLE_OUTPUT<\/span>
\n<\/span><\/span><\/p>\n

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

SQL_ID\u00a0\u00a04mjqpbqxby921, child number 0<\/span>
\n<\/span><\/span><\/p>\n

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

select to_char(REGDATE,’YYYY’) as Year , sum(CASHAMOUNT) from<\/span>
\n<\/span><\/span><\/p>\n

TRANSACTIONS group by to_char(REGDATE,’YYYY’)<\/span>
\n<\/span><\/span><\/p>\n

Plan hash value: 1427863798<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

| Id\u00a0\u00a0| Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Starts | E-Rows | A-Rows |\u00a0\u00a0\u00a0A-Time\u00a0\u00a0\u00a0| Buffers | Reads\u00a0\u00a0|\u00a0\u00a0OMem |\u00a0\u00a01Mem | Used-Mem |<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a00 | SELECT STATEMENT\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07 |00:00:09.00 |\u00a0\u00a0\u00a0\u00a0\u00a0179K|\u00a0\u00a0\u00a0\u00a0179K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a01 |\u00a0\u00a0HASH GROUP BY\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a014M|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07 |00:00:09.00 |\u00a0\u00a0\u00a0\u00a0\u00a0179K|\u00a0\u00a0\u00a0\u00a0179K|\u00a0\u00a01186K|\u00a0\u00a01186K|\u00a0\u00a0982K (0)|<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a02 |\u00a0\u00a0\u00a0TABLE ACCESS FULL| TRANSACTIONS |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a017M|\u00a0\u00a0\u00a0\u00a0\u00a017M|00:00:03.68 |\u00a0\u00a0\u00a0\u00a0\u00a0179K|\u00a0\u00a0\u00a0\u00a0179K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

15 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

no rows selected<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0elapsed\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0disk\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0query\u00a0\u00a0\u00a0\u00a0current\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rows<\/span>
\n<\/span><\/span><\/p>\n

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

\u00a0\u00a09.001912\u00a0\u00a0\u00a0\u00a0\u00a0179503\u00a0\u00a0\u00a0\u00a0\u00a0179510\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Row Row_Source_Operation<\/span>
\n<\/span><\/span><\/p>\n

——— ————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07 SELECT STATEMENT\u00a0\u00a0\u00a0(cr=179510 pr=179503 pw=0 time=9001912)<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07\u00a0\u00a0HASH GROUP BY\u00a0\u00a0(cr=179510 pr=179503 pw=0 time=9001912)<\/span>
\n<\/span><\/span><\/p>\n

17389554\u00a0\u00a0\u00a0TABLE ACCESS FULL TRANSACTIONS (cr=179510 pr=179503 pw=0 time=3682351)<\/span>
\n<\/span><\/span><\/p>\n

\uc774\uc804\uc5d0 In-Memory \uc5d0 \ub4f1\ub85d\ud55c userinfo \ud14c\uc774\ube14\uc744 \uc601\uc5ed\uc5d0\uc11c \uc81c\uc678\ud569\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

17:19:10 SQL> alter table userinfo no inmemory ;<\/span>
\n<\/span><\/span><\/p>\n

Table altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.31<\/span>
\n<\/span><\/span><\/p>\n

transactions \ud14c\uc774\ube14\uc744 In-memory \uc601\uc5ed\uc5d0 \ub4f1\ub85d\ud558\uace0 Population(Load) \uc2dc\ud0b5\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

Population \uc774\ub780 ??<\/strong><\/span>
\n<\/span><\/p>\n

Populate\ub294 \ub370\uc774\ud130\ub97c IM \uc5f4 \uc800\uc7a5\uc18c\ub85c \uac00\uc838 \uc624\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \uc6a9\uc5b4\uc785\ub2c8\ub2e4.\u00a0<\/strong><\/span>
\n<\/span><\/p>\n

load\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc0bd\uc785\ud558\ub294 \uac83\uc744 \uc758\ubbf8\ud558\uae30 \ub54c\ubb38\uc5d0\u00a0“load”\ub300\uc2e0 “populate”\ub77c\ub294 \uc6a9\uc5b4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/p>\n

Populate\u00a0\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc0c8 \ub370\uc774\ud130\ub97c \uac00\uc838 \uc624\uc9c0 \uc54a\uc73c\uba70 \uae30\uc874 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\ub85c \uac00\uc838 \uc640\uc11c \ucd5c\uc801\ud654 \ub41c \uc5f4 \ud615\uc2dd\uc73c\ub85c \ud615\uc2dd\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/p>\n

17:20:06 SQL> alter table TRANSACTIONS inmemory priority high;<\/span>
\n<\/span><\/span><\/p>\n

Table altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.08<\/span>
\n<\/span><\/span><\/p>\n

17:21:03 SQL> alter table transactions inmemory memcompress for query high priority high;<\/span>
\n<\/span><\/span><\/p>\n

Table altered.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.30<\/span>
\n<\/span><\/span><\/p>\n

17:22:02 SQL> conn \/as sysdba<\/span>
\n<\/span><\/span><\/p>\n

Connected.<\/span>
\n<\/span><\/span><\/p>\n

17:22:09 SQL> execute dbms_inmemory.populate(‘BILLING’,’TRANSACTIONS’) ;<\/span>
\n<\/span><\/span><\/p>\n

PL\/SQL procedure successfully completed.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:00.01<\/span>
\n<\/span><\/span><\/p>\n

\uadf8\ub9ac\uace0 \ub2e4\uc2dc \uc218\ud589\ud574 \ubd05\ub2c8\ub2e4… \uc774\ubc88\uc5d0\ub294 \ubc18\ubcf5\uc801\uc73c\ub85c \uc218\ud589 \ud569\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:22:20 SQL> conn billing<\/span>
\n<\/span><\/span><\/p>\n

Enter password:<\/span>
\n<\/span><\/span><\/p>\n

Connected.<\/span>
\n<\/span><\/span><\/p>\n

17:22:26 SQL><\/span>
\n<\/span><\/span><\/p>\n

17:22:26 SQL><\/span>
\n<\/span><\/span><\/p>\n

17:22:27 SQL> select to_char(REGDATE,’YYYY’) as Year , sum(CASHAMOUNT) from TRANSACTIONS group by to_char(REGDATE,’YYYY’) ;<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:16.00<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:22:54 SQL>\u00a0\u00a0select to_char(REGDATE,’YYYY’) as Year , sum(CASHAMOUNT) from TRANSACTIONS group by to_char(REGDATE,’YYYY’) ;<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:07.13<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:23:49 SQL> \/<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:06.87<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:24:13 SQL> \/<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:06.79<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:24:23 SQL> \/<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:06.77<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:28:54 SQL> \/<\/span>
\n<\/span><\/span><\/p>\n

YEAR SUM(CASHAMOUNT)<\/span>
\n<\/span><\/span><\/p>\n

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

2009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09820469306<\/span>
\n<\/span><\/span><\/p>\n

2010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09457840955<\/span>
\n<\/span><\/span><\/p>\n

2008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.4209E+10<\/span>
\n<\/span><\/span><\/p>\n

2007\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09733116098<\/span>
\n<\/span><\/span><\/p>\n

2011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.0298E+10<\/span>
\n<\/span><\/span><\/p>\n

2012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09119469224<\/span>
\n<\/span><\/span><\/p>\n

2006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0581415840<\/span>
\n<\/span><\/span><\/p>\n

7 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

Elapsed: 00:00:06.95<\/strong><\/span>
\n<\/span><\/span><\/p>\n

17:29:06 SQL><\/span>
\n<\/span><\/span><\/p>\n

\ud50c\ub79c\uc744 \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

PLAN_TABLE_OUTPUT<\/span>
\n<\/span><\/span><\/p>\n

————————————————————————————————————————————————————————————————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

SQL_ID\u00a0\u00a063x3yk3wsf5rt, child number 0<\/span>
\n<\/span><\/span><\/p>\n

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

select to_char(REGDATE,’YYYY’) as Year , sum(CASHAMOUNT) from<\/span>
\n<\/span><\/span><\/p>\n

TRANSACTIONS group by to_char(REGDATE,’YYYY’)<\/span>
\n<\/span><\/span><\/p>\n

Plan hash value: 1427863798<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

| Id\u00a0\u00a0| Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Starts | E-Rows | A-Rows |\u00a0\u00a0\u00a0A-Time\u00a0\u00a0\u00a0| Buffers |\u00a0\u00a0OMem |\u00a0\u00a01Mem | Used-Mem |<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a00 | SELECT STATEMENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07 |00:00:06.95 |\u00a0\u00a0\u00a0\u00a0\u00a0114K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a01 |\u00a0\u00a0HASH GROUP BY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a014M|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07 |00:00:06.95 |\u00a0\u00a0\u00a0\u00a0\u00a0114K|\u00a0\u00a01186K|\u00a0\u00a01186K| 1000K (0)|<\/span>
\n<\/span><\/span><\/p>\n

|\u00a0\u00a0\u00a02 |\u00a0\u00a0\u00a0TABLE ACCESS INMEMORY FULL| TRANSACTIONS |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a017M|\u00a0\u00a0\u00a0\u00a0\u00a017M|00:00:01.97 |\u00a0\u00a0\u00a0\u00a0\u00a0114K|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/span>
\n<\/span><\/span><\/p>\n

———————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

15 rows selected.<\/span>
\n<\/span><\/span><\/p>\n

no rows selected<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0elapsed\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0disk\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0query\u00a0\u00a0\u00a0\u00a0current\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rows<\/span>
\n<\/span><\/span><\/p>\n

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

\u00a0\u00a06.946008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0114607\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Row Row_Source_Operation<\/span>
\n<\/span><\/span><\/p>\n

——— ————————————————————————————————————————<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07 SELECT STATEMENT\u00a0\u00a0\u00a0(cr=114607 pr=0 pw=0 time=6946008)<\/span>
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07\u00a0\u00a0HASH GROUP BY\u00a0\u00a0(cr=114607 pr=0 pw=0 time=6946008)<\/span>
\n<\/span><\/span><\/p>\n

17389554\u00a0\u00a0\u00a0TABLE ACCESS INMEMORY FULL TRANSACTIONS (cr=114607 pr=0 pw=0 time=1974611)<\/span>
\n<\/span><\/span><\/p>\n

\ud50c\ub79c\uc740 INMEMORY \ub85c \ubcc0\uacbd\ub418\uc5c8\uc73c\uba70, 9.001912\u00a0\ucd08 \uac78\ub9ac\ub358 \ucffc\ub9ac\uac00\u00a06.946008 \ub85c \uc218\ud589 \uc2dc\uac04\uc774 \ub2e8\ucd95 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

Oracle 12c\uc5d0 \ub098\uc628 In-Memory \ud14c\uc2a4\ud2b8\ub97c \ub9c8\uce58\uba70<\/strong><\/span>
\n<\/span><\/p>\n

\u00a0Population \uc989 Memory\uc5d0 \uc801\uc7ac (\ucc44\uc6b0\uae30) \uac00 \ub05d\ub098\uba74 \ucffc\ub9ac\uc758 \ubcc0\uacbd \uc5c6\uc774 \ub370\uc774\ud0c0\uc758 \uac80\uc0c9 \uc18d\ub3c4\uc758 \ud5a5\uc0c1\uc774 \uc788\uc74c\uc744 \ud655\uc778 \ud558\uc600\uc2b5\ub2c8\ub2e4.\u00a0<\/strong><\/span>
\n<\/span><\/p>\n

\u00a0\ud14c\uc2a4\ud2b8 \ud658\uacbd\uc740 \ub370\uc774\ud0c0\ub294 \uc801\uc740 \ub370\uc774\ud0c0\uc774\uae30 \ub54c\ubb38\uc5d0 \ud070 \ucc28\uc774\ub97c \ubcf4\uc774\uae30 \uc5b4\ub835\uc9c0\ub9cc \uc218\uc2dc\uac04 \uc218\ud589 \ub418\ub294 \ubc30\uce58\uc758 \uacbd\uc6b0 \uc5d0\ub294 \ub354 \ud070 \ub2e8\ucd95 \uc2dc\uac04 \uc808\uac10\uc744 \uc608\uc0c1 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/span>
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc720\ub2c8\uc6d0\uc544\uc774\uc564\uc528 DB\uae30\uc220\ud300 \uc758 \ubc15\uc6a9\uc11d \uc218\uc11d \uc785\ub2c8\ub2e4. \uc624\ub298\uc740 Oracle 12c\uc758 In-Memory \uae30\ub2a5 \ud14c\uc2a4\ud2b8\ub97c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \ud14c\uc2a4\ud2b8 \ud560 \ud14c\uc774\ube14 \uc815\ubcf4\uc785\ub2c8\ub2e4. ======================= ====== TABLE SIZE ===== ======================= OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SEGMENT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0PARTITION_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SEGMENT_TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TABLESPACE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TSIZE ————— ————————- —————————— —————— ————— ———- BILLING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERINFO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TABLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0BILLING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.31 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0*************************\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0———- \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.31 ***************\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0———- sum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.31 INDEX_OWNER ——————————————————————————————————————————– INDEX_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0COLUMN_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0COLUMN_POSITION ——————————————————————————————————————————– ——————– ————— BILLING IDX_USERINFO_EMAIL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0EMAIL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 IDX_USERINFO_MOBILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MOBILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 IDX_USERINFO_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 IDX_USERINFO_REGDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0REGDATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 IDX_USERINFO_USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 UDX_USERINFO_ACCOUNTNUM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ACCOUNTNUM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 UDX_USERINFO_DUPID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0GROUPNUM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0CP_FLAG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a03 9 rows selected. […]<\/p>\n","protected":false},"author":1,"featured_media":2080,"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":[20],"tags":[783,712],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/lZQ.jpg?fit=744%2C400","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1614"}],"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=1614"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1614\/revisions"}],"predecessor-version":[{"id":2099,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1614\/revisions\/2099"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2080"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1614"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}