not to be an a$$, but it took 14 hours to do a forced recovery? i'm guessing because it was 5 tb?
the oracle forms error was classic though...
not to be an a$$, but it took 14 hours to do a forced recovery? i'm guessing because it was 5 tb?
the oracle forms error was classic though...
that sounds more like a project planning wtf rather than a technology/development wtf. the reason i posted this topic was that i think i may have found something in oracle that was actually relatively easy to use and wanted to see if anyone ran into other difficulties.
Does anyone have any good WTFs related to Oracle's HTMLDB/APEX application?
so what was the error in the mmon trace files?
from what you've written, i get the impression these folks are somewhat literate in sql syntax as there's no mention of an app inbetween the db and the users, only that the users seem to be writing their own queries on the database. perhaps finding some commonalities in their select statements and building indices of those common fields would be a start, and as a follow-up providing them information on index hints in oracle might help too. if none of that works, oracle can always use more memory(unless it's on windows, ugh) and processor power too.