Manual partitioning can help you to keep a critical table with fewer rows. Oracle offers the “partitioning” feature to split a table into n table partitions, in order to limit the records in a physical table.
A standby database is a DRP (Disaster Recovery Plan) solution, and it is nothing but a copy of the primary database, which can be automatically synchronized with Dataguard. Either using Dataguard or shell scripts for automatic or manual synchronization, the primary database must operate in archive mode.
In general, we write down SQL sentences and we execute them whithout analyzing any metrics. Metrics are important. A small improvement is multiplied by the times the statement is executed