Home » RDBMS Server » Performance Tuning » Performance Problem / Query Problem
Performance Problem / Query Problem [message #64823] Sun, 15 February 2004 18:43
kothari Alpesh
Messages: 27
Registered: December 2001
Junior Member
Hi All,

My company using oracle 8.1.7.0 and there is bug called memory leackage problem but solution is set the init.ora parameter

_db_handles_cached = 0

but after setting this parameter , I found problem with the query

and query are taking too long time means in hrs and not giving any result. what could be the reasons for this can anybody help for this

select  disk_reads, sorts,parsing_schema_id,sql_text
from    v$sqlarea
where   disk_reads > 50000
order  by disk_reads desc;

select * from (
  select s.sid, s.username, s.osuser, s.program, v.value "Open Cursors"
  from   sys.v_$sesstat v,  sys.v_$session s
  where  v.sid        = s.sid
    and  v.statistic# = (select statistic#
                       from sys.v_$statname
                      where name like 'opened cursors current')
  order  by v.value desc
)
where rownum < 11;

 

Thanks

 

Alpesh Kothari

 
Previous Topic: number of stmts executed against an oracle instance
Next Topic: Oracle 9i Performance Doubts
Goto Forum:
  


Current Time: Tue Sep 29 10:31:47 CDT 2020