dbTalk Databases Forums  

I am new database administrator.

comp.databases.oracle.server comp.databases.oracle.server


Discuss I am new database administrator. in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Monwar
 
Posts: n/a

Default I am new database administrator. - 07-14-2011 , 12:02 AM






Sir, I am new database administrator so what i will do and how can i
will become a expert? from where i will start to study. PLZ give me
some tips. Thanks

Reply With Quote
  #2  
Old   
gazzag
 
Posts: n/a

Default Re: I am new database administrator. - 07-14-2011 , 04:40 AM






On Jul 14, 6:02*am, Monwar <monwa... (AT) gmail (DOT) com> wrote:
Quote:
Sir, I am new database administrator so what i will do and how can i
will become a expert? from where i will start to study. PLZ give me
some tips. Thanks
You could do worse than start with the Oracle Concepts guide:

http://download.oracle.com/docs/cd/E...e16508/toc.htm

HTH
-g

Reply With Quote
  #3  
Old   
joel garry
 
Posts: n/a

Default Re: I am new database administrator. - 07-14-2011 , 10:50 AM



On Jul 13, 10:02*pm, Monwar <monwa... (AT) gmail (DOT) com> wrote:
Quote:
Sir, I am new database administrator so what i will do and how can i
will become a expert? from where i will start to study. PLZ give me
some tips. Thanks
Welcome! Here is a (slightly old) welcome to the group:
http://dbaoracle.net/readme-cdos.htm

The best way to become an expert is to be inquisitive and try things
on your own test systems. The best experts not only do that, but tell
you how to do it too! So, as gazzag suggested, the very first thing
to do is read the Concepts manual, and don't forget to re-read
sections as you become more curious about particular concepts. The
next thing, if you haven't already, is to download Oracle onto your
own system. otn.oracle.com lets you download a full featured
enterprise edition to your laptop or pc, assuming you have a
relatively modern system. Also, your work ought to have a test system
which reflects your production system, that of course varies by site.
After that, different people have different ways they learn best, but
it is better to use several different ways of learning: watch videos,
read, make your own system fail, question what experts tell you by
trying it on your own system, and especially learn how to participate
in the various online fora. Pay close attention to the "How to ask
smart questions" link in the readme, different fora have slightly
different rules, but there are things that everyone appreciates such
as: checking the docs before asking; be explicit about which versions
and operating systems you are referring to; and if you are asking a
coding question, give a script to set up a test case so people can
quickly set up their own tests. People want to help, so help them
help you! Always remember they can't see what is on your screen, so
you have to tell them about it.

Database administrator has a variable definition, so where to go next
is up to your situation. Check out the Tom Kyte books, and the ones
he recommends at http://asktom.oracle.com .

jg
--
@home.com is bogus.
http://www.zdnet.com/blog/howlett/do...to-oracle/3291

Reply With Quote
  #4  
Old   
rogergorden@....gmail.com
 
Posts: n/a

Default Re: I am new database administrator. - 07-14-2011 , 01:47 PM



On Jul 14, 1:02*am, Monwar <monwa... (AT) gmail (DOT) com> wrote:
Quote:
Sir, I am new database administrator so what i will do and how can i
will become a expert? from where i will start to study. PLZ give me
some tips. Thanks
Learn how to properly backup and restore a database using RMAN.
Learn how and when to supplement these RMAN backups with exports using
expdp and impdp.
Learn how to properly take advantage of Oracle's flashback query
feature.
Learn how to use Oracle's Grid Tuning Advisor to tune and take a
course or read some books to determine when Oracle's Grid Tuning
Advisor really doesn't make good recommendations so you can tune
poorly written SQL.
Learn how to properly size and tune Oracle's SGA and PGA.

Everything else is just cool SQL tricks!

Reply With Quote
  #5  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: I am new database administrator. - 07-14-2011 , 01:55 PM



On Thu, 14 Jul 2011 08:50:50 -0700, joel garry wrote:

Quote:
The best way to become an expert is to be inquisitive and try things on
your own test systems.
Not unlike checking the gas in your tank by lighting a match. That's
curiosity and testing combined. And a Darwin, too.



--
http://mgogala.byethost5.com

Reply With Quote
  #6  
Old   
joel garry
 
Posts: n/a

Default Re: I am new database administrator. - 07-14-2011 , 05:14 PM



On Jul 14, 11:55*am, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:
Quote:
On Thu, 14 Jul 2011 08:50:50 -0700, joel garry wrote:
The best way to become an expert is to be inquisitive and try things on
your own test systems.

Not unlike checking the gas in your tank by lighting a match. That's
curiosity and testing combined. And a Darwin, too.

--http://mgogala.byethost5.com
That would be trying things on production systems :-O

(Did I post here about my propane to city gas conversion experience?)

jg
--
@home.com is bogus.
But those crazy Croatians:
http://dailypicksandflicks.com/2011/...asoline-spill/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.