The process of querying the database table is locked statement which

2011-09-08  来源:本站原创  分类:Database  人气:110 

The process of querying the database table is locked statements which, to 'PTL_PARAMETER', for example, see 'PTL_PARAMETER' table which the user is locked:

SELECT A.OWNER,
A.OBJECT_NAME,
B.XIDUSN,
B.XIDSLOT,
B.XIDSQN,
B.SESSION_ID,
B.ORACLE_USERNAME,
B.OS_USER_NAME,
B.PROCESS,
B.LOCKED_MODE,
C.MACHINE,
C.STATUS,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM
FROM ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )
and A.Object_Name = 'PTL_PARAMETER'
ORDER BY 1,2
相关文章
  • The process of querying the database table is locked statement which 2011-09-08

    The process of querying the database table is locked statements which, to 'PTL_PARAMETER', for example, see 'PTL_PARAMETER' table which the user is locked: SELECT A.OWNER, A.OBJECT_NAME, B.XIDUSN, B.XIDSLOT, B.XIDSQN, B.SESSION_ID, B.ORACLE_USERNAME,

  • Database table is locked 2011-03-06

    The afternoon of March 3, there was a serious system failure, a large number of daemon throws the following exception: DBCP object created 2011-03-03 12:35:19 by the following code was never closed: java.lang.Exception at org.apache.commons.dbcp.Aban

  • About the value of encoding used to store an unlimited hierarchical tree structure of the database table design 2009-02-05

    About the value of encoding used to store an unlimited hierarchical tree structure of the database table design, here is detail. Here I tried to use relatively short text, few graphics, and related core sql statement to describe the design: First, we

  • JBPM database table creation 2009-12-31

    Jbpm the process definition and process execution will be persisted to the database, so we need to create the required database, database tables, database tables to create the following three ways. 1. Manually create <br /> after decompression in th

  • cakephp update changes the database table learning problems 2010-03-12

    Modify the database table update problem The process of doing the project, due to changes in customer demand, the project process should be done accordingly with the changes. I remember one time the project is based on cakephp framework mysql databas

  • DatabaseMetaData usage (transfer) method to obtain the database table structure 2010-03-10

    DatabaseMetaData usage (transfer) 2008-08-07 at 12:25 1. Be an instance of this object Connection con; con = DriverManager.getConnection (url, userName, password); DatabaseMetaData dbmd = con.getMetaData (); 2. Methods getTables usage <br /> prototy

  • Database table design details 2010-03-23

    The principle of building a database table Database table and field names, design SQL Optimization - Index Set the table for a field (in oracle example) For any field length should not be too stingy, or unknown cause before and after the change sets

  • Cursor by querying the database was populated listview problems 2010-05-08

    1, obtained by querying a database filled listView Cursor section must qurey the projection of _id of this column contains the table, otherwise error of. Why does this column? We believe that, when filled, will listView Item with each table correspon

  • MySQL, SQLSERVER, ORACLE for database table names and field names of the methods 2010-06-29

    1, MySQL Get table name: Use "show tables" command. Can also be used in the procedure to obtain the order, in return RowSet in the "Tables_in_db" time out. Which "db" is the name of your database, for example Tables_in_produc

  • Vocabulary database table 2010-08-27

    1. Access method (access method): This step, from document storage and retrieval of records. 2. Alias (alias): another name for an attribute. In SQL, you can replace the table with the alias name. 3. Alternate keys (spare key, ER / relationship model

  • MySQL, SQLSERVER, ORACLE for database table names and field names 2011-05-27

    1, MySQL Get table name: With "show tables" command. Can also be used in the procedure to obtain the order, in return RowSet in the "Tables_in_db" read out. Where "db" is the name of your database, for example Tables_in_produ

  • Analysis of the database table connections and common usage 2011-07-25

    2009-12-20 22:22 27 Read Comments (0) Add report Original Address: http://database.ctocio.com.cn/197/9015697_2.shtml Analysis of the database table connections and common usage The connection table is in a SQL statement by the association between tab

  • The Oracle architecture - database table space instances Introduction 2010-10-29

    First, the database Database suggests that it is a collection of data, but Oracle is the management of these data collection software system, it is an object-relational database management system. Second, the table space Oracle table space is related

  • Oracle database table using the index to improve query speed 2011-02-13

    Oracle database table using the index to improve query speed in the index table stored in the ROWID of the disease is not the actual physical address of record, but the logical physical address. Therefore, some database administrators to index table

  • Large forum such as the design of the database table structure 2011-03-02

    Do not consider this issue first, according to business requirements to design. After completion of performance testing, and then determine whether to optimize the database, according to the performance test results to develop optimal solutions. You

  • ORACLE database table partitions (rpm) 2011-04-16

    1.1 Partition Table PARTITION table In ORACLE, especially if you encounter a large table, you can use the partition table to change the application's performance. 1.1.1 The establishment of the partition table: A company's annual sales have a tremend

  • the process of creating a database manually under linux 2011-06-15

    1 Stop the database sqlplus / nolog conn / as sysdba; shutdown 2 Create sid, modify the oracle user environment variables. Bash_profile file returns the root directory of the oracle user cd Enter vi. bash_profile As follows: PATH = $ PATH: $ HOME / b

  • Export oracle database table structure to the word 2011-08-16

    Due to the work requirements, write software, operating documentation, but after the software production process in the continuously changing, and some of the original design document form table structure with the current structure with greater acces

  • PowerDesigner generates database table SQL script to build double quotes 2010-03-10

    PowerDesigner generates a database table using SQL script building, especially Oracle database, the table name with quotation marks generally. In fact, the quotes are PL / SQL specification, the database will be strictly in accordance with the ""

  • Steps on the database table design 2010-03-31

    The design of the database table 1, the first based on relevant business needs (mainly refer to output and input conditions) planning out the basic structure 2 state of the field based on business rules design 3, according to the company or departmen