Websites
http://www.freelists.org/webpage/oracle-l | The Oracle-L Mailing List |
http://groups.google.com/group/ comp.databases.oracle.server/ | comp.databases.oracle.server on usenet |
http://www.oaktable.net | Oak Table Network |
http://www.jlcomp.demon.co.uk/ | Jonathan Lewis’ tips and consultancy. |
http://www.juliandyke.com/ | Julian Dyke |
http://www.hotsos.com/ | Hotsos – Cary Millsap |
http://www.ixora.com.au/ | Steve Adams |
http://www.puschitz.com/ | Werner Puschitz |
http://www.evdbt.com/ | Evergreen Database Technologies – lots of papers by Tim Gorman and Jeff Maresh |
http://www.tanelpoder.com/ | Tanel Poder |
http://integrid.info/ | Small consulting org of Tanel Poder |
http://www.smartchaps.com/ | Another site by Tanel Poder; wiki-based, doesn’t seem to be much content yet. |
http://asktom.oracle.com/ | The Ask Tom website. |
http://www.oracledba.co.uk/ | Connor McDonald’s site |
http://www.oraperf.com/ | Maintained by Anjo Kolk |
http://www.pythian.com/ | Pythian Consulting |
http://www.dizwell.com/ | Dizwell Informatics – Howard Rogers’ site; includes a knowledge base, forums and a wiki |
http://www.petefinnigan.com/ | Pete Finnigan – lots of great Oracle security information; includes a forum. |
http://www.oracle-base.com/ | Tim Hall’s oracle resources |
http://www.miracleas.dk/ | Miracle A/S Consulting; headquartered from Mogens Nørgaard’s old garage. |
http://www.orafaq.com/ | The Oracle FAQ; also includes a forum, archives of the Oracle-L mailing list and newsgroups, and many other resources. |
http://www.centrexcc.com/ | Centrex Consulting Corporation – Wolfgang Breitling’s company. |
http://www.brendangregg.com/ | Homepage of Brendan Gregg – very smart solaris guy. Download very good DTrace toolkit here. |
http://www.dbaexpert.com/ | Charles Kim’s site. |
http://www.optimaldba.com/ | Daniel Fink’s site. |
http://www.gplivna.eu/ | Gints Plivna’s site – great paper on long-running ops. |
Blogs
Aggregators
http://orana.info/ | OraNA – Oracle News Aggregator |
Oracle
http://www.oracle.com/technology/ | Technet |
http://forums.oracle.com/ | Forums |
https://metalink.oracle.com/ | Metalink |
http://tahiti.oracle.com/ | Tahiti (db docs) |
http://www.oracle.com/corporate/pricing/pricelists.html | Price Lists |
Free Utilities and Scripts
SQL Developer | Free graphical tool for database development similar to TOAD. Browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements. Run any number of provided reports, as well as create and save your own. |
TOra | GPL graphical tool for database development. Windows binaries no longer distributed because they require commercial QT libraries but linux downloads are available. Not sure how actively this is being maintained these days although there was a sudden update on 9/18/07. |
OraSRP | Oracle Session Resource Profiler. Processes Extended SQL Trace (a.k.a. 10046 event) files, similar to Hotsos profiler. |
Swingbench | Free load generator (and benchmarks) designed to stress test an Oracle database (9i or 10g). Designed especially for RAC. |
Hammerora | Open source load generation tool for Oracle Database 8i,9i and 10g and HTML environments. |
ORION | Oracle I/O Numbers Calibration Tool designed to simulate Oracle I/O workloads. |
IOzone | Filesystem benchmark tool that generates and measures a variety of file operations (read, write, re-read, re-write, read backwards, read strided, fread, fwrite, random read, pread ,mmap, aio_read, aio_write). Ported to many machines and runs under many operating systems; useful for performing a broad filesystem analysis of a vendor’s computer platform. |
Session Snapper and SnapperLoop | Tanil Poder’s tool to report session level performance counter and wait information in real time without creating any objects. |
oracle-developer.net utilities | Collection including modified versions of Tom Kyte’s runstats harness and Jonathan Lewis’ mystats package. |
print_table and show_space | Tom Kyte’s indispensable functions. |
oraperf utilities | Kyle Hailey’s collection including an ASH Simulator and DMA Performance Monitor |
JLOCI | Jonathan Lewis Oracle Computing Index (from Miracle A/S) – SQL statement that is basically CPU bound and gives a good indication on how many LIO a certain CPU can do. Jonathan Lewis also posted a short page about the history of the “JLOCI” (which he didn’t name). |
SLB [second page] | Kevin Closson’s “Silly Little Benchmark” – for testing the memory subsystem. He specifically put this together as part of a blog series about the Opteron processor. |
SQLinForm | Java-based online SQL formatter. Very useful when troubleshooting a large, complex SQL statement. |
Instant SQL Formatter | Online SQL Formatter that doesn’t require java. |
SQL and PL/SQL Formatter | Online SQL and PL/SQL Formatter from OraFAQ. |
CVU (aka CLUVFY) | Utility that was developed to assist in the installation and configuration of Oracle Clusterware and RAC. Checks range from initial hardware setup through fully operational cluster and cover all the intermediate stages of installation and configuration of various components. |
OS Watcher | Utility by Carl Davis from Oracle’s Center of Expertise. It is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support in diagnosing performance issues. (Metalink note 301137.1) |
ProcWatcher | Tool to examine and monitor Oracle database and CRS processes at an interval. The tool will collect stack traces of these processes using Oracle tools like oradebug short_stack and OS debuggers like pstack, gdb, dbx, or ladebug. I’m pretty sure that Michael Polaski from Oracle Support put it together.(Metalink note 459694.1) |
RDA | A set of command line diagnostic scripts, executed by an engine written in Perl. Gathers detailed information about an Oracle environment; useful to aid in problem diagnosis and for seeing the overall system configuration. This also provides pre-install checks and replaces InstallPrep.sh and HCVE. (Metalink note 314422.1) |
RACDDT | Data collection tool designed and configured specifically for gathering diagnostic data related to RAC. (Metalink note 301138.1) |
RACDIAG | User friendly guide to troubleshoot RAC hung sessions or slow performance scenerios. The script includes information to gather a variety of important debug information to determine the cause of a RAC hang. (Metalink note 135714.1) |
LTOM (Lite Onboard Monitor) | Java program designed as a real-time diagnostic platform for deployment to a customer site. Provides real-time automatic problem detection and data collection. (Metalink note 352363.1) |
Oracle Default Password Scanner | SQL script that queries your Oracle database for accounts that are unlocked (open) and have default passwords. (Metalink note 361482.1) Pete Finnigan also has an excellent password scanner posted on his site. |