kill session

View the lock table process SQL statement 1:SelectSess.sid, sess.serial#, Lo.oracle_username, Lo.os_user_name, AO.object_name, Lo.locked_mode fromv$locked_object Lo, dba_objects ao, v$session sesswhereAo.object_id =Lo.object_id

Manually deleting an Oracle database user often occurs when the session process is still in use causing the deletion to fail. It is inconvenient to query the session and delete the session to successfully delete the database user.Applicable

--View lock table process SQL statements 1:select Sess.sid, sess.serial#, Lo.oracle_username, Lo.os_user_name, Ao.object_name, Lo.locked_ Modefrom v$locked_object Lo, dba_objects ao, v$session sesswhere ao.object_id = lo.object_id and lo.session_id =

Java small rookie one, remember the interviewer once asked me a question, is that you use SQL statements, in addition to write and delete changes, but also wrote what other orders did not, at that time really do not remember, so I intend to record,

SELECT l.session_id SID,SUBSTR (O.owner,1,8) Owner,O.object_type Object_type,SUBSTR (O.object_name,1,) object_name,Decode (L.locked_mode,0,' None ',1,' Null ',2,' Row-s ',3,' Row-x ',4,' Share ',5,' S/row-x ',6,' Exclusive ')

Resolve Oracle Database Ora-00054:resource busy and acquire with NOWAIT specified errorWhen I use the PL/SQL Developer client call stored procedure to find a halfway card machine and then force termination of PL/SQL developer, Oracle has been locked

1. Querying for locks in the databaseSELECT * from V$lock;SELECT * from V$lock where block=1;2. Querying for Locked objectsSELECT * from V$locked_object;3. Query blockingCheck for blocked sessionsSELECT * from V$lock where lmode=0 and type in (' TM '

A developer directly on the database server to do the delete table operating system, from the time of the peak operation, resulting in a long time to execute unresponsive, and then shut down the Sqlplus client, run the DELETE statement again,

--cmd Import and Export database BMP file　1. Execute the statement in the query result ( select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0 '2. Then execute cmd = = "Import: Imp admin/[email protected]

Today in the project development, in order to test the project SQL execution effect, with Plsql developer execution, no commit to continue to tap the code, and then re-use Plsql Developer, may be network reasons, Plsql Developer disconnected from

Oracle session connection number and inactive issue recordhttp://timnity.javaeye.com/blog/280383Since last week, the server Oracle database problems, in less than half a day, will be reported maxsession (150) problem, it is certain that the database

The so-called lock wait: is a transaction A to a data table DDL or DML operation, the system will be added to the table-level lock, when the other transaction to the table operation will wait for a commit or rollback, before you can continue the

PL/SQL login for a short time session automatically disconnects1. First look at your profile file for this userSelect profile from dba_users where username= ' username ';2. Review the Idle_time settings in the profile fileSELECT * from Dba_profiles

Tmux (full name is Terminal multiplexer) is an excellent end-use software, similar to GNU screen, but from OpenBSD, with BSD licensing. The most intuitive benefit of using it is that when you log in to a remote host through a terminal and run Tmux,

If there is a lock waiting, we might be more interested in knowing who locked the table and who's waiting.The following statement can query who locked the table: Copy Code code as follows: SELECT/*+ Rule * * s.username, Decode

ORACLE EBS operates on a form interface, or when a background database operates on a table, it is found to be "suspended animation", possibly because the table is locked by a user, causing other users to fail to continue Copy Code code as

During the execution of the system, the user forcibly disconnects the client from the database server by shutting down Pl/sql because of the long operation time on a table, but the database server-side session still continues, and the table is

--Query for locked tables and related session information SELECT object_name,        session_id SID,         MACHINE,        VS. MODULE,        ' alter   system   kill   session    ' | | session_id | | ',' ||        serial# | | ''';'

1. Oracle differs from SQL Server 2005.On the macro level:1. The biggest difference is that the platform, Oracle can run on different platforms, SQL Server can only run on the Windows platform, because the stability and security of Windows platform

Oracle I. Common problems 1. Initial password after Oracle installation completed Internal/oracle Sys/change_on_install System/manager Scott/tiger Sysman/oem_temp 2. Oracle9iAS WEB Cache's initial user and