Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Free Oracle DBA tests on the web

Re: Free Oracle DBA tests on the web

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 20 Mar 2001 10:37:23 -0800
Message-ID: <F001.002D20D3.20010320103158@fatcity.com>

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 mm

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 Chris
Dempster's site (includes OCP guides)
http://www.geocities.com/kgkrish K Gopalakrishnan's site (Details of new 8i OCP)
http://cramsession.brainbuzz.com/
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--------------------------

U may find these white papers useful:

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US