We use grep command to search for strings in the Unix Operation system. Now when we work on Windows , we dont have grep command in Windows, So We often look for grep equivalent in windows.This problem can be solved on Windows using these three free tools. These tools can do many work same as […]
How to use grep command in Unix and Linux with examples
grep command Means – globally search regular expression. It is very useful while searching for strings in Unix and Linux operating system. Here we would be taking a look on grep command in Unix with examples,Linux grep examples,grep command options,egrep command in Unix How to use grep command in Unix The grep utility searches text […]
How to change the DBNAME /DBID using DBNEWID(nid) utility for Oracle database
The DBNEWID(NID) Utility is a new utility introduced with Oracle database. The NID Utility in oracle allows you to change only the DBNAME, or only the DBID or both DBNAME and DBID in the same command.Lets discuss each of these option in detail and how to implement Change Only the DBID using NID Utility Here […]
Top 10 Oracle Database Security Best Practices
Critical data are stored in database and data leaks can jeopardize the organization. So database security is very important. Database Security has always been a concern for a Database Administrator. However, Oracle Database is very much secure, even then there are gaps which has to be filled by DBA to make Oracle Database Secure. Oracle […]
Query to get session details in oracle database
Many times DBA need to look at the session details for analysis. The details includes sql_id, stats ,locking ,wait events.Here I am giving Query to get session details in oracle database,how to get the sql text from sid in oracle and other queries which will help in troubleshooting Query to get session details in oracle […]
Query to find full table scans in oracle
Many times the performance of the database will be slow.We need to first find out if any big table full table scan is going on. Lets first check out what is Full table scan and then We will see the query to find full table scans in oracle What is Full table Scan Full table […]
