今天跟深圳小兄弟打賭,內容不詳述了,結果如下,當事人和當時圍觀的人自然清楚,不清楚的我也不便解釋了,O(∩_∩)O哈哈~ 其實這個測試我本來不用做的,因為飛總早在幾個月前已經測試過了,但是兄弟不相信,我不得不再弄一次,O(∩_∩)O哈哈~ 先看下當前環
今天跟深圳小兄弟打賭,內容不詳述了,結果如下,當事人和當時圍觀的人自然清楚,不清楚的我也不便解釋了,O(∩_∩)O哈哈~
其實這個測試我本來不用做的,因為飛總早在幾個月前已經測試過了,但是兄弟不相信,我不得不再弄一次,O(∩_∩)O哈哈~
先看下當前環境,注意,這里的信息都足以證明是一個非exadata環境……
[root@localhost ~]# imageinfo -bash: imageinfo: command not found [root@localhost ~]# imagehistory -bash: imagehistory: command not found [root@localhost ~]# uname -a Linux localhost.localdomain 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:37:40 EST 2012 x86_64 x86_64 x86_64 GNU/Linux [root@localhost ~]# cat /etc/*relea* Enterprise Linux Enterprise Linux Server release 5.8 (Carthage) cat: /etc/lsb-release.d: Is a directory Oracle Linux Server release 5.8 Red Hat Enterprise Linux Server release 5.8 (Tikanga) [root@localhost ~]# [root@localhost ~]# ls /etc/*relea* /etc/enterprise-release /etc/oracle-release /etc/redhat-release /etc/lsb-release.d: core-4.0-amd64 core-4.0-noarch graphics-4.0-ia32 printing-4.0-amd64 printing-4.0-noarch core-4.0-ia32 graphics-4.0-amd64 graphics-4.0-noarch printing-4.0-ia32 [root@localhost ~]# [root@localhost ~]# [root@localhost opt]# ps -ef|grep xd root 23530 23350 0 20:35 pts/1 00:00:00 grep xd [root@localhost opt]# [root@localhost ~]# cd /opt [root@localhost opt]# ls ORCLfmap [root@localhost opt]# pwd /opt [root@localhost opt]#
下面我們來測試in-memory option功能(注意版本):
SQL> SELECT * FROM V$VERSION; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit 0 PL/SQL Release 12.1.0.2.0 - 0 CORE 12.1.0.2.0 0 TNS for Linux: Version 12.1.0.2.0 - 0 NLSRTL Version 12.1.0.2.0 - 0 SQL> SHOW PARAMETER inmemory; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ inmemory_clause_default string inmemory_force string DEFAULT inmemory_query string ENABLE inmemory_size big integer 200M SQL> select TABLE_NAME,INMEMORY_PRIORITY,INMEMORY_DISTRIBUTE,INMEMORY_COMPRESSION from user_tables; TABLE_NAME INMEMORY INMEMORY_DISTRI INMEMORY_COMPRESS ------------------------------ -------- --------------- ----------------- LUNAR SQL> SELECT * FROM V$INMEMORY_AREA; POOL ALLOC_BYTES USED_BYTES POPULATE_STATUS CON_ID -------------------------- ----------- ---------- -------------------------- ---------- 1MB POOL 166723584 0 DONE 3 64KB POOL 33554432 0 DONE 3 SQL> alter table LUNAR inmemory; Table altered. SQL> SELECT COUNT(*) FROM LUNAR; COUNT(*) ---------- 90000 SQL> SELECT * FROM V$INMEMORY_AREA; POOL ALLOC_BYTES USED_BYTES POPULATE_STATUS CON_ID -------------------------- ----------- ---------- -------------------------- ---------- 1MB POOL 166723584 4194304 DONE 3 64KB POOL 33554432 131072 DONE 3
猜猜,誰贏了,O(∩_∩)O哈哈~
原文地址:打賭結果——12.1.0.2.0曾經可以這樣, 感謝原作者分享。
聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com