SQL> set autotrace trace explain SQL> select * from v$parameter; Execution Plan ---------------------------------------------------------- Plan hash value: 1128103955 ------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------...
大家好!我用cp命令时报错,实际上文件已经拷到了目标目录,但是所有权限都为空。 也就是---------- cp: cannot set the permission bits on ./USG_D00001DATA2011010101.txt.00: No such file or directory 请问这个是什么原因呢?
奇怪问题: 在AIX 5.1下为什么不能切换用户? # su - sybase cannot set process environment. # ls -l /sybase/.profile -rwxr----- 1 sybase sybase 573 Jun 26 16:22 /sybase/.profile SU到其他用户都不行, # su - oracle cannot set process environment. 在图形终端下也只有root可以登陆,为什么会这样??
oracle显示所查询的解释计划和所用资源分析工具. 配置autotarce: 1. 登陆oracle -bash-3.00$ sqlplus /nolog SQL*Plus: Release 10.2.0.2.0 - Production on Sun Mar 9 15:45:14 2008 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. 2.执行utlxplan和plustrce两个sqlp脚本 SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql Table created. SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql SQL> SQL> drop role plus...
利用管理员权限提交了 plustrce.sql. grant plustrace to test ; 用test 进入数据库 set time on 成功 set autotrace on explain SP2-0613: 无法验证 PLAN_TABLE 格式或实体 SP2-0611: 启用EXPLAIN报告时出现错误 set autotrace traceonly SP2-0613: 无法验证 PLAN_TABLE 格式或实体 SP2-0611: 启用EXPLAIN报告时出现错误 请解疑! 谢谢!
locale: cannot set LC_CTYPE to default locale: No such file or directory2009-04-30 17:13locale: cannot set LC_CTYPE to default locale: No such file or directory 解决: debian:~# apt-get install locales debian:~# dpkg-reconfigure locales debian:~# locale-gen debian:~# locale 本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u3/95834/showart_1917830.html
先看一下帮助
SQL> set autotrace
Usage: set AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
总体来说有3个开关,OFF,ON,TRACE
OFF即关闭trace,ON打开trace,TRACE[ONLY]仅显示trace信息,不显示查询结果。
[oracle@CESTOS5 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 25 20:50:08 2010
Copyright (c) 19...