| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
