Re: shared pool memory issue on OPS (non-MTS)

What does V$RESOURCE_LIMIT say? You can probably post that as a reply... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 2:27 PM No messages in the alert log about dynamic lock allocation, the node that is having the issue

Re: Does any one know how to call LDAP from UNIX script ?

You need to do an LDIF export, using the LDAP export tool that came with your LDAP server -- the tools differ between servers. Or you could write your own using one of the Perl LDAP modules. -Joe --- Steven Joshua [EMAIL PROTECTED] wrote: Hello: Hope the subject make sense. I'm new to

Inactive sessions where program = dllhost.exe

Hi All, In a particular instance there are some inactive sessions where program is dllhost.exe. It appears when user disconnects this dllhost.exe is not going away. Does anyone know why these dllhost.exe are not going away? Thanks Rick -- Please see the official ORACLE-L FAQ:

Re: shared pool memory issue on OPS (non-MTS)

Trivial checks that you've probably gone through, but are there messages for Dynamic resource allocation Dynamic lock allocation in the alert log. Are you using partitioned views Do you see lots of waits for DFS Lock handle on the instance that isn't having the memory problem

RE: Hardware requirements for large data sets

Tim, Good description. Hence, my original statement for not needing RDBMS. I'm leaning towards calling this monstrosity a data parking of a sort. Just trying to figure out the best way to build the parking lot. Gary Weber -Original Message- Sent: Thursday, May 02, 2002 5:07 PM To:

RE: Create a new database

ftp://oracle-ftp.oracle.com/server/patchsets/unix/SUN_SOLARIS2/81patchsets/3 2BIT/ -Original Message- Sent: Thursday, May 02, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Would you please let me know where can I download the Patch2 or 3 for 8.1.7 for OSsun5.7,

RE: shared pool memory issue on OPS (non-MTS)

Here is the results of looking at the v$resource table for the node with the issue. select * from v$resource; ADDR TYID1ID2 -- -- -- D4F7C2F8 TS 3 692077582 D4F7C340 TS 38 268439158 D4F7C388 RT 2 0 D4F7C3D0

RE: Create a new database

Thanks Tim, Would you please let me know where can I download the Patch2 or 3 for 8.1.7 for OSsun5.7, Appreciate Thanks -Original Message- Sent: Thursday, May 02, 2002 1:54 PM To: Multiple recipients of list ORACLE-L ORA-03113 (and ORA-03114) are error messages issued by the client

RE: Create a new database

Tim, This is me again, this is all in $ORACLE_HOME/rdbms/log Thu May 2 10:15:06 2002 Shutting down instance (abort) That's it which I found as a log. Thanks for your HELP -Original Message- Sent: Thursday, May 02, 2002 1:54 PM To: Multiple recipients of list ORACLE-L ORA-03113 (and

RE: Does any one know how to call LDAP from UNIX script ?

Interesting, Charlie! By the name of this script, I assume it's used to change your Oracle password, but it's not searching against OiD, unless you've manually added the Directory Manager cn. Are you using iPlanet? Are your Oracle clients authenticating against this LDAP server? Or for Oracle

RE: shared pool memory issue on OPS (non-MTS)

Here is the results from v$resource limit on the node with the problem. RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU -- --- --- -- -- processes

Re: shared pool memory issue on OPS (non-MTS)

Hmmm, Not v$resource but v$resource_limit .. Anjo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 11:37 PM Here is the results of looking at the v$resource table for the node with the issue. select * from

Re: Does any one know how to call LDAP from UNIX script ?

Thanks for the code. But can we do this in UNIX shell script or Java? Thanks again Steven --- Charlie Mengler [EMAIL PROTECTED] wrote: I hope you can read UGLY Perl code. HTH YMMV! #!/usr/local/bin/perl # File: chg-oracle-passwd.cgi use Net::LDAP; use Carp; use DBI;

Re: Hardware requirements for large data sets

I would include PL/SQL in that mix for operations that can be easily done within the database, as it will be faster than Perl. You just have to balance the mix. Add to that a decent scheduler and who needs Informatica? Jared Joe Raube [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: shared pool memory issue on OPS (non-MTS)

V$RESOURCE_LIMIT not V$RESOURCE... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 3:37 PM Here is the results of looking at the v$resource table for the node with the issue. select * from v$resource; ADDR TY

Re: shared pool memory issue on OPS (non-MTS)

Check out the following two values: Resource Current MaxInitial Limit Name Utilization UtilizationAllocation Value ---- ---- lm_ress252143 256732 177599

Re: Does any one know how to call LDAP from UNIX script ?

Yes, you'd need the LDAP API libraries, check here http://www.openldap.org/ Steven Joshua wrote: Thanks for the code. But can we do this in UNIX shell script or Java? Thanks again Steven --- Charlie Mengler [EMAIL PROTECTED] wrote: I hope you can read UGLY Perl code. HTH

RE: shared pool memory issue on OPS (non-MTS)

Bryan, There have been issues with this hanging problem with OPS in some releases. I am not sure if this is the problem, but applications that heavily use the rowcache in an OPS environment can have performance problems if the shared_pool is loaded and cause sudden hangs when the row cache object

RE: Does any one know how to call LDAP from UNIX script ?

Are you kidding? Charlie goes through the trouble of sending this to you and the list and you ask for it in a different language? Jump in, learn something new. It's fun in here. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA

Re: Does any one know how to call LDAP from UNIX script ?

Here are a few more resources: http://www.umich.edu/~dirsvcs/ldap/ldclients.html (you could download the client for Unix and use those libraries in shell) http://www.mozilla.org/directory/standards.html Suzy Vordos wrote: Yes, you'd need the LDAP API libraries, check here

RE: Does any one know how to call LDAP from UNIX script ?

I'm very very appreciate call the helps I get here. Just have to listen to the users also. Thanks --- Koivu, Lisa [EMAIL PROTECTED] wrote: Are you kidding? Charlie goes through the trouble of sending this to you and the list and you ask for it in a different language? Jump in, learn

Re: shared pool memory issue on OPS (non-MTS)

That certainly sounds like the solution to the immediate problem. (Mind you, those initial numbers look like generated values, not manual settings). However, it doesn't answer the question of why one of the machines has the problem. Do you think it;s possible that lots of material gets loaded

Re: pl/sql is INTERPRETED?

Recess is over children. Let it go. Time to get back to work. Jeeze By the way Alex, nice to see another m-net.arbornet.org user on the list. Brian P. MacLean Oracle DBA, OCP8i

Re: pl/sql is INTERPRETED?

Hmmm... Appears I'm violating some of my own rules here. My bad, I apoligize to the list. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/02/2002 12:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: ERD generation tool

All bugs that I am experiencing are in 3.5.2. A lot of the problems with ERwin are not CA's fault. And trust me, I have no respect for CA. -Original Message- Chris Sent: Thursday, May 02, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Yes, I always have that box checked. I

Re: pl/sql is INTERPRETED?

Okay then, but you are on probation for 30 daze, don't do it again ;^) Brian Jared.Still@ra

oracle nt threads sql / Re: ORACLE-L Digest -- Volume 2002, Number 122

ORACLE-L Digest -- Volume 2002, Number 122 -- From: Yechiel Adar [EMAIL PROTECTED] Date: Wed, 1 May 2002 13:14:18 +0200 Subject: Re: CPU Pegged at 100% Hello Igor Thank you for the info. I got the following script from one of the articals that Thomas

Re: ORACLE-L Digest -- Volume 2002, Number 122

the more important question is where are the rocky mtn oysters!? -- From: Weaver, Walt [EMAIL PROTECTED] Date: Wed, 1 May 2002 14:16:25 -0600 Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) Ball in your court, Mr. Pierce. -- Please see the

Re: Create a new database

Hamid, Generally, finding an alert*.log file in the default $ORACLE_HOME/rdbms/log directory, even when BACKGROUND_DUMP_DEST has been set, indicates that someone issued the SHUTDOWN ABORT command when the instance wasn't already running. Alternatively, issuing the STARTUP FORCE command (which

Re: ORACLE-L Digest -- Volume 2002, Number 122

It is kind of amazing how irrelevant and lacking in substance this discussion is. -- From: Seefelt, Beth [EMAIL PROTECTED] Date: Wed, 1 May 2002 16:00:57 -0400 Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) Hmmm, I'm guessing you're a

One way replication in multimaster environment

hi experts, In my replicated environment, i have one site (example: site X) that consolidate data from other sites (example : site Y and Z). I'm using multimaster to push transaction from site Y and Z to site X. How can i set - off the replication in site X , cause i dont want site X to push

OID problem

Dear All, We have installed the OID. We want to use the LDAP inside this for authenticating the users to our application. We were able to connect to this using the JNDI, but we are not able to add anything to this. Could anybody explain why this is happening. It would be nice if somebody can

<    1   2