Search results for query: *

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...

I would like to use a JAVA API on a server and display results in VB clients. The JAVA API cannot be installed on each client, so it has to be remotely called. If relevant, I can set up an http server on the JAVA server. What would be the best solution ?

Thanks a lot !

I'm trying use an external C API in VB. I tried some functions that work properly but I have a problem: How do you pass a function (for a callback mechanism)as parameter in VB 6? Is it really possible? Thanks a lot

It is because date type include Hours minutes and seconds. Sysdate is a function that returns system date in date format (ie including hours mins and secs) to_date() function converts a string into a date. So when you do to_date(sysdate), oracle first converts (implicitly) sysdate to a string...

Hours for querying 100M - 200M seems to be too much ! You may need some helpful indexes. Would you post queries and explain plans ?