-
编辑 删除
本人投过简历DBA职位的公司
2007-6-11 灵川软件2007-6-13 杭州龙健科技2007-6-23杭州卡当网2007-7-5杭州彩通2007-9-10今天投了网新恒天的Asst. Database Engineer,也就是道富公司的职位.哈哈,管他呢先投了再说![@more@]
-
编辑 删除
Oracle Dynamic views
The Oracle server provides a number of standard views to obtain information on the database andinstance. These views include:V$SGA: Queries the size of the size of the instance for the shared pool, log buffer, data buffercache, and fixed memory sizes(operating system-dependent).V$INSTANCE: Queries the status of the instance, such as the instance mode, instance name, startup time, and host name.V$PROCESS: Queries the background and server processes created for the instance.V$BGPROCESS: Queries t
-
编辑 删除
练习二
建立用户wangyi: SQL>create user wangyi identified by wangyi default tablesapce testdata; 赋予DBA的权限: SQL> grant conn,dba to wangyi; 建立department和employees表: SQL>CREATE TABLE employees( employee_id NUMBER(6), first_name VARCHAR2(20), last_name VARCHAR2(25),email VARCHAR2(25), phone_number VARCHAR2(20), hire_date DATE DEFAULT SYSDATE, job_id VARCHAR2(10), salary NUMBER(8,2), commission_pct NUMBER (2,2), manager_id NUMBER(6), department_id NUMBER(4) ) tablespace testdata; SQL>CRE
-
编辑 删除
练习一
在windows 2003下安装了oracle 9204,新建数据库ORA92.用sql语句新建表空间testdata: sql>create tablespace testdata datafile 'F:ORACLEORADATAORA92 estdata01.dbf' size 100M autoextend on next 5M maxsize 200M; 以后的练习就以这个数据库和表空间为基础了。You can remove a tablespace from the database when the tablespace and its contents are no longerrequired with the following commond: Drop TABLESPACE tablespace [INCLUDEING CONTENTS [AND DATAFILES] [CADCADE CONSTRAINTS]] where: tablespace --- specifies t
-
编辑 删除
决定转型做一名oracle DBA!
准备今年转型做一名oracle DBA,从去年7月开始从事技术支持工作开始接触oracle到现在也有一年的时间了,但是说实话对oracle了解的并不够多,从oracle的系统结构到备份恢复,从sql语句到oracle性能调优都不是很清楚.我希望自己能在今年剩下的时间里能具有初级DBA的水平,并能找到一份DBA的工作.今天开通blog也是希望能够坚持下去并在这里记录自己的学历历程.[@more@]
