Oracle

warning: Creating default object from empty value in /var/www/html/modules/taxonomy/taxonomy.pages.inc on line 34.

Oracle Kill Session How To

| October 6, 2010

This will obtain a list of sessions:

SELECT s.sid,
s.serial#,
s.osuser,
s.program
FROM v$session s;

Kill a session using the following syntax:

ALTER SYSTEM KILL SESSION ’sid,serial#’;

Renaming an Oracle Database

| October 6, 2010

Back in the old’n days (pre 9i) renaming an Oracle database meant modifying your control file, manually changing the name within the data dictionairy in multiple places, then finally changing the name in any external configuration files and scripts.  The process has been streamlined a bit since then with the introduction of the Oracle dbnewid utility, nid.  DBNEWID will update your control files as well as all your data files, all in one fell swoop!  This utility can also change your database’s DBID if you like.

DBNEWID Options: