摘要：select sql_text from v$sqlarea where sql_text like '%select * from emp where empno%'select * from emp where empno=7369startup forcevariable vaa numberprint vaaThe data dictionary cache,terminology,and tuningcontent:Definitions of dictionary objectsterminology:gets:number of requests on objec 阅读全文

摘要：鸟儿的翅膀系上黄金,它就飞不起来了.declarebegindbms_lock.sleep(120);end;grant execute on dbms_lock to scottselect sid,event,total_waits,average_wait from v$session_wait where sid=144insert into stats$begin_dc select * from v$rowcache;A collection of wait events provides information on the sessions that had to wait o 阅读全文

摘要：The Alert log file contains the following information which can be used in tuning the database:Checkpoint start and end times.Incomplete checkpointsTime to perform archivingCrash recovery start and complete times.egg:conn sys/oracle as sysdbashow parameter log_checkpoint_interalshow parameter log_ch 阅读全文

摘要：=============oralce安装===============基本位置：Oracle安装在哪一个目录（注意不同版本的区别）%driver_name%\app\username目标驱动器：一般Oracle自动选择剩余空间最多的驱动器Oracle主目录：用于设置环境变量OracleHome，一般指向Oracle 程序文件所在的目录（db_1）类型：版本区别与操作系统无关个人版标准版企业版选择Oracle产品时，是与OS有关的。win32，unix/linux、Mac OS、visita附加启动数据库如果不选，只安装软件，没有数据库如果选，需要设置数据库名全局数据库名：在网络上唯一标识数据 阅读全文

摘要：志存当高远，功到自然成。 阅读全文