Compression is a feature whereby we are reducing the storage footprint of a database by reducing the size of a table or so. This technique is very helpful in maintaining the performance of a system …
Read More »Using advanced Oracle technologies
Flashing back query, table, database in Oracle Using advanced Oracle techniques
Flashing back query, table, database in Oracle Compression is a feature whereby we are reducing the storage footprint of a database by reducing the size of a table or so. This technique is very helpful …
Read More »Multitenant Architecture and Pluggable Databases – Using advanced Oracle techniques
One of the most advance features of the Oracle 12C is the multitenant architecture of the Oracle 12C. It is generally known as the pluggable databases which were developed to take advantage of the latest …
Read More »Oracle database replay – Using advanced Oracle techniques
Oracle database replay It is a tool whereby we can do realistic application testing for testing the performance for workload and database monitoring. Initially when Oracle was not offering such services , one used a …
Read More »Flashback data archive – Using advanced Oracle techniques
This is referred as the database mechanism which allows to store all the row versions in a table over the lifetime. Therefore by using this no versions or stages of the table is lost during …
Read More »