orasql.org
Oracle SQL | Tag Archives: 12c
http://orasql.org/tag/12c
12c: New SQL PLAN OPERATIONS and HINTS. July 8, 2015. This post is just a compilation of the links to other people’s articles and short descriptions about new SQL PLAN OPERATIONS and HINTS with a couple little additions from me. Continue reading →. 12c: Little test of “TABLE ACCESS INMEMORY FULL” with count stopkey. March 17, 2015. The table has 9M rows:. Oracle 12c: behavior tests of the Inline functions, “Identities” and “defaults”. July 13, 2013. I have done several minitests:. 3 How IDENTITY works?
orasql.org
Oracle SQL | Tag Archives: result_cache
http://orasql.org/tag/result_cache
Tag Archives: result cache. RESULT CACHE: run-time dependency tracking. July 5, 2015. As you know, since 11.2. 8220;relies on”. Clause was deprecated and oracle tracks dependencies at runtime now. Test function and tables. And it works fine with normal tables:. But don’t forget that the result cache also caches such functions with the objects, that usually should not be cached, and such objects will not be listed in the result cache dependencies list:. Note that there is no “RESULT CACHE” line. Recently ...
uhesse.com
Data Guard | The Oracle Instructor
https://uhesse.com/tag/data-guard
Explain, Exemplify, Empower. Posts Tagged Data Guard. Another reason why you should use the Data Guard Broker for your #Oracle Standby. Posted by Uwe Hesse. On May 18, 2016. The Data Guard Broker is recommended for various reasons,. This one is less obvious: It prevents a Split-Brain problem that may otherwise occur in certain situations. Let me show you:. Oracle@uhesse ]$ dgmgrl sys/oracle@prima. Oracle@uhesse ]$ ps -ef grep smon. Oracle 6279 1 0 08:30? 00:00:00 ora smon prima oracle 6786 1 0 08:32?
uhesse.com
Invisible Indexes & Exadata | The Oracle Instructor
https://uhesse.com/2011/05/05/invisible-indexes-exadata
Explain, Exemplify, Empower. Laquo; Now OCM for 10g AND 11g. My Exadata Series made it into the OU Newsletter. Invisible Indexes & Exadata. You may have noticed that we introduced. As an 11g New Feature. Their main benefit is that we can test whether performance differs if we would drop an index. Without actually dropping it. This is particular useful after an Exadata Migration because we expect that some conventional indexes migrated are now obsolete and may be substituted by Storage Indexes. Index alte...
uhesse.com
Uwe Hesse | The Oracle Instructor
https://uhesse.com/author/uhesse
Explain, Exemplify, Empower. This user hasn't shared any biographical information. Homepage: http:/ uhesse.com. How to fix a problem with the spfile in #Oracle. On August 31, 2016. An invalid entry in the spfile may prevent the instance from starting up:. SQL alter system set sga target=500m scope=spfile;. System altered. SQL shutdown immediate. Database closed. Database dismounted. ORACLE instance shut down. SQL startup. The instance doesn’t come up! File created. SQL startup. On August 9, 2016. ADAM@pd...
uhesse.com
OU course formats | The Oracle Instructor
https://uhesse.com/ou-course-formats
Explain, Exemplify, Empower. Oracle University (OU) course formats explained. Over the years, we have developed various different course formats, each for a good reason. This can be sometimes confusing for (potential) attendees as I know from many events where I talked about that topic with participants of my courses. If you want to get Education from Oracle University or if you are an OU Sales person or Reseller, you may find the following brief explanation helpful. ILT comes in two formats:. Means we h...
uhesse.com
Reorganizing Tables in Oracle – is it worth the effort? | The Oracle Instructor
https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort
Explain, Exemplify, Empower. Laquo; Using Flashback in a Data Guard Environment. Data Guard and Oracle Restart in 11gR2. Reorganizing Tables in Oracle – is it worth the effort? This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. I decided therefore to cover it briefly here in order to be able to point to this post in the future. Short answer: Probably not. SQL select * from v$version;. CORE 11.2.0.1.0 Production. SQL delete from...
uhesse.com
TOI | The Oracle Instructor
https://uhesse.com/category/toi
Explain, Exemplify, Empower. Archive for category TOI. How to fix a problem with the spfile in #Oracle. Posted by Uwe Hesse. On August 31, 2016. An invalid entry in the spfile may prevent the instance from starting up:. SQL alter system set sga target=500m scope=spfile;. System altered. SQL shutdown immediate. Database closed. Database dismounted. ORACLE instance shut down. SQL startup. ORA-00821: Specified value of sga target 512M is too small, needs to be at least 1392M. File created. SQL startup.
db-blog.web.cern.ch
Heat Map Visualization of Latency Histograms for NetApp C-Mode | Databases at CERN
http://db-blog.web.cern.ch/blog/luca-canali/2015-07-heat-map-visualization-latency-histograms-netapp-c-mode
Databases at CERN blog. Databases at CERN blog. Heat Map Visualization of Latency Histograms for NetApp C-Mode. This post is about collecting and visualizing I/O latency histograms for NetApp. The drill down of I/O latency is an important technique for troubleshooting and benchmarking storage. Average latency values can hide details. Representing latency histograms over time is a 3-D visualization problem and can be nicely solved using heat maps. This has been discussed in details by Brendan Gregg in .
uhesse.com
Live Demonar | The Oracle Instructor
https://uhesse.com/live-demonar
Explain, Exemplify, Empower. A Demonar is a free 20 minutes webinar with only. I’ll do that up to four times per month if enough of you are interested to join. This is how it works:. You fill in the form below. On the day before the Demonar (latest) you get an email with the logon details. The number of attendees is presently limited to 25, so better fill in the form fast🙂. Upcoming Demonar: Tuesday, May 12, 16:00 Europe/Berlin TZ. On May 5, 2015 - 09:42. On May 6, 2015 - 09:35. Enter your comment here.
SOCIAL ENGAGEMENT