10g中dbms_shared_pool取消了.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
SQL> select owner,object_name from all_objects where object_name='DBMS_SHARED_POOL';
OWNER OBJECT_NAME
------------------------------ ------------------------------
SYS DBMS_SHARED_POOL
SYS DBMS_SHARED_POOL
可在10g中,
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
SQL> select owner,object_name from all_objects where object_name='DBMS_SHARED_POOL';
OWNER OBJECT_NAME
------------------------------ ------------------------------
SQL>
已经没有了
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/197458/viewspace-1006320/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量152
-
访问量724077
最新文章
- hadoop 代码编译 mvn报错 Unsupported major.minor version 51.0
- windows 根据标题，关闭进程
- expdp ORA-31637 ORA-06512 ORA-39080 ORA-00832
- grant debug connect session to db_test;
- 11g 启用或关闭自动统计任务
- ORA-600 [kkopmCheckSmbUpdate:2] or [kkopmCheckSmbUpdate:3]
- sqlserver 2005 安装注意事项
- http://www.tianya.cn/publicforum/content/no11/1/1136654.shtml
- 修改上传文件大小
- oracle bulk collects 之 java select
