OT: Anybody using QlikView BI tools?

2003-03-15 Thread Don
After management learned the cost of Cognos PowerPlay, they decided to look at QlikView from QlikTech (Sweeden). I would be interested in hearing from anybody that has had experience with this BI tool. Pro and con issues are welcome. Thx - Don -- Please see the official ORACLE-L FAQ: http://w

RE: Server Recommendations

2003-03-15 Thread DENNIS WILLIAMS
Tom If this is a multitier system, what will be running on this server? Both Oracle DB and an application server? I second Raj's comment, consider Oracle licensing. Servers today are priced as commodities. Oracle DB is not. If you run only Oracle DB on a server, you will get maximum benefit from

Re: log buffer space

2003-03-15 Thread Mogens Nørgaard
It's a fantastic ratio :-). Anjo Kolk wrote: 1 log switch per minute ;-) AK wrote: log buffer is 320 K and log files are 30M approx. there are about 50 log switch /hr . -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 200

RE: Statspack recomendations.

2003-03-15 Thread M Rafiq
The bookpool is no doubt the best and clean site for tech books with low S&H charges. For price comparison http://www.bestwebbuys.com/books/ is a good site... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 14 Mar 2003 14:23

Re: Data Transfer or Views from SQL Server to Oracle

2003-03-15 Thread Arup Nanda
Nikunj, You can try something I did a long time ago, in Oracle 7.3; but it's also applicable now. Create an ODBC datasource on the machine where the SQL Server resides to pint to the Oracle database. For the initial load, I suppose you can create a table in SQL Server as "select * from table_in_o

RE: Multiple Instances and 9iRAC

2003-03-15 Thread Jamadagni, Rajendra
We run 4 production databases on one dual node RAC, each node hosting one instance of each database.   Raj -Original Message-From: Thompson, Todd [mailto:[EMAIL PROTECTED]Sent: Friday, March 14, 2003 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple Insta

RE: Server Recommendations

2003-03-15 Thread Jamadagni, Rajendra
Title: RE: Server Recommendations Others have talked about CPU ... consider licensing costs too. But 512MG RAM? Gimme me a break ... I have 768MB RAM on my home PC that I use for casual work.   But the max RAM that your bean counters will allow you to, and then some more. This is true, espe

Re: Data Transfer or Views from SQL Server to Oracle

2003-03-15 Thread Raman Pujani
2 Options: 1. Use MS Data Transport Service (DTS) and schedule transfer task 2. Write a Java program that will connect to both databases and transfer the data. Raman. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, March 15, 2003 12:48

RE: Backup Strategy

2003-03-15 Thread Jack van Zanen
I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they won't work with 9i. I'll see if I can find the time to do the same for 9i one of these days (have to learn SQL Server first) Jack -Original Message- Sent: vrijdag 14 maart 2003 20:24 T

Re: Data Transfer or Views from SQL Server to Oracle

2003-03-15 Thread Stephane Faroult
Nikunj Gupta wrote: > > Hello, > > SQL Server in on Windows 2000 Box. > Oracle 8.1.7 is on Unix. > > Is there any process by which data can be transferred from SQL SERVER to > ORACLE directly.. something like views / snapshots. (Requirement is almost > realtime data from SQL Server to Oracle) >