Oracle table partitioning: why, when and how

Why partitioning: Enhances the performance, manageability, and availability. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces. When to partition a table: Tables larger than 2gb size. Historical data Contents must be stored in different storage Avoid index maintenance when data is removed Index maintenance on parts of data like rebuilding…

Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…