Kosmos world

So now that I have installed oracle 12C ..its time to look into its new features. I struggled a bit to build the oracle 12c server on my laptop. After a few rounds of failed installations I could successfully install oracle 12C on the windows7 64bit Laptop. Initially I downloaded two different zip files so when I was trying to install them it was showing some installation files were missing and later on I re-downloaded the correct one files and started the installation. I guess next time it failed as there is something with the privileges on my work laptop which did not let the installation go through. Finally oracle 12c is up and running on my laptop...yay..! so time to fidget with it..! So here I start with some new features . refrerence : http://www.orafaq.com/node/2822 01. Pluggable Databases Through Database Consolidation: Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this...

Reference to the article from Burleson Consulting http://www.dba-oracle.com/t_sql_query_not_using_index.htm Sometimes the optimizer will just not use an index even if exists . There could be many reasons to that. Answer:   Oracle SQL not using an index is a common complaint, and it’s often because the optimizer thinks that a full-scan is cheaper than index access.   Oracle not using an index can be due to: ·          Bad/incomplete statistics – Make sure to re-analyze the table and index with dbms_stats to ensure that the optimizer has good metadata. ·          Wrong optimizer_mode – The first_rows optimizer mode is to minimize response time, and it is more likely to use an index than the default all_rows mode. ·          Bugs – See these important notes on optimizer changes in 10g that cause Oracle not to use an index. ·  ...