- 浏览: 25990 次
- 性别:
- 来自: 北京
最新评论
Assuming you want to study oracle database, specifically to prepare yourself
as a DBA, not other products such as Apps or Developer Suite...]
1.0 Download from otn.oracle.com, or borrow CDs for, oracle server software
enterprise edition. Make sure it's not any other lesser edition. Choose the OS
you're most comfortable with. Select the version that is either (a) the latest,
or (b) the one your company is using, or (c) the most popular. Install it and
create a database.
1.1 Download full documentation from docs.oracle.com for your version. If
you're short of space, choose to install only HTML pages by deleting all .pdf
files after installation, i.e. file copying. (If you like PDF better than HTML,
then delete HTML files leaving PDFs).
2.0 If you have little experience with oracle, find a practical book such as
some OCP (Oracle Certified Professional) guide or oracle 101 and quickly go
through it. Combine this study with reading Admin guide.
2.1 If you have some experience, read the Concepts manual now. It's a tedious,
seemingly thankless process. But months of reading it, with frequent hands-on
work and experiment on your database, is the fastest way to learn oracle.
2.11 After a week of reading Concepts manual, you can start to read on public
forums such as comp.databases.oracle.server
(http://groups.google.com/group/comp.databases.oracle.serve),
http://forums.oracle.com, oracle-L
(http://www.freelists.org/archives/oracle-l/). This is because it's simply not
possible you'll encounter a large variety of problems in your own study. By
reading messages posted by others, you indirectly learn from their real-life
experience. Ignore the messages that are too difficult or non-technical, and
research those you just learned.
2.12 Constantly check the Reference manual and Admin guide while reading
Concepts because memorizing hundreds of initialization parameters, DBA_ and V$
views can't be achieved in a few weeks.
3.0 After the drudge of sequential read of the Concepts and scattered read of
Reference and hands-on work with Admin guide, you can read in either sequential
or scattered manner:
Performance tuning manual, Administration manual, "Effective oracle by Design"
(by Tom Kyte) and as great reference due to lack of updated versions, "Expert
One On One" (by Tom Kyte)
4.0 You need to constantly search on the following three web sites when you
have problems.
4.1 Google Usenet/Newsgroup archive
(http://groups.google.com/advanced_group_search). You can put in group name,
most likely comp.databases.oracle.server, occasionally
comp.databases.oracle.misc or comp.databases.oracle.tools.
4.2 Google Advanced Search (http://www.google.com/advanced_search). After this
search, you may or may not search the same thing on other web sites such as
Altavista, which was used by us before Google came to life. But occasionally
alltheweb.com can find something Google hasn't indexed yet.
4.3.0 oracle Metalink if your company purchased oracle support. This is the
only search site that is oracle-aware. By that I mean it knows "ORA-01000" is
the same as "ORA-1000" so you don't have to search twice as on any generic
search site. It knows "user$" is not the same as "user" as all other search
engines would assume. In addition, if you need to search for an oracle bug
report or patch, this is the only place.
4.3.1 oracle Metalink Advanced search. Bookmark the no-frame page URL
http://metalink.oracle.com/metalink/plsql/kno_main.newAdvancedQuery
If you search for a keyword or a string that is too obscure, do remember to
check the Bug Database as well as Archived Articles checkboxs so you get more
hits.
[continued in oracleStudy2.txt, a note of oracle research in general]
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 852declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6841.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7551.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 848thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7091.How can I get the largest amo ... -
RMAN
2012-01-14 17:07 6591.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7181.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11211.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5361.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6181.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 708When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 557A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6551.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4131.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7611.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5401. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6581.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8691.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 626ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6101.utl_file_dir: indicate the di ...
相关推荐
Instructions on how to download software via Passport Advantage site. How to download Software from PAO site.pdf
讲学习方法的,你们可以看看,很有意义,能学到很多
### how to study python ###### ANSWER Python is a great language for beginners as well as experienced programmers. There are various ways to learn Python, and some of the best sources are listed ...
How to automate Excel from MFC and Visual C++ 2005 or Visual C++ .NET to fill or obtain data in a range using arrays
HOWTO-html<br>News-HOWTO-html<br>News-Leafsite-html<br>Oracle-HOWTO-html<br>Plug-and-Play-HOWTO-html<br>PPP-HOWTO-html<br>Printing-HOWTO-html<br>QT 3.3 中文白皮书.pdf Quota RCS-...
This document will cover the process to duplicate an Oracle 10g database on another server using a Galaxy backup. This document should in no way be treated as the “End All” procedure. It is merely ...
How To Push data from BI to XI
如何有效地学习? 3 tips on how to study effectively_classic-20231213-122521.pdf
FAQ (7KB) 一份有用资讯来源的列表 Networking-HOWTO (20KB) 针对 Linux 作业系统的网路能力提出一个概观的说明 News-HOWTO (20KB) 如何设定、维护在 Linux 系统下的 USENET News 伺服器 Oracle-HOWTO ...
oracle timesten how to setup
How to Bring Data from MATLAB Into Simulink
How to Call Python from MATLAB.zip
How to Call MATLAB from Python.zip
about stock how to earn money from the market
学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习QTxczvc 学习...
介绍如何入门,如何入门如何学习好MFC编程
Grade 7 Up"Ace" is written in six chapters and presents information on test anxiety... study techniques; and standardized, objective, and written test-taking techniques for adolescent and older students.
OA Framework How to Identify Required Oracle JDeveloper Patches For Oracle E-Business Release 12.x or 11i (Doc ID 416708.1)
Polya is one of the most frequently quoted mathematicians, and the following statements from "How to Solve It" make clear why: "My method to overcome a difficulty is to go around it." "Geometry is ...
how to listen 测音软件 训练金耳朵 评分: 软件为测试听音软件 可以自定义语音、训练自己的耳朵可以分辨音频的细微差别