Oracle 10g 创建表空间慢问题 - 数据库编程

=====end date:Mon Dec 5 11:04:01 EAT 2011===============
$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 397 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <create tablespace test4 datafile '/oradata/test4.dbf' size 2048M;
quit;
EOF
echo "===========end date:`date`==============="

"create_tablespace.sh" 10 lines, 397 characters
$ ./create_tablespace.sh
===========start date:Mon Dec 5 11:05:32 EAT 2011 ============

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 11:05:32 2011

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL>
Tablespace created.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
===========end date:Mon Dec 5 11:16:03 EAT 2011===============
$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 397 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <create tablespace test3 datafile '/data/test3.dbf' size 2048M;
quit;
EOF
echo "===========end date:`date`==============="

$ vi create_tablespace.sh
"create_tablespace.sh" 10 lines, 397 characters
#!/bin/sh
echo "===========start date:`date` ============"
sqlplus / as sysdba <create tablespace test3 datafile '/data/test3.dbf' size 2048M;
quit;
EOF
echo "===========end date:`date`==============="

$ ./create_tablespace.sh
===========start date:Mon Dec 5 12:43:34 EAT 2011 ============

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 12:43:34 2011

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SQL> SQL>
Tablespace created.

Oracle 10g 创建表空间慢问题(二)