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 731 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 15 of 22

lock()This method locks a persistent object on the database server. Syntax void lock(PObject::LockOption … lock_option); Parameters lock_option Specifies whether the lock operation should wait if the object

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 27 of 36

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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Dynamic Performance Views for Tuning

V$LOCKThis view has a row for every lock held or requested on the system. You should examine this view if … you find sessions waiting for the wait event enqueue. If you find sessions waiting for a lock, then … the sequence of events could be the following: Use V$LOCK to find the sessions holding the lock … . Use V$SESSION

Reference, 9i Release 2 (9.2.0.2)

Dynamic Performance (V$) Views, 96 of 238

V$LOCKa 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 user or system lock The locks on the user types are obtained by user applications. Any

Deployment and Performance, 9i Release 2 (9.2.0.2)

Configuring Multi-Block Lock Assignments (Optional)

Lock Namessyntax of lock names is type ID1 ID2, where: type-- Is always BL because locks are buffer locks. ID1 … -- The database address of the blocks. ID2-- The block class. Examples of lock names are: BL (100, 1 … )-- This is a data block with lock element 100. BL (1000, 4)-- This is a segment header block with lock

Concepts, 9i Release 2 (9.2.0.2)

Using Multi-Block Lock Assignments (Optional)

Lock GranularityThere are two levels of lock granularity: 1:1 locks, which is the default, and 1: n locks. 1: n … locks implies that a lock manages two or more data blocks as defined by the value for n. With 1: n … locks, a few locks can manage many blocks and thus reduce lock operations. For read-only data, 1: n … GC_FILES_TO_LOCKS parameter

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Oracle Database Event Tests

Lock Limitoperations. This event test checks for the utilization of the lock resource against the values (percentage

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: ALTER TABLE to ALTER TABLESPACE, 2 of 3

TABLE LOCKtables. ENABLE TABLE LOCK Specify ENABLE TABLE LOCK to enable table locks, thereby allowing DDL … operations on the table. DISABLE TABLE LOCK Specify DISABLE TABLE LOCK to disable table locks, thereby

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 14 of 19

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

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 15 of 36

lock (OUT)Return value for the lock status.

Deployment and Performance, 9i Release 2 (9.2.0.2)

Configuring Multi-Block Lock Assignments (Optional)

Lock Names and Lock FormatsThe following section describes the lock names and lock formats of locks. The topics in this … section are: Lock Names and Lock Name Formats Lock Names Lock Types and Names

Deployment and Performance, 9i Release 2 (9.2.0.2)

Configuring Multi-Block Lock Assignments (Optional)

Lock Names and Lock Name FormatsInternally, Oracle global lock name formats use one of the following formats with parameter … descriptions as shown in Table A-4: type ID1 ID2 type, ID1, ID2 type (ID1, ID2) Table A-4  Lock Name … Format Variable Descriptions Variable Meaning type A two-character type name for the lock type, for … example, BL, TX, TM ID1 The first

Concepts, 9i Release 2 (9.2.0.2)

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

Deployment and Performance, 9i Release 2 (9.2.0.2)

Configuring Multi-Block Lock Assignments (Optional)

Lock Assignment ExamplesDATABASE... DATAFILE... RESIZE statement, then you may also need to adjust the lock assignment. When … 120 blocks, which is a multiple of 60. Each lock covers two data blocks. In datafiles 2 and 3, 40 … locks map to a total of 160 blocks. A lock can cover either one or two data blocks in datafile 2, and … two or three data blocks

Reference, 9i Release 2 (9.2.0.2)

Oracle Wait Events, 5 of 5

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: duration The duration that the user specified in the DBMS_LOCK.SLEEP or USER_LOCK.SLEEP procedures

Deployment and Performance, 9i Release 2 (9.2.0.2)

Configuring Multi-Block Lock Assignments (Optional)

Lock Types and Namesand Names Type Lock Name Type Lock Name CF Controlfile Transaction PS Parallel Execution Process … Recovery TX Transaction IV Library Cache Invalidation UL User-Defined Locks L[A-P] Library Cache Lock … Registration Attribute Lock PF Password File XI Instance Registration Lock PR Process Startup Copyright

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Introduction

1.3 Lock Managementspecified rows, or some combination: Lock at the workspace level ( SetWorkspaceLockModeON procedure) if … to be locked. Lock at the session level ( SetLockingON procedure) if the data changes are being made … workspaces in which the session participates. Lock specific rows ( LockRows procedure) either to lock the

Deployment and Performance, 9i Release 2 (9.2.0.2)

Monitoring Performance in Real Application Clusters with Oracle Performance Manager

Row Cache Lock ChartThe Row Cache Lock chart displays the following statistics for the entire cluster database: The … dlm_requests which is the number of times DLM lock requests are generated for consistent read blocks … The dlm_conflicts which is the number of times when another instance already owned a lock on a … to the Row Cache Lock

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 28 of 52

LOCK TABLE StatementThe LOCK TABLE statement lets you lock entire database tables in a specified lock mode. That … enables you to share or deny access to tables while maintaining their integrity. For more information, see "Using LOCK TABLE".

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Database Concepts

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