oracle
shuaigechen
这个作者很懒,什么都没留下…
展开
-
Oracle settting up autotrace in sql/qlus
1. Execute cd $ORACLE_HOME/rdbms/admin.2. Log into SQL*Plus as any user with create table and create public synonym privileges.3. Run @utlxplan to create a plan_table for use by autotrace.4. Run creat...2008-06-22 01:45:46 · 82 阅读 · 0 评论 -
pl/sql 命令大全(摘自网络)
第一章:日志管理 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [...2008-06-22 01:46:41 · 194 阅读 · 0 评论