Jumping into 12.2 on Exadata Express is made easy with the packaging up of the client configuration files. Here’s what I had to do to get SQL Plus going into the database
1) Download the client credentials file from the Service Console
2) Unzip the file into a folder
3) And voila! Just set TNS_ADMIN to where you unzipped the files and you’re ready to go!. By default, the TNS name is “dbaccess”
C:\>set TNS_ADMIN=C:\oracle\tns\exadata_express
C:\>sqlplus mcdonac/*******@dbaccess
SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 5 12:16:07 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Wed Oct 05 2016 08:55:07 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.0.3 - 64bit Production
SQL>
Simple And yes… it’s an Exadata !
SQL> create table t as select * from all_objects;
Table created.
SQL> set autotrace traceonly explain
SQL> select * from t;
Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873
----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 62226 | 8082K| 331 (1)| 00:00:01 |
| 1 | TABLE ACCESS STORAGE FULL| T | 62226 | 8082K| 331 (1)| 00:00:01 |
----------------------------------------------------------------------------------
Hello Connor,
@ Simple Smile And yes… it’s an Exadata !
According to “Known Issues for Oracle Database Exadata Express Cloud Service” http://docs.oracle.com/cloud/latest/exadataexpress-cloud/CSDBK/GUID-0FD6DE2D-93AC-4A5F-A8FB-B4C86DF0B4F8.htm#CSDBK-GUID-0FD6DE2D-93AC-4A5F-A8FB-B4C86DF0B4F8
There are several options that are disabled including:
Parallel Query
The parallel query option is disabled.
Exadata Smart Scan and Exadata Hybrid Columnar Compression (HCC)
Exadata Smart Scan is not supported in this initial release. Exadata HCC is supported.
Is the documentation out of date and these options are already enabled, or you wanted to say that it’s an Exadata without Smart Scan and Parallel Query?