I have oracle 11.2.0.4 and this database has a active data guard . Yesterday, i had this error in alert.log of active data guard : ERROR: unrecoverable error ORA-29701 raised in ASM I/O path;terminating process 51908 This error raised when users wants to join two tables with any where clause...

I have a table of auction results and a straightforward LIKE statement for the search. I need a more comprehensive search, which would give more "google-like" results. At the moment, If you put in a three-word search term, I only get results containing those exact three words, in that order. I al...

A lot of the answers I've seen seem to be quite old and I'm trying to figure out if the landscape has changed. All writes are to a single table with multiple indexes. Is one DB preferred today over another for write speed and concurrency? (or even ability to queue writes as IO becomes available)

I am not sure what is causing this but it seems really bothersome why this is happening every hour, for a delete statement which is on the same object, but filtered on a separate columns. I also looked at the plan, and it suggests that it is using 2 different non-clustered indexes and doing a see...

I have a frustrating issue that I can't resolve. This is my PostgreSQL: UPDATE the_table SET content = regexp_replace(content, 'padding-top:[^;]*;', ': 0;') WHERE user = 1; When I run this I get the error: ERROR: unterminated quoted string at or near "') WHERE user = 1" Then It highlig...