-
编辑 删除
Oracle各版本下载地址
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XPhttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.ziphttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.ziphttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip...
-
编辑 删除
oracle 隐藏参数查询
col PARAMETER for a30col KSPPDESC for a40col SESSION_VALUE for a15col INSTANCE_VALUE for a15--- 隐含参数命名比较难记，所以首先通过模糊查询找到需要的参数名称select ksppinm from x$ksppi where ksppinm like '%&like%';---将获取到的参数名称输入即可查询出对应的值SELECT A.KS...
-
编辑 删除
db_keep_cache_size
使用：1：手动分配keep buffer pool size SQL> alter system set db_keep_cache_size=4m;2：修改需要keep 在内存中的表的存储参数SQL> alter table a storage(buffer_pool keep);查看表属性SQL> select table_name,buffer_pool from user_tables where table_name='A';TABLE_NAME BUF...
