Bet result 12.1.0.2.0 can be like this once

I bet with my brother in Shenzhen today that the content will not be detailed. The result is as follows: the client and the onlookers at that time are naturally clear, and I cannot explain it clearly) O Haha ~ In fact, I didn't need to do this test because I have already tested it a few months ago, but I don't believe it, so I have to do it again ~ First look at the current ring

I bet with my brother in Shenzhen today that the content will not be detailed. The result is as follows: the client and the onlookers at that time are naturally clear, and I cannot explain it clearly) O Haha ~ In fact, I didn't need to do this test because I have already tested it a few months ago, but I don't believe it, so I have to do it again ~ First look at the current ring

I bet with my brother in Shenzhen today that the content will not be detailed. The result is as follows: the client and the onlookers at that time are naturally clear, and I cannot explain it clearly) O Haha ~

In fact, I didn't need to do this test because I have already tested it a few months ago, but I don't believe it, so I have to do it again ~
Take a look at the current environment. Note that the information here is sufficient to prove that it is a non-exadata environment ......

[root@localhost ~]# imageinfo-bash: imageinfo: command not found[root@localhost ~]# imagehistory-bash: imagehistory: command not found[root@localhost ~]# uname -aLinux 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 directoryOracle Linux Server release 5.8Red 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-noarchcore-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 xdroot     23530 23350  0 20:35 pts/1    00:00:00 grep xd[root@localhost opt]# [root@localhost ~]# cd /opt[root@localhost opt]# lsORCLfmap[root@localhost opt]# pwd/opt[root@localhost opt]# 

Next we will test the in-memory option function (note the version ):

SQL> SELECT * FROM V$VERSION;BANNER                                                                               CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit                         0PL/SQL Release 12.1.0.2.0 -                                                               0CORE    12.1.0.2.0                                                                        0TNS for Linux: Version 12.1.0.2.0 -                                                       0NLSRTL Version 12.1.0.2.0 -                                                               0SQL> SHOW PARAMETER inmemory;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------inmemory_clause_default              stringinmemory_force                       string      DEFAULTinmemory_query                       string      ENABLEinmemory_size                        big integer 200MSQL> select TABLE_NAME,INMEMORY_PRIORITY,INMEMORY_DISTRIBUTE,INMEMORY_COMPRESSION from user_tables;TABLE_NAME                     INMEMORY INMEMORY_DISTRI INMEMORY_COMPRESS------------------------------ -------- --------------- -----------------LUNARSQL>  SELECT * FROM V$INMEMORY_AREA;POOL                       ALLOC_BYTES USED_BYTES POPULATE_STATUS                CON_ID-------------------------- ----------- ---------- -------------------------- ----------1MB POOL                     166723584          0 DONE                                364KB POOL                     33554432          0 DONE                                3SQL>  alter table  LUNAR inmemory;Table altered.SQL> SELECT COUNT(*) FROM LUNAR;  COUNT(*)----------     90000SQL> SELECT * FROM V$INMEMORY_AREA;POOL                       ALLOC_BYTES USED_BYTES POPULATE_STATUS                CON_ID-------------------------- ----------- ---------- -------------------------- ----------1MB POOL                     166723584    4194304 DONE                                364KB POOL                     33554432     131072 DONE                                3

Guess who won, O (lead _ win) O Haha ~

Original article address: Bet result -- 12.1.0.2.0 once can be like this, thanks to the original author for sharing.