Recent content by fmorel

what do you mean?

Hi all ! I use Apache 2.49 as an internal proxy. It itself use a remoteProxy behind a firewall to access the WWW. It works quite well, except for some (few) URLs : for example http://www.aserver.com/news/ works, but http://www.aserver.com/news does not work (proxy returns a 404), whereas...

you should put your database in archivelog mode !!! It works very well !

Before restoring the backup, you should backup (somewhere else) your crashed database.

A lot is 205 Mb. Database size is around 5GB and SGA is select * from v$sga NAME VALUE Fixed Size 103396 Variable Size 87531520 Database Buffers 396623872 Redo Buffers 180224 ... but DBWR has nothing to deal with SGA... Is it a bug?

If it is a production database, I suggest that you call Oracle Support. If your database is in archivelog mode, you may try to do a "alter database recover automatic" when connected as a sysdba. If your database is not in archivelog mode, you way need to restore a full cold backup.

Hi all! A database process, ora_dbw0_MYSID uses a lot of memory on my system (far too much compared to the database size). Do you know what this process is? What initialization parameters can modify this process memory usage ? Thanks a lot for answers!

A view should work! create view my_view is ( select * from db1.apps.gl_balances where dt<xxx union all select * from db1.arch.gl_balances where dt>=xxx ) owner of my_view should have been granted the &quot;select&quot; right on apps.gl_balances and arch.gl_balances directly...

Great Dave ! It is always useful to read tech-tips ! I thought I knew a good way to unchain rows (analyze table list chain rows into..), but I did not know the &quot;MOVE&quot; trick... Thanks a lot!

Hi all! I am very new to Apache, and I am looking for a simple way to write a filter to modify URL in HTML content delivered by Apache in proxy mode. For example my proxy is &quot;ProxyServer&quot; it is a reverse proxy to &quot;Server1&quot; and to &quot;Server2&quot...

Pabloj: Some people were complaining about oracle license fees (I do so...). So I asked in this thread. I don't want to be &quot;flamed&quot; after opening a thread on SAP DB in an Oracle user group. Did you only test that database or did you use it in production?

Did anyone ever tested SAP-DB ? It is open source and seems to be better than mysql or postgres. What do you think?

When you have multiple rows and you want 1 row, you have to use grouping and aggregate functions, eg GROUP BY and sum(), max(), min() ...

Thanks a lot for your answer palbano. I am on a windows environment too. The path to the DLL is in the OS PATH. I tried to copy the missing dll file to C:\WINNT and it worked (but it is not very satisfied by this workaround ...). - So why does it look in C:\WINNT and not in the PATH ? This...

I tested a JAVA API that does JNI in a standard JAVA application and it works properly. I have problems using it in a servlet : I get an error message: &quot;java.lang.UnsatisfiedLinkError: no xxx in java.library.path&quot; where xxx is the name of a dll used by the JAVA API. I know that this...