|
Technology Forum
DBA
Mr. JC. Jaffray (Expert DBA) with more
than 25 years in database management write
regulary in his BLOG and here he recommend
his favorite Oracle documentation directly
from Oracle web site, the Concept book,
reading this book is learning from inside
the black box, most of the literature on
database administration just tell you what
to do , but not why, in concept you will
understand from inside out.
Good practice for Database creation:
Using DBCA , create and maintain one main
correct template for future uses, do not
invent the wheel each time!!! Yes you
can edit the template.dbt file and use it
again.
contact him at : jc@jaffrayconsulting.com
Visit
my BLOG
Application Design
He Likes ERWIN (computer associate
trademark) to start your logical Model, then
create physical and then real DBA job start!
First thing first, before creating a good
database you should have a good application
design, your tables should be designed
correctly and your data must be cleaned,
redundant or incomplete data will create
problems down the road, this part is usually
performed by DA or Analyst.
Tuning
Did you know that almost 90% of performance
issues and problems in a production database
arise from bad SQL query, wrong index, Bad
or not enough statistics, wrong partition
(for example hash might be very slow) and
bad design, In many occasion Query are
mostly generated from some third parties
tools in a global context and in regards
with the functionalities only, in many
occasion there is not enough communication
and cooperation between DBA and developers,
or is because of issues in IT management
or inheriting an old legacy system from
some guys who moved out, Other exception
for performance exist , one important
classic one in Hardware is I/O.
But when you have fixed the issues of Bad
I/O , bad disks, Not enough memory or CPU,
you go back tuning your query.
High Availability:
Data Guard, RAC, Replication, Stream
Each has its own headache and problem, we
have tried it all, consult us, we will talk
to you why and how, if interested we will do
it, so sure we could even come with specific
time frame and budget.
|
1-571-331-6020
