Èç¹û»ñÈ¡ÄãÃÎÏëµÄ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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
OracleÊý¾Ý¿âµÄÊý¾Ý¿éDB_BLOCK_SIZE´óСȷ¶¨Êý¾Ý¿âµÄ×îСÊý¾Ý¿éµÄ´óС£¬ÔÚ´´½¨±í¿Õ¼äʱ¿ÉÒÔÈç¹û²»ÏëʹÓÃĬÈϵÄÊý¾Ý¿é´óС£¬¿ÉÒÔͨ¹ýÉèÖÃ×Ô¼ºµÄÊý¾Ý¿é´óС¡£
¾ßÌåʵÀýÈçÏ£º
create tablespace test_16k
bloc ......
Oracle TNS¼òÊö
ʲôÊÇTNS?
TNSÊÇOracle NetµÄÒ»²¿·Ö,רÃÅÓÃÀ´¹ÜÀíºÍÅäÖÃOracleÊý¾Ý¿âºÍ¿Í»§¶ËÁ¬½ÓµÄÒ»¸ö¹¤¾ß,ÔÚ´ó¶àÊýÇé¿öÏ¿ͻ§¶ËºÍÊý¾Ý¿âҪͨѶ,±ØÐëÅäÖÃTNS,µ±È»ÔÚÉÙÊýÇé¿öÏÂ,²»ÓÃÅäÖÃTNSÒ²¿ÉÒÔÁ¬½ÓOracleÊý¾Ý¿â,±ÈÈçͨ¹ýJDBC.Èç¹ûͨ¹ýTNSÁ¬½ÓOracle,ÄÇô¿Í»§¶Ë±ØÐë°²×°Oracle client³ÌÐò.
TNSÓÐÄÇЩÅäÖÃÎļþ ......
ÏÈ¿´ÏÂÃæµÄÀý×Ó: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 ......