You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for LOCK


1 to 20 of 614 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

POb ject Class

lock()Locks a persistent object on the database server. Syntax void lock( PObject::LockOption lock_option … object only after acquiring a lock; if the object is locked by another user, the pin call with this … option will wait until it can acquire the lock before returning to the caller; equivalent to SELECT … FOR UPDATE OCCI_LOCK_NOWAIT

Reference, 10g Release 1 (10.1)

V$LOCK

V$LOCKThis view lists the locks currently held by the Oracle Database and outstanding requests for a lock … or latch. Column Datatype Description ADDR RAW(4 | 8) Address of lock state object KADDR RAW(4 | 8 … ) Address of lock SID NUMBER Identifier for session holding or acquiring the lock TYPE VARCHAR2(2 … ) Type of

SQL Reference, 10g Release 1 (10.1)

LOCK TABLE

LOCK TABLEPurpose Use the LOCK TABLE statement to lock one or more tables, table partitions, or table … subpartitions in a specified mode. This lock manually overrides automatic locking and permits or denies … placed on the same table at the same time. Other locks allow only one lock for a table. A locked … savepoint before

Reference, 10g Release 1 (10.1)

V$LOCK

System Type Description System Type DescriptionLA.. LP Library cache lock instance lock (A..P = namespace) UN User name MM Mount definition global

Programmer's Guide, 10g Release 1 (10.1)

OCI Get Object Status Functions

lock (OUT)Return value for the lock status.

Programmer's Guide, 10g Release 1 (10.1)

OCI Pin, Unpin, and Free Functions

lock (IN)Lock option. See OCIObjectPin().

User's Guide and Reference, 10g Release 1 (10.1)

LOCK TABLE Statement

LOCK TABLE StatementThe LOCK TABLE statement locks entire database tables in a specified lock mode. That enables you to … LOCK TABLE". Oracle has extensive automatic features that allow multiple programs to read and write … ever, need to lock tables yourself. Syntax Description of the illustration lock_table_statement.gif … execute

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

library cache lockThis event controls the concurrency between clients of the library cache. It acquires a lock on the … object) This lock is also obtained to locate an object in the library cache. Wait Time: 3 seconds (1 … second for PMON) Parameter Description handle address Address of the object being loaded lock address … Address of the load

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

3 Database Concepts

3.11.2 Using LOCK TABLEYou use the LOCK TABLE statement to lock one or more tables in a specified lock mode. For example … use. EXEC SQL LOCK TABLE EMP IN ROW SHARE MODE NOWAIT; The lock mode determines what other locks can … time, but only one user at a time can acquire an exclusive lock. While one user has

Concepts, 10g Release 1 (10.1)

13 Data Concurrency and Consistency

Oracle Lock Management ServicesWith Oracle Lock Management services, an application developer can include statements in PL/SQL … blocks that: Request a lock of a specific type Give the lock a unique name recognizable in another … procedure in the same or in another instance Change the lock type Release the lock Because a reserved

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

PL/SQL lock timerThis event is called through the DBMSLOCK.SLEEP procedure or USERLOCK.SLEEP procedure. This event will most likely originate from procedures written by a user. Wait Time: The wait time is in hundredths of seconds and is dependent on the user context Parameter Description duration The duration that the user specified in the DBMS_LOCK.SLEEP or USER_LOCK.SLEEP procedures

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

row cache lockThe session is trying to get a data dictionary lock. Wait Time: Wait up to 60 seconds. Parameter

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

library cache load lockThe session tries to find the load lock for the database object so that it can load the object. The … load lock is always obtained in Exclusive mode, so that no other process can load the same object … . If the load lock is busy the session will wait on this event until the lock becomes available. Wait … loaded

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

global cache lock cleanupPMON is waiting for an LCK process to cleanup the lock context after a foreground process died … while doing a global cache lock operation. Wait Time: 1 second Parameter Description file# See "file#" block# See "block#" lenum See "lenum" on page A-8

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

DFS lock handleThe session waits for the lock handle of a global lock request. The lock handle identifies a global … lock. With this lock handle, other operations can be performed on this global lock (to identify the … global lock in future operations such as conversions or release).

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

DFS db file lockinstance holds a global lock on each file in shared mode. The instance that is trying to offline the … file will escalate the global lock from shared to exclusive. This signals the other instances to … synchronize their SGAs with the controlfile before the file can be taken offline. The name of this lock is

Application Developer's Guide - Workspace Manager, 10g Release 1 (10.1)

1 Introduction to Workspace Manager

1.15.5 Lock Management SubprogramsLock management subprograms control Workspace Manager locking. Table 1-9 shows the subprograms … available for lock management. Table 1-9 Lock Management Subprograms Procedure Description SetLockingON

Performance Tuning Guide, 10g Release 1 (10.1)

10 Instance Tuning Using Performance Views

library cache lockThis event controls the concurrency between clients of the library cache. It acquires a lock on the … the object This lock is also obtained to locate an object in the library cache.

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

batched allocate scn lock requestA session is waiting on another process to allocate a system change number (SCN). If the foreground timed out waiting on a process to get the SCN, the foreground will get the SCN. Wait Time: The wait time is 1 second on the assumption that an SCN allocation should normally need much less than that Parameters: None

Release 1.8, 10g Release 1 (10.1)

Defining and Controlling Transactions

Using the LOCK TABLE Statementfollowing error: ORA-01002: fetch out of sequence Using the LOCK TABLE Statement