Outer Web | Explore

Explore >> Select a destination

You are here		alexzeng.wordpress.com # Expert Oracle Practices # PL/SQL and the CBO \| Alex Zeng's Blog
\|	\|	alwayssql.wordpress.com Query to check the Backup and Restore progress in SQL Server - Always SQL with Kundan Dasange	6.7 parsecs away Travel
\|	\|	Many times it happens that your backup (or restore) activity has been started by another Database Administrator or by a job, and you cannot use the GUI anything else to check the progress of that Backup / Restore. By combining multiple commands, I have generated below script which can give us a summary of current...	6.7 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	7.2 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	7.2 parsecs away Travel
\|	\|	iggyfernandez.wordpress.com The golden rule of NOT tuning SQL \| So Many Oracle Manuals, So Little Time	7.7 parsecs away Travel
\|	\|	Dear NoCOUG members and friends, The golden rule of not tuning SQL is "operate with as little information as possible." Not only will this increase your chances of failure but it will make it difficult for others to help you. Every exercise in problem solving - no matter how little - has exactly six stages:...	7.7 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	77.6 parsecs away Travel
\|		When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE\|LIST\|HASH] ITERATOR or PX PARTITION [RANGE\|LIST\|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...	77.6 parsecs away Travel