Outer Web | Explore

Explore >> Select a destination

You are here		mauro-pagano.com Testcases for SQL Tuning, build a hypothesis... and test it! \| Mauro Pagano's Blog
\|	\|	carlos-sierra.net Custom SQL Profile and Plan Stability on 10g \| Carlos Sierra's Tools and Tips	7.2 parsecs away Travel
\|	\|	SQLTXPLAIN includes into the sqlt/utl sub-directory a script named coe_xfr_sql_profile.sql. This script inputs a SQL_ID, then it asks to choose from a list of known Plan Hash Values (PHV), and after a few seconds it outputs another script that contains the Outline of the PHV together with the SQL Text for the given SQL_ID. These...	7.2 parsecs away Travel
\|	\|	blog.zeddba.com How to obtain the Historical Database Total Used and Allocated Size from OEM Repository \| Zed DBA's Oracle Blog	10.1 parsecs away Travel
\|	\|	From time to time, it's useful to know the total allocated size of a database at OS level, how much of it has been used and what the maximum total size the database can grow to at OS level, see blog post: How to obtain the Database Total Used, Allocated and MaxSize However, it's also...	10.1 parsecs away Travel
\|	\|	mahmoudhatem.wordpress.com Adaptive Dynamic Sampling : DYNAMIC_SAMPLING_RESULT & STALE_PERCENT \| Hatem Mahmoud's blog	9.0 parsecs away Travel
\|	\|	Since oracle 12.2.0.1 Adaptive Dynamic Sampling result are stored inside SPD as a special directive type "DYNAMIC_SAMPLING_RESULT". This will allow the result of ADS to be persisted on disk,thus it will survive memory flush and database restart.For more detailed info please check Mauro Pagano blog Post Something new about SQL Plan Directives and 12.2 We...	9.0 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Using "nonunique index to enforce uniqueness" is a good way?	87.1 parsecs away Travel
\|		A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	87.1 parsecs away Travel