By time sequencing a Wireshark capture with a 10046 trace file

Interviewed for the November 2010 NoCOUG Journal

canadian goose jacket Almost two months ago I was interviewed canada goose outlet reviews for canada goose outlet jackets an article that was to appear in an upcoming NoCOUG Jornal newsletter. It was a great opportunity to canada goose outlet uk sale participate in the interview, and Chen (Gwen) Shapira provided to mea great set of thought provoking questions. The interview went a bit long, so some of the canada goose outlet questions and answers had to be trimmed from the printed NoCOUG Jornal newsletter article (Iggy Fernandez, Chen, and the other responsible parties did a fantastic job of picking the best answers for inclusion). The picture used in the article let just say that of the 50 or so pictures that I reviewed for submission, it was canada goose outlet black friday the only one that effectively hidmy gray hair,where I did not show either a distressed (or puzzled) expressionor appear that I had just spent eight hours writing a critical book review (is that a hint that anotherbook review is in the process of being put together?). canadian goose jacket

Canada Goose Jackets I have decided to post a couple of the questions and answers that had to be trimmed due to space canada goose outlet canada constraints (with the exception of the war story from my experience, which drifted a bit too far off topic, and involved some rather gruesome gutting of computer internals). You definitely have more Excel expertise than most Oracle DBAs? How did you get into the Excel business? Do you have some tricks to share with our readers? Canada Goose Jackets

canada goose uk shop Among other things, I was a computer/technology official canada goose outlet instructor prior to working for K Machine Fabricating, canada goose jacket outlet Inc., and one of the topics that I taught was using Microsoft Excel for data analysis and data visualization. Excel canada goose outlet toronto factory has a full featured macro language that is canada goose outlet in usa quite similar to Microsoft Visual Basic 6.0 (and also the 2.0 version of Visual Basic), and canada goose outlet store uk is somewhat similar to the much simplified VBScript that is integrated into some ERP packages (Infor’s Visual Manufacturing for example), some engineering applications (AutoCAD, at least for a period of time, supported VBScript), classic ASP web pages, and even the Windows operating system. It is the macro automation, either from within Excel or another program (whether a Microsoft Office component, custom developed program, or even an operating system script), that provides the most useful features in Excel for a DBA. canada goose uk shop

buy canada goose jacket cheap In June 2009 canada goose outlet online uk I delivered a presentation to a regional canada goose black friday sale ERP user’s group that among other things showed how to leverage Microsoft Excel as a query and reporting tool for ERP data. The Excel portion of the presentation required roughly 90 minutes and showed how to tap into the ERP data for reporting and visualization, as well as querying flat files, Windows event logs, and the WMI database that is built into all Windows operating systems since Windows 2000 was released. It took about three months to prepare for that presentation, canada goose outlet shop and the preparation involved reading three books about Microsoft Excel programming: „Professional Excel Development“, „Excel Power Programming with VBA“, and „Pro Excel 2007 VBA“. The first two books are great references but also are easily readable from start to end. The third book really does not introduce anything that could not be discovered by a couple of hours of experimentation and Excel help documentation reading (the help file in Excel 2007 is much better than earlier versions and was improved again in Excel 2010. buy canada goose jacket cheap

canada goose uk outlet As for tricks, turn on the macro recorder in Excel, make a couple of changes or set up a Microsoft Query that accesses an Oracle Database, and then examine the resulting macro. This method of generating macros is a great starting point, as long as you keep in mind that the generated code is not necessarily the most efficient approach to producing the intended results, and there is a small chance that the generated code will not work as expected when it is later executed. canada goose outlet If you see an unusual command, click in the middle of the command and press the F1 key for additional information about the command. canada goose uk outlet

canada goose factory sale Tell us about your favorite network tools. When do you recommend bringing out network tracing? What about other operating system knowledge, do you feel that DBAs would benefit from looking at more low level tracing and measuring? canada goose factory sale

uk canada goose outlet For the rare times when I need to perform network analysis, I typically reach for ping, tnsping, or tracert (traceroute) first. If I am working on canada goose outlet new york city a computer running Windows I might also run either nbtstat or netstat with various parameters. One of the little known key network tools is actually the event log found in a managed network switch, which might provide a clue about misconfigured switch or server settings, failing hardware or failing network links, faulty wiring, and a number of other problems. For automated network monitoring it is hard to find a better free tool than Nagious. For a DBA, network monitoring with a packet capture tool such as Wireshark (available on Windows, Unix/Linux with an X Window environment, and Mac) or tcpdump probably should only be attempted when a 10046 trace at level 8 or canada goose outlet parka 12 finds that only a small canada goose outlet sale percentage of processing time is confirmed to be server side database related activity, essentially when most of the elapsed time is in SQLNet type wait goose outlet canada events. By time sequencing a Wireshark capture with a 10046 trace file, it might be possible to determine why, for example, every time the client submits a specific SQL statement and a FETCH call is found in the 10046 trace file there is a two second delay before the next entry in the 10046 trace file essentially answering if there was a problem/slowness in the network communication, or if the client was busy canada goose factory outlet using the retrieved data. If the Wireshark capture shows that a problem was not found in the 2 second problematic interval, then a switch to client side tracing canada goose outlet online with Wireshark and/or another tool such as Micosoft’s Process Monitor, Microsoft’s Spy++, SQLNet tracing, or other client side tracing utility might help. Selecting a cell is not necessary to modify its value, so we can eliminate that line. Also, because we are not specifying a formula, but instead a specific value, we can change FormulaR1C1 to Value. uk canada goose outlet

canada goose uk black friday When posting test case samples, it is much easier for people to reproduce the test case when the SQLPlus line prefixes are not included if possible, please remove canada goose outlet nyc those line canada goose outlet uk prefixes. This: canada goose uk black friday.