Below is the query that can help you with multiple enqueue.
This has some useful DBA stuff, which is a collection of my learning and experience. It has the information which is useful in practical aspect.
Thursday, June 9, 2011
Wednesday, June 8, 2011
Locks in Database
Locks are mainly helpful to serialize jobs. Lock on a object is required by a session to update/edit the same, and if some other session wants to update it then it has to wait until earlier one releases the object and it comes to a consistent state.
This may be an object level enqueue to get the object edited by different sessions, or may be library lock/pin for the latch being used. But its dba who can decide what session should not be allowed to proceed or to be terminated taking others on priority.
Below are few of those tables and views that can help in identifying all kinds of locks
This may be an object level enqueue to get the object edited by different sessions, or may be library lock/pin for the latch being used. But its dba who can decide what session should not be allowed to proceed or to be terminated taking others on priority.
Below are few of those tables and views that can help in identifying all kinds of locks
Friday, May 27, 2011
Direct Login to forms in eBusiness Suite
The usual url for loggin in to Oracle Application is
http://<server name>:<port>/
which most of the times gets directed to
http://<server name>:<port>/OA_HTML/AppsLocalLogin.jsp
But for some reason or for troubleshooting purpose we may need to login directly to forms.
Below are the urls for directly connecting forms.
http://<server name>:<port>/
which most of the times gets directed to
http://<server name>:<port>/OA_HTML/AppsLocalLogin.jsp
But for some reason or for troubleshooting purpose we may need to login directly to forms.
Below are the urls for directly connecting forms.
Subscribe to:
Posts (Atom)