用户执行sql语句
user process把语句送给server process
server processshared pool是否有sql的解析
如果有就直接...]]> blog lijiebin Mon, 14 Jan 2008 15:08:09 GMT http://space.itpub.net/8135069/viewspace-136105

Oracle中写Procedure一直是Oracle开发中比较复杂的地方，但是掌握procedure 和cursor将使得你在Oracle开发中如鱼的水，真正体会Oracle的强大。下面通过我自己写的一个Procedure简单就proce...]]> blog lijiebin Thu, 10 Jan 2008 15:23:49 GMT http://space.itpub.net/8135069/viewspace-136104 怎么放呢?
warehouse对temp研究深啊]]> blog lijiebin Thu, 10 Jan 2008 14:57:33 GMT http://space.itpub.net/8135069/viewspace-136103
TO_UUID                                            CHAR(12)
TO_LOGINNAME&nb...]]> blog lijiebin Thu, 10 Jan 2008 13:02:51 GMT http://space.itpub.net/8135069/viewspace-136102 比如有个变量money
当money>1000时,返回1,否则返回0]]> blog lijiebin Thu, 10 Jan 2008 12:56:59 GMT http://space.itpub.net/8135069/viewspace-136101 TO_UUID                                            CHAR(12)
TO_LOGINNAME  &...]]> blog lijiebin Thu, 10 Jan 2008 10:46:44 GMT http://space.itpub.net/8135069/viewspace-136100 表jet 在lijiebin用户下
现在的用户是 xiaomianhua
create index jet_ind on lijiebin.jet(loginname);
当前用户使用表jet时会用到jet_ind这个索引的
请问用户lijiebin和其他的用户会用该表的索引吗?]]> blog lijiebin Tue, 08 Jan 2008 15:07:50 GMT http://space.itpub.net/8135069/viewspace-136099 我想把186这台机器的密码不用手工输入,直接写在命令行中,怎么写呢,假如密码为pwd]]> blog lijiebin Thu, 03 Jan 2008 11:07:46 GMT http://space.itpub.net/8135069/viewspace-136098 database, the size of Database Buffer Cache needs to be increased immediately for
the current as well as future instances of the database. The Oracle instance ...]]> blog lijiebin Wed, 02 Jan 2008 18:12:51 GMT http://space.itpub.net/8135069/viewspace-136097 performed the first time any UPDATE statement is issued after the instance is
started? Choose two

A. Creating the parse tree of the statem...]]> blog lijiebin Wed, 02 Jan 2008 18:00:49 GMT http://space.itpub.net/8135069/viewspace-136096 select substr(to_char(sysdate,'yyyymmddhh24mi'),1,8) cdkau from dual;
spool /home/lijiebin/lijie&&filename..txt
........

我每天都运行a.sql的脚本
产生文件名为lijie20080...]]> blog lijiebin Wed, 02 Jan 2008 15:24:22 GMT http://space.itpub.net/8135069/viewspace-136095 oca多少题啊,2个小时内能做完吗
怎么把握做题的速度呢?]]> blog lijiebin Sat, 29 Dec 2007 10:01:01 GMT http://space.itpub.net/8135069/viewspace-136094 A.Indexes and views can be created on temporary tables.
B.Both the data and the structure of temporary tables can be exported.
C.Temporary tables are alw...]]> blog lijiebin Fri, 28 Dec 2007 10:42:43 GMT http://space.itpub.net/8135069/viewspace-136093 In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The
job has successfully completed. Which three pieces of information would you check to confirm that the ...]]> blog lijiebin Thu, 27 Dec 2007 15:26:14 GMT http://space.itpub.net/8135069/viewspace-136092 up at regular intervals without your intervention. What should you do to achieve the objective?
A.configure the da...]]> blog lijiebin Thu, 27 Dec 2007 14:18:58 GMT http://space.itpub.net/8135069/viewspace-136091 1.Shut down the instance, if not already done.
2.Copy one of the remaining control files to a new location.
3.Change the value of the CONTR...]]> blog lijiebin Wed, 26 Dec 2007 10:27:31 GMT http://space.itpub.net/8135069/viewspace-136090 QUESTION 101:
Which two statements about Flashback Query are true? (Choose two.)
A.It is generated by using the redo log files.
B.It helps in row-level recovery from user errors.
C.It can be perfor...]]> blog lijiebin Wed, 26 Dec 2007 10:16:13 GMT http://space.itpub.net/8135069/viewspace-136089 blog lijiebin Wed, 12 Dec 2007 22:17:09 GMT http://space.itpub.net/8135069/viewspace-136088 我的油箱
lijiebinjing@163.com]]> blog lijiebin Wed, 28 Nov 2007 18:49:58 GMT http://space.itpub.net/8135069/viewspace-136087
You execute the following set of commands to create a database user and to grant
the system privileges in your production environment.
SQL> CREATE USER user01
IDENTIFIED BY oracle
DEFAULT...]]> blog lijiebin Thu, 22 Nov 2007 12:48:55 GMT http://space.itpub.net/8135069/viewspace-136086 in group 2, and archiving has stopped. All the redo logs are filled and database
activity is halted. Database writer has written everything to disk. Whic...]]> blog lijiebin Thu, 22 Nov 2007 12:39:05 GMT http://space.itpub.net/8135069/viewspace-136085 和delete同样一条记录
两个操作,哪个占用undo大呢?为什么]]> blog lijiebin Wed, 21 Nov 2007 12:32:23 GMT http://space.itpub.net/8135069/viewspace-136084 这句话怎么翻译呢?]]> blog lijiebin Mon, 19 Nov 2007 14:43:29 GMT http://space.itpub.net/8135069/viewspace-136083 那么让优化器只用rbo,而不用cbo吗??]]> blog lijiebin Thu, 15 Nov 2007 15:36:00 GMT http://space.itpub.net/8135069/viewspace-136082 输出结果为700万行
a为1000万行,b为800万行的表
a的key,和b的key都是唯一索引
上面的查询,
a走索引,b不走
a走,b走
a不走,b走
a,b都...]]> blog lijiebin Wed, 14 Nov 2007 14:45:09 GMT http://space.itpub.net/8135069/viewspace-136081 表a,1亿行
spool /home/lijiebin/a.txt
select * from a
跑了半天没反应啊
有什么可以变快的方法吗?]]> blog lijiebin Tue, 13 Nov 2007 16:30:09 GMT http://space.itpub.net/8135069/viewspace-136080 房子还没找好
何时能象db一样,不时常的迁移呢?
何时能象db一样,有个高可用的地方住呢?]]> blog lijiebin Tue, 13 Nov 2007 14:04:33 GMT http://space.itpub.net/8135069/viewspace-136079


Import: Release 9.2.0.5.0 - Production on Tue Nov 6 15:32:55 2007

...]]> blog lijiebin Tue, 06 Nov 2007 15:35:41 GMT http://space.itpub.net/8135069/viewspace-136078 回来的时候客户端已经断掉
出现了错误,怎么解决呢


SQL> select * from temp_ge
  2  /

no rows selected

SQL>...]]> blog lijiebin Fri, 02 Nov 2007 12:14:03 GMT