Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the …
Read More »dbtut
How To Filter SQL Server Error Log(Like or Not Like)
The SQL Server Error Log file is one of the first places each DBA looks at in order to understand and solve the problem. …
Read More »Who Uses Temp Tablespace in Oracle
When you see that there is intense use of temp in a running database, it is necessary to determine who is using a temp …
Read More »How To Gather Statistics of a Table Partition(Update Partition Statistics)
When the table is large in Partitioned tables, the statistical update process is very long. Although the information we query will take place in …
Read More »How To Increase SQL Server Error Log File Count
For more information about SQL Server Error Log, you should type Error Log in our search section. SQL Server Error Log consists of 6 …
Read More »How To Report Exadata Disk Topology
Simply run the following script from any database server to query the physical disk, celldisk, griddisk, and flash disks on the cell nodes in …
Read More »SQL Server Alert List(sys.messages)
You can capture errors that occur on SQL Server with the help of the following query. You can generate alerts using any of these …
Read More »How To Restore RAC Database From rman backup
When a database completely crashes, you need to do is to setup from scratch and return from backup. If you have a Rman backup …
Read More »Oracle Exadata Default Passwords
Exadata installation is done with standard user name and password unless you specify otherwise. All standard passwords must be changed. The standard user name …
Read More »Mirror Backup On SQL Server(Multiple Copies of a Backup)
You may want to import a database backup on multiple disks as multiple copies. For example, suppose you have a storage that you use …
Read More »