Taking the new command line tool @SQLcl for a first test drive.
– installation super-easy
– a lot of commands interchangeable with SQL Developer
– connectivity via TNS is easy to setup. TIP: if you do not have TNS_ADMIN environment variable in place, run
in SQL Developer in order to get the location for the tnsnames.ora file!
No minus points found yet🙂
I will be speaking on:
Solaris 11, the OS for the Cloud
Infrastructure as a Service in Oracle Public Cloud
First day starting with “Extending Database In-Memory on Exadata Flash” by Roger MacNicol from Oracle. Very Good presentation!
Followed by SQL-on-Hadoop for Analytics and Data Integration – What are My Options, What is the Future? by Mark Rittman.
Oracle Exadata and Database Memory – Frits Hoogland of Accenture Enkitec Group
Next, SuperCluster M7 – Configuration Guidance and Best Practices by Oracle. OVM server for SPARC has the virtualization technology built into the M7 chip. For more than four domains, we setup root domains and IO domains.
Introduced 11gR1 and based on virtual columns. Allows better selectivity.
Condition has the be equality or IN-lists.
We should use them when we have issues by an order of magnitude on the cardinality.
- Column Group: Have to be from same table. Max 32
- Expression: CBO does not know how an applied function impacts the cardinality of a column so it uses default of 1%!!!
They can be seen in DBA_TAB_COLS by checking the hidden columns. Or in data dictionary by checking *_STAT_EXTENSIONS. They have system generated names. The 12c prefix is different of the 11g prefix.
Question: how to fond the correlations?
- 11gR1 manually
- 11gR2 manually / assisted
- 12gR1 manually / assisted / automatic
Start new certification: Solaris 11 System Admin!
Today I start prepping for Solaris 11 System Administration Certification.
First step is Exam 1Z0-821.
Passing the exam will ensure achieving OCA level.
I have decided to use this book: Michal Ernest’s guide (ISBN 0071775749 / 9780071775748).