SqlPlus、SecureCRT使用技巧
[常用secureCRT映射]
select /*+ PARALLEL(a,4) */ * FROM
select /*+ parallel(a,4) parallel(b,4) leading(b) use_hash(a,b) */
SELECT /*+ PARALLEL(a,4) */ COUNT(*) FROM
WHERE yyyymmdd BETWEEN TO_DATE(20100304, 'yyyymmdd') AND TO_DATE(20100314, 'yyyymmdd') + 86399 / 86400
WHERE yyyymmdd >= trunc(sysdate-1) AND yyyymmdd < trunc(sysdate-1)+1
WHERE ROWNUM < 10
exec print('
SELECT DISTINCT name FROM all_source WHERE LOWER(text) LIKE LOWER('%
SELECT text FROM all_source WHERE name like UPPER('
SELECT DISTINCT owner, table_name FROM ALL_TABLES WHERE table_name LIKE UPPER('%
explain plan for
select * from table(dbms_xplan.display)
SELECT etl.fun_cn_geturl('
SELECT etl.fun_en_geturl('
select url_id, replace(replace(replace(replace(url,'(.+)','*'),'\',''),'^',''),'$','') url FROM cnlog.url_dimt0 WHERE url_id IN (
SELECT url_id, replace(replace(replace(replace(url,'(.+)','*'),'\',''),'^',''),'$','') url FROM enlog.url_dimt0 WHERE url_id IN (
[sqlplus 中常用的设置]
set linesize 1000
set trims on --将SPOOL输出中每行后面多余的空格去掉
set feedback off --禁止显示最后一行的计数反馈信息
set term off --输出的内容只会保存在输出文件中,不会显示在屏幕上,提高spool的速度
[sqlplus 后台执行sql]
1、先建一个可执行的文件(extract_alimail.sql),将
CREATE TABLE cnlog.alimail_path_fatdt0 AS SELECT /*+ PARALLEL(a,8) */ * FROM cnlog.path_fatdt0 WHERE PROFILE_ID = 20 AND yyyymmdd &gt;= TO_DATE(20101101, 'yyyymmdd'); COMMIT; EXIT;
写入;
2、在LINUX执行以下命令:
$>nohup sqlplus 用户名/密码@主机连接字串 @建好的可执行文件 > 日志文件 &
nohup sqlplus cnlog/sdkjfi34Fj@lograc @extract_alimail.sql > /home/admin/log/extract_alimail.log 2>&1
即可