ORACLE

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 …

  A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, …

  In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of …

  In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work …

  In order to change the size of the Redolog files, it is necessary to create redolog files of the desired size and drop the …

  If Redo Log Switch count is too much, you can increase the redo log sizes if you need. However, the larger the Redo Log, …

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 …

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. …

  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/] …

  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/] …