| August/September, 2002 |
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Freespace in Locally Managed Tablespaces The following script will check the exact free space in permanent and temporary locally managed tablespaces. COLUMN ts format a15
COLUMN file_name format a20
COLUMN mb_free format 9990.99
COLUMN MAX_CONTIG_SPACE format 9990.99
COLUMN MIN_CONTIG_SPACE format 9990.99
COL NUM_EXENTS format 9999
SET pages 50
REM Ttitle center "=============Datafile Fragmentation Report============="
COMPUTE sum of MB_FREE on TS
BREAK on ts skip 1
SELECT a.tablespace_name ts, COUNT (*) num_exents,
SUM (a.bytes / 1048576) mb_free,
(SUBSTR (file_name, INSTR (file_name, '/', -1) + 1)) file_name,
MAX (a.bytes / 1048576)
max_contig_space,
MIN (a.bytes / 1048576) min_contig_space
FROM dba_free_space a, dba_data_files b
WHERE a.file_id = b.file_id
GROUP BY a.tablespace_name, file_name
HAVING COUNT (*) > 1
/
|
|||||||||||||
|
|||||||||||||
|
Freelist Internals - An Overview A freelist is a list of free blocks associated with a segment, which are eligible for accepting data when a new insert request comes. This normally speeds up the insert process since Oracle does not need to look at the entire block to put that row inside a table. The freelist structure is managed by a chain structure called a linked list. A singly linked list is the data structure used in managing freelists. In a singly linked list the current element will hold the address of the next element. The last element will hold the null pointer as the next element's address. The header will hold the address of the starting point, which is nothing but the first element.
Click Here for
the topic.
|
|||||||||||||
|
|||||||||||||
|
Testing & Debugging Stored Procedures Stored procedures can be subroutines, modules, or main programs and may be called from remote or local programs. A primary advantage of stored procedures is to reduce the costs of formatting and transmitting messages in a client/server environment. These significant costs are reduced by formatting and transmitting a message to execute a stored procedure which can contain any number of SQL and host language statements. These statements are executed at the remote site and the results transmitted to the caller. This presentation outlines some ways in which you can test and debug these types of procedures. It was originally presented by David Cohn, Senior Systems Advisor for Themis, Inc., at the 2002 International Users Group Conference in San Diego. Click Here for the presentation.
|
|||||||||||||
|
|||||||||||||
|
Create & Manage SQL Server
Stored Procedures using Transact-SQL As we learn more about SQL Server and Transact-SQL it is easy to become overwhelmed with the amount of information out there. I can recall hundreds of times when I have said, "I know there is a (stored proc, DBCC command, SQL statement, etc.) out there that does that, I just can't remember its name." I thought I would deviate from my normal article style and see if writing an article that groups stored procs, DBCC commands, and SQL statements by their main or secondary usage would help others. My current job involves creating and maintaining hundreds of stored procedures so I thought I would put together objects that I knew about that are used in the creation and maintenance of SQL Server stored procedures and extended stored procedures in SQL Server 7.0 and 2000 (I'm not going to list or discuss objects used to obtain users permissions as I feel that those objects are best left for another article). Click
Here for the article. |
|||||||||||||
|
|||||||||||||
|
Managing Risk - Part I Each month, Tom Mochal presents a set of project management tips and techniques for handling various aspects of planning and managing a project. Tom has over 23 years of IT experience. He has developed a comprehensive, scalable project management process called TenStep, which can be viewed at www.tenstep.com Risk refers to future conditions or circumstances that exist outside of the control of the project team that will have an adverse impact on the project if they occur. In other words, whereas an issue is a current problem that must be dealt with, a risk is a potential future problem that has not yet occurred. Click Here for tips
and techniques on managing risk. |
|||||||||||||
|
|||||||||||||
|
Free Seminar - Running Fast &
Lean with DB2 on the Mainframe
Free e-Seminars
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword Puzzle: "Capital Cities"
|
|||||||||||||
|
|||||||||||||
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, we will mail you a FREE gift from Quest as a gesture or our appreciation. 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. It is currently circulated to 28,000 readers. 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 send a note to unsubscribe@quest-pipelines.com and we will make every effort to remove you from our list. 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
|
|||||||||||||
