一些oracle相关网站

Websites

http://www.freelists.org/webpage/oracle-lThe Oracle-L Mailing Listhttp://groups.google.com/group/
comp.databases.oracle.server/comp.databases.oracle.server on usenethttp://www.oaktable.netOak Table Networkhttp://www.jlcomp.demon.co.uk/Jonathan Lewis’ tips and consultancy.http://www.juliandyke.com/Julian Dykehttp://www.hotsos.com/Hotsos – Cary Millsaphttp://www.ixora.com.au/Steve Adamshttp://www.puschitz.com/Werner Puschitzhttp://www.evdbt.com/Evergreen Database Technologies – lots of papers by Tim Gorman and Jeff Mareshhttp://www.tanelpoder.com/Tanel Poderhttp://integrid.info/Small consulting org of Tanel Poderhttp://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 sitehttp://www.oraperf.com/Maintained by Anjo Kolkhttp://www.pythian.com/Pythian Consultinghttp://www.dizwell.com/Dizwell Informatics – Howard Rogers’ site; includes a knowledge base, forums and a wikihttp://www.petefinnigan.com/Pete Finnigan – lots of great Oracle security information; includes a forum.http://www.oracle-base.com/Tim Hall’s oracle resourceshttp://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

http://www.matttopper.com/Matt Topper – another fellow ITC dude, seems to be doing a lot of java stuff these dayshttp://www.dannorris.com/Dan Norris – chair of RAC SIG, DB server guy for COUG, chair of the dev DBA SIG for ODTUG.http://padraigs.blogspot.com/Padraig O’Sullivan – fellow ITC dude, experience with core dba and unix os stuffhttp://orajourn.blogspot.com/Charles Schultzhttp://blogs.oracle.com/AlejandroVargas/Alejandro Vargas – lots of great RAC and ASM tipshttp://tonguc.wordpress.com/Tonguc Yilmezhttp://seilerwerks.wordpress.com/Don Seiler (old site was http://ora.seiler.us/)http://laurentschneider.com/Laurent Schneider (sweet last name)http://jonathanlewis.wordpress.com/Jonathan Lewishttp://kevinclosson.wordpress.com/Kevin Clossonhttp://oramossoracle.blogspot.com/Jeff Mosshttp://tkyte.blogspot.com/Tom Kyte – for more technical content see the AskTom websitehttp://blogs.sun.com/glennf/Glenn Fawcett – doesn’t seem to be a lot of recent activity but he does seem like a rather smart chap.http://blog.oracloid.com/Alex Gorbachev’s old blog.http://www.pythian.com/blogs/author/alexAlex Gorbachev’s new blog.http://oracledoug.com/Doug Burnshttp://dbasrus.blogspot.com/Nuno Soutohttp://oraclesponge.wordpress.com/David Aldridgehttp://el-caro.blogspot.com/Farlie Regohttp://wedonotuse.blogspot.com/Mogens Nørgaardhttp://www.dizwell.com/prod/blogHoward Rogershttp://www.rittmanmead.com/Mark Rittman – he has a lot of great BI stuff.http://www.petefinnigan.com/weblog/entries/Pete Finniganhttp://pjsrandom.wordpress.com/Peter Scotthttp://www.oracle-base.com/blog/Tim Hallhttp://storagemojo.com/Robin Harris – storage related stuffhttp://igor-db.blogspot.com/Gary Myershttp://www.oraclemusings.com/Dominic Delmolinohttp://christianbilien.wordpress.com/Christian Bilien – excellent RAC materialhttp://optimaldba.blogspot.com/Daniel Finkhttp://sysdba.wordpress.com/Lutz Harmannhttp://blog.tanelpoder.com/Tanel Poderhttp://www.uaex.edu/srea/Steve Rea – Oracle and Bannerhttp://halisway.blogspot.com/Hampus Linden – has some great scriptshttp://kleinoracledenkraam.wordpress.com/Erik Buddelmeijerhttp://oraexplorer.com/Ittichai Chammavanijakul – fellow seminary-educated Chicago-area DBA :)

 

Aggregators

http://orana.info/OraNA – Oracle News Aggregator

 

Oracle

http://www.oracle.com/technology/Technethttp://forums.oracle.com/Forumshttps://metalink.oracle.com/Metalinkhttp://tahiti.oracle.com/Tahiti (db docs)http://www.oracle.com/corporate/pricing/pricelists.htmlPrice Lists

 

Free Utilities and Scripts

SQL DeveloperFree 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.TOraGPL 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.OraSRPOracle 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.ORIONOracle I/O Numbers Calibration Tool designed to simulate Oracle I/O workloads.IOzoneFilesystem 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 SnapperLoopTanil Poder’s tool to report session level performance counter and wait information in real time without creating any objects.oracle-developer.net utilitiesCollection including modified versions of Tom Kyte’s runstats harness and Jonathan Lewis’ mystats package.print_table and show_spaceTom Kyte’s indispensable functions.oraperf utilitiesKyle Hailey’s collection including an ASH Simulator and DMA Performance MonitorJLOCIJonathan 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.SQLinFormJava-based online SQL formatter. Very useful when troubleshooting a large, complex SQL statement.Instant SQL FormatterOnline SQL Formatter that doesn’t require java.SQL and PL/SQL FormatterOnline 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 WatcherUtility 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)ProcWatcherTool 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)RDAA 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)RACDDTData collection tool designed and configured specifically for gathering diagnostic data related to RAC. (Metalink note 301138.1)RACDIAGUser 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 ScannerSQL 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.