(Andrejus Baranovskis) I was researching how to plugin WebSocket into JET. I would like to share my findings and explain how it works. It is amazing, how scalable and quick it is to send JSON message through WebSocket channel and render it in JET.
Tag: Oracle
The Oracle wait interface granularity of measurement
(Frits Hoogland) The intention of this blogpost is to show the Oracle wait time granularity and the Oracle database time measurement granularity. One of the reasons for doing this, is the Oracle database switched from using the function gettimeofday() up to version 11.2 to clock_gettime() to measure
Automatic date formats
(connormcdonald) Notice in all of the examples below that the date string does not match the format mask.
What the SQL? (History)
(Jeff Smith) Oracle SQL Developer has 2 client-side logging mechanisms for capturing SQL that is executed:
Not Another Standby Monitoring Script
(mdinh) I know what you are thinking. Not another standby monitoring script, right?
No Data Loss without Sync Data Guard
(Arup Nanda) A few months ago I wrote about an exciting product that allows you to achieve no data loss in a disaster even without using the maximum protection Data Guard that relies on super expensive synchronous networks.
Nested loop internals. Part 2: decision making
(savvinov) In the previous part of this mini-series we looked at differences in multiblock read behavior for different nested loop optimization mechanisms depending on degree of ordering of the data.
SQL*Plus quick tip
(connormcdonald) SQL Plus does not appear to be bothered by the direction of slashes, ie “/” or “” in its scripts
Get Help, Just Hit TAB
(Jeff Smith) You’re at the command-line, you need to add a data file to your tablespace.
Primarys Keys and their supporting indexes
(Neil Chandler) Sometimes things just happen which makes you realise that stuff you thought all experienced DBA’s knew about isn’t common knowledge. I suppose it’s a side effect of working with the same evolving product for over 25 years at dozens of clients, when the colleague you are talking to ha
