A Simple Photo of mine taken in Canary Wharf, London

Oracle Database

1. How to change oracle user account password?

1. Login to Oracle database using SQL Plus session.
2. Type the command "password" at the prompt. And follow the instructions

2. How to terminate a hung user session with oracle database?

1. Login to Oracle database as sysadm user.
2. Query the database for the following:
   select sid, serial#, status, username, osuser, program from v$session where status='ACTIVE';
3. Terminate the session.
   alter system kill session 'xx, xxxx'; where xx is sid, and xxxx is serial# of session.

MySQL Database

Visit the MySQL Website at: MySQL.com

vijay.theunixplace.com

Welcome to the home page of Vijay Chinnasamy- Database Page

Main menu: Home | Blog | Resume | ITIL | Unix/Linux | Databases | Contact |