db
iteye_7135
这个作者很懒,什么都没留下…
展开
-
设置sqlplus 的autotrace
[code="java"]SQL> conn as / sysdbaSP2-0306: 无效选项。用法: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]其中 : : = [/][@] | /SQL> conn / as sysdba已连接。SQL> @E:\oracle\ora92\rdbms\admin\utlxplan.sql...原创 2010-08-18 20:54:03 · 132 阅读 · 0 评论 -
order by 排序
[code="java"]fuyou@ORCL> select * from emp order by 1; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO---------- -------------------- --------...原创 2010-08-04 23:56:01 · 94 阅读 · 0 评论 -
跟踪 oracle 监听
在cmd 里输入下面的命令[code="java"]D:\Documents and Settings\yubao>lsnrctl trace 2LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-8月 -2010 18:20:26Copyright (c) 1991, 2005, Oracle. ...原创 2010-08-01 18:17:34 · 169 阅读 · 0 评论 -
sql plus new_vlaue 用法
直接用代码说话[code="java"]fuyou@ORCL> select ename from emp;ENAME--------------------SMITHALLENWARDJONESMARTINBLAKECLARKSCOTTKINGTURNERADAMSJAMESFORDMILLER已选择14行。...原创 2010-07-31 17:30:22 · 91 阅读 · 0 评论 -
oracle 配置autotrace
10g 下orace_home/product/10.2.0/db_1/RDBMS/ADMIN下有个xplainpl.sql1:以sys登录,执行xplainpl.sql语句2:create public synonym plan_table fro plan_table --创建同义词3:grant all on plan_table to public --...原创 2010-07-31 10:49:40 · 82 阅读 · 0 评论 -
set echo on/off
[code="java"]fuyou@ORCL> @testDU--Xfuyou@ORCL> set echo onfuyou@ORCL> @testfuyou@ORCL> select * from dual;DU--Xfuyou@ORCL> set echo offfuyou@ORCL> @testDU--X...原创 2011-01-22 01:03:41 · 172 阅读 · 0 评论 -
设置事务
[code="java"]set transaction isolation level read committed;set transaction isolation level serializable;rollback;set transaction isolation level serializable;rollback;set transaction ...原创 2010-07-25 12:16:06 · 103 阅读 · 0 评论 -
iot 堆表 与普通表
普通表与堆表测试对比[code="java"]drop table heap;create table heap ( a varchar2(30), b varchar2(30), c varchar2(30), constraint heap_pk primary key (a, b ));drop table iot;create table...原创 2010-07-24 23:19:30 · 217 阅读 · 0 评论 -
get_undo
get_undo用例[code="java"]drop table t1;create table t1 ( x number );create or replace function get_undoreturn numberis l_undo number := 0;begin begin select used_ublk * (select va...原创 2010-07-24 23:05:49 · 186 阅读 · 0 评论 -
get_redo_size
这个get_redo_size 用法[code="java"]create or replace function get_redo_sizereturn numberas l_redo_size number;begin select value into l_redo_size from v$mystat m, v$statname s wh...原创 2010-07-24 22:51:20 · 91 阅读 · 0 评论 -
tkprof
tkprof1: [code="java"]alter session set timed_statistics=true;--方便看时间 alter session set sql_trace=true;[/code]2:执行要测试的sql3:关闭[code="java"]alter session set sql_trace=true;[/code]...原创 2010-07-24 18:14:58 · 81 阅读 · 0 评论 -
oralce 常用脚本
statspack相关:[code="java"]//free SPACE 表空间SELECT tablespace_name,SUM(bytes)/1024/1024 free FROM DBA_FREE_SPACE GROUP BY tablespace_name //创建statspack1:查看表空间,要有大于150M...原创 2010-07-24 17:42:44 · 110 阅读 · 0 评论 -
set sqlpath
[code="java"]D:\Documents and Settings\yubao>set sqlpath=c:\sql--设置变量D:\Documents and Settings\yubao>set sqlpath--查看变量sqlpath=c:\sqlD:\Documents and Settings\yubao>sqlplus fuyou/fuyouS...原创 2010-07-24 17:31:48 · 138 阅读 · 0 评论 -
ORA-19815 ORA-16038
用sqlplus 登录oracle 报下面的错:[code="java"]ORA-01033: ORACLE initialization or shutdown in progress[/code]检查了log 发现有下面的警告:[code="java"]Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\...原创 2010-07-24 17:15:15 · 215 阅读 · 0 评论 -
windows2003 下简单备份
[code="java"]exp fuyou/fuyou file=H:/ora_backup/test.dmp log=H:/ora_backup/test.log tables = (a,b )ren "H:\ora_backup\test.dmp" "%date:~0,4%_%date:~5,2%_%date:~8,2%.dmpren "H:\ora_backup\test.log...原创 2010-07-16 11:45:37 · 70 阅读 · 0 评论 -
MySQL LAST_INSERT_ID
在看代码时,看到有这样的用法:插入一条记录,然后用 [code="java"]SELECT LAST_INSERT_ID() [/code] 取这条记录的id(此id是AUTO_INCREMENT)当时第一反应会不会有线程安全的问题查看MySQL文档 [url]http://dev.mysql.com/doc/refman/5.0/en/information-function...原创 2012-10-09 14:13:37 · 148 阅读 · 0 评论