如果获取你梦想的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
相关文档：
1、查找表的所有索引（包括索引名，类型，构成列）：
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = 要查询的表
2、查找表的主键（包括名称，构成列）：
select cu.* from user_cons_columns cu, user_constr ......
在对数据库进行操作过程中我们可能会遇到这种情况，表中的数据可能重复出现，使我们对数据库的操作过程中带来很多的不便，那么怎么删除这些重复没有用的数据呢?
重复数据删除技术可以提供更大的备份容量，实现更长时间的数据保留，还能实现备份数据的持续验证，提高数据恢复服务水平，方便实现数据容灾等。 重复的数据 ......
Oracle数据库的数据块DB_BLOCK_SIZE大小确定数据库的最小数据块的大小，在创建表空间时可以如果不想使用默认的数据块大小，可以通过设置自己的数据块大小。
具体实例如下：
create tablespace test_16k
bloc ......
相当于alias(别名),比如把user1.table1在user2中建一个同义词table1
create synonym table1 for user1.table1;
这样当你在user2中查select * from table1时就相当于查select * from user1.table1;
优点自己总结吧。
例如：
在oracle中对用户的管理是使用权限的方式来管理的，也就是说，如果我们想使用数据库，我� ......
