Enabling the archive log mode in the RAC database is slightly different from the normal database. You can enable archive log mode in the rac …
Read More »ORACLE
How To Access SESSION Information in Oracle from the Process ID in the Operating System
You can use the following script to access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-6628e0b5e9e88227622696/] If your …
Read More »DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports
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 »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 »