>Oracle – session, process sayisi

>http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5671284058977

ps -auxww | grep

set autotrace on statistics;
select username from v$session where username is not
null;

(1.1*processes)+5. That means process=415 will give me sessions=461

300 – 335

ps -eaf
——————————————-
the number of dirty buffers that are waiting to be written;

select dirty, count(*) from v$bh group by dirty;
update big_table.big_table set id=id where rownum < 1000;
select dirty, count(*) from v$bh group by dirty;
alter system checkpoint;
select dirty, count(*) from v$bh group by dirty;
————————————————-
alter session set sql_trace=true;

select p.spid
from v$session s, v$process p
where s.paddr = p.addr
and s.audsid = userenv(‘sessionid’);

———————————
select username,count(*)
from v$session
group by username;
select *
from v$resource_limit
where resource_name in (‘processes’,’sessions’);

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s