Any tool available for identifying junk code?

2002-06-09 Thread Sandeep Kurliye
Hi Guys, Sorry, if this sounds bit awkward or unrelated to this mailing list. Can any one of you please let me know whether there is any tool available to identify junk code in an application. My applications are written in Oracle Forms and VB. Backend is Oracle. I am in the process

Re: Cache vs. Oracle

2002-06-09 Thread Don Granaman
Cache = Mumps++ (Yes, it used to be called Mumps. Is that an omen? ;-) I worked almost four years in a shop where one of the two most critical systems ran on Cache, but I didn't have anything to do with it. The other 40+ production databases were Oracle - those were mine. My only opinion of

Re: Archiver process in 7.3.4

2002-06-09 Thread Yechiel Adar
Look in v$database column log_mode. Tested on 7.3.4 on NT. Work also in 8.1.6 and 9.0.1 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 7:13 PM Anybody knows how to get status of archiver process

Re: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread Joe Testa
Ian, is that peopleslop? joe MacGregor, Ian A. wrote: SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM 10; VOUCHER_ 3394 3395 3396 3397 3398 3399 3400 3401 3402 set

Re: Any tool available for identifying junk code?

2002-06-09 Thread Joe Testa
Sandeep, you message at the end contained a bunch of useless characters, is that an example of junk code? joe Sandeep Kurliye wrote: Hi Guys, Sorry, if this sounds bit awkward or unrelated to this mailing list. Can any one of you please let me know whether there is any tool available to

Re: Any tool available for identifying junk code?

2002-06-09 Thread Stephane Faroult
Sandeep Kurliye wrote: Hi Guys, Sorry, if this sounds bit awkward or unrelated to this mailing list. Can any one of you please let me know whether there is any tool available to identify junk code in an application. My applications are written in Oracle Forms and VB. Backend is Oracle.

Re: I/O contention with external process reading the oracle logs (online redo logs)

2002-06-09 Thread Yechiel Adar
Hello All I just had a meeting today about replication. The situations is: One master db that is currently replicated (master to master synchronous replication) to a second DB. Both machines are NT and the is a direct cable connection between the network cards on both machines. However, this

Re: I/O contention with external process reading the oracle logs (online redo logs)

2002-06-09 Thread Tim Gorman
why wouldn't you consider simply using the standby database feature? do you need the remote site to support users also? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 11:43 AM (online redo logs) Hello All I just had a

RE: Index Constraint

2002-06-09 Thread Igor Neyman
Hamid, First, I don't think it's high class to misspell my name intentionally (you did it more than once). Second, rtfm is best advice, you can get, when asking such generic questions, which show your unwillingness to do your home work and which could (and should) be investigated first using

RE: Index Constraint

2002-06-09 Thread JoJo Al-Zawawi
Come on, you guys. If you don't want to answer somebody's question, all you have to do is Delete the e-mail. You really don't have to respond rudely. You don't even have to say rtfm. You could NICELY point out, your best bet is the manual. You know what? Sometimes for us newbies, the

Re: Slow disk-to-disk - [W2K OT]

2002-06-09 Thread Jared Still
Sean, Goto sysinternals.com and get their monitoring tools. (free) You can log all IO and see what other IO may be taking place, as well as timing information. There's also a utility that will ( I think ) let you track what the AV software is doing as well. Jared On Friday 07 June 2002

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread MacGregor, Ian A.
Yep sure is. Ian -Original Message- Sent: Sunday, June 09, 2002 5:43 AM To: Multiple recipients of list ORACLE-L Ian, is that peopleslop? joe MacGregor, Ian A. wrote: SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM 10; VOUCHER_ 3394 3395 3396

Re: Why is Parallel Query Running after upgrading to 8.1.7.2

2002-06-09 Thread Binley Lim
I saw something similar after an upgrade from 8.0.5 to 8.1.7.2. In that case, the fix was to explicitly alter table noparallel, and then back to whatever degree you want. Afraid this is more than a couple of hours... [EMAIL PROTECTED] 06/09/02 10:38AM To: Multiple recipients of list

RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-09 Thread Joe Testa
JoJo, take a hint from someone who'd been doing oracle for 11 years now. The docs are ALOT better than they were in 5.x/6.x days. Heck you dont even have to buy oracle anymore to read the docs. They used to come only in paper, than using Oracle Book(anyone rememeber that one), and now on

Re: I/O contention with external process reading the oracle logs (online redo logs)

2002-06-09 Thread Rachel Carmichael
and if you need the remote site to support users, you could use the logical standby feature of 9iR2, which generates SQL statements to be applied and allows the database to be open and active. --- Tim Gorman [EMAIL PROTECTED] wrote: why wouldn't you consider simply using the standby database

Re: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread Joe Testa
what modules, if you dont mind me asking, i'm at a site where we're going to implement HR, Financials And EPM soon. thanks, joe MacGregor, Ian A. wrote: Yep sure is. Ian -Original Message- Sent: Sunday, June 09, 2002 5:43 AM To: Multiple recipients of list ORACLE-L Ian, is

RE: Can we find SQL user

2002-06-09 Thread sam d
Really appreciate it Richard, This is what I was missing where a.sql_address=b.address(+) Thx a Lot list, Sam --- Richard Huntley [EMAIL PROTECTED] wrote: Sam, had problems sending this to the list, but thought this might help... here is what you need...enter the specific username

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread MacGregor, Ian A.
Accounts payable. But this is not a Peoplesoft problem, but an Oracle one. I tried the same query against another Peoplesoft instance, and it ran fine. So there's something more than the view involved here. It's in Oracle Support's court now. I must be living right. It's failing in