RE: Oracle Monitoring with BMC

2001-07-29 Thread Alan Dewey
Raja, I no longer use this at my current job. I did at my last job and am currently working with an ex-BMC installer. Here is some information that might be useful. Please let me know if you need more information or care to talk more on this subject. Ok, BMC Patrol and the Oracle KM are the

RE: Avoiding Duplicates and Transitive Operations

2001-07-29 Thread MacGregor, Ian A.
Mr. MacGregor would like to recall his posts on this subject. His brain has failed regression testing. He feels that Real Application Clusters will solve his lapses into silliness. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday,

Re: Urgent..DB creation problem..

2001-07-29 Thread Christian Trassens
Look at the parameter mts_dispatcher in the init.ora. Probably you'll see this: mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) I suggest you to choose on the Database Assistant the option of generating the scripts. And before running these, renmark the parameter.

Cache Object

2001-07-29 Thread Hamid Alavi
Hi All, I have a question regarding Cache Object in Memory, If I want to Cache a large data table in the memory i know it will much faster but what happen if server crash, in this case all modification on table will be gone or NOT. Any idea about cashing tables not only lookup tables realy

Re: severe lib cache contention !!

2001-07-29 Thread Christian Trassens
I don't remember the answers you received. However I suggest you to reduce the shared_pool_size to a minimum size possible. Set the shared_pool_reserved_size if you have PL code. Put the STANDARD package in keep with the dbms_shared_pool.keep. Set also _kgl_bucket_count to a value like 4 or 3

RE: Oracle internet directory example.

2001-07-29 Thread Christian Trassens
Sorry for the delay. Try with oidadmin. Have you created the cn=OracleContext ???. Regards. --- [EMAIL PROTECTED] wrote: Yes Christian I have run @?/rdbms/admin/catldap.sql and Package DBMS_LDAP has been installed in sys user. When i run ldapadd command line command then again i

RE: Year of Unix file

2001-07-29 Thread yong huang
How about using stat(2)? $ ls -l proc.txt -rw-rw-r-- 1 oracle dba 3414 Jul 1 00:10 proc.txt $ perl -e '$a=(stat proc.txt)[9]; print int $a/31536000+1970,\n' 2001 There's a better way to convert seconds since epoch to year but for now I just divide it by number of seconds in a year

RE: Avoiding Duplicates and Transitive Operations

2001-07-29 Thread Rachel Carmichael
Ian, love those caffeine free moments, don't you? As the project manager for one of the databases I messed up (you try accidentally dropping a production tablespace in the middle of the day when you only do cold backups and are in noarchivelog mode) said: that concludes your mistakes for

Re: Cache Object

2001-07-29 Thread David A. Barbour
NOT Hamid Alavi wrote: Hi All, I have a question regarding Cache Object in Memory, If I want to Cache a large data table in the memory i know it will much faster but what happen if server crash, in this case all modification on table will be gone or NOT. Any idea about cashing tables

Re: Cache Object

2001-07-29 Thread Viraj Luthra
Hello all, A very basic question; the background processes, smon, pmon, etc. do they have an executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do they start? like eg. BMC' Patrol agent when it runs is run because there is an executable called PatrolAgent, is it

Urgent: Need help

2001-07-29 Thread Viraj Luthra
Hello all, A very basic question; the background processes, smon, pmon, etc. do they have an executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do they start? like eg. BMC' Patrol agent when it runs is run because there is an executable called PatrolAgent, is it

Re: Cache Object

2001-07-29 Thread Joe Testa
they start when oracle starts, they are forked from the oracle executable. joe Viraj Luthra wrote: Hello all, A very basic question; the background processes, smon, pmon, etc. do they have an executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do they start?

Urgent

2001-07-29 Thread Viraj Luthra
So how does oracle come to know the names of the smon process, like in a default installtion, it will be, ora_smon_orcl815, how does oracle come to know this name; also if this process is goes down, how does oracle come to know that smon is down, can I find this smon name in some

RE: RE: CURSOR_SHARING = FORCE

2001-07-29 Thread Reardon, Bruce (CALBBAY)
Larry, On 8.1.7.1.5 W2K Pro SP1 No errors: SQL select 'x ' from dual; 'X -- x SQL select ' x' from dual; 'X -- x SQL alter system set cursor_sharing=force; System altered. SQL Select 'x ' from dual; 'X' x SQL Select ' x' from dual; 'X'

8.1.6. on Linux installation problem

2001-07-29 Thread Okan CIMEN
Hello When I try to install Oracle 8.1.6 for Linux, I get a message saying; Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... and installation does not even start. I thought that the problem's reason is my box's

Lock contention

2001-07-29 Thread Viraj Luthra
Hello, How do I find out the sessions in the systems that are waiting for locks and corresponding locks. In other words, how, an sql script will really help, will provide me if a lock contention is going on? rgds, raja Get 250 color business cards for FREE!

Re: Urgent..DB creation problem..

2001-07-29 Thread Saurabh Sharma
there are two parameters infact that need to be removed(commented) from init file. mts_dispatcher mts_server thanks for all replies. problem goes away. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list

Re: 8.1.6. on Linux installation problem

2001-07-29 Thread Jared Still
Try the linux dist from www.blackthorne.org. It worked for me on SuSE 7.1 Jared On Sunday 29 July 2001 21:30, Okan CIMEN wrote: Hello When I try to install Oracle 8.1.6 for Linux, I get a message saying; Initializing Java Virtual Machine from