如果获取你梦想的Oracle DBA职位
How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Oracle DBAs commonly earning more than $130,000 and with Oracle superstars earning more than $250,000.
There are two major reasons for higher salaries among Oracle professionals. First, Oracle DBAs manage databases that are worth billions of dollars, and with big responsibilities come big salaries. Second, Oracle’s database is the world’s most robust and flexible in the industry, and it often takes years to learn all of its nuances.
Learn more about how to get an Oracle DBA job
Read about how to get a high-paying Oracle job
Read this three-part series to learn more about becoming an Oracle professional
Oracle Corp. recently published its 2009 Oracle salary survey, which showed the average salary for a DBA is $97,000, with higher salaries among those located in large cities. The salary survey also showed that experience, along with the level of job responsibility, is what makes the biggest difference when it comes to the level of one’s salary.
As a general guideline, a well-qualified Oracle professional, typically someone with a master’s degree, will earn three times his age. For example, a 30-year-old Oracle professional can expect, on average, to make $90,000 per year.
Before we continue, however, a reality check is in order. No company is going to pay you top-dollar as a junior Oracle professional unless you have demonstrated a commitment to professional database management. This commitment is best shown by successfully completing an extensive amount of college coursework. If you don’t possess at least a bachelor’s degree in software engineering, information systems or computer science, you will find it difficul
相关文档:
索引组织表(IOT)有一种类B树的存储组织方法。普通的堆组织表是以一种无序的集合存储。而IOT中的数据是按主键有序的存储在B树索引结构中。与一般B树索引不同的的是,在IOT中每个叶结点即有每行的主键列值,又有那些非主键列值。
在IOT所对应的B树结构中,每个索引项包 ......
Oracle数据库的数据块DB_BLOCK_SIZE大小确定数据库的最小数据块的大小,在创建表空间时可以如果不想使用默认的数据块大小,可以通过设置自己的数据块大小。
具体实例如下:
create tablespace test_16k
bloc ......
vi /opt/back.sh(oracle用户)
#!/bin/ksh
tim=`date +%Y%m%d`
unset USERNAME
#export DISPLAY=0.0.0.0:0.0
#export ORACLE_BASE=/home/oraprod3
#export ORACLE_HOME=/prod/oracle/prod3db/9.2.0
#export ORACLE_SID=PROD3_db
#export LD_LIBRARY_PATH=/prod/oracle/prod3db/9.2.0/lib
#export ORACLE_TERM=vt100 ......
先看下面的例子:oracle中两个系统表.emp,dept.
example:
1:not exists(not in)
not exists:
这条语句返回select * from scott.dept d where e.deptno=d.deptno and d.deptno=10条件满足的结果集.也就是说,
返回的结果集中不存在d.deptno=10结果集的记录,即emp表中没有dept表中d.deptno=10的记录.
SQL& ......
1、数据库的逻辑结构和物理结构:
Oracle logically divides the database into a smaller units to manage ,store,and retreive
data efficently.
Tablespace\Blocks\Extents\segment\
有四种segment:
data segment、Index segment、Temporay segment、Rollback Segment
temporary segment:
Ar ......