HI Guys, We were put in a Situation that we had to Create the New data files for the tablespaces in the RECO diskgroup …
Read More »Correction of Corrupted UNDO tablespace.
If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. ORA-00376: file string cannot be read …
Read More »How To Move The Tempdb Database To Another Disk On SQL Server
I explained how to change the disks of a normal database in the article “How To Change The Disk Of Database Files On SQL …
Read More »MySQL updatable/Insertable views
In MySQL, views are not only query-able but also updatable. It means that you can use the INSERTor UPDATE statement to insert or update rows of the base table through the …
Read More »AWR baseline drop operation
The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots. Therefore, it is necessary …
Read More »SQL Server Startup Parameters
With SQL Server Startup Parameters, the location of certain files in the startup phase of the SQL Server service, and some conditions in the …
Read More »14 Tips for upgrading Oracle RAC from 11g to 12c
Note: These tips were based on upgrades from 11.2.0.4 to 12.1.0.2 (Linux and Solaris ONLY) OS user grid was the “owner” of the Grid …
Read More »DAC(Dedicated Administrator Connection) On SQL Server
Sometimes SQL Server becomes inaccessible and DBA cannot even intervene. In such cases, there is a back door so that DBAs can find and …
Read More »Querying Oracle alert.log Errors With SQL Query
You can query errors in Alert.log by sql query. You can use the following queries for this. The following query returns with 20 rows. …
Read More »DB2-Database Monitoring-1
Hello Everyone, This is my first blog here regarding db2 database monitoring.I am going to start from the basic level ,therefore starts and learners …
Read More »