Advice on maintaining a DB

[FSM]

Hi guys, I was wondering if you could hand out a couple of tips on how to maintain a db, how do i know if it's fragmented, do I export and then "alter" my tables?? how can i see what tables are full???where and how can i start.

Thank you guys!!!!


FSM

 

[Turkbear]

Much too large a topic for a forum...See the 'Backup and Recovery' and 'Tuning' manuals ...Also the Oracle Server Concepts and other docs....

 

[FSM]

I know that it is a huge topic, but i just wanted a "north"(where to begin) because im reading a lot but some times i just want to "jump" into somethings and you guys,(turkbear, Karluk among others)have been very helpful, since im a beginer in oracle. I just wanted a couple of advise to what to "look for" for maintaining my db.

Thanks

FSM