Monthly Archives: March 2014

ORACLE Tuning

 

sql_tuning_hierarchy

With this post we are going to make ths first of a serie to aproach to
a big oracle topic, tuning, u can read a entire book only talking about tuning, so here only will write some tips, for a detail lecture please take a book or visit a tuning guru website.

Continue reading

Advertisements

Larry Ellison, the ‘god’ of Oracle I

The busy life of a computer guru, Larry Ellison, the ‘god ‘ of Oracle
Lawrence Joseph Ellison was born the son of a single mother in Chicago 56 years ago . Achieving their full business got when he founded the software company Oracle . Selfish and whimsical, is one of the most controversial figures of the current technological landscape .

Continue reading

How many rows there are in each block of a table?

Is very easy know how many rows fit into each block and very easy to check. lets see example:

We have 8 KB blocks

sho parameter db_block_size

NAME TYPE VALUE
———————————— ———– ——————————
db_block_size integer 8192

Continue reading

First job day as ORACLE DBA

 

You get dba job, using help my las post :),  now first day, i will no let you alone with out help.

What I will mention are general questions regarding the work of a DBA for the first day and I hope they are useful for people who have experience , and much more for those who do not.

Continue reading

Tips to get a dba job I

 

 

 

 

 

Is a Catch 22: For get a dba job you first need have experience, but you must get a job to get experience.

DBA market can be divided into two groups – juniors and seniors.

Juniors with less than three years of experience, guys, bad news, companys not use to hire this kind of profiles, normal big companys never hire junior dbas, but no all is lost, there companys that no want spend more than $90k annually for a experienced profesional, and
sometimes take juniors and train them.

Continue reading