Posted on March 25, 2017 by mudhalvan
Indexes will become invalid for various reason. When indexes are invalid your query may not perform well and sometime it will lead into your operation fail during few DML. So it is DBA responsibility periodically check and rebuild during off business hours. 1. How to find the Invalid Indexes Indexes can be from normal tables or partitioned/subpartitioned tables respectively we
Read More »
Posted on January 25, 2017 by mudhalvan
1. What is Advance Compression: As you already know in oracle compression started playing major role these days on saving cost and improving performance. Oracle Advanced Compression option help to improve performance while reducing storage costs. It allows significantly reduce overall database storage footprint by enabling compression for all types of data –relational (table), unstructured (file), index, network and backup
Read More »
Posted on January 24, 2017 by mudhalvan
What is the scenario: Exported the database using 12c expdp. Now we have to import into 11g Rel 2 database. What Command you used: impdp system/system directory=backup dumpfile=test12c.dmp logfile=test12.log schemas=test version=11.2 What Error message you get: ORA-39142 incompatible version Solution: impdp system/system directory=backup dumpfile=test12c.dmp logfile=test12.log schemas=test version=latest Note: You can also do expdp again with version=11.2 and do direct impdp
Read More »
Posted on January 3, 2017 by mudhalvan
Content-Type: text/html; charset=”utf-8″ This is the Test Post =
Read More »
Posted on December 30, 2016 by mudhalvan
How to setup Oracle 12c Upgrade and Migration Hands on Lab provided by Oracle corporation. You can very well setup on your laptop and does not required any special software. I created it on my laptop and to make comfortable. I created video and uploaded. You can setup on your laptop. Will try to add more.
Read More »