-
编辑 删除
关于虚拟机装oracle10g64位数据库查看版本位数有趣的问题
环境：虚拟机vmware workstation7.1.4 硬件服务器已开启虚拟机化 虚拟机中系统为solaris10 u8数据库为oracle10gr2[@more@] 第一种方法：通过sqlplus / as sysdba登录显示mds00afcd01>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 6 15:31:53 2012Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>第二种方法：
-
编辑 删除
ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started
环境oracle10gR2 solaris10在执行sql_trace查看一些sql执行情况时，做了一下操作：[@more@]环境oracle10gR2 solaris10在执行sql_trace查看一些sql执行情况时，做了一下操作： 1 SQL>alter system set sql_trace scope=both; 2 SQL>shutdown immediate 3 SQL> startup 4 ORA-32004: obsolete and/or deprecated parameter(s) specified 5 ORACLE instance started. 6 Total System Global Area 167772160 bytes 7 Fixed Size 1218316 bytes 8 Variable Size 71305460 bytes 9 D
