如果获取你梦想的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
相关文档:
Oracle数据库的数据块DB_BLOCK_SIZE大小确定数据库的最小数据块的大小,在创建表空间时可以如果不想使用默认的数据块大小,可以通过设置自己的数据块大小。
具体实例如下:
create tablespace test_16k
bloc ......
Oracle 物件的命名限制
任何物件的名稱不得超過 30 位元(Bytes)
Oracle 的 dummy query 寫法
SELECT SYSDATE from dual
Oracle 選取部分資料的方法
SELECT * from table WHERE ROWNUM<10; /* 取出前 10 筆 */
實現 Oracle 上的分頁顯示 [精華] ......
Oracle TNS简述
什么是TNS?
TNS是Oracle Net的一部分,专门用来管理和配置Oracle数据库和客户端连接的一个工具,在大多数情况下客户端和数据库要通讯,必须配置TNS,当然在少数情况下,不用配置TNS也可以连接Oracle数据库,比如通过JDBC.如果通过TNS连接Oracle,那么客户端必须安装Oracle client程序.
TNS有那些配置文件 ......
每隔几秒钟listener日志中就出现一次该错误的记录,即使是在没有人使用的情况下也是如此,不过并没有发现客户端机器不能正常连接数据库的情况。
Oracle关于TNS-12502错误的解释:
Error: ORA-12502 / TNS-12502
Text: TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was ......