How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
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
lock (IN) → Lock option. See OCIObjectPin().
V$LOCK → This 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
V$LOCK → 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 user or system lock The locks on the user types are obtained by user applications. Any
Lock Names → syntax 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
Lock Granularity → There 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
Lock Limit → operations. This event test checks for the utilization of the lock resource against the values (percentage
TABLE LOCK → tables. 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
LOCK TABLE → Purpose 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
lock (OUT) → Return value for the lock status.
Lock Names and Lock Formats → The 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
Lock Names and Lock Name Formats → Internally, 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
Oracle Lock Management Services → With 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
Lock Assignment Examples → DATABASE... 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
PL/SQL lock timer → This 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
Lock Types and Names → and 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
1.3 Lock Management → specified 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
Row Cache Lock Chart → The 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
LOCK TABLE Statement → The 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".
Using LOCK TABLE → You 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