| very urgent..drop user username hangs..what to do.. [message #50139] |
Sun, 03 March 2002 23:06  |
ksr
Messages: 112
Registered: January 2002
|
Senior Member |
|
|
Hi,
I have issued drop user username cascade;
It hangs for a long time and there is no response at all.
What may be the problem with the database.
There are no people working on this database and they are no database operations going on.
I have shutdown the database and restarted it.It went fine.
After that,i have again issued drop user username cascade.
Still it hangs.I have waited for nearly an hour,but still it does not drop the user.
Any help is appreciated..
|
|
|
|
| Re: very urgent..drop user username hangs..what to do.. [message #50154 is a reply to message #50139] |
Mon, 04 March 2002 05:55  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Are you sure the user is not connected. Use this query before you do the drop.
rem =========================================================================
rem
rem ps.sql
rem
rem Copyright (C) Vladimir Begun, 1999
rem
rem Downloaded from http://www.oriolecorp.com
rem
rem This program is free software; you can redistribute it and/or modify
rem it under the terms of the GNU General Public License as published by
rem the Free Software Foundation; either version 2 of the License, or
rem any later version.
rem
rem This program is distributed in the hope that it will be useful,
rem but WITHOUT ANY WARRANTY; without even the implied warranty of
rem MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
rem GNU General Public License for more details.
rem
rem You should have received a copy of the GNU General Public License
rem along with this program; if not, write to the Free Software
rem Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
rem
rem =========================================================================
rem
rem like Unix ps command
rem
SET LINE 132 PAGESIZE 1000 FEED OFF;
COLUMN "sid_serial" FORMAT A12
COLUMN "user" FORMAT A10
COLUMN "st" FORMAT A8
COLUMN "schema" FORMAT A10
COLUMN "osuser" FORMAT A10
COLUMN "box" FORMAT A20
COLUMN "prg" FORMAT A30
COLUMN "logon_time" FORMAT A22
SELECT
''''
|| sid
|| ','
|| serial#
|| ''';' "sid_serial"
, username "user"
, status "st"
, schemaname "schema"
, osuser "osuser"
, machine "box"
, program "prg"
, TO_CHAR(logon_time, 'DD.MM.YYYY HH24:MI:SS') "logon_time"
FROM
v$session
WHERE type <> 'BACKGROUND'
ORDER BY
osuser,program
/
PROMPT ALTER SYSTEM KILL SESSION;
SET LINE 120 PAGESIZE 25 FEED ON;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
