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 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.
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).