Exadata Express – I’m in !

Posted by

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

image

2) Unzip the file into a folder

image

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 Smile 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 |
----------------------------------------------------------------------------------

2 comments

  1. 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?

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.