It will be hard to find drivers that connect to Oracle 8i.

Perhaps you could export the database and import it into Oracle 12 and use that as a source for...

The databases were fully backupped once?

Databases are in full/bulk logging mode?

Perhaps there are long running transactions/replications going on

You could convert the maintance plan to a normal job to see what's...

How are you quering Oracle through SSRS?

Using SQLServer as a datasource and using the LINKEDSERVER..SCHEMA.TABLE / OPENQUERY notation

Or Using Oracle as a datasource?

Is it possible to post the query?

Waittypes of the queries (IO/NETWORK/CXPACKET/...)

Can be done with sp_Whoisactive or the dynamic management views.

MS SQL Server max memory does not include reporting services.

Total memory-MS SQL Server max memory= memory for OS, SSRS, SSAS, SQL Agent, SSIS, other applications

Thanks for the build list.

I'm relying on sqlserverbuilds.blogspot.be[/url] as it has the builds up to SQL 7.

You're welcome

Did you try casting p.TriggerDate >= '06-Nov-2014'

to a date-variable? (instead of relying on strings)

->where p.TriggerDate>=TO_DATE('2014-11-06','YYYY-MM-DD')

Whilst there are people who can soak knowlegde, actually applying certainly helps.

Can't forget about maintaining it, so your brain doesn't purge it.

Oracle Client and the use of OracleOleDB?

MSOra is probably the old deprecated oracle driver

Congratulations Koen, keep writing!

Glad you keep the thread awake

Happy Holidays and a fun New Year.

Oracle 9 is really old by now. Maybe you can connect to it if you have the oracle 11g client en the oracle database is at least 9.2.0.4. The 12c...

Could you rephrase it to What is the recommended minimum memory requirement ...?