by Bert Scalzo
There may be times when a DBA might desire to disable Oracle 10g's and 11g's AWR (Automatic Workload Repository). I am neither advising nor condoning such a practice, but merely elaborating on how such a thing could be done. One reason might be to avoid licensing issues, because AWR isn't part of the standard or even enterprise database – as it requires the optional (extra cost) Oracle Enterprise Manager (OEM) Diagnostic pack. So even though your 10g/11g database automatically collects AWR data every sixty minutes and retains it for a week – you cannot legally use the Oracle supplied PL/SQL packages, the OEM screens for AWR, ADMM and ASH, or even the AWR data dictionary views if you're not licensed. >Read full article
by Robert Catterall
Among some people who are familiar with certain non-IBM DBMSs but are relatively new to DB2, there can be a bit of confusion about table-pinning in a DB2 environment. This may be due to the fact that table-pinning is covered in the documentation of some other DBMSs but is not mentioned in any of the DB2 manuals. Thus it is that one might conclude that DB2 does not support the pinning of tables in memory. In fact, DB2 has ALWAYS supported table-pinning - the difference is in nomenclature and in the process by which a DB2 table gets pinned. >Read full article
by Dagon Design
This script finds all of the MySQL databases on your server, individually backs them up (for easy recovery of specific data), compresses them, and stores the file in a specified directory and/or emails it to you. It has been updated since the initial public release and includes several new features. >Read full article
by Tom Mochal
One-on-one interviews are probably the most common method of gathering business requirements. The techniques involves having an interviewer and an interviewee, although there are some variations, including having a scribe present to document the discussion and the requirements. Interviewing is basically just talking, although it is a discussion with a purpose. The interviewer must keep control over the discussion to make sure that the basic objectives of the interview are met. >Read full article
 |
VendorRate is a reliable IT decision making tool that every technology department can use before making a purchasing decision. Rating a vendor is free, takes three minutes or less, is fully confidential, and shares your opinions with the world. New member drawing for 16GB iPod Touch ends 11/30, so enter your vendor rating for Quest Software today at VendorRate.com.
|
|
