ITPub博客

select dbms_flashback.get_system_change_number from dual;select sequence#,first_change#,next_change# from v$archived_log;alter tablespace users offline;alter tablespace users online;alter system switch logfile;select file#,checkpoint_change# from v$datafile;select file#,checkpoint_change...

今天学习使用java访问oracle数据库，出现如下错误：检查了系统环境变量classpath确实包含了oracle驱动，百思不得其解，后来忽然想到win7更改环境变量以后需要重新启动cmd才生效。重新启动cmd，果然可以！

    今天打算学习一下loadrunner测试oracle，在录制脚本的时候发现无法启动sqlplus应用程序，后来上网查找loadrunner只能打开32为应用程序，自己安装的oracle数据库是64位的，后来重新下载一个32位的客户端，可以顺利打开sqlplus了。如果仔细看弹出的对话框也能得出结论：Win32应用程序！...

1.select *from v$log;2.select *from v$logfile;3.alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo01.log' to group 1;alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo02.log' to group 2;alter database add logfile member 'D:\app\maxine\oradata\smart\log...

1.select * from v$lock where sid in(254,257) and type'AE' order by sid;2.SELECT * from v$lock_type where type in('TM','TX');3.select * from v$locked_object;4.select * from v$lock where kaddr='000007FF633694C0';5.select * from v$parameter where name='ddl_lock_timeout';6.lock mode:7.乐...

1.select * from dba_temp_files;2.select * from v$process;3.select * from v$sql_workarea_active;4.select * from dba_tables where table_name in ('GT1','GT2','GT3','GT4','GT5');5.SELECT * FROM V$TEMP_EXTENT_MAP;6.SELECT * FROM V$TEMP_EXTENT_POOL;7.SELECT * FROM V$TEMP_SPACE_HEADER;8.SELEC...

1.select * from v$tablespace;2.select * from dba_tablespaces;3.select * from DBA_DATA_FILES;4.select * from DBA_ROLLBACK_SEGS;5.create undo tablespace UNDOTBS02 datafile 'D:\APP\MAXINE\ORADATA\SMART\UNDOTBS02.DBF' size 10m;6.select * from dba_segments where tablespace_name='UNDOTBS02';7....

今天在学习oracle undo表空间时，在测试表中插入大量数据时出现ORA-30036: 无法按 8 扩展段 (在还原表空间 'UNDOTBS02' 中)解决办法如下：（参考博客http://blog.sina.com.cn/s/blog_676255e101018d5s.html）1.查询了一下undo表空间的使用,发现已经超过了80%SELECT a.tablespace_name as tablesp...

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit1.show parameter audit;2.select * from v$parameter_valid_values where name='audit_trail';3.select * from v$system_parameter where name='audit_trail';4.alter system set audit_trail='DB_EXTENDED' scope=spfile;5.select * from DB...