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() → 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
V$LOCK → This 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
LOCK TABLE → Purpose 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
System Type Description System Type Description → LA.. LP Library cache lock instance lock (A..P = namespace) UN User name MM Mount definition global
lock (OUT) → Return value for the lock status.
lock (IN) → Lock option. See OCIObjectPin().
LOCK TABLE Statement → The 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
library cache lock → This 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
3.11.2 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
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
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 Description duration The duration that the user specified in the DBMS_LOCK.SLEEP or USER_LOCK.SLEEP procedures
row cache lock → The session is trying to get a data dictionary lock. Wait Time: Wait up to 60 seconds. Parameter
library cache load lock → The 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
global cache lock cleanup → PMON 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
DFS lock handle → The 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).
DFS db file lock → instance 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
1.15.5 Lock Management Subprograms → Lock 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
library cache lock → This 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.
batched allocate scn lock request → A 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