CALL DBMS_XDB.CFG_UPDATE(
UPDATEXML(
DBMS_XDB.CFG_GET(),
'/xdbconfig/descendant::http-port/text()',
'8888'
)
);"SYS as SYSDBA" in the database.ORA-03113: end-of-file on communication channel error. This happens only if the view is merged by the query optimizer into the query. Using the NO_MERGE hint on the view fixes the issue. I experienced this on Oracle 9iR2 9.2.0.1.0 on a Win2003 server. The same query ran perfectly on a HP-UX box with 9.2.0.6.0 (using the same code and data). This is definitely a bug that was fixed somewhere between 9.2.0.1.0 and 9.2.0.6.0.SELECT instance FROM v$threaddbms_session.free_unused_user_memory() procedure can be used to free up memory that is not in use. They even have an example for index-by tables (in 9i they are called associative arrays) and it works just as expected. However the memory is only released if the table being used was indexed by a numeric datatype! For tables indexed by VARCHAR2 it will not free the memory. Try it yourself if you've doubts about it. Unfortunately I'm using VARCHAR-indexed PL/SQL tables quite heavily in my application (for caching table data) and this bug hit me pretty seriously. I've to rewrite a lot of code now so my app does not abort due to ORA-04030 (out of process memory) exceptions. 
wpg_docload.download_file() procedure to download a BLOB to the browser, then be sure to close the BLOB prior the function call. Otherwise the browser will never get the contents of the BLOB (actually it'll never get an answer at all). I don't know whether this is a bug or not, but it occured to me on Oracle 9iR2 (Windows).
Recent comments
1 day 20 hours ago
1 day 20 hours ago
4 days 20 hours ago
4 days 22 hours ago
6 days 15 hours ago
6 days 16 hours ago
1 week 1 day ago
1 week 4 days ago
2 weeks 4 days ago
2 weeks 4 days ago