Re: Business Intelligence Suites

How about Business Objects ??? Binay Kumar Oracle Certified DBA - --- Ron Rogers <[EMAIL PROTECTED]> wrote: > Brian, > If I remember correctly Cognos will present data to the users only > after you have populated the catalogs of Cognos

Performance Tuning

Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3

Oracle Tunning

Hi Everyone Can anyone suggest me some very good book on Oracle Tunning. Please only mention those books which you think is really worth purchasing Binay Kumar Oracle Cerified DBA London --- The contents of this e

RE: Query

Yes you can, Each database would have its own Oracle _sid *** Binay Kumar Focus 3 -Technical Support P & O Nedllyod London 0044 207 441 1648 *** > -Original Message- > From: Ghadge,Sameer [SMTP:[EMAIL PROTECTE

RE: Column Title

Thanks Alex, It worked fine. Still wondering how come that this problem is only there in one of the 16 Oracle database instance ? -Binay Binay, It is a bug related to cursor_sharing=force. Try alter session set cursor_sharing=exact. Alex. -Original Message--

Column Title

Hello DBA-Gurus, Executing the same query on 2 databases, but getting different output- the column title. In all the databases its limited to the value of the row except in one database we've. All the databases are of 8.1.7.2 running on IBM/unix server. Database- A -- select substr('LET

RE:simple sql problem

Create a file like sqlplus -s scott/tiger << ! select * from emp; ! Then simply execute the file Binay --- Hello all, Why cannot I do :- sqlplus -s scott/tiger select * from emp; or sqlplus -s scott/tiger "select * from emp;" Both the cases I get :

RE:Deleting Oracle8 on NT(cleaning

Can you please tell us which version of NT you are working on?? also throw some info about type of database, number of users (generally as well as concurrently)?? if possible, give a brief description about the character of your SYSADMIN??? regards *** Binay

RE:Determinants of control file

you can user "Alter database backup controlfile to trace" and then can have a look at all the desired parameters which was set while creating the database Binay --- Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But a

[no subject]

SET ORACLE-L NOMAIL --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not c

RE:Dead locks

Statement is rolled back and not the transaction. binay *** Hi lists, If a dead lock occurs , will the statements be rolledback by oracle ? will oracle do anything other than dumping trace? I tried. But both session never comeout. Just they hung. Regards, Sr

Re: v$sqlarea statistics

Hi Deepak, Can you elaborate what is consistent gets - Eric, here's a high level from my understanding on this issue: Buffer gets {also called Logical IO's} These happen as oracle scans blocks of data in the buffercache(in-mem scans). Many people believe that since these are memor