Ora Training Blog

In Windows we cannot delete log files which are still being used by a service, for example Oracle related services (though there are many third-party tools which can do but we are talking in general). In Solaris/Linux, we can rename the files but sometimes you will see that the new log entries are coming into […]

Many users face issue running Oracle forms on Microsoft Internet Explorer 7 or 8 (IE7 or IE8) which causes the page to redirect to following url with “Website restore error” title res://ieframe.dll/acr_error.htm#,http://<server>:<port>/forms/frmservlet?config=<config> It displays following error. We were unable to return you to the page you were viewing. Internet Explorer has stopped trying to restore […]

/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if […]