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 as it actually reduces the size the data takes or is occupied by the database. We have two categories of …
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 in maintaining the performance of a system as it actually reduces the size the data takes or is occupied by …
Flashing back query, table, database in Oracle Using advanced Oracle techniques Read More »
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 technologies of the Oracle 12C such as the cloud computing etc. This needs to be noted that the this multitenant …
Multitenant Architecture and Pluggable Databases – Using advanced Oracle techniques Read More »
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 third party tool or used to write a considerable amount of coding to do the testing. Since it is necessary …
Oracle database replay – Using advanced Oracle techniques Read More »
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 the period. This feature is also a licensed feature whereby which comes along with the advanced compression only and thus …
Flashback data archive – Using advanced Oracle techniques Read More »