RE: User Processes Taking 200 Megs of RAM Upon Connecting

!! Please do not post Off Topic to this List !! Thanks for all who have replied. My lack of Unix understanding is becoming very clear. Please bear with me. If top is showing the SGA's memory added to the user's allocation, why does pmap show what it does? Oracle has been less than helpful.

Re: User Processes Taking 200 Megs of RAM Upon Connecting

: !! Please do not post Off Topic to this List !! What are your hard and soft ulimits? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 tcarlson@tripo s.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

User Processes Taking 200 Megs of RAM Upon Connecting

Hey gang. New job, new problems. I have just been handed a 8.1.7.0.0 database on solaris 5.8 with a little problem. Everything time a client connects, regardless of type, the OS dedicates over 200+ Megs of RAM (as shown by Top) to the user process. Naturally, this is running the box out of

NLS_LANG

Does anyone know how or if it is possible to change the NLS_LANG value for a database that has already been created? I believe the answer is no, but I wanted a sanity check (Lord knows I need one). Thanks. Todd Carlson Oracle 8i Certified DBA Bunge North America -- Please see the official

RE: 817 Intermedia on AIX

The Bootylicious DBA? I can't believe you went there. ;-) Koivu, Lisa

RE: !! Keeping the list alive - part deux

Dido. Todd Carlson Oracle 8i Certified DBA Bunge North America George

RE: Problem connecting to a db

Make sure that the user 'administrator' has been added to the local ORA_DBA group on the box. Reboot. Try again. Todd Carlson Oracle 8i Certified DBA Bunge North America

RE: OT: Just chatter about Wireless costs and PocketDBA

LOL! Todd Carlson Oracle 8i Certified DBA Bunge North America Robertson To:

MetaDink Returns

Maybe because it's Friday? Fri, 29 Jun 2001 14:10:44 GMT ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at SURE.SURE_API, line 1291 ORA-06512: at METALINK.ML2_DOCUMENTS, line 324 ORA-06512: at line 7 DAD name: plsql PROCEDURE :

RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy

Completely depends on the school and teacher/master. Most places, laughter is acceptable, unless you are training with people who take it very seriously. On the other hand, continual laughter might be distracting. If they have a problem with it, find another school. After all, you are paying

Re: Intelligent Agent Upgrade

Looks good, if you uninstall the 8.0.5 agent. Todd Carlson Oracle 8i Certified DBA Bunge North America

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3

What version of Oracle? What version of Windows? Todd Carlson Oracle 8i Certified DBA Bunge North America

RE: OT RE: organizational culture / RE: TUSC and Kevin Loney

Apparently, the WKG (Wanton Kickboxing Goddess) is not dead, just incognito. Todd Carlson Oracle 8i Certified DBA Bunge North America

RE: problem with trunc()

You seem to have lost your sig. Are you no longer a 'Wanton Kickboxing Goddess'? ;-) Todd Carlson Oracle 8i Certified DBA Bunge North America -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: RV: vni-2015 authentication error

OS or database job? If OS, we just solved this issue. Assuming your target node is not a PDC or BDC, the NT user must be local and the preferred credentials of the node in OEM must be set to the same user. Hope it helps. Todd Carlson Oracle 8i Certified DBA Bunge Corporation

Re: DB link for nonoracle databases

'Oracle heterogeneous services' are purchased separately. They are services that run on the target systems that allow Oracle to talk to them through Net*8. We use an Oracle gateway to talk to our AS400s. For the most part, this works well. Call your rep. Todd Carlson Oracle 8i Certified DBA

RE: Oracle vs DB2

I just bought 3 STANDARD UPC server licenses for our site. We saved 275K by not using Enterprise. Email me if you want the details. Walt is right, they are lying to you. (The concept of trusting salespersons for technical issues is inherently wrong.) HTH, Todd Carlson Oracle 8i Certified DBA

Metalink Again

Is anyone else having problems with Metalink today? Todd Carlson Oracle 8i Certified DBA Bunge Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Long Raw Problems

OK, I admit it. In 3 years as a DBA I haven't had to deal with a single LONG RAW column. BLOB, CLOB and BFILE yes LONG RAW, no. So here is my Monday morning challenge. I had a database hose itself on Sunday. I rebuilt the database, but it is still misbehaving (looks like hardware). I can't get

RE: Long Raw Problems

That worked. How simple! I was looking for something much more complicated. KISS. I assume that PL/SQL is doing a conversion on the datatype that SQL doesn't. Thanks Jack! Todd Carlson Oracle 8i Certified DBA Bunge Corporation

Re: Standard vs Enterprise Edition

We use it for all of our small, under 10 gig, NT databases (at last count we had 13). Many of the features of Enterprise are just not needed for these systems because the user/data volume is small and we are not using replication or fine-grain access control. All of the 3rd party applications

Re: Standard vs Enterprise Edition

Sometimes I forget that unhappiness is only based on perception. "Thater,

Re: 8.1.6 upgrade

We have done this on several machines without a problem. Don't use the patch on server running Designer 6.5. Bad Mojo. I have an open iTAR with Oracle about this. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation