ITPub博客

排序:使用到排序的操作有: create index,order by ,group by ,收集统计信息时,都可能会用临时表空间  排序操作首先会在sort area 内存中进行排序,一旦sort area 内存不足,则会使用到临时表空间 sort in disk...

This document discusses the DB_FILE_MULTIBLOCK_READ_COUNT parameter, its suggested usage and restrictions. WHAT IS DB_FILE_MULTIBLOCK_READ_COUNT? ====================================== The db_file_...

Purpose:   This bulletin provides the Database Administrator a better understanding of checkpoint processing and a description of four key initialization parameters used for checkpoint tuning: ...

PURPOSE-------This article explains the concept of allocating the initial ITLs in the block header and its relationship with the block size. What is INITRANS and MAXTRANS ?============================...

最近可能想回家想疯了,上班时只要自己工作一做完,就看火车站相关新闻,终于看到京广线基本恢复,那回去希望又大点,但看到火车站又是一轮一轮的回家的人到来,不知道能不能挤上车,挤也要挤回去,在外流浪一年的人终究是...

又是一个人孤单的在广州过,今天晚上又要继续加班希望5号能正常上火车,安全到家

The following example describes the most basic level of operations that Oracleperforms. This illustrates an Oracle configuration where the user and associatedserver process are on separate machines (c...

交易日志（Transaction logs）是数据库结构中非常重要但又经常被忽略的部分。由于它并不像数据库中的schema那样活跃，因此很少有人关注交易日志。　　交易日志是针对数据库改变所做的记录，它可以记录针对数据库的任...

This document contains:Part I: What Is Oracle?Chapter 1, "Introduction to the Oracle Server"This chapter provides an overview of the concepts and features you need forunderstanding the Oracle data s...

如何用sql从mssql中查出某个存储过程里面的原码use 库名sp_helptext 'sp_who'  

 导出数据bcp 库名.dbo.表名 out c:\表名.dat -T -n 导入到另外一个库上首先要在这个库上建立好相同的表名bcp 库名.dbo.表名 in c:\表名.dat -T -n查看存储过程权限和角色权限use  LCUs...

puber上的一个帖子:http://www.itpub.net/thread-927626-1-2.html: 解决方法:先用system用户赋予test用户EXP_FULL_DATABASE角色;  exp test/test file=/oracle/backup/001.dmp log=/oracle/back...

log_archive_dest _3='location=d:\archpaul\  NOREOPEN ALTERNATE=LOG_ARCHIVE_DEST_4'log_archive_dest _4='location=d:\backup\  NOREOPEN OPTIONAL'log_archive_dest_state_3=ENABLElog_archive_dest_...

alter system set event="10203 trace name context forever off" scope=spfile 参数需要重启才生效 shutdown immediate 关闭数据库 paul@TEST(192.168.1.117)> startup; ORA-02194: event specification syntax err...

今天在论坛上看到一个帖子, http://www.itpub.net/838293.html 不知道数据库的SID名，客户端有无办法连接上去？ 自己按照方法测试了一下,确实是挺方便的,可以当一回黑客了,呵呵 测试如下: host改为服务器IP地址,前提...

SQL>create table test (a number);SQL> begin  2  for i in 1..2000 loop  3  insert into test values(i);  4  end loop;  5  commit;  6  end;  7&nbsp...

SQL> explain plan for select * from test where flag=:a;Explained.SQL> select * from table(dbms_xplan.display);PLAN_TABLE_OUTPUT--------...

 SELECT ksppinm, ksppstvl, ksppdesc   FROM x$ksppi x, x$ksppcv y   WHERE x.indx = y.indx  AND translate(ksppinm,'_','#') like '#%'  order by ksppinm; KSPPINM&...

This event can be used to dump SQL statements executed by a session with execution plans and statistics. Bind variable and wait statistics can optionally be included. Level 12 is the most detailed. Fo...

D:\oracle\ora92>sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 6月 3 15:16:03 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect sys as sysdba 请输...