oracle
wanggangytsoft
10年以上的数据库项目经验,Oracle11g,10g OCM,熟练掌握目前各种流行开发工具和B/S流行架构,有实际多项成功应用项目经验,精通Lunix(RHCE),熟练利用各种数据库:oracle、db2、sqlserver、mysql等进行数据库应用开发,在SQL上有深厚的理解,擅长在数据库后台编写系统核心算法过程、包、触发器等,尤其在数据库oracle上有着深厚的数据库设计、性能优化及备份与恢复、数据挖掘、RAC、Dataguard等经验。
展开
-
PRAGMA EXCEPTION_INIT的用法
PRAGMA EXCEPTION_INIT的用法PRAGMA EXCEPTION_INIT的用法如果要处理未命名的内部异常,必须使用OTHERS异常处理器或PRAGMA EXCEPTION_INIT 。PRAGMA由编译器控制,或者是对于编译器的注释。PRAGMA在编译时处理,而不是在运行时处理。EXCEPTION_INIT告诉编译器将异常名与ORACLE错误码结合起来,这样可以转载 2010-03-23 16:24:00 · 11059 阅读 · 0 评论 -
Tom大师关于oracle优化的经典法则
• You should do it in a single SQL statement if at all possible. And believe it or not, it is almost always possible. • If you can’t do it in a single SQL Statement, do it in PL/SQL—as little PL/SQL as possible! Follow the saying that goes “more co原创 2010-09-25 13:35:00 · 790 阅读 · 0 评论 -
oracle绑定变量与非绑定变量的性能对比
<br />create table t ( x int );create or replace procedure proc1asbeginfor i in 1 .. 10000loopexecute immediate'insert into t values ( :x )' using i;end loop;end; /create or replace procedure proc2asbeginfor i in 1 .. 10000loopexecute immediate'insert into原创 2010-09-30 12:13:00 · 821 阅读 · 1 评论 -
Tom大师性能分析常用包
<br />create or replace view statsas select 'STAT...' || a.name name, b.valuefrom v$statname a, v$mystat bwhere a.statistic# = b.statistic#union allselect 'LATCH.' || name, getsfrom v$latchunion allselect 'STAT...Elapsed Time', hsecs from v$timer;create gl翻译 2010-09-30 12:12:00 · 1119 阅读 · 1 评论 -
oracle数据文件的收缩
<br />一般来讲,oracle的数据文件只扩展,不会因为tablespace上的表数据删除而自动收缩数据文件,释放磁盘空间。昨天在asktom看了一篇文章,很有意思,贴过来看看。<br />The only thing that'll make a file "shrink" is to alter the database and shrink the datafile - datafiles will NOT shrink on their own due to "offline/online"原创 2010-11-10 12:16:00 · 1318 阅读 · 0 评论 -
oracle的truncate table的操作
oracle对于truncate table的操作有着自己的独特做法,truncate一个表几十条数据和千万条数据所用的时间都差不多,说穿了oracle对这类操作只做数据字典的更新,并不对实际数据操作。sys@ORCL> create table big_table as select * from all_objects;Table created.sys@ORCL> insert into big_table select * from big_table;68480 rows created.sys原创 2010-11-11 17:28:00 · 6402 阅读 · 0 评论 -
oracle基于函数的索引分析
<br />顾名思义,基于函数的索引就把要做索引的字段的值先用function计算好,然后对计算好后的值作为索引的值再创建索引,广泛的用在很多场合,比如某个字段的值查询时大小写不敏感等可用此类型索引!当我们创建基于函数的索引时,oracle究竟做了哪些处理我们值得研究一下:1.首先我们创建测试表:create table test_fi as select * from all_objects; select obj# from obj$ where name='TEST_FI';sys@ORCL> s原创 2011-02-09 17:15:00 · 566 阅读 · 0 评论 -
Use Direct NFS for Data Files
With Oracle Database 11g ,instead of using the operating system kernel NFS client, you can configure Oracle Database to access NFS V3 servers directly using an Oracle internal Direct NFS client.以下原创 2011-12-20 09:33:42 · 956 阅读 · 0 评论 -
关于11g OCM升级考试
我的11gOCM升级考试一波三折,终于在前几天收到通过的邮件,个人觉得考试并不很难,升级考主要考11g新特性,考试题目基本上按照考纲来出的,所以对照考纲练习即可,关键是理解透这些新特性,Database, RMAN, EM and Network Configuration 和 Data Guard没有难度,Data and Data Warehouse Management 和Performan原创 2012-03-09 10:57:40 · 2597 阅读 · 0 评论 -
修改sqlplus的环境,让操作更方便
vi $ORACLE_HOME/sqlplus/admin/glogin.sql define _editor=vi set serveroutput on size 1000000 set trimspool on set long 5000 set linesize 100 set pagesize 9999 column plan_plus_exp format a80 column global_name new_value gname set te原创 2010-09-25 13:34:00 · 499 阅读 · 0 评论 -
Resource Manager plan
由于ocm需要考试资源管理计划,,所以简单做个试验,实验步骤如下,主要用了几个dbms包,关键是把资源管理计划几个概念搞清楚,其他的只是调用几个包创建罢了: create test users: create user oltp identified by oracle; create user olap identified by oracle; create consumer group: begin原创 2010-06-29 11:42:00 · 1489 阅读 · 0 评论 -
Getting Contiguous Space Currently in the Shared Pool(Oracle10g Tuning Technology)
Why does the shared pool return errors when an object is loaded? The answer is that a largeenough piece of the shared pool is not available to fit the piece of code. We saw in the lastsectio原创 2010-03-24 16:33:00 · 548 阅读 · 0 评论 -
Oracle OCM 认证指南
OCM考试全称为Oracle Certified Master(Oracle认证大师),是在OCA(Oracle认证专员Oracle Certified Associate)、OCP(Oracle认证专家Oracle Certified Professional)之后更高一级的Oracle技术认证,也是Oracle技术认证最高的一个级别。 考试是两天的时间,全转载 2010-03-29 16:34:00 · 2021 阅读 · 1 评论 -
Identifying Locking Issues
Identifying locking issues is instrumental in locating the user who is waiting for someone or something else. You can use this strategy to identify users who are currently being locked in the system.原创 2010-04-09 14:41:00 · 346 阅读 · 0 评论 -
转:ORACLE查找并解除死锁进程
1、查找死锁进程select /*+RULE*/v$lock.sid, decode(v$lock.type, MR, Media Recovery, RT,Redo Thread, UN,User Name, TX, Transaction, TM, DML, UL, PL/S原创 2010-04-02 10:20:00 · 464 阅读 · 0 评论 -
Oracle Waits event:DB File Scattered Read
The DB File Scattered Read wait event generally indicates waits related to full table scans or fast full index scans. As full table scans are pulled into memory, they are scattered throughout the原创 2010-04-19 15:58:00 · 364 阅读 · 0 评论 -
Oracle waits event:DB File Sequential Read
The DB File Sequential Read wait event generally indicates a single block read (an index read, for example). A large number could indicate poor joining orders of tables or unselective indexing. T原创 2010-04-19 15:59:00 · 472 阅读 · 0 评论 -
Oracle wait problems and potential solutions
Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scatt原创 2010-04-20 09:38:00 · 352 阅读 · 0 评论 -
转:Oracle 一致性读的原理
在Oracle数据库中,undo主要有三大作用:提供一致性读(Consistent Read)、回滚事务(Rollback Transaction)以及实例恢复(Instance Recovery)。 一致性读是相对于脏读(Dirty Read)而言的。假设某个表T中有10000条记录,获取所有记录需要15分钟时间。当前时间为9点整,某用户A发出一条查询语句:select原创 2010-04-21 16:11:00 · 702 阅读 · 0 评论 -
11g OCM考试练习
一、考试准备 1. 考试中有两个机器,Management Server(Even)和Database Server(Odd),大部分考试在database server上进行,management server上做rman catalog 和 dg的physical standby,口令考试 都有说明. 2.注意执行root操作的需要sudo,监考老师一般拒绝...原创 2019-10-09 23:23:58 · 278 阅读 · 0 评论