欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

打赌结果12.1.0.2.0曾经可以这样

程序员文章站 2022-05-25 17:21:51
...

今天跟深圳小兄弟打赌,内容不详述了,结果如下,当事人和当时围观的人自然清楚,不清楚的我也不便解释了,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哈哈~