Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by fmorel
-
-
Yet another trailing slash problem
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...- fmorel
- Thread
- Replies: 2
- Forum: Linux (server)
-
Media Recovery Needed
you should put your database in archivelog mode !!! It works very well !- fmorel
- Post #9
- Forum: Oracle: All versions
-
Media Recovery Needed
Before restoring the backup, you should backup (somewhere else) your crashed database.- fmorel
- Post #4
- Forum: Oracle: All versions
-
ora_dbw0 memory usage
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?- fmorel
- Post #3
- Forum: Oracle: All versions
-
Media Recovery Needed
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.- fmorel
- Post #2
- Forum: Oracle: All versions
-
ora_dbw0 memory usage
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!- fmorel
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Alias For Table
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 "select" right on apps.gl_balances and arch.gl_balances directly...- fmorel
- Post #2
- Forum: Oracle: All versions
-
Storage size(s) for the NUMBER data type
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 "MOVE" trick... Thanks a lot!- fmorel
- Post #6
- Forum: Oracle: All versions
-
write a simple filter ?
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 "ProxyServer" it is a reverse proxy to "Server1" and to "Server2"...- fmorel
- Thread
- Replies: 1
- Forum: Linux (server)
-
Oracle license renewal
Pabloj: Some people were complaining about oracle license fees (I do so...). So I asked in this thread. I don't want to be "flamed" 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?- fmorel
- Post #8
- Forum: Oracle: All versions
-
Oracle license renewal
Did anyone ever tested SAP-DB ? It is open source and seems to be better than mysql or postgres. What do you think?- fmorel
- Post #6
- Forum: Oracle: All versions
-
SQL Query
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() ...- fmorel
- Post #3
- Forum: Oracle: All versions
-
Servlet and JNI
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... -
Servlet and JNI
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: "java.lang.UnsatisfiedLinkError: no xxx in java.library.path" where xxx is the name of a dll used by the JAVA API. I know that this...
