Slow bench

[ricardo25ti]

Environment information:
* Oracle version: Oracle 10g
* Operating system: Red Hat 5

Good morning,

99] It has been a few days since I noticed that my server was slow (Oracle 10 and Red Hat 5), monitoring the logged sessions, I saw that all life that a session with the Sysman user is active the performance falls, one knows how to Does it run any job or any process you are leaving the bank slow?

[victorhugomuniz]

Sysman
The Sysman User Represents The Enterprise Manager Super Admin Account. This in Admin Can Create and Modify Other in Admin Accounts as well as admin the database instance itself.

[ricardo25ti]

beleza, the problem is not what sysman is and yes know if it is running, if it's some job or something that leaves the bank slow. Another information I saw when you looked at the sessions is this: Program = Oracle @ Sever (J000) if someone knows what he is running (or if he is superb verifying) I thank you.

Thanks for the face

[victorhugomuniz]

How do you know he's active in some session?

was the V $ session?

LA with you get the sql_id and go in v $ sql .. so you can see exactly what he performed

[ricardo25ti]

That was right there, in the Program field had Oracle @ Sever (J000), is that it? WILL A JOB? Or do you see this on another table?

Thanks for the attention.

[ricardo25ti]

The excuse did not see the part of V $ SQL. I'll test thanks

[victorhugomuniz]

Select all

 
select sql_text, object_status, first_load_time, username, sid, lockwait, sql.LAST_ACTIVE_TIME 
from v$session ses, v$sql sql 
where ses.sql_id = sql.sql_id  

The SQL_Text field brings what you want

[ricardo25ti]

Dude I discovered this here:

Select all

select /*+ rule */ bucket, endpoint, col#, epvalue  
from histgrm$  
where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

I honestly do not know what it is, do you have any idea?

[victorhugomuniz]

I know no brother ...: oops:

Select all

 
--aqui ela até aparece 
select table_name,index_name,table_name,column_name from dba_ind_columns where table_name='HISTGRM$'; 
 
-- aqui eu não tenho privilegios 
select * from SYS.Histgrm$ 

Maybe he can help you http://forums.oracle.com/forums/thread. ... &tstart=15

[ricardo25ti]

Dude to suspect a job, her description is:

Select all

EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();

Do you know what it is? User is Sysman