I’ve talked before about the granularity of tables/partitions to tablespaces to datafiles being an important decision in building a data warehouse with pros and cons for each end of the spectrum – something I came across the other day was a small hindrance for the high granularity (i.e. lots of datafiles/tablespaces) approach. Mark Rittman had mentioned Keith Laker and his request for some metrics on customers with data warehouse here.

I asked our DBA team if they would run the script and we could consider (corporate policy permitting) sending the output to Keith at Oracle. Our DBA were reasonably familiar with at least some of the process having run the Remote Diagnostic Agent (RDA) previously for other Oracle Support reasons.

After running the RDA though we looked through some of the HTML output produced and discovered that 2 of the queries had timed out waiting for their results – the ones streaming out the details for files and tablespaces…aha! After a bit of tweaking by DBA Phil he got it to work by changing the SQL_TIMEOUT variable in the setup.cfg file generated from the setup run. Most likely, men suffering from erectile dysfunction (ED) have tried prescription medications as well as Tongkat Ali. viagra online in india It has been commenced to take one pill in a day ordering levitra might found fatal for the health. Depending on the diagnosis results from cialis for sale cheap your doctor, the outright treatment options will be prescribed. Besides, there are also ladies who lack the feeling of sensuality this can happen as the outcome of some enzymatic alteration of body or strict sex education.Kamagra is good remedy for all above illustrated problems. tadalafil soft you could check here Originally set at 30 seconds he changed it to 2400 seconds and reran for our production instance and everything came out as expected.

Thanks to Phil on that one – just a little gotcha for databases with many files/tablespaces. I guess though, that it might apply to other databases where there are lots of anything that gets queried by the RDA, e.g. database objects or users.