# Is it possible to add our own notes to the Toad Knowledgebases? **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 22, 2010, 11:18am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280 "2010-02-22T11:18:51Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 22, 2010, 11:18am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/1 "2010-02-22T11:18:51Z")
Was poking TFO to find way to collect SQL a particular user had run in database today and along the way found StatPack Browser and earmarked it for a later look. TFO Help tells me how to use the StatsPack Browser and the KB gave me a bit more info (sort of) but still wasn’t sure about StatsPack so I went to my O’Reilly Safari and found this: “A Statspack report is generated from two snapshots of the database. These snapshots are a copy of the contents of the various dynamic performance tables that are continuously accumulating information about activity in the database. Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) were offered as replacements for Statspack beginning with Oracle Database 10g and are no longer documented in the Oracle manuals. However, you can use AWR and ADDM only with Enterprise Edition and only if you have a license for Diagnostics Pack—an extra-cost option available only with Enterprise Edition. In my experiences, very few organizations have the requisite licenses. I therefore emphasize the use of Statspack and use it a lot in my own work. Note that Oracle did make several incremental enhancements to Statspack in Oracle Database 10g and 11g , thus further increasing its usefulness and relevance. However, you will have to refer to Chapter 21 of Oracle Database 9i Performance Tuning Guide and Reference for documentation on Statspack because it is not documented in the Oracle Database 10g and 11g manuals. A useful introduction to Statspack as well as installation instructions can be found in spdoc.txt in the ORACLE\_HOME\rdbms\admin folder. “ Beginning Oracle Database 11g Administration: From Novice to Professional by Iggy Fernandez. I’d really like to have the last couple of sentences of the quote (or similar info) stored in KB somewhere so I don’t lose it and can know where to go when wondering about StatPack again. Deborah M Flad, DBA Delaware Children’s Department, State of Delaware 1825 Faulkland Rd, Wilmington DE 19805 Office: 302.633.2694 [deborah.flad@state.de.us](mailto:deborah.flad@state.de.us) Emergencies: 302.528.3652 Txt: [www.vtext.com](http://www.vtext.com) Our website: [www.kids.delaware.gov](http://www.kids.delaware.gov) How am I doing? Email my manager Eugene Mitchell at [Eugene.Mitchell@state.de.us](mailto:Eugene.Mitchell@state.de.us) with any feedback. “Please consider your environmental responsibility before printing this e-mail” * * * Confidentiality Notice – This electronic mail transmission and any attachment(s) are privileged and confidential and are intended only for the review of the party to whom it is addressed. If you have received this transmission in error, please immediately notify the sender and delete the unintended message received. Unintended transmission shall not constitute waiver of work product or any other privilege. ![Picture (Device Independent Bitmap) 1.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f5a8579594ee0f84f077f79be62b544f9c7268f4.jpeg) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 22, 2010, 3:24pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/2 "2010-02-22T15:24:26Z")
Yes, you can add custom notes to KXpert topics. What version of Knowledge Xpert are you using? ![Picture (Device Independent Bitmap) 1.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f5a8579594ee0f84f077f79be62b544f9c7268f4.jpeg) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 23, 2010, 2:50am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/3 "2010-02-23T02:50:12Z")
Morning Deborah, > > Was poking TFO to find way to collect SQL a particular user > > had run in database today and along the way found Statspack > > Browser and earmarked it for a later look. Just a warning about Statspack: Statspack is nice, useful when you don't have other tools to help out. But .... The numbers you see in the Statspack reports are averaged (the mean) over the time period between snapshots. It the time period is long, the numbers tend to flatten out - so a query that reads 8 million blocks from disc each execution would have it's figures spread over the time period. You could see 8 million blocks per hour instead of over a 2 minute period. Any code that starts within the period between the snapshots but finishes outside the later snapshot will not show any resources used during the reported period. Ditto any job that started before the first snapshot and finished during the monitored period - all it's stats will be dumped into your report. This can skew things a little if the job that just finished had been running for 20 hours! I'm pretty certain that in order to collect the SQL for a user it needs to meet some preset criteria such as the number of seconds used, blocks read and so on. You also need to gather stats at level 6 or higher to get the SQL. Tom Kyte advises 5 minute snapshots for best results, bearing in mind the caveats about jobs not starting and ending within the 5 minute period affecting the results. Oh and don't ignore the so called idle event "SQL\*Net message from client" it shows the client's "think" time and could show where the response problem really is - in the application rather than the database. Have fun. Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [February 23, 2010, 7:23am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/4 "2010-02-23T07:23:45Z")
That’s why originally the TOAD stats pack screen would not give advice for period longer than 30 minutes – which we thought was already excessive. BUT – customer feedback was that it needed to be much longer – that few people did and Tom K. When doing stats pack (and even ADDM/AWR) snapshots, the finer the granularity the more reliably and faster you’ll find problems J ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 8:24am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/5 "2010-02-23T08:24:18Z")
KB 10.1 for Oracle Admin and PL/SQL (Engine 10.1.0.188) Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 “Please consider your environmental responsibility before printing this e-mail” ![image002.png](https://global.discourse-cdn.com/quest/original/2X/f/ff0da3efa7e9707c3e9163d517dde19dc2758d88.png) ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 8:24am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/6 "2010-02-23T08:24:18Z")
KB 10.1 for Oracle Admin and PL/SQL (Engine 10.1.0.188) Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 “Please consider your environmental responsibility before printing this e-mail” ![Picture (Device Independent Bitmap) 1.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f5a8579594ee0f84f077f79be62b544f9c7268f4.jpeg) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 23, 2010, 10:20am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/7 "2010-02-23T10:20:27Z")
You want to add a comment then, you also have the choice to make that visible to other KXpert users. ![image001.png](https://global.discourse-cdn.com/quest/original/2X/8/8c8ddbd7a040ae439eebee5f44b324c942963c9b.png) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 23, 2010, 10:20am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/8 "2010-02-23T10:20:27Z")
You want to add a comment then, you also have the choice to make that visible to other KXpert users. ![image002.png](https://global.discourse-cdn.com/quest/original/2X/f/ff0da3efa7e9707c3e9163d517dde19dc2758d88.png) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [February 23, 2010, 10:20am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/9 "2010-02-23T10:20:27Z")
You want to add a comment then, you also have the choice to make that visible to other KXpert users. ![Picture (Device Independent Bitmap) 1.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f5a8579594ee0f84f077f79be62b544f9c7268f4.jpeg) ---
**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\ **Post date:** [February 23, 2010, 12:36pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/10 "2010-02-23T12:36:17Z")
In addition to KB, you can also add notes to Toad’s native ToadTips. Very handy! ![image006.jpeg](https://global.discourse-cdn.com/quest/original/2X/4/4dc5cbdfa4c67881f9bdc9b2e25aecda951d98c9.jpeg) ---
**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\ **Post date:** [February 23, 2010, 12:36pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/11 "2010-02-23T12:36:17Z")
In addition to KB, you can also add notes to Toad’s native ToadTips. Very handy! ![Picture (Device Independent Bitmap) 1.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f5a8579594ee0f84f077f79be62b544f9c7268f4.jpeg) ---
**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\ **Post date:** [February 23, 2010, 12:36pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/12 "2010-02-23T12:36:17Z")
In addition to KB, you can also add notes to Toad’s native ToadTips. Very handy! ![image005.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/258b582142495abd12a0e14c0bee3a413340978d.jpeg) ---
**Author:** ![matt.wilkins](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/matt.wilkins/32/146_2.png) [@matt.wilkins](https://forums.toadworld.com/u/matt.wilkins)\ **Post date:** [February 23, 2010, 12:36pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/13 "2010-02-23T12:36:17Z")
In addition to KB, you can also add notes to Toad’s native ToadTips. Very handy! ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/2798a6756bc912fb65f0ebff6cbaae909c24b072.jpeg) ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 1:09pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/14 "2010-02-23T13:09:07Z")
Thanks guys – took searching and reading! the Toad and KB Help files but found how to add my own notes in both places. Cool. Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 "Please consider your environmental responsibility before printing this e-mail" ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/2798a6756bc912fb65f0ebff6cbaae909c24b072.jpeg) ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 1:09pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/15 "2010-02-23T13:09:07Z")
Thanks guys – took searching and reading! the Toad and KB Help files but found how to add my own notes in both places. Cool. Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 “Please consider your environmental responsibility before printing this e-mail” ![image006.jpeg](https://global.discourse-cdn.com/quest/original/2X/4/4dc5cbdfa4c67881f9bdc9b2e25aecda951d98c9.jpeg) ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 1:09pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/16 "2010-02-23T13:09:07Z")
Thanks guys – took searching and reading! the Toad and KB Help files but found how to add my own notes in both places. Cool. Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 “Please consider your environmental responsibility before printing this e-mail” ![Picture (Device Independent Bitmap) 1.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f5a8579594ee0f84f077f79be62b544f9c7268f4.jpeg) ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 1:09pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/17 "2010-02-23T13:09:07Z")
Thanks guys – took searching and reading! the Toad and KB Help files but found how to add my own notes in both places. Cool. Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 “Please consider your environmental responsibility before printing this e-mail” ![image002.png](https://global.discourse-cdn.com/quest/original/2X/f/ff0da3efa7e9707c3e9163d517dde19dc2758d88.png) ---
**Author:** ![flyfishpanfish](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/flyfishpanfish/32/141_2.png) [@flyfishpanfish](https://forums.toadworld.com/u/flyfishpanfish)\ **Post date:** [February 23, 2010, 1:09pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/18 "2010-02-23T13:09:07Z")
Thanks guys – took searching and reading! the Toad and KB Help files but found how to add my own notes in both places. Cool. Deborah M Flad, DBA Office: 302.633.2694 Emergencies: 302.528.3652 "Please consider your environmental responsibility before printing this e-mail" ![image005.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/258b582142495abd12a0e14c0bee3a413340978d.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [February 23, 2010, 6:22pm UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/19 "2010-02-23T18:22:36Z")
Hi, Norman, > Any code that starts within the period between the snapshots but > finishes outside the later snapshot will not show any resources used > during the reported period. > > Ditto any job that started before the first snapshot and finished during > the monitored period - all it's stats will be dumped into your report. > This can skew things a little if the job that just finished had been > running for 20 hours! Oracle has apparently corrected that problem in the 11g version of Statspack and it should be possible to manually fix the code in the 10g version of Statspack. From the 10gR2 documentation: "Statistics displayed in V$SQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds. This makes it easy to see the impact of long running SQL statements while they are still in progress." ([V$SQL](http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2113.htm)) From the 11g version of spdoc.txt: "SQL statements which have not completed execution (e.g. have a 0 execution count as the statement was still running when the End snapshot was taken) can now appear in the SQL reports." > You also need to gather stats at level 6 or higher to > get the SQL. We get the SQL text and execution metrics at level 5 (the default). I believe that level 6 produces the actual execution plans in addition to the SQL text and execution metrics. Regards, Iggy ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 24, 2010, 3:26am UTC](https://forums.toadworld.com/t/is-it-possible-to-add-our-own-notes-to-the-toad-knowledgebases/9280/20 "2010-02-24T03:26:30Z")
Morning Iggy, > > Oracle has apparently corrected that problem in the 11g > > version of Statspack and it should be possible to manually > > fix the code in the 10g version of Statspack. > > Excellent news, thanks for that. The closest I've been to an 11g > > database is installing the 11gR1 docs on my desktop. 10g is "news tuff" > > here where I am at the moment. I am working through the new features > > guide though - slowly! > > ... > > We get the SQL text and execution metrics at level 5 (the > > default). I believe that level 6 produces the actual > > execution plans in addition to the SQL text and execution metrics. > > True, you get "high resource usage SQL statements" at level 5 - but no > > execution plans. At level 6 you get plans and plan usage which makes the > > output from "sprepsql" more informative. Thanks for correcting me. Looking forward to 11g even more now! Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk)