Explore >> Select a destination
|
You are here 
|
jarneil.wordpress.com | ||
| | | | |
power2build.wordpress.com
|
|
| | | | | Another tool to help with SQL Tuning? Yes! Hopefully with some advantage over what you used until today :-) Collecting diagnostics around a SQL is not fun, if you've been there you know that.... Source: SQLd360, SQL diagnostics collection made faster | |
| | | | |
savvinov.com
|
|
| | | | | It has been (unforgivably) long since my last blog post so let me try and rehabilitate myself by posting a couple of recent interesting investigations. I'll start with one that combines two of my favourites: stack profiling and "twittershooting" (collective troubleshooting using Twitter as a collaboration tool). The database in question is a 3-node RAC... | |
| | | | |
coskan.wordpress.com
|
|
| | | | | <-- Blogroll Report 16/10/2009 - 23/10/2009 1-Solution to ASMLIB creadisk problem with EMC Power Path Orhan Biyiklioglu-ASMLIB createdisk problem on emcpower devices - solved 2-How to create a database link in another users schema ? Marko Sutic-Create a Database Link in another user's schema 3-How DST works for current running sessions? Freek D'Hooge-Wintertime (again) 4-How... | |
| | | | |
nenadnoveljic.com
|
|
| | | Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD. | ||
