Dick ,
Thanks a ton for ur feedback. I ran UTLBSTAT/UTLESTAT and found out that the problem was with memory. Then I went and queried V$SGASTAT, V$SQLAREA, V$SQLTEXT. Can u tell me if there can be any other problems ? I found out later that there were some indexes added afterwards.
Thanks nyways.
Chetan
[EMAIL PROTECTED] wrote:
Chetan,First questions, What changed? Did someone add/delete an index? Was therean oversized data load done? When were the statistics, if present, lastcomputed? Has a new program/application been added to the server? Did a memorybank go offline? Did a disk interface card go offline?I use HP's HP-UX boxes as well, except most of my DB's are 10 times largerthen yours. Just about everytime something like that happens, especially all ofa sudden, one of those questions is the cause. The last item I'd go lookingfor, have only had one instance of it so far, is a unrestricted user whoreleased "the query from HELL" into the database as a "one time requirement". If you can find him/her I've a used gallows rope is still here, one usage only.Dick GouletReply SeparatorAuthor: Chetan Date: 6/26/2002 2:18 AMHi guys ,Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX.The application was running fine uptil yesterday. Suddenly a part of the applnis running extremely slow. I can not figure what might be the problem. Wanted totrack this down asap.Here is some information about the db.Database size - 20GBOptimizer - CHOOSEDisk Structure - RAID 1+0No. of processors - 4Block Size - 8KArchivelog mode : ARCHIVELOGPlease tell me what should be the ideal way I should try to trace the problem. Ithought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run thatpart of the appln. Has anybody worked with STATSPACK before ?Can anybody tell me what should accurate and fastest way to hunt down theproblem ? I think its something to do with indexes or changes in the queries.Also can someone tell me the ide!
!
al backup strategy for this database consideringthe fact that it's a 24x7 system.Thanks in advance .Chetan Chindarkar-Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World Cup
Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX.The application was running fine uptil yesterday. Suddenly a part of the applnis running extremely slow. I can not figure what might be the problem. Wanted totrack this down asap.
Here is some information about the db.
Database size - 20GB
Optimizer - CHOOSE
Disk Structure - RAID 1+0
No. of processors - 4
Block Size - 8K
Archivelog mode : ARCHIVELOG
Please tell me what should be the ideal way I should try to trace theproblem. I thought of running UTLBSTAT/UTLESTAT orSTATSPACK and asked the user to run that part of the appln. Hasanybody worked with STATSPACK before ?
Can anybody tell me what should accurate and fastest way to hunt downthe problem ? I think its something to do with indexes or changes in thequeries.
Also can someone tell me the ideal backup strategy for thisdatabase considering the fact that it's a 24x7 system.
Thanks in advance .
Chetan Chindarkar
Do You Yahoo!?href="http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl">Sign-up for Video Highlights of 2002 FIFA World Cup-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup