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	2.9 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...	2.9 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	1.7 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...	1.7 parsecs away Travel
\|	\|	mwidlake.wordpress.com 03 \| July \| 2009 \| Martin Widlake's Yet Another Oracle Blog	2.4 parsecs away Travel
\|	\|	1 post published by mwidlake on July 3, 2009	2.4 parsecs away Travel
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	13.3 parsecs away Travel
\|		There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....	13.3 parsecs away Travel