Outer Web | Explore

Explore >> Select a destination

You are here		tanelpoder.com NULL is not zero! \| Tanel Poder Consulting
\|	\|	use-the-index-luke.com Indexing NULL in the Oracle Database	10.1 parsecs away Travel
\|	\|	How to index NULL to improve SQL performance for "where ... IS NULL" queries in the Oracle Database.	10.1 parsecs away Travel
\|	\|	blog.tanelpoder.com How to detect when a cursor was closed from SQL trace output? \| Tanel Poder Consulting	12.6 parsecs away Travel
\|	\|	After Randolf's comment on my last post about identifying cursor SQL text from sql trace file I think one thing needs elaboration. I mentioned earlier in this post that this cursor dumping technique works "as long as the cursor of interest is still open". So how do you know whether this cursor of interest is still open or has been closed and that slot reused by some other statement instead? You would not want to get misled to wrong SQL statement... - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.	12.6 parsecs away Travel
\|	\|	www.brentozar.com Performance Tuning for SQL Server	13.4 parsecs away Travel
\|	\|	Using Perfmon (Performance Monitor), Profiler and other tools to maximize SQL Server database performance.	13.4 parsecs away Travel
\|	\|	aeturrell.com Data science maturity and the cloud - Arthur Turrell	73.1 parsecs away Travel
\|		Arthur Turrell is an economic data scientist.	73.1 parsecs away Travel