oracle how to view a table that was locked, which users and other

2010-06-24  来源:本站原创  分类:Database  人气:177 

See the table is locked:
select p.spid, c.object_name, b.session_id, b.oracle_username, b.os_user_name from v $ process p, v $ session a, v $ locked_object b, all_objects c where p.addr = a.paddr and a.process = b.process and c.object_id = b.object_id

Unlock:
alter system kill session '146 '; (146 to lock the process ID)

相关文章
  • oracle how to view a table that was locked, which users and other 2010-06-24

    See the table is locked: select p.spid, c.object_name, b.session_id, b.oracle_username, b.os_user_name from v $ process p, v $ session a, v $ locked_object b, all_objects c where p.addr = a.paddr and a.process = b.process and c.object_id = b.object_i

  • oracle database, view the table space usage 2010-03-29

    oracle database, view the table space usage; oracle tablespace should always see what the situation is generally idle too low when the ratio should consider increasing the table to see space. See as follows SQL: Method 1: select dbf.tablespace_name,

  • Oracle \ MS SQL Server database table associated with multiple and multi-table update update UPDATE 2010-04-06

    http://hi.baidu.com/suofang/blog/item/249c067b40c8def00ad187aa.html An Update update statement is more than one table can not be updated, unless the trigger implicit update. And table update operation, in many cases need to be updated in the referenc

  • Oracle learning path [c] cache table 2010-12-03

    ================================================== ======================= oracle BUFFER CACHE provides multi-pool technology . Into the buffer cache :default,keep ,recycle . By default, all tables are in default under the . Oracle The db_buffer_pool

  • Oracle database in the temporary table usage 2010-12-05

    This article introduces the Oracle database in the temporary table usage, we hope to help study and work. A: Grammar In Oracle, you can create two temporary tables: (1) session-specific temporary table CREATE GLOBAL TEMPORARY ( ) ON COMMIT PRESERVE R

  • Oracle Database how to create table space 2011-08-04

    oracle how to create the table space and the backup data 1 Create a data table space CREATE TABLESPACE "chenxm" LOGGING DATAFILE 'E: \ spaces_eu \ chenxm.ora' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; ALTER DATABASE DATAFI

  • oracle 10g in the Flashback Table feature 2010-10-26

    Contact oracle10g the beginning, some time on the table to delete the class action when there are many names found in the database hash table BIN $*******=$ 0, that is their due to operator error, and then I This is a deleted table in the recycle bin

  • Oracle Learning path [three] cache table 2010-12-03

    ================================================== ======================= oracle Provides BUFFER CACHE multi-pool technology . The buffer cache is divided into :default,keep ,recycle . By default, all tables are in default under the . Oracle The db_

  • oracle Study Notes - view. Index 2011-02-14

    1 view (VIEW) 1.1 is a conceptual view ----- SELECT query (either a single table or multi-table query) defines a "logical form", only the definition of no data, is a "virtual table." When creating the view, but the definition of the vi

  • Chapter 4 Oracle synonymous sequence view. Index 2011-05-08

    Chapter 3, Oracle locks, table partitioning Chapter 5 Using Oracle PL / SQL Chapter 4 Oracle synonyms, sequences, views, indexes 1, the technical objectives Use synonyms Using the sequence Create view Creating an index 2, what is the Oracle database

  • oracle character set view 2010-06-08

    Through the oracle system administrator view Server character set: select name, value $ from props $ where name = 'NLS_CHARACTERSET'; Client character set: select userenv ('LANGUAGE'), userenv ('LANG') from dual;

  • Oracle to delete the user table 2010-08-16

    The following article is primarily about the user tables in Oracle to delete the actual operation project, this article mainly related to the practical application of the code of the Fang Shi Lai raises Qi practice of operating steps, Yi Xia Wen Zhan

  • ORACLE database query basic information table, primary keys, foreign keys, etc. 2011-07-23

    ORACLE database query basic information table, primary keys, foreign keys, etc. Because the project some of the module data structure design is not strictly in accordance with a standard design, we can only query data from the database structure, you

  • oracle - to build a small table title 2010-09-30

    create table myemp as select * from emp; // This statement is executed, will complete table structure and data copied out , Create table emp as temporary table goes Add Data : insert Statement, and insert a null value is not inserted , Effect is the

  • Oracle study notes explain the table cache 2011-04-09

    Oracle study notes explain the table cache http://database.51cto.com 2010-04-16 13:52 Anonymous I want to comment (0) Abstract: The current network appears on the "Oracle Cache Table" question, greatly accelerates the finishing line to find some

  • View the table space 2011-08-19

    -- View a table of size -- select sum(bytes) / (1024 * 1024) as "size(M)" from user_segments where segment_name = upper('tbl_mo_part_00'); -- View index number and type of -- select index_name, index_type, table_name, t.sample_size from user_ind

  • oracle create user and password, user empowerment, view the table space 2010-07-15

    Create temporary table space Create temporary table space CREATE TEMPORARY TABLESPACE test_temp TEMPFILE 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl \ test_temp01.dbf' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; Create

  • oracle 10g how to view a table space, what are the table 2010-02-26

    Want to see what are inside a table space table, you can use: select * from dba_tables where tablespace_name=' Table space names '

  • Oracle used to view table structure command 2011-06-20

    Get table: select table_name from user_tables; / / current user's table select table_name from all_tables; / / all user tables select table_name from dba_tables; / / include system tables select table_name from dba_tables where owner = 'username' use

  • Oracle View the table space 2011-05-09

    select dbf.tablespace_name, dbf.totalspace " The total amount (M)", dbf.totalblocks as " Total number of blocks ", dfs.freespace " Total remaining (M)", dfs.freeblocks " The remaining number of blocks ", (dfs.freesp