Oracle 9i RAC建库过程报错:ORA-29807: specified operator does not existhttp://cuug.com.cn/html/activity_283_283.html?wnbk这是oracle bug,针对这个bug描述如下:This is a known issue (bug 2925665). You can click on the "Ignore" button to continue.Once DBCA has completed database creation, rememb...【阅读全文】
1. 首先用语句查询容量大于1G的数据段select segment_name,sum(bytes)/1024/1024 from dba_segments group by segment_name having sum(bytes)/1024/1024>1000;得到如下结果:SYS_LOB0000136091C00003$$ 255332MSYS_LOB0000136441C00004$$ 7170MSYS_C0082042...【阅读全文】
转载请注明出处:http://blog.csdn.net/guoyjoe/article/details/206475531丶配置安装VNC[root@guodb2 Disk1]# yum install vnc*2丶设VNC密码[root@guodb2 Disk1]# vncserverYou will require a password to access your desktops.Password:Verify:New \'guodb2:1 (root)\' desktop is guodb2:1Creating default startup script /root/.vnc/xstartupStarting applications specified in /root/.vnc/xstartupLog file is /root/.vnc/guodb2:1.log3丶重新启动VNC服务[root@guodb2 Disk1]# service vncserver stopSh【阅读全文】
10.SQL语句执行过程select * from dba_data_files;1.客户端输入SQL语句 SQL语句通过网络到达数据库实例ServerProcess接受SQL语句Oracle认识SQL语句,但是不能直接执行,需要解析A.SQL--被解析生成执行计划,然后Oracle才能执行B.解析:判断SQL语法-->SQL涉及的表和视图是否存在/SQL所访问的一些表和视图是否...【阅读全文】