11g的Oracle Grid Infrastructure
2010年05月2号 |
23:59分类：Linux&Unix
, 管理维护
| 编辑
| 标签：11g
、grid
本文出自 “inthirties（男
人三十）
”博客，转载请务必注明作者和保留出处。
11g里出现了一个新角色。
Oracle Grid Infrastructure
http://download.oracle.com/docs/cd/E11882_01/install.112/e10840/oraclerestart.htm#LADBI999
The Oracle grid infrastructure for a standalone server is the Oracle
software that provides system support for an Oracle database including
volume management, file system, and automatic restart capabilities. If
you plan to use Oracle Restart or Automatic Storage Management, you must
install the grid infrastructure before installing your database. The
grid infrastructure for a standalone server is the software that
includes Oracle Restart and Automatic Storage Management. Oracle
combined the two infrastructure products into a single set of binaries
that is installed as the grid infrastructure home. The grid
infrastructure should be installed before installing Oracle Database 11g
Release 2.
Automatic Storage Management is a volume manager and a file system
for Oracle database files that supports single-instance Oracle Database
and Oracle Real Application Clusters (Oracle RAC) configurations.
Automatic Storage Management also supports a general purpose file system
for your application needs including Oracle Database binaries.
Automatic Storage Management is Oracle’s recommended storage management
solution that provides an alternative to conventional volume managers,
file systems, and raw devices.
Oracle Restart improves the availability of your Oracle database by
providing the following:
When there is a hardware or a software failure, Oracle Restart
automatically starts all Oracle components, including Oracle database
instance, Oracle Net Listener, database services, and Automatic Storage
Management.
Oracle Restart starts up components in the pro
相关文档：
1.打开cmd，输入sqlplus，回车
2.输入用户名：system/manager@orcl as sysdba，回车
3.create user muzai identified by muzai; //创建muzai用户，密码为muzai
4.grant dba to muzai; //把dba的权限赋给muzai这个用户 ......
查看当前用户的缺省表空间
SQL>select username,default_tablespace from user_users;
查看当前用户的角色
SQL>select * from user_role_privs;
查看当前用户的系统� ......
1. 游标: 容器，存储SQL语句影响行数。
2. 游标类型: 隐式游标，显示游标，REF游标。其中，隐式游标和显示游标属于静态游标（运行前将游标与SQL语句关联）,REF游标属于动态游标(运行时将游标与SQL语句关联)。
3. ......
author:skatetime:2010-05-04
在我们的系统里，大家在写pl/sql时，处理多条记录时，几乎都是通过游标来完成的，这样是非常影响性能的。我们可以用批量绑定可以大大的改善。
批量绑定是oracle9i增加的特性，是指执行单次sql操作能传递所有集合元素的数据。通过绑定绑定变量可以极大的提高数据处理速度，提高应用程 ......
