How To Kill Inactive Connections Automatically

Apr 26, 2011

i was gone through the below link

[URL]

so when i changed my idle_time value in profile and the when the user exceeds the idle_time value the user still i can see in-active state in v$session.

and when i was tried to execute any query on inactive session that time i got an ORA- error and then session was not visible from v$session.

in my environment inactive session was not getting used afterwards so is there any way to kill that sessions automatically once reached idle_timeout value.

lets say i have 50 max sessions, out of which 10 are inactive state and 40 in active state .what if i created one more sessions will that give me ORA- error stating max sessions reached or it will kill the one session which are in-active state.

View 5 Replies


ADVERTISEMENT

How To Kill Invalid Sessions Automatically

Jul 3, 2013

On the oracle 11g, we see too many invalid sessions. Because of which, login is getting restricted. What do i need to do to kill those invalid session periodically, which will avoid of restarting of system.

View 4 Replies View Related

Inactive Sessions In Database?

Dec 12, 2011

In our databace there are around 300 sessions were in inactive state.

Database is not releas the sessions.

View 2 Replies View Related

INACTIVE Sessions In Oracle?

Apr 22, 2011

our db shows more than 200 INACTIVE Sessions ; and the DBA plans to reboot the db to get rid of these sessions . Can we not KILL these sessions and avoid the reboot ?

View 4 Replies View Related

Session Inactive State?

Jul 1, 2012

want to know the following

1. when the oracle session changed from active to inactive?
2. what is the time for active session?
3. session is changed to inactive from active. but it is still showing in v$session.
4. in v$session, can i see the ipaddress of client machine ?

View 6 Replies View Related

Forms :: List Item Becomes Inactive After Using Once

Dec 6, 2012

i have a form having 5 listitems for making selections. once selecting through listitems i am adding this selection into below datablock by a ok button and saving it into database by a ok button. as i made one selection and press ok buttton it's working fine but after this when i want one more selection through listitems, listitems becomes inactive. it's not working after one selection. my coding on ok button is like this:

begin
select distinct lcode intolcode_ss from vac_view where locality=:vac_view.locality;
select distinct hid intohid_ss from vac_clr_vu where vr_no=:vac_view.vr_no;
:prop_temp.vr_no :=:vac_view.vr_no;
:prop_temp.qtr_type :=:vac_view.qtr_type;
:prop_temp.locality :=:vac_view.locality;
[code]....

may be it's all because of clear_list('vac_view.locality'); but i have to put this as i want to make clear all listitems after making each selections.

View 1 Replies View Related

Server Administration :: High CPU For Inactive Session?

Nov 22, 2012

when I was analyzing high CPU utilization issue, I saw that the most of the top PID's were INACTIVE in database. But it was utilizing more than 4% CPU. how it is utilizing CPU without doing any work in database?

PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
24013 oracle 2167M 1581M sleep 53 0 0:01:53 20% oracle/1
13260 oracle 2167M 1580M sleep 30 0 0:01:16 14% oracle/1
24399 oracle 2167M 1582M sleep 59 0 0:03:01 4.2% oracle/1
11509 oracle 2178M 1593M sleep 59 0 0:02:10 2.8% oracle/11

[code].....

View 3 Replies View Related

Query For Inactive Sessions Consuming Memory

Apr 5, 2013

Share a query for inactive sessions consuming memory? I have found many inactive sessions with the following query and would like to join this information with memory usage as well.

select username, machine, program, to_char(LOGON_TIME, 'hh24:mi:ss DD-MM-YYYY'), LAST_CALL_ET/60, status from gv$session where status='INACTIVE';

View 19 Replies View Related

Forms :: Change Color Of Active / Inactive Tab Canvas

Apr 19, 2010

how can we change the color of active & inactive Tab canvas dynamically. I am using Dev Suite 10gR2

View 2 Replies View Related

Server Administration :: Session Inactive But Running Queries?

Mar 4, 2010

I am using 10.2.0.4 oracle database on Solaris 10. We are running some Peoplesoft upgrade on one of the database from last 6-7 hours. The status of the session is INACTIVE from couple of hours. And the sql_id is null for these sessions.

select sid,serial#,STATUS,to_char(logon_time,'DD-MON_YY HH24:MI:SS') from v$session where username like '%&usern%' ORDER BY 4 DESC;
533 2234 INACTIVE 04-MAR_10 01:59:02
525 5919 ACTIVE 04-MAR_10 01:54:50
534 4186 INACTIVE 04-MAR_10 01:05:15
520 2320 INACTIVE 04-MAR_10 00:29:44

[code].....

While when i see the current sql from the v$active_session_history, it keep on changing after every 10-15 minutes. Using below query to find the sql_text for the session from v$active_session_history.

select sql_id, sql_text
from v$sql
where sql_id in (
select sql_id
from v$active_session_history
where session_id=511

[code].....

We have not faced issue like this during Peoplesoft upgrade. what could be the reason that the status is not changing while the base sqls keep on changing after every 10 minutes.

View 8 Replies View Related

Forms :: Killing Inactive Session Through Oracle Application Server

Mar 5, 2013

I am trying use host command in Oracle forms. I get the process id as input from the user and on clicking ok the form should kill the session related to process id.

PS: Users will be entering only frmweb.exe process id which are inactive.

cmd := 'CMD /C taskkill /F /FI /pid 'process which is got as input' /IM frmweb.exe'; host(cmd)I also tried by writing the above command into a .bat file in application server.When trying to execute the bat file it din work. But when tryin to run the bat file by double clicking in Application server the session was killed.

On executing the above I am unable to kill the process. I would also like to know whether the host command was successful or not. Orakill and alter session are working but I don want to use it.

View 2 Replies View Related

Unable To Kill Session Using Command?

Oct 22, 2010

I killed the session using the command like :

alter system kill session '454,48158';

but again it is showing the session in v$session view. How can i kill the session.

View 1 Replies View Related

Server Administration :: Not Able To Kill Session

Aug 23, 2011

My disk is completely full so i decided to drop temporary tablespace and create a new one but unfortunately the query to drop temp tablespace hang in between to whic I come to know that there were some sessions which were using it for sort purpose.

check out the queries below with results:

SQL> SELECT b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,
2 a.username,a.osuser, a.status
3 FROM v$session a,v$sort_usage b
4 WHERE a.saddr = b.session_addr;
[code]....

Was able to killed three of the four sessions but not the last one.

View 20 Replies View Related

Reports & Discoverer :: How To Kill A Report Job ID

Jul 6, 2011

i used below code to call Report from Form

Function to call procedure to run report:

DECLARE
report_id Report_Object;
v_report_other VARCHAR2(4000);
vc_connect varchar2(50);
BEGIN
--Call run_report_object
[code]......

its showing report output in a new window, but problem is that if i copy the url, then close current report browser window, start new IE session and paste the copied url it showing the same report... but i don't want to allow this and want to Kill the current job id ( while it displaying the same report ), how i can do this?

View 1 Replies View Related

Performance Tuning :: SSL On Database Connections?

Oct 10, 2012

insight into the overheads for mutally authenticated SSL for database connections? This is over a fast local network, to a RAC cluster, with DB firewall in front. There's always a large element of "it depends"

Information I'm interested in are things like latency for initial session setup and subsequent data transfer. Also the increase in network packet size, and the increase in CPU cost for the database server. I guess there is some implications for session memory usage as well.

View 4 Replies View Related

PCI - Auditing Connect / As Sysdba - Connections?

Feb 15, 2012

I have a problem with a PCI DSS - requirement in Oracle 11.2. (PCI DSS = Payment Card Industry Data Security Standard)

Problem:

we connect via ' ssh -2 -X -l oracle hostname ' to the databaseserver and become os-user 'oracle'. we have also two offshore locations with dba's and each dba comes with his personalized user to the jumphost and then with the above ssh command to the database server.

the problem is that each dba becomes the oracle-os-account and can now connect with '/ as sysdba' to the database.in pci-dss this is not allowed !

now my question:how can I audit these '/ as sysdba'-connections and prove which user connected at which time with the '/ as sysdba' command ?

database is in audit mode. we log to syslog on linus redhat 5. I know one solution could be setting "SQLNET.AUTHENTICATION_SERVICES" parameter to "NONE" in sqlnet.ora file will make it not possible to connect to the database without a password as sysdba. (sqlplus / as sysdba). but we have to many applications and jobs and this is not really the solution in this case.

I think I can only solve this problem with personalized OS-user DBA-accounts in the dba-goup on os-site and os-user oracle should not be used for the future ?? I also need personalized dba-user-accounts in the database. using sys and system is not allowed. this users has to be locked and only for special administration work could it be unlocked.

View 3 Replies View Related

SQL & PL/SQL :: Kill One Users Sessions Using A Procedure?

Mar 1, 2012

I want to create a procedure that kills the sessions of the user TEST.

I have coded the below, but that dont work.

CREATE OR REPLACE PACKAGE BODY SYSTEM.test AS procedure killsessions IS
v_sessions_sql varchar2(40);
--v_sessions_sql2 varchar2(40);

[Code].....

View 4 Replies View Related

How To Find Number Of Connections From Specific Client

Mar 13, 2013

We are interested to find the number of connections from specific client. Is tracing on sqlnet.ora in the client machine the answer? If yes, which trace has the information?

View 1 Replies View Related

SQL & PL/SQL :: How To Check Open Http Connections In Database

Apr 13, 2012

How to check the open http connections in the database as I am getting.

ORA-29270: too many open HTTP requests

View 7 Replies View Related

Server Administration :: How To Count Connections Exist On DB

Jul 6, 2011

I wanna know the way to count connections exist on Database, and the max connections db accept.

View 14 Replies View Related

Windows :: Unable To Kill A Session Using Orakill

Sep 25, 2012

Iam unable to kill one database session, Today i killed one session

alter system kill session '418,12499'

but status shows as killed but process still exits in OSLevel

SQL> select sid,serial#,status from gv$session where sid=418;

SID SERIAL# STATUS
---------- ---------- --------
418 12499 KILLED

we all know we can kill by using ORAKIL but still we unable to kill

SQL> select spid from v$process a, v$session b where a.addr = b.paddr and b.sid = '418';

SPID
------------
5644

i killed using orakill

C:Documents and SettingsAdministrator>orakill oraci 5644

Kill of thread id 5644 in instance oraci successfully signaled. but still process exits in os level also i notice below error in alert log

orakill: ssthreadkill(tid=5644) unable to get the thread list mutex: err=0

View 3 Replies View Related

Server Administration :: Best Way To Kill Oracle Session

Feb 6, 2010

Which is the best way to kill a session?

alter system kill session sid,serail#
or
kill -9 spid
or
orakill sid,thread

I am using unix,windows operating system.

View 3 Replies View Related

Server Administration :: How To Kill Killed Session

Apr 23, 2013

How to kill of a killed session?

I had killed inactive session using alter system kill session 'sid,serial#';

after that that sessions marked as killed and still get in v$session.

Then i try to get spid so that i can killed then from os command kill -9 spid

but when i try to get that join with v$process, no row select.

select * from v$session where username ='CAS' and status ='KILLED'

return 205 records.

select p.*,s.username,s.program,s.machine,s.status from v$process p,v$session s
where p.addr=s.paddr and s.status='KILLED'

return no record.

View 24 Replies View Related

How To Identify And Kill Unwanted Process On Windows

Aug 24, 2012

we have third party application which uses oracle database (version 10.2.0.5) on WINDOWS. Our no of process used keeps increasing by 15-20 everyday.

However number of sessions remain constant 32-35 . So in couple of days we reach our limit of max processes and DB needs to be restarted to release processes.

How to identify unwanted process ?? is it safe to kill process(windows threads) which have V$PROCESS.ADDR not equal to V$SESSION.PADDR using orakill or some other third party utility or should I use another way ??

No of sessions remains constant and currently we don't have control over application.

View 15 Replies View Related

Checking Real Amount Connections To Oracle Database

Mar 12, 2013

My problem:

+ Oracle 11g
+ Centos 5.5
+ I create many users by shell script (user01, user02, user03 ..... user0n)
+ How can I connect all user to Oracle database in Centos (may be create connect.sh) - command line env ?
......
// user01 , user02 ... ---===> connect Oracles ?
My idea: using fork to create multi sqlplus to connect but it cant o_0

If all users can connect to Orcl db, I can count real user connections.

View 4 Replies View Related

Networking And Gateways :: Select For Update - How To Kill Old Locks

Aug 3, 2011

My code executes a Select For Update before updating a table. In some cases the network is disconnected and it causes the lock to hang. Then, I must kill the session in order to realese this lock.

I want to do it automatically. I would like to create a job that kills session that has a lock due to Select For Update that is not alive.

View 18 Replies View Related

Server Utilities :: Safe To Kill Full DB Export?

Jan 7, 2011

We started a full db export using exp, and we need to kill it. Is it "safe" to do so? Killing it won't affect the database in any way, right?

$ORACLE_HOME/bin/exp system/xxxxxx BUFFER=140000 FULL=Y FILE=/export/<sid>.exp VOLSIZE=2000M GRANT
S=Y INDEXES=Y COMPRESS=Y

View 1 Replies View Related

Clusterware :: Listener On RAC Node 2 Not Accepting User Connections

Apr 11, 2013

I have a 2 RAC node cluster . The problem is that the second listener is not registering any connections . I have verified the services of listener using lsnrctl status (the default name is LISTENER), i also have verified the local and remote listener parameters they are fine but running the fol query shows count =0 against inst_id=2;

SQL > select count() from gv$session where username='XYZ' and inst_id=2;*

Count
--------
0

View 12 Replies View Related

Networking And Gateways :: Clients Connections Failed Intermittently?

Jul 16, 2012

have some problem between my database and the listener Sometimes I have connection errors: The error occurred intermittently

Oracle 11.2.0.2.0 on RHEL 5
My listener:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
LISTENER =

[code]...

The listener starts and stops normally
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
>lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 17:51:09
Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /opt/oracle/product/EE_11.2.0/bin/tnslsnr: .

[code]...

But there is an error when the database register into the listener (in listener.log):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Started with pid=4029
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Listener completed notification to CRS on start

[code]....

View 2 Replies View Related

RMAN Full Backup - All Application Connections Goes In Wait Mode

Aug 8, 2012

on our 10.2.0.5 database, when we run full backup, my system performance comes to an halt. we run full backup and then do a validate backup to validate the structure of the database etc. Database performance takes a hit and all of the application connections goes in wait mode: On ASH or AWR - this is the top wait i see:

RMAN backup & recovery I/O

Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
RMAN backup & recovery I/O 22.22 "1","32","2147483647" 21.79 count intr timeout

what can we do to over come this issue?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved