![]() ![]() Step 2 Convert txt to zip Select zip or any other format, which you want to convert. Post the info re stats, tables, execution plans, etc.Select txt file, which you want to convert, from your computer, Google Drive, Dropbox or drag and drop it on the page. It is YOUR responsibility to post the information needed to help you. If you don't have picture #1 you will have a hard time comparing picture #2 to anything. Did the execution plans of any of the key queries change? Did the statistics change? Or perhaps no one updated them lately?Ĥ. Did the amount of data in the tables (which you haven't told us anything about) change?ģ. What changed between picture #1 and picture #2?Ģ. You have to use a process just like in those picture games for kids where they show two pictures and ask them: find the objects in the two pictures that are different.ġ. Ok - so did you actually COMPARE the base lines to see what was different? What did you find was different? Why haven't you posted here and told us what you found that was different? I have gathered 1 week worth of AWR stats reports just to campare baselines because that is what is always heard here. The 'template' you seek is to determine WHAT CHANGED. If you 'experienced very slow performance' then, by definition, you MUST know that previously the performance was 'faster'. There is no solid way I have found for a template for a clear solution. Again this topic is the most unmastered part of my carrier as dba.Īnd it will likely continue to be 'unmastered' until you actually press the keyboard with your fingers and start doing things yourself. My boss told me to investigate the issue and find the cause. That's a good start to defining the problem. ![]() The webpage is hanging or disconnecting often and many transaction were dropped or not processed. In short you seem to be relying on us to solve your problem and haven't provided ANY feedback about what, if anything, you are doing to solve it: Yesterday Jan 15, 2014, we experienced very slow performance in our App. Himmy got the same treatment: If this is an OLTP database can you try gathering stats on all tables of schemas used by the application.ĭid you do that? Are the stats current? Why didn't you respond to let us know WHAT you are doing to solve the problem? You marked the reply 'helpful' but never said a word about whether you did those things and what the result was. If index is already there, try to analyze it and gather statistics.Ĭheck whether the index are in usable form. You also never responded to the reply by Gayu0726: To solve: Why didn't you comment about the AWR suggestion that was made? If you want responders to help you have to be responsive to their comments. The only comment you made was a sarcastic one about the formatting. Focus on an AWR derived from the snapshots that make up the period the problem occurred. Why not just post the AWR HTML parts that are interesting? Such as: Time model, Top 5 Waits, Load profile.Īlso, a one week AWR report is not very useful in your case. Alvaro posted this: These logs you have provided are completely unformated and next to impossible to read. You also aren't responding to the questions or suggestions others have already posted. Go back and read it again - especially the part about the info needed for a tuning request. #NOTEPAD++ DOWNLOAD SLOW HOW TO#Yes - but that is just one SMALL part of the info mentioned in that link about how to ask a question. The application is just 3rd party developed in java. I already mentioned the db & OS version above
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |