|
February, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Moving ASM Database Files from one Diskgroup to Another by Jeff Hunter There are times when it becomes necessary to move ASM database files from one diskgroup to another. As with most tasks that involve file management in ASM, RMAN is the easiest and preferred method as ASM files cannot be accessed through normal operating system interfaces. In this article, I will detail the steps required to move ASM files from one diskgroup to another using RMAN. Click here for the article.
| ||||||||||||||||
|
||||||||||||||||
|
Table Spaces And Locking Levels, Part 1 Yes, programmers, you do acquire table space and table locks. While I was talking with a programmer about locking contention and overhead one day, I mentioned table and table space locking. She looked at me and in all innocence said, "Oh, we don't ever use table space or table locking here. We only use page locking." Buried in that response was the seed of a column. Why? Everyone who uses DB2 for z/OS (MVS or OS/390) acquires table space and table-level locks. And partition-level locks. And, well, lots of levels of locks. I set the idea for the column aside. Click here for the article.
| ||||||||||||||||
|
||||||||||||||||
|
On Generics and Traces What is the best way to write generic procedures to work on strings and/or lists of strings? For example, what is the best way to write a function to parse a delimited string into a collection, with a specific separator? I assume that function parameters should be declared as VARCHAR2(with no length) and "internal" strings should be declared as VARCHAR2(32767). What is the best way of representing a list of strings in the most generic way possible? Also, is there a good way to extend the code to support CLOBs (character large objects) as well, without duplicating the code (to cover every possible combination of parameter types)? Sounds as if you like to write generic, reusable code. So do I. It is intellectually stimulating and can save me lots of time, because I can avoid writing the same things over and over again. Click here for the article.
An ODTUG Seriously Practical Conference for Oracle Developers and DBAs who rely on PL/SQL to get their jobs done.Click here to register!!
|
||||||||||||||||
|
||||||||||||||||
|
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world. | ||||||||||||||||
|
||||||||||||||||
|
MySQL Triggers Tryout MySQL 5.0, the version of MySQL that recently became generally available for testing new features, has trigger support. This is no surprise, as triggers were promised in the MySQL Development Roadmap, but it's a novel experience to work with one of the big "MySQL can't do that" features and watch MySQL doing it.For these tests I downloaded the most recent MySQL 5.0 source as described in the MySQL Reference Manual section Installing from the Development Source Tree. Material downloaded from the source tree is generally much newer--and less tested--than what you find on the MySQL 5.0 Downloads page.
Click here to see this article. | ||||||||||||||||
|
||||||||||||||||
Managing the expectations of the client is important on all projects, but especially when the project is large, highly visible, political and / or business critical. When expectations are managed well, all parties feel good about the outcome, even if the project experiences a number of changes and challenges. When expectations are not managed well, even a project that comes in on time and on budget might be seen as unsuccessful from a client perspective. Managing expectations means keeping the client informed as to how the project is going and the changes, if any, that are made to previous agreements and understandings. Major surprises can be fatal to a project. The project manager should ensure that client staff is involved in the project and that the expectations of the client and project manager are always aligned. The bottom line is that you want to make sure you inform your clients of any major news (good or bad) before they find out from some other source.
Click
here for more information on
frameworks to manage project expectations. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Famous Couples"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
