yourfirstserver.comThursday, 24 May 2012
Find Us on : RSS/Feed Facebook Twitter

How To Check Oracle Processes In Windows Using Command Line?

Is there any command in Windows like ps command in Unix?

How to check Oracle processes in windows. This is burning problem for every Oracle DBA.

In unix there is command called “ps“. Using ps command Oracle DBA can check all type of processes which are running in system. Ps command is very useful to administrating and monitoring oracle in unix/linux systems for all Oracle DBA.

But there is no command available in windows just like ps in unix! Means there is no way to

...

5 Useful Mysql Command Options-Pager-Prompt-Rehash-Tee-System

There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them.

Below are the 5 most useful MySQL Command Options.

1. \# OR rehash: Enable automatic rehashing.

Do you have long table names, you find it difficult to remember tablenames or you’re just as lazy as I am, rehashing is good for you.
Enter:
mysql> \#
or
mysql> rehash
This enables database, table, and column name completion.
To complete a name, enter the initial part of name and

...

Mysql Command Line

MySQL is a very powerful open source database which means that it is free to use. One of the many tools that come with MySQL is their MySQL Command Line that will allow you to do pretty much everything from create a database to add and edit entries in the database. This article will help you to begin using MySQL Command Line Successfully.

When you install MySQL you will receive a command line application where you can create new databases, modify current databases, and delete databases.

Once you launch the MySQL Command Line Client you will be prompted for a

...