|
December, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
Script to Dump Contents of a BLOB Column This script can be used to dump the contents of a BLOB column. The user will be prompted for the OWNER, TABLE_NAME, and COLUMN_NAME for the BLOB column to read from. The anonymous PL/SQL block will write the contents of the BLOB to a file named using the format: OWNER_TABLE_COLUMN_<counter>.out Click Here
for the script. |
||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
Tuning Database Buffer Cache Buffer pool or buffer cache is a memory structure within
Oracle SGA that is used for caching data blocks in the memory. Accessing data from the memory is
significantly faster than accessing data from disk. The goal of block buffer tuning is to efficiently
cache frequently used data blocks in the buffer cache (SGA) and provide faster access to data.
Find out how to tune oracle database buffer cache beyond buffer hit ratio. This article presents a step-by-step guide for tuning and efficiently utilizing database block buffer. Click Here
for the article. |
||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
Ad Hoc Queries Against
Tables/Views The adhoc_pak is a PL/SQL package geared towards allowing Ad Hoc queries against tables/views. It relies on Oracle iAS to provide the Web interface. To use, first alter the package specification by changing the schema owner variable as appropriate and compile it into the database. Then compile the package body into the database - no changes are needed. Click Here for the package.
|
||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
|
Cluster That Index!
Part 2 A while back I wrote an article
about clustered indexes (Cluster that index!), where I stated that in my opinion
all tables should have a clustered index defined for them. Since I wanted to
keep the focus specifically on the advantages and disadvantages of clustered
indexes I intentionally left some information and discussion regarding indexes
out of the article. In this article I would like to elaborate on these matters
as well as respond to some comments by readers to the previous article. Click here for the article. This article was previously
published by SQL Server Central. |
||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||
In a small project, there is usually not a lot of effort associated with formally defining the work. However, some definition work still needs to be performed. The result of this short definition process is a one-to-two page document called a Service Request. Click here
for tips and techniques on small projects & the service request
process. Free Webcasts Interactive Crossword
Puzzle: "Lord of the Rings" Click here
to Play! We love getting white papers, tips,
articles, and code examples/archives from our readers around the
world. Send your submission to newsletter@quest-pipelines.com.
If your article is published, it will be mailed to over 28,000
subscribers. Our mission at Quest Software -
RevealNet Labs is to anticipate the daily responsibilities and
challenges faced by database professionals. Our products help
thousands of people solve problems and implement solutions every
day. This newsletter is designed to help facilitate the
sharing of information among database professionals. About the Newsletter This newsletter is distributed to
Quest Software - RevealNet Labs customers, prospects and friends who
have subscribed to it from our website. If you would like to
unsubscribe, please
visit http://qlist01.quest.com/UnsubMailingList/
Subscribe a Friend!
Do you know someone who would like to
receive the Pipeline Newsletter? If so, please enter their email
address in the box below and click SUBMIT.
Past Issues of the Pipeline
Newsletter
| ||||||||||||||||||||||||||||||||||||||||||
