Create Notification For Blocking Session
Aug 1, 2013I want to create notification/ or triggered mail to my client and my dba group which will occur while session and user has been blocked. I want to create this procedure in 12c OEM.
View 3 Replies
ADVERTISEMENT
Not Able To Find Blocking Session
Jan 10, 2013I am working on oracle 11g and AIX.We were facing some blocking issues.For more investigation on the blocking sesssion we checked active session history of the database.Like session 'A' was blocked by session 'B' ...Now if we check infromation about sessions 'A' it is showing that this session was blocked by session 'B'.
But when we checked for session 'B' informaiton ,it is not showing any thing...from where we can get infromation about session B and in what all scenarios active session history does not show information about blocking session....
Server Administration :: Logwr Database Blocking Other Session
May 24, 2013One issue happens frequently in My database,Logwr process blocking other session,when i checked blocked session in v$session wait_class was commit and event was logfile sync,
EVENT# WAIT_CLASS
------ ----------------------------------------------------------------
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
115 Configuration
116 Commit
116 Commit
116 Commit
116 Commit
EVENT# WAIT_CLASS
------ ----------------------------------------------------------------
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
116 Commit
EVENT# WAIT_CLASS
------ ----------------------------------------------------------------
As per this we predicate Logbuffer Might be full so i just to reboot server,Note server was 32 Bit i can allocate only 1GB of SGA SYStem not allows me to increase SGA further. Server reboot is proper solution?
Object Locked But Can't Find Session / Process Blocking?
Sep 5, 2012I am on database 10.2.0.5, windows x64.
A developer calls me and tells me there are locks on 3 tables, and the locks are not released. So I run this to see which objects are locked by which session
select vlo.object_id, vlo.session_id, vlo.oracle_username, vlo.process
, DECODE(vlo.LOCKED_MODE, 0,'NONE', 1,'NULL', 2,'ROW SHARE', 3,'ROW EXCLUSIVE', 4,'SHARE', 5,'SHARE ROW EXCLUSIVE', 6,'EXCLUSIVE', NULL) LOCK_MODE
, do.owner, do.object_name, do.object_type
[code]...
When I run the query later, I sometimes get another session, but the lock stays. It seems here, that I am catching the same SID on new sessions, but it is probably a different serial # than the original session locking the table rows.
I get nothing from
select * from dba_waiters;
select * from dba_blockers;
Now why are those 3 tables row locked on some rows and I can't find the session responsible? The developer tells me his application crashed and the rows are locked since. So far ( keep in mind I am not a locking expert) the only way I found to release the locks is a DB bounce, its a test DB so no biggy.
PL/SQL :: Cannot Create Table After Change Schema With ALTER SESSION
Sep 1, 2012SQL> ALTER SESSION SET CURRENT_SCHEMA = CLA_T3;
Session altered.
SQL> select sys_context('USERENV','SESSION_USER') current_user,
2 sys_context('USERENV','SESSION_SCHEMA') current_schema
3 from dual
4 ;
CURRENT_USER
--------------------------------------------------------------------------------
CURRENT_SCHEMA
--------------------------------------------------------------------------------
CSR_ETL
CLA_T3
SQL> set linesize 300;
SQL> /
CURRENT_USER
----------------------------------------------------------------------------------------------------
CURRENT_SCHEMA
----------------------------------------------------------------------------------------------------
CSR_ETL
CLA_T3
SQL> create table cla_t3.test (r number, b char(2));
create table cla_t3.test (r number, b char(2))
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> create table test (r number, b char(2));
create table test (r number, b char(2))
*
ERROR at line 1:
ORA-01031: insufficient privileges
After Setting current schema to 'CLA_T3', I am unable to create table in cla_t3 schema.
Application Express :: Kill Current Session When Another Session With Same User Starts
Nov 19, 2012I have an urgent requirement to kill an existing session if a new session starts for the same user. I have been reading lot of blogs and posts on the above topic, but could clearly tell me how to do it.
I thought of putting a process in 101 page when login button is pressed to catch this and kill the old session.
SQL & PL/SQL :: Disconnect User Who Are Blocking Sessions
Apr 11, 2011I have an assignment, i am suppose to disconnect all the users that are blocking sessions for over three hours. Below is my code which is not working
Create or replace procedure b_user IS
Declare
ssid number;
serial number;
Begin
[code]......
Blocking Port 7778 For A Range Of IP
Mar 18, 2013I am using Oracle Application Server 10gAs and Linux 4.
Our Test Application is access by users using 7778 port,i want just few users to access my test application(just admin user) and all other user should not get access to the application,even if they specify proper URL and port number.
Some access control policy using oracle application server 10gas.
Application Express :: (X) Process Taking 60% CPU In Two Session (30% Each Session)
Oct 23, 2012We are using Apex 4.0/Oracle 10gR2/ Hp-Ux, We noticed that there is a process Running in Two Sessions that seems running since 3 Hours using 60% CPU,** 30% given below sql it executes in two Sessions!
declare function x return boolean is begin -- if instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY')>0 then
declare
l_position number := 0;
begin
loop
l_position := instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) ;
exit when instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) = 0 ;
[code]....
Server Administration :: Oracle 10g Blocking Sessions
Aug 19, 2010I am using oracle 10g as server in my lab. I faced some problems initially, but later after increasing the USERS tablespace it is working fine.
But there is still one problem. During the query execution some queries will be blocked and it doesn't leave any consequent queries to execute from the same user.
The blocked sessions will be displayed in the admin page under blocking sessions link. There is a option to kill the session. But when i do that, it affects all the users and the connection will be lost to all the users. again I have startup the database from beginning.
Performance Tuning :: Identify Blocking Sessions
Feb 21, 2011My statspack reports are sometimes showing figures such as this from the Foreground Wait Events section:
Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
PL/SQL lock timer 1,430 100 6,982 4883 0.0 18.0
enq: TM - contention 3 0 6,438 ###### 0.0 16.6
db file sequential read 310,385 0 1,765 6 3.5 4.6
TCP Socket (KGAS) 12,593 13 180 14 0.1 .5
db file scattered read 23,673 0 87 4 0.3 .2
log file sync 19,409 0 82 4 0.2 .2
ksfd: async disk IO 1,680 0 29 17 0.0 .1
[code].....
The TM lock that occurred 3 times appears to be disastrous.Historically, this could be caused by missing indexes on foreign key columns.
How can I be alerted when this event occurs, so that I can do some real-time investigation into the sessions and the SQL that hit it? I suppose I could schedule a job to query v$lock/dba_waiters/dba_blockers every few minutes, but is there a better way? Any standard edition scripts for this?
Server Administration :: How To Avoid Blocking Locks
Nov 8, 2011how to avoid blocking locks.
View 27 Replies View RelatedPerformance Tuning :: One Procedure Is Blocking And Another Is Locking It
Jan 25, 2011I am new to performance tuning. One procedure is blocking and another is locking it.
SQL> @glockers
Oracle OS
INSTANCE SID TY Usernam SERIAL# SPID Process LMODE REQUEST
---------- ------ -- ------- ---------- ------------ ------- ------------------------------------ ------------------------------------
[code]...
Script To Find Blocking Locks More Than 30 Minutes
Jun 29, 2012writing a script where there is a blocking lock for more than 30 minutes ?
View 2 Replies View RelatedGrant Select On V$session And Gv$session Directly?
Aug 28, 2013Instead of giving permission directly to v$session and gv$session to a developer, Is there any other way to do the same?
View 3 Replies View RelatedNotification In Workflow
Jun 6, 2011My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.
View 1 Replies View RelatedSQL & PL/SQL :: Dbms_scehduler Email Notification
Sep 13, 2012I have set up my dbms_scheduler schedule and all run fine. I have set up the smtp server for outgoing email and it all looks good just like multiple of our other boxes here.The problem is that the event (SUCCESS) for a job is raised yet the email notification is not sent. My question is this: Is there somewhere where the actual log of email notifications sent (and/or failure there-of) is actually kept?
View 6 Replies View RelatedPL/SQL :: How To Get Database Notification To C++ Application
Dec 3, 2012We are developing a C++ server which will process based on time based events. For example if a particular user has configured a particular task that has to be processed at a particular time, then an event or notification needs to be sent to the C++ server from the database, to initiate the task. The timming configuration is stored in the database, and the C++ server shouldnt poll the database at an interval, but event should be notified from the database at the configured timming.
We are using odatabase and odynaset libraries to connect and access the oracle database 11g.
How To Implement Change Notification Database
Sep 3, 2013how to implement change notification database in oracle forms?
I want to display some data to user،when change a table in database . now Can i do this work with change notification database in oracle form10g?
Enterprise Manager :: OEM 10g Backup Notification
Oct 16, 2007I have been starting to use OEM 10g and am configuring backups through the maintenance portion. Is there a way to get backup success / failure notification sent to an email address?
View 8 Replies View RelatedLoader Throughput (rows Per Second) Gives Out A Notification?
Feb 22, 2013the Metric "Loader Throughput (rows per second)" gives out a notification on my Oracle 11gR2 instance:
Loader Throughput (rows per second) for <hostname>:1158_Management_Service,XMLLoader0 exceeded the critical threshold (3000). Current value: 3695.652173913043478260869565217391304348My problem is, that I can't interprete this value and don't know, if that is really terrible so I have to do something.
which and what this value belongs and what does that mean?
SQL & PL/SQL :: Email Notification Using Oracle Advance Queue
Nov 28, 2012I want to send an email notification using oracle aq for events like when a message goes to error queue. Similarly,Can I send an email notification when I create a queue or drop a queue?
How can I do this?
Enterprise Manager :: Configure Gmail ID For Notification?
Aug 25, 2010how to configure gmail id in enterprise manager.
it has smtp address but still i'm getting a error message
smtp.gmail.com: Test failed with message: "Sending failed; nested exception is: javax.mail.MessagingException: 530 5.7.0 Must issue a STARTTLS command first. t18sm1156251qco.20 "
RAC & Failsafe :: Fast Application Notification With OCI Based App
Feb 14, 2006We have an application that is written in C/OCI, and we want to use FAN on the database. Can we write C APIs that will work with FAN (monitoring)?
View 2 Replies View RelatedEmail Notification To DBA When Threshold Of 80% Reached For Archive Log?
Jul 10, 2013 11.2.0.3 I want the database to email me when the threshold of 80% is reached for the archivelog and backup piece at recovery_dest folder how to do this. Is this the dict table I will check for threshold?
select * from v$recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE 0 0 0 REDO LOG 0 0 0 ARCHIVED LOG 2.02 1.06 21 BACKUP PIECE 4.76 0 11 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
Application Express :: Exit Icon On The Notification
Jan 24, 2013I am using the notification from COM.ORACLE.APEX.GRITTER_NOTIFICATION but i am trying to make the exit button/icon be displayed all time. By default the exit / close button only appears when mouse over it what about if i want the icon to be displayed all time?
View 1 Replies View RelatedWorkflow :: Notification Timeout When Requested For Information?
Feb 21, 2013We have implemented a approval notification for our customer which on a high level is as follows
requester -> Approver 1-> Approver 2
Once a request is submitted, the 'approval' notification goes to Approver 1 followed by Approver 2. The request is approved when both approves approve the request. If no action is taken by the approvers, the original notifications are cancelled and escalation notification is sent to supervisor of approver 2.
We have a timeout of 48 hours set for the initial approval notifications sent to the approvers (1 & 2). In case Approver 2 requests for more information using the 'Request information' button, the TIMEOUT clock does not seem to reset and the notification is cancelled after 48 hrs even if the notification is in the queue of the requester.
This is causing the escalation notification to be supervisor of approver 2.
The question here is why does the timeout clock not reset when the notification goes back to the requester for additional information. Is this how the standard oracle workflow notification behaves ? Is there a way to customize and achieve this ?
How To Find Detail Of Failure Notification With Enterprise Manager
Apr 25, 2013I use Oracle 9i and I created DBMS Job for run Procedure. when job run by scheduled I found Failure notify but I can not find where the detail of it. How do I find path or detail of Failure notify? I use oracle enterprise manager console.
View 1 Replies View RelatedHow To Change Port Number Of Email Alert Notification
Nov 24, 2010I want to configure the Email Alert Notification in OEM.
In OEM --> Setup --> Notifications Methods --> I am able to see a provision to enter SMTP Address, but there is no port number.
Due to some security policies, my company has opened only Port Number : 9925 for SMTP and blocked Port number : 25.
When I click on "TEST MAIL SERVERS" button, it gives me a error that :
"Test failed with message : Could not connect to SMTP Host , Port No. 25" .
Now I want to change this port number 25 to 9925.
Workflow :: How To Get Response Of Notification Email From MS Outlook Express
Oct 20, 2012I have two questions:
1. Our business users had a requirement to approve or reject the Workflow Notification Emails form their Email account on MS Outlook Express. When they perform action from MS Outlook Express it sends email to wfmailer but no action perform in application. The notification inbox in application shows this notification as OPEN notification and the requested function also shows 'Waiting for Approval'.
2. I need to hide Request Information button/link from the email notification send through Workflow mailer to user. There are three actions button available in email notification Approve, Reject and Request Information. I need to have only two button Approve and Reject. How to hide Request Information button.