Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Free Oracle DBA tests on the web
Andrey,
Here is a partial list that I have.
I give credit for these site and their content to the original authors. This is a
partial list I have gleaned from this list.
ROR mª¿ªm
http://www.stewartmc.com/oracle
http://www.stewartmc.com/oracle/tips.html
www.oraes.com/scr/expfull.sh
http://www.lazydba.com http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/ http://www.oreilly.com/catalog/orinternals/www.perl.com
http://www.hot-oracle.com/ http://www.pitchmark.freeserve.co.uk/cert.htm http://www.brainbench.com/ http://www.oraclenotes.com/ http://www.selftestsoftware.com http://www.geocities.com/SiliconValley/Heights/1397/index.htm ChrisDempster's site (includes OCP guides)
http://technet.oracle.com http://www.orafaq.org http://www.lazydba.com http://www.oracle-dba.com http://www.revealnet.com/generator.htm http://ourworld.compuserve.com/homepages/Peter_Koletzke http://www.orafans.com http://www.oreview.com/ http://www.solvit.net/dbscripts http://www.ipass.net/~davesisk/oont.htm http://www.oracle-users.com http://www.oracleguru.com http://www.dbdomain.com http://www.oracletool.com/ http://www.stewartmc.com/oracle/ http://www.teleport.com/~jkstill/util/ http://www.ozemail.com.au/~gpiper/index.html http://homepage.interaccess.com/~akaplan/oracle.html http://www.AppsDBA.com http://www.orapub.com http://www.oramag.com/ http://www.uaex.edu/srea/ http://www.onwe.co.za/frank/faqmain.htm http://www.geocities.com/SiliconValley/Peaks/4535/oracle/www.mindspring.com/~hayden
http://www.jlcomp.demon.co.uk/index.html (scroll down) http://www.webdiego.com/osr http://www.appsdba.com (oracle application orientated) http://www.tusc.com tuning tips--------------------------
"Oracle Performance and Tuning: Overview"
http://pillango.sirma.bg/oracle/N014_p%26t_overview.pdf
"Performance Tuning - Now You are the V8 Expert"
http://pillango.sirma.bg/oracle/N023_tun_all.doc
"Identifying Resource Intensive SQL in a production environment" -
http://pillango.sirma.bg/oracle/N026_tuning2.pdf
"Database Tuning Methodology" -
http://pillango.sirma.bg/oracle/N027_DB_Tune.doc
"SQL Tuning for the Oracle DBA" -
http://pillango.sirma.bg/oracle/N050_tuning.pdf
"Practical Tuning Advice for the Oracle8 DBA" -
http://pillango.sirma.bg/oracle/N064_tuning.pdf
"Finding the Performance Bottlenecks in Your Application" -
http://pillango.sirma.bg/oracle/N067_performance.pdf
"Inside the Oracle Cost Based Optimizer" -
http://pillango.sirma.bg/oracle/N080_optimizer.doc
"Seven Deadly SQL Traps and How to Avoid Them" -
http://pillango.sirma.bg/oracle/N082_tuning.doc
"Secrets of SQL and Application Tuning" -
http://pillango.sirma.bg/oracle/N108_tuning.doc
You can get the same kind of info on indexes. For sample code see the
following:
http://www.oracle.com/oramag/code/cod04139.html
http://www.solvit.net/dbscripts/resize_db.html http://www.dbasupport.com/scripts/Administration/Session_Management/
HOT BACKUP INFO
http://www.wolfenet.com/~jeremiah/hot-backup.html
24X7 oracle
http://www.wolfenet.com/~jeremiah/oracle.html
"Oracle DBA Checklist"
http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf
"DBA101: A Refresher Course"
http://pillango.sirma.bg/oracle/N092_dba.doc
http://harbinger.sirma.bg/Oracle
Here's a newer (v1.3) version of the same document.
http://www.geocities.com/tbcox23/dba_checklist13.doc http://technet.oracle.com/software/products/oem/software_index.htm
http://technet.oracle.com/cgi-bin/go?oem21-full
Account administration guidelines. The table of contents:
http://www.oreilly.com/catalog/orasec/toc.html
and here is a sample chapter, "Developing a Database Security Plan":
http://www.oreilly.com/catalog/orasec/chapter/ch07.html
FREE SPACE SCRIPT
Take a look at OraSnap : http://www.stewartmc.com/oracle/orasnap/
RAID INFO
http://sw.expert.com
REPORT.TXT info
Try send a few sample report files to http://www.oraperf.com/.
CRAMMSESSION ORACLE 8i UPGRADE
http://cramsession.brainbuzz.com/cramsession/oracle/Oracle8iupgrade
EXCEL to ORACLE
http://www.oraxcel.com
STATUS REPORT TIPS
www.arikaplan.com
REDO LOG INFO
For info on the log block size, please see
http://www.ixora.com.au/tips/creation/raw_log_files.htm.
For the answer on redo wastage please see
http://www.ixora.com.au/q+a/1999_09.htm and scroll down to the entry
from 25 September 1999.
>>> bronfin_at_visualtop.com 03/20/01 12:36PM >>>
Hi DBAs !
I'm looking for some FREE Oracle DBA / developer resources on the web :
self-tests , OCP preparations materials , articles , books , etc ...
Please share your resources !
Thanks a lot in advance .
Andrey .
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Mar 20 2001 - 12:37:23 CST