oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top …
Read More »
oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top …
Read More »Find a Column Name in Whole Database Sometimes you may want to search for a column name in whole database. Instead of looking all the …
Read More »During the database shutdown process, this alert is written to the alert log file because the processes of the running jobs cannot be propagated. The …
Read More »In particular, if you are using Always On Availability Group and you haven’t included some of your databases to an always on availability groups, in …
Read More »With a feature that introduced with 12c R2, we can see the history of Sqlplus and run the commands we have run without rewriting. By …
Read More »One of the first steps a good database administrator should take when looking at a database system is to find and remove unused indexes and …
Read More »It is possible to forget the passwords of the users in the DB Links created for the communication between Oracle databases. These users’ passwords can …
Read More »Index is an object that improves performance in the database in general. Many inexperienced database administrators or application developers create too much index thinking that …
Read More »Enable DDL Auditing in 11g It is possible to enable ddl auditing in a database or shema. In this way, we can monitor all DDL …
Read More »In the database, especially during the new development phase, indexes are the most important performance providers for us. You should be familiar with the index …
Read More »