The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the …
Read More »ORACLE
Materialized Views in Oracle Database
A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, …
Read More »How many Percent of ASM Disks are used?
In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of …
Read More »Oracle – Recreate Central Inventory in Clustareware in Linux
In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work …
Read More »How To Change the Size of Redo Log Files
In order to change the size of the Redolog files, it is necessary to create redolog files of the desired size and drop the …
Read More »How Many Redo Log Switches Per Hour
If Redo Log Switch count is too much, you can increase the redo log sizes if you need. However, the larger the Redo Log, …
Read More »About SQL Server and Comparison with Other Relational Database Management Systems
SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …
Read More »How To Query Transaction Count in Oracle
A script that you might need during database scaling. Calculation of transaction numbers between two specific dates. This script was tested in 11gR1 and 11gR2. …
Read More »Example of Using Data Pump
In this article I will share an example about data pump usage. First we start with export. EXPORT: [crayon-676c58f683d15442094851/] [crayon-676c58f683d19531603899/] or [crayon-676c58f683d1b879438092/] or [crayon-676c58f683d1c916654451/] …
Read More »Handling Oracle Audit Vault Services
In this article I’ll tell you how to stop Oracle Audit Vault Services. You should follow below sequence of steps: [crayon-676c58f683faf021660119/] [crayon-676c58f683fb3943997007/] [crayon-676c58f683fb5259395697/] [crayon-676c58f683fb6575798225/] …
Read More »