-- 使用绑定变量
1.打开时间显示
SQL> set timing on ;
2.语句绑定变量
select * from trans_table t where t.id = &id;
3.语句块
SQL> create table D ( id varchar(10));
绑定前
declare
i number;
sqlstr varchar(2000);
begin
for i in 1 .. 10000 loop
sqlstr := ' insert into d values(' || to_char(i) || ')';
execute immediate sqlstr;
end loop;
commit;
end;
绑定后
declare
i number;
sqlstr varchar(2000);
begin
for i in 1 .. 10000 loop
sqlstr := ' insert into d values(:i)';
execute immediate sqlstr
using i;
end loop;
end;
1.打开时间显示
SQL> set timing on ;
2.语句绑定变量
select * from trans_table t where t.id = &id;
3.语句块
SQL> create table D ( id varchar(10));
绑定前
declare
i number;
sqlstr varchar(2000);
begin
for i in 1 .. 10000 loop
sqlstr := ' insert into d values(' || to_char(i) || ')';
execute immediate sqlstr;
end loop;
commit;
end;
绑定后
declare
i number;
sqlstr varchar(2000);
begin
for i in 1 .. 10000 loop
sqlstr := ' insert into d values(:i)';
execute immediate sqlstr
using i;
end loop;
end;
-- 查看表空间的读写信息，数据文件I/O
select * from v$filestat;
select * from dba_data_files t;
select * from v$filestat;
select * from dba_data_files t;
-- 查看oracle安装的组件
select * from dba_registry;
select * from dba_registry;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769573/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
