Oracle 9i reports

Hi All, Can you please clarify me the following. We have been using reports 6i on Solaries, Now We would like to migrate to Reports 9i, We are told that (As Character set was depricated in 9i ) we need to keep one xterm console open and ruuning every time we execute rwrun. is this true? are

Re: 170systems

hi , CAN YOU PLEASE SEND ME ONE COPY AS WELL. Reg, Ravi --- Eric King [EMAIL PROTECTED] wrote: If the zip file is less than 1MB, can you also send me one copy. I heard it on the radio, but do not know how it works. Thanks Eric - Original Message - To: Multiple recipients of

Oracle Data Guard

Hi All, can any one let me know kindly the following info. 1) Has any one used the Oracle 9i Data Guard? 2) If yes then, is there any performance impact on Target/Source server database. 3) any drawbacks using Data Guard. with many thanks, Vijay.

Re: Oracle Data Guard

Hi Tanel, Much appreciated, The fact is I am interested in Logical standby rather than physical. Our 30-50% of our Production data needs to be replicated to another database and where they will have their processing and batches. Now We didn't go to Snapshot because It is on multiple

Re: Oracle Data Guard

Hi Carel, That is good help, can you please send me the pdf that you implemented there then. Tell me one thing I agree that we some times (rather most of the time ) generate less redo so we should be smooth. Can you tell me is there any releation between LSB and Primary keys, I

Re: Oracle Data Guard

Hi Carel, What if 50% of tables doesn't have Primary/Unique keys, how it is going be with LSB then? Can you please explain more. with thanks, Vi --- Carel-Jan Engel [EMAIL PROTECTED] wrote: Comments inline At 14:54 8-12-03 -0800, you wrote: Hi Carel, That is good help, can you please

Oracle reports 9i with 9i2

HI , Please kindly share your experience or any known issues with Oracle reports 9i on oracle 9i2 Database on SUN Solaries. We would like to move from 8.1.7 to 9i2 and from reports 6i to 9i. OS: Sun solaris 8 DB : 8.1.7 Reports : 6i To DB 9i2 and reports 9i. with many thanks, Ravi.

ora-1013

Hi All, We are hitting ora-1013 error,,even if we don't use the controol C. There are no trace files are being generated . Any suggestions how to solove this. This is during bathc and report generation. DB: 8.1.7 and OS: AIX 3.0 with regards, Ravi

snapshots problems

Hi All, Can you please kindly clarify the following doubts on snapshots: we have got around 50 snapshots to be created on same database from 1 schemas 2 another readonly majority of these snapshots access same base tables 1) can I refresh them parallely? At a time Howmany can I refresh

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

Dear All, When We run simple pl/sql we are getting the follwoing error ORA-2: ORU-10027: buffer overflow, limit of 2000 bytes. But the fact is it is running fine in another database Completely on different server). I have compared the following thigs please let me know if there is anything

performance

Dear All, Can any one please give me some hints or tips when we move to archive mode? when Our DB is non-archive mode that was ok,when we moved to Archive, it is dead slow. Obviosuly archive mode performance is slow, is there any other precations to be taken care? Thanks for your help.

Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

Hi Tim, Thanks for the response, but that is not the point,here developers question is why it is working in other database? (sure they haven't set anything over there) thanks, ravi --- Tim Gorman [EMAIL PROTECTED] wrote: Ravi, The DBMS_OUTPUT package stores all output from PUT_LINE

Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

Tim, Excellent Mate, You are 100% right. I just did it. (some how my mind didn't work) Can you please explain me a bit more about check point not complete error. Cheers Mate, Ravi --- Tim Gorman [EMAIL PROTECTED] wrote: No big mystery. When they run it in the other database, they generate

sqlloader tuning

Hi all, Can any one please tell me what is the deciding factor to specify rows value and bindsize value in sqlloader option? is there any option to use direct=true while using function in control file? DB:8.1.7 os:SUN SS thanks for your help. Cheers, Ravi

RE: sqlloader tuning

Hi, Beth and Kirti thank you so much for your clarification. cheers, ravi --- Deshpande, Kirti [EMAIL PROTECTED] wrote: 1. Review this article by Stephen Andert: http://oracle.oreilly.com/news/oraclesqlload_0401.html 2. No. - Kirti - Original Message - To: Multiple

db file sequential read in v$session_wait haning

Dear All, My CTAS is hanging,when I see wait events says db file sequential read , I saw the table on which it is wating ,but there are no activities on this table at the movement. My DB is : 8.1.7 and OS is SUN OS Thanks for your help. Cheers, John.

rows values in tkprof

Dear All, In my tkprof output rows values under explain plan section are not getting printed, is there any parameter to be set? Thanks, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music

any sql or pl/sql distribution list

Hi, Like this any sqlplus or pl/sql message board where I can clear doubts. Thanks, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the

Re: any sql or pl/sql distribution list

Hi Peter, Thanks --- Peter Barnett [EMAIL PROTECTED] wrote: oracle developer tools users group. www.odtug.com maintains a list at fat city. --- Nalla Ravi [EMAIL PROTECTED] wrote: Hi, Like this any sqlplus or pl/sql message board where I can clear doubts. Thanks

ORA-600

Dear All, I am gettying the follwoing error on our alert_log file,though no porblem in the activity of database. Has any one faced this problem, It is AIX, Oracle 8.1.7 Database and non archived mode. We never gave like recover any thing, why it is trying to recover from error message as

RE: ORA-600

Hi Micheal, Thanks, I would do that cheers, Ravi --- Michael P Sale [EMAIL PROTECTED] wrote: This is an error that occurred while recovering from a rolled back transaction. Not a database recovery. This could be caused by doing a control-c while trying to truncate a large table (Bug

Bind Variable values

Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi.

tkprof analysis

Hi, Can any one point me or kindly send me the analysis of TKProf outout please. Thanks you so much for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts

Re: Bind Variable values

and you can read the explain from the plan table(should have been created beforehand) HTH jack Nalla Ravi

RE: Bind Variable values

Hi Dennis, Thanks for the answer, I just put event leve4, I could not get the bind variables values, rather gave me :b1,:b2 How do I get those values? And another thing is in tkprof values can please explain me about the query and current rows and cpu and elapsed times? my understanding

TEMP segment is not being realsed.

Hi All, MY DB is 8.1.7 on AIX, TEMP space is not being realeasd after sort even after alter tablespace name coalesce. TEMP space was created as temporary. We didn't event put ant events to not to clear. Please let me know if there is any problem. Cheers, Ravi.

RE: TEMP segment is not being realsed.

Thank you John, The things is When we run a partucular query based on view it takes around 1Gb space from TEMP tablespace and is not being relased and from that point on words It give space problem on other txns. that means It didn't mark fro Free to use does it? Ravi. -- Lau, John [EMAIL

Ora-600

Can any one please point me to right search URL in metalink for ORA-600 error. Thans for your help Cheers, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com --

ORA-600

Hi All, Can any one please point me to right URL for ORA-600 error search in Metalink. Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts

RE: Ora-600

your TAR, it will force you to the page you want. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- From: Nalla Ravi [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Subject: Ora-600 Can any one