Oracle
文章平均质量分 78
palm_civet
这个作者很懒,什么都没留下…
展开
-
Oracle Analytic SQL Practical Examples
<br /> Selecting the Top n Records<br /> select sql_id, BUFFER_GETS_DELTA from (select sql_id, BUFFER_GETS_DELTA, dense_rank() over(order by BUFFER_GETS_DELTA desc) dr from DBA_HIST_SQLSTAT) x where dr <= 5;Calculate转载 2010-06-06 22:44:00 · 673 阅读 · 0 评论 -
Some Testing on Intra-Block Row Chaining
from:http://hemantoracledba.blogspot.com/2009/10/some-testing-on-intra-block-row.html Per MetaLink Note#1062906.6, Intra-Block Row Chaining occurs when a Table definition has more than 255 columns转载 2009-10-18 23:17:00 · 382 阅读 · 0 评论 -
Inside Oracle9i Tablespace Management
from:http://www.dbazine.com/oracle/or-articles/burleson11 Inside Oracle9i Tablespace Managementby Donald K. BurlesonOver the past few releases Oracle has been automating and improving the转载 2009-10-17 22:09:00 · 534 阅读 · 0 评论 -
Oracle and RTF data
Yes, Oracle Text can do this.http://download-west.oracle.com/docs...cpkg.htm#12729You need a context index with the INSO filter on the RTF document column inorder to use it.e.g.create table RTFDOCUMEN转载 2009-10-16 22:15:00 · 3249 阅读 · 0 评论 -
自定义分析函数
from:http://yangtingkun.itpub.net/ Oracle在文档中明确说明支持自定义聚集函数和分析函数。但是我只看到聚集函数的例子。我在这篇文章中介绍了自定义聚集参数:http://blog.itpub.net/post/468/3380 今天在论坛里看到有人提出,由于对字符串合并操作和对数值的SUM操作并不完全一样。数值的sum满足交换率,也就是说,转载 2009-10-11 23:04:00 · 511 阅读 · 0 评论 -
Introduction to Oracle Locking and Enqueue
from:http://www.confio.com/English/Tips/Locking_and_Enqueue.php Introduction to Oracle Locking and EnqueueIn Oracle databases, many users may update the same information at roughly the same转载 2009-10-11 21:25:00 · 619 阅读 · 0 评论 -
Causes of Oracle Buffer Busy Waits
from:http://www.dba-oracle.com/art_builder_bbw.htm Oracle Tips by Burleson ConsultingWritten December 9, 2003UpdatedFebruary 10, 2008 One of the most转载 2009-10-10 10:45:00 · 1286 阅读 · 0 评论 -
Decoding 'latch:cache buffers chains' object from Oracle trace file
from:http://blogs.sun.com/glennf/entry/decoding_latch_cache_buffers_chains If you have been using Method-R for response time based profiling, then you will appreciate this note. The "Cache Buffe转载 2009-10-10 10:17:00 · 702 阅读 · 0 评论 -
Cache Buffers Chains and Latch Spelunking
from:http://www.ardentperf.com/2007/09/13/cache-buffers-chains-and-latch-spelunking/ Last night I posted a case study where I used the AWR (a blessed new feature) to investigate “gc buffer busy转载 2009-10-09 22:59:00 · 512 阅读 · 0 评论 -
Using the Oracle Wait Interface to Troubleshoot I/O Issues
from: http://www.pythian.com/news/275/using-the-oracle-wait-interface-to-troubleshoot-io-issues By: Shakir SadikaliOr, Why I Like Broccoli and Wait EventsThere’s been a fair bit of discussion转载 2009-10-09 22:57:00 · 459 阅读 · 0 评论 -
怎样将V$LATCH_CHILDREN、X$BH、DBA_EXTENTS三张表关联起来
from:http://www.itpub.net/thread-805849-1-1.html 数据库中有些类别的latches拥有多个。V$LATCH中提供了每个类别的总计信息。如果想看到单个latch,你可以通过查询V$LATCH_CHILDREN。 ------------------------------------------------------转载 2009-10-09 21:43:00 · 1800 阅读 · 0 评论 -
他山之石,可以攻玉--Oracle自定义的聚集函数的强大功能
from:http://blog.csdn.net/inthirties/archive/2009/10/10/4652245.aspx 作者: 三十而立时间:2009年10月10日 4:43:17他山之石,可以攻玉,说的是别的山上的石头可以作为砺石,用来琢磨玉器。也许我们并没有非常好的手段和工具,但是巧用别人的思想和工具,我们也可以把自己的东西一样的做的很好。 Oracle转载 2009-10-11 23:11:00 · 458 阅读 · 0 评论 -
high "latch: cache buffers chains" waits in 10.2.0.3 DB
from:http://www.freelists.org/post/oracle-l/high-latch-cache-buffers-chains-waits-in-10203-DB From: "bkaltofen@xxxxxx" To: Oracle-L Date: Tue, 26 Feb 2008 18:25:02 +0100转载 2009-10-10 10:43:00 · 839 阅读 · 0 评论 -
Nested loops, Hash join and Sort Merge joins – difference?
from:http://oracle-online-help.blogspot.com/2007/03/nested-loops-hash-join-and-sort-merge.html Nested loop (loop over loop)In this algorithm, an outer loop is formed which consists of few entrie转载 2009-10-21 22:01:00 · 1030 阅读 · 0 评论 -
Oracle Created (Default) Database Users
Default UsersUsernameDefault PasswordAccount DescriptionSYSchange_on_installAll of the base tables and views for the databases data dictionary are stored in the schema SYS.转载 2009-10-21 21:59:00 · 727 阅读 · 0 评论 -
oracle并行查询一例
from http://miracle.blog.51cto.com/255044/147058 版权声明:原创作品,允许转载,转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://miracle.blog.51cto.com/255044/147058 今天碰到一个开发人员反映SQL转载 2010-05-16 14:40:00 · 415 阅读 · 0 评论 -
在sqlplus中操作blob和 clob
http://wallimn.javaeye.com/blog/472399 Tom在他的《Expert one on one oracle》给出了sqlplus中将文件load进BLOB或者CLOB字段的例子。 create directory utllobdir as d:create table blobtest(col1 BLOB);create tab转载 2010-05-01 14:14:00 · 683 阅读 · 0 评论 -
Pipelined Functions: Better Than DBMS_OUTPUT
http://blog.fatalmind.com/2009/11/11/pipelined-functions-better-then-dbms_output/ Pipelined Functions: Better Than DBMS_OUTPUT In Portability on 2009-11-11 at 15:36Every now and t转载 2010-05-01 17:35:00 · 725 阅读 · 0 评论 -
How to call an external C function from within Oracle
From : http://www.shutdownabort.comOne very useful feature of Oracle is its ability to call external C procedures from within the database. It’s handy for creating interfaces to legacy systems.转载 2009-12-17 22:51:00 · 873 阅读 · 0 评论 -
Security concern in connection pooling
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:22140261281764 关于jdbc pool,oralce package-level variable的一些讨论 Submitted on 12-Aug-2004 11:50 Central time zoneToms转载 2010-02-16 18:20:00 · 6914 阅读 · 0 评论 -
Here is How to Unpersist Your Persistent PL/SQL Package Data
Avoid standalone procedures and functions and always use packages to construct your application. That is one of the “best practices” when developing Oracle PL/SQL programs.Of course, as an Oracle PL转载 2010-02-12 21:39:00 · 899 阅读 · 0 评论 -
开源协议简介
from:http://www.oschina.net/bbs/thread/2826http://www.oschina.net/bbs/thread/2830http://www.oschina.net/bbs/thread/2829http://www.oschina.net/bbs/thread/2828http://www.oschina.net/bbs/thread转载 2009-12-03 19:06:00 · 592 阅读 · 0 评论 -
Oracle Cursor Query
FROM: http://snipplr.com/view/9047/oracle-cursor-query/ import java.sql.*;import java.io.*;import oracle.jdbc.driver.*; class curvar{ public转载 2009-11-23 21:13:00 · 582 阅读 · 0 评论 -
Oracle直方图详解
http://blog.csdn.net/randyamor/archive/2008/12/21/3574181.asp 当系统中的某些表存在高度不均匀的数据分布时,使用柱状图能够产生更好的选择性评估,从而产生更加优化的执行计划。柱状图提供一种有效和简捷的方法来呈现数据的分布情况。下面通过一个具体的例子解释柱状图的使用。SQL> create table tab (a numbe转载 2009-11-01 23:01:00 · 415 阅读 · 0 评论 -
Some Testing on Intra-Block Row Chaining
from:http://hemantoracledba.blogspot.com/2009/10/some-testing-on-intra-block-row.html Per MetaLink Note#1062906.6, Intra-Block Row Chaining occurs when a Table definition has more than 255 colu转载 2009-10-22 20:07:00 · 337 阅读 · 0 评论 -
Inside Oracle LRU latches
Inside Oracle LRU latches Oracle Tips by Burleson ConsultingQuestion: I noted that the Oracle internal latches are not documented and there are several parameters where you sp转载 2009-10-19 22:25:00 · 559 阅读 · 0 评论 -
create-db-10.sql
from:http://www.db-ora.nl/create-db-10.html create-db-10.sql:### execute first. ### vi /etc/oratab ### . oraenv #!/bin/bash export ORA_BASE=/oracle export ORA_DATA=/oracle/data export ORA_FLASH=/o转载 2009-10-21 22:00:00 · 485 阅读 · 0 评论 -
一些oracle相关网站
Websiteshttp://www.freelists.org/webpage/oracle-lThe Oracle-L Mailing Listhttp://groups.google.com/group/comp.databases.oracle.server/comp.databases.oracle.server on usenethttp转载 2009-10-09 22:54:00 · 511 阅读 · 0 评论 -
Tuning Latch Contention: Cache-buffers-chain latches
from:http://www.pythian.com/news/1135/tuning-latch-contention-cache-buffers-chain-latches By: Riyaj Shamsudeen Recently, I had an opportunity to tune latch contention for cache buffers chain (CB转载 2009-10-09 21:58:00 · 800 阅读 · 0 评论 -
Parent and child cursors in the library cache
refer: http://www.ixora.com.au/q+a/0104/19005414.htm From:Steve AdamsDate:19-Apr-2001 00:54Subject: Parent and child cursors in the library cache First转载 2009-10-06 11:24:00 · 442 阅读 · 0 评论 -
Latch wait posting
refer:http://www.ixora.com.au/q+a/0009/23120936.htm From:Steve AdamsDate:23-Sep-2000 12:09Subject: Latch wait posting The _latch_wait_posting转载 2009-10-05 16:58:00 · 373 阅读 · 0 评论 -
Reading the Oracle 10046 Trace File sections, parse, execute, fetch & wait
Inside the Oracle 10046 Trace File OutputThe trace file contains a great deal of information. Each cursor that is opened after tracing has been enabled will be recorded in the trace file. Here转载 2009-10-05 12:13:00 · 642 阅读 · 0 评论 -
Automatically tuned multi-block reads in 10g
http://www.dba-oracle.com/t_automatically_tuned_multiblock_reads.htm Question: I did play around with different settings of db_file_multiblock_read_count within 10g with no appreciable results.转载 2009-10-02 22:53:00 · 383 阅读 · 0 评论 -
Oracle sequential read disk I/O tuning
http://www.dba-oracle.com/art_builder_io_speed.htm 10gr2 Note: Starting in Oracle 10g release2, Oracle recommends not setting the db_file_multiblock_read_count parameter, allowing转载 2009-10-02 22:43:00 · 779 阅读 · 0 评论 -
interval-based-row-generation
refer: http://rwijk.blogspot.com/2007/11/interval-based-row-generation.html Well, I didnt have a good name for this common SQL problem, so I decided to call it "interval based row generatio转载 2009-09-28 23:26:00 · 412 阅读 · 0 评论 -
Making up Data with Partition Outer Join
refer:http://nuijten.blogspot.com/2009/07/making-up-data-with-partition-outer.html Just the other day on the Oracle SQL and PL/SQL forum, someone asked on how to create non-existent rows. This p转载 2009-09-28 23:23:00 · 334 阅读 · 0 评论 -
Partition Outer-Joins(Example)
Partition Outer-Joinshttp://www.gennick.com/partition.html by Jonathan Gennick, 1 November 2003Oracle Database 10g brings a new feature called the "partition outer-join". You use the feature t转载 2009-09-28 23:18:00 · 373 阅读 · 0 评论 -
Analytical Functions: A Brief Introduction
I have been using SQL since 1985, and in my humble but biased opinion, Oracles extensions to standard ANSI SQL are superior to those of its competitors. Oracle 9i added a complete suite of analytical转载 2009-09-28 23:07:00 · 518 阅读 · 0 评论 -
Find sequence gaps using Oracle's analytic functions
refer:http://www.builderau.com.au/program/oracle/soa/Find-sequence-gaps-using-Oracle-s-analytic-functions/0,339028441,339282747,00.htmBy Bob Watkins, TechRepublic | 2007/10/11 15:42:02 Seque转载 2009-09-28 22:43:00 · 389 阅读 · 0 评论 -
Oracle 10g Enhancements to Analytical Functions -- Using Partitioned Outer Joins To "Densify" Data
One morning I arrived early at my client site to find a developer running multiple SQL queries, then feverishly transferring the resulting output into a Microsoft Excel spreadsheet. When I asked her t转载 2009-09-28 23:05:00 · 525 阅读 · 0 评论