Re: for years I have been using korn shell

- Original Message - -What is everyone else using out there? -Do you think I should make an issue of this one? Paula, that mob is having you on. If they know even the most basics of Unix shell scripting, they should be using the comment convention as the first line of any of

RE: Interesting PL/SQL Puzzle

You have not provided me with anything (I cannot post these things to public forums because of my email)! The only thing you said bad code, good code! I was not impressed the way the code works, this is why I had to research issue until I found the problem using LIKE. Of course it was easy for

Re: Interesting PL/SQL Puzzle

Khedr, Waleed wrote: You have not provided me with anything (I cannot post these things to public forums because of my email)! Please re-read my posts. The only thing you said bad code, good code! How should it be named? I was not impressed the way the code works, this is why I had to research

RE: what is in the UGA?

Hi Ryan, The words session specific have to do with the difference between a process and a session. Many Oracle environments run with just one user session per process, but in general there can be multiple user sessions being serviced by a single process. The UGA holds persistent data structures

RE: what is in the UGA?

Good info Steve. But what I want to ask is what is a CGA ? Regards Pawan -Original Message- Sent: Tuesday, November 11, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Hi Ryan, The words session specific have to do with the difference between a process and a session. Many

Memory consumption on HP-UX

Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the

Re: Valid Oracle Passwords

In article [EMAIL PROTECTED], Stephane Faroult [EMAIL PROTECTED] writes Ron, Passwords follow the same rules as identifiers, they are internally managed exactly as identifiers. Maximum length is 30 and anthing goes between double quotes.

Re: Memory consumption on HP-UX

Hi Helmut, Notice the parameter is called pga_aggregate_TARGET and not pga_aggregate_MAX_SIZE. That's because the P_A_T is just that, a target the Oracle does it's best to not exceed. It does this by controlling and rationing the tuneable component of the PGA (ie. those portions of the PGA

Anyone downloaded Oracle 9i for Solaris64 lately (Technet)

Title: Anyone downloaded Oracle 9i for Solaris64 lately (Technet) Hi All, I'm trying to download Oracle 9i for Solaris64 and have done so from two locations both yesterday and the day before and keep getting cpio: Can't read input: end of file encountered prior to expected end of

RE: what is in the CGA?

Hi Pawan, CGA = Call Global Area. It contains data structures that can be freed at the end of the (parse, execute, fetch, ...) call. For example, if a sort while executing a select statement exceeds the sort_area_retained_size any additional sort memory required (up to the sort_area_size) will be

Re: Monitor Index Usage

Note that 9.2 has the nice family of v$segment_statistic views that can give you this level of information very easily. It has advantages over v$object_usage in that is gives you an indication on how often indexes are used, rather than that they've been used. Although sampling and other factors

RE: Memory consumption on HP-UX

Use glance if you have that package installed, look for ps -ef | grep midaemon Allan -Original Message- Sent: Tuesday, November 11, 2003 3:54 AM To: Multiple recipients of list ORACLE-L Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory

OT (DB2)

Hi, Anyone out there who used to be subscribed to the DB2-L listserv. Since it moved hosts, I have received no more emails and cannot register for the new one. Regards Lee ** The information contained in this

RE: Monitor Index Usage

Richard ... thanks for this advise ... now I can add that to my list of observations ... Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any

RE: for years I have been using korn shell

Here's a snippit from my ~/.kshrc, which kinda-sorta approximates bash's default behavior. Unfortunately, there doesn't seem to be any way to bind TAB for filename completion in ksh88. :-( Apparently ksh93 can handle this, but it isn't available on any of the servers I support. set

Oracle Error

Hi All! Oracle 920 on SunOS (Cluster) A have a process that refresh data in the database . I shutdown database and then start it up, before running refresh. This is errors from my log file. After this happened all databases on this server were shutdown and they never failover to the second node

Re: for years I have been using korn shell

Bash is a very big shell which I typically don't need. I use korn shell which is available as pdksh package (see rpmfind.net). On 11/10/2003 04:54:25 PM, Jesse, Rich wrote: For Linux, I use bash. For Unix (HP/Sun) accounts, I use Korn, where bash typically isn't available. I like either, but

RE: for years I have been using korn shell

The few bash scripts I've done would work the same if they were headed with #!/bin/ksh. If I need to get complex, I typically pop off a pearl of a Perl. Whoops...as I check on my scripts at home I see they're all headed with #!/bin/sh. Oh well. :) Rich Rich Jesse

Re: RE: what is in the CGA?

my 'C' isnt very good, but I would assume CGA is allocated with malloc right? they are just dynamic allocations. do you know what type of data structures oracle uses to sort? dynamic arrays or linked lists? From: Steve Adams [EMAIL PROTECTED] Date: 2003/11/11 Tue AM 08:14:26 EST To:

RE: for years I have been using korn shell

Following advice from a fine book on optimizing Oracle, I don't think the time and effort it would take to test and implement this could be justified here. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI

Re: Oracle Error

You need to dig into the sun reference manuals and find out what an error 36 is in reference to semaphores. They are online I believe, somewhere at sun.com. .. How about that? Your exact error is duplicated in a post on MetaLink. Did you check there? Sounds like someone was playing around

Multi-threaded server - will it help in this case

Environment: AIX 4.3 Oracle 8.1.7 The application is a CAE tool which stores metadata for a hierarchy of 3D engineering design models. When a user opens a model at a given level in the design, the application retrieves data about that model and all of the models below it in the design try. This

Re: Oracle Error

This is was my fault, I should not take db down (restart) in cluster environment. Some cluster command needs to be executed first before restart database. This cluster command (take db temporary from cluster or pause cluster) needs to be run as root user. Maybe some one has an example of this

Re: Multi-threaded server - will it help in this case

Peter, MTS (or SS in 9i onwards) is an excellent choice to accomodate this application. Please be aware that you can mix dedicated and MTS by setting up different TNS names on different ports for each, so it is not an all-or-nothing situation. Most connections to the database outside of this

Re: Oracle Error

I believe that post/wait driver has to be loaded from /etc/system or some other config file. Oracle tries to use post/wait driver for inter process communication because, generally speaking, it's faster then semaphores. There used to be a parameter called use_pw or post_wait or something like

RE: Memory consumption on HP-UX

Take care with automatic PGA management. We have TNS12500 HPUX err 12 using it because proceses RESERVING lots of swap. We change to manual PGA (we use sort_area_size, etc.) It was on 9.2.0.1 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Richard Foote

Re: for years I have been using korn shell

PDKSH is also needed for Mac OS X, available on http://www.osxgnu.org/software;... Bash is a very big shell which I typically don't need. I use korn shell which is available as pdksh package (see rpmfind.net). On 11/10/2003 04:54:25 PM, Jesse, Rich wrote: For Linux, I use bash. For Unix

Re: Oracle Error

I'm going to assume this is Veritas Cluster Server. If so, why aren't you just doing this from the GUI? It's a little simpler that way. You can see the commands being executed via the log viewer tearoff on the menu. Jared On Tue, 2003-11-11 at 07:04, Greg Faktor wrote: This is was my fault,

RE: Oracle Error

Didn't this have to be in /etc/inittab or am I thinking of something totally different ??? Regards Lee -Original Message- Sent: 11 November 2003 15:04 To: Multiple recipients of list ORACLE-L I believe that post/wait driver has to be loaded from /etc/system or some other config file.

Re: Multi-threaded server - will it help in this case

Tim, This bit: accomodate this application. Please be aware that you can mix dedicated and MTS by setting up different TNS names on different ports for each, so it is not an all-or-nothing seems to imply that MTS and Dedicated will each require their own listener ( different ports). Been

RE: for years I have been using korn shell

Concerning pdksh: Unless it has been fixed (and I don't think it has), it is too buggy to be used for scripting. If you are going to download and install ksh, get The Real Thing. If you have way too much time on your hands and want a monster shell -- the biggest of them all, get zsh; it's

Re: Oracle Error

This is Sun Cluster 3.0. Process schedule through cron at 2:00 AM. greg [EMAIL PROTECTED] 11/11/2003 10:24:24 AM I'm going to assume this is Veritas Cluster Server. If so, why aren't you just doing this from the GUI? It's a little simpler that way. You can see the commands being executed

RE: Multi-threaded server - will it help in this case

I thought setting server=dedicated in the tnsnames.ora was the setting to change this -Original Message- Sent: Tuesday, November 11, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Tim, This bit: accomodate this application. Please be aware that you can mix dedicated and

RE: Multi-threaded server - will it help in this case

Jared Still scribbled on the wall in glitter crayon: Tim, This bit: accomodate this application. Please be aware that you can mix dedicated and MTS by setting up different TNS names on different ports for each, so it is not an all-or-nothing seems to imply that MTS and Dedicated

Re: Multi-threaded server - will it help in this case

Nope. They can use the same listener and I'm pretty sure they can even use the same port, but if you did the latter, you'd just want to differentiate in the TNSNAMES definition with the (SERVER=SHARED) or (SERVER=DEDICATED) clause. However, I haven't done this last thing lately and as I write,

Re: Oracle 7.3.4.0 on Win 2000

Thanks Reginald Paul for your inputs, it definitely helped me get to the solution. I thought of closing the thread with what worked for me Installed Oracle 7.3.4.0 on Windows 2000 SE server (The installation failed to start and stop Oracle Agent and installation ended reporting the account does

RE: Multi-threaded server - will it help in this case

Jared, I don't think that is what Tim meant. You can use something akin to the following: For an MTS connection/client: MYDB_MTS.MYCOMPANY.COM = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=MYHOST.MYCOMPANY.COM)(PORT=7505))(CONNECT_DATA=(SID=MYSID))) For a dedicated connection/client:

RE: for years I have been using korn shell

Oh, wait! I know this! ^H=back a character! ^U=erase line! IT'S VMS! -Original Message- Sent: Tuesday, November 11, 2003 8:05 AM To: Multiple recipients of list ORACLE-L Here's a snippit from my ~/.kshrc, which kinda-sorta approximates bash's default behavior. Unfortunately, there

SQL comparison question...

This is part of a row-level security implementation: For some reason the following comparison works but currently it isn't: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) --

SQL comparison addition:

I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where the comparison only worked when I put in the trim. ? 1

RE: SQL comparison addition:

Perhaps it's your clients? I've spouted off here before about the MACHINE column of V$SESSION having an extra CHR(0) at then end of it for Winders clients. Maybe something similar's happening to you, but with whitespace (the TRIM in your statement won't lop off CHR(0)). HTH! Rich Rich Jesse

Re: SQL comparison addition:

I may be barking up the wrong tree, but humour an old dba... Could you try running the following and post the output? select sys_context('userenv','session_user'), dump(sys_context('userenv','session_user')), a.reports_login, dump(a.reports_login) from global.client_dim a WHERE

Re: Oracle Error

Greg: This is what I got from our SA. You have to be root to be able to do this. Good luck! Barb, A little firsthand knowledge is required... Namely, you have to know the cluster resource group name of the resource for the instance of oracle: scstat -g will list the resource groups at the top,

RE: SQL comparison addition:

SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN; SYS_CONTEXT('USERENV','SESSION_USER')

RE: SQL comparison addition:

But wouldn't whitespace show up when I select '|'||reports_login||'|' ?? -Original Message- Sent: Tuesday, November 11, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Perhaps it's your clients? I've spouted off here before about the MACHINE column of V$SESSION having an extra

RE: for years I have been using korn shell

How about just use ESC for filename completion? I'm using 11/16/88 version ksh. $ set -o emacs $ what /bin/ksh /bin/ksh: Version M-11/16/88i SunOS 5.8 Generic 110662-04 May 2001 $ touch yongtest $ ls yongtest yongtest The last line was typed by pressing ls yongtESCESC. Yong

RE: SQL comparison addition:

I don't see any extraneous characters in sys_context('userenv','session_user')either. But the trailing null in v$session.machine for Windows connections is a known problem. Bug 646174 shows version 8.1.5. I tried in 9.2.0.1. It still exists: SQL select dump(machine) from v$session where machine =

RE: Multi-threaded server - will it help in this case

Thanks John, this is the way I have done it in the past. Tim, thanks for your clarification. Thought that was more or less what you meant, just wanted didn't want to see any myths started stating that MTS requires its own listener. ;) Jared John Kanagaraj [EMAIL PROTECTED] Sent by:

RE: for years I have been using korn shell

Yeah, using double-ESC works fine for filename completion. I was just pointing out that there's no way to map it to TAB (as far as I know), like bash uses. -Original Message- Yong Huang Sent: Tuesday, November 11, 2003 12:34 PM To: Multiple recipients of list ORACLE-L How about just

var source_data varchar2(12)

I'm looking at a PL/SQL script that goes like this -- Header var Source_Data VARCHAR2(12) DECLARE Num1 NUMBER; BEGIN Source_Data := '1';

Re: SQL comparison addition:

Hmmm... I was expecting to see something like Yong writes about. The only suggestion I have is to use DUMP() the next time this happens and figure out where the two strings differ. Daniel Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2

Multithreaded server - effect of POOLING=ON option

Thanks for all of the input on the multi-threaded server. I have one more question: What is the effect of the POOLING option on the MTS_DISPATCHERS specification? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL

Re: var source_data varchar2(12)

It took me awhile to figure this one out. The real problem is Maryann Atkinson wrote: I'm looking at a PL/SQL script that goes like this -- Header var Source_Data VARCHAR2(12) DECLARE Num1 NUMBER; BEGIN Source_Data := '1'; -- Please see the official ORACLE-L FAQ:

PCTFREE, PCTUSED and ASSM

Int the note 247752.1 named Oracle9i Space Management Demystified oracle says the following: --- AUTOMATIC SEGMENT SPACE MANAGEMENT ARCHITECTURE Oracle9i introduces a new way of managing free space within a segment

Re: SQL comparison addition:

Chris There is a contradiction below: Chris Stephens wrote: SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') =

RE: SQL comparison addition:

SQL select sys_context('userenv','session_user'), 2 dump(sys_context('userenv','session_user')), a.reports_login, 3 dump(a.reports_login) 4 from global.client_dim a 5 WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN); SYS_CONTEXT('USERENV','SESSION_USER')

Re: Memory consumption on HP-UX

Hi Juan, We encountered the same problem. Issue was due to OS being set in Eager swapping mode. Support viewed the fact it reserved a massive amount of swap as a feature. However, after switching the OS (HP 5.1 TRU64) to Lazy swap mode, the problem (as one would hope) disappeared and we haven't

var source_data varchar2(12)

My original posting had a few lines truncated, so here I go again: I'm looking at a PL/SQL script that goes like this -- Header var Source_Data VARCHAR2(12) DECLARE Num1 NUMBER; BEGIN Source_Data := '1'; What's the purpose of having a VAR statement in front or Before of the

Re: var source_data varchar2(12)

The purpose is to confuse the heck out of the person who tries to understand it. Using military vocabulary, so popular these these days, the var before the declare block is here to confuse and deceive the enemy. You see, if the program was written in such a way that another human being could

RE: OT (DB2)

-Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 November 2003 00:45 To: Multiple recipients of list ORACLE-L Subject: OT (DB2) Hi, Anyone out there who used to be subscribed to the DB2-L listserv. Since it moved hosts, I have

Re: var source_data varchar2(12)

Maryann, SOURCE_DATA is a SQL*Plus variable, declared using the VAR (a.k.a. VARIABLE) command. It can be referenced inside the PL/SQL block and then used by SQL*Plus commands (such as PRINT) or SQL commands (such as SELECT) outside of the block. My guess is that it is being used for

Re: var source_data varchar2(12)

Of course, within sqlplus one can only use it to invoke another PL/SQL procedure. That is, in my opinion, what packages and package variables are for. On 11/11/2003 05:04:26 PM, Tim Gorman wrote: Maryann, SOURCE_DATA is a SQL*Plus variable, declared using the VAR (a.k.a. VARIABLE) command.

Mladen Re: var source_data

At 04:59 PM 11/11/2003, you wrote: The purpose is to confuse the heck out of the person who tries to understand it. Using military vocabulary, so popular these these days, the var before the declare block is here to confuse and deceive the enemy. You see, if the program was written in such a way

Re: var source_data varchar2(12)

Got it Tim, thanks. maa At 05:04 PM 11/11/2003, you wrote: Maryann, SOURCE_DATA is a SQL*Plus variable, declared using the VAR (a.k.a. VARIABLE) command. It can be referenced inside the PL/SQL block and then used by SQL*Plus commands (such as PRINT) or SQL commands (such as SELECT) outside of the

Re: var source_data varchar2(12)

The 'var' variable can be used as a bind variable in pl/sql. Variables referenced with or are substution variables. The code in your example looks incomplete to me, or the programmer just didn't bother to complete it, as Mladen has already suggested. Here's a ( rather useless) example of

Re[2]: var source_data varchar2(12)

Tuesday, November 11, 2003, 5:44:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG Of course, within sqlplus one can only use it to invoke another MG PL/SQL procedure. You can also PRINT (SQL*Plus command) the value of a REFCURSOR variable returned by a stored procedure to generate a SQL*Plus

Re: (looong) PCTFREE, PCTUSED and ASSM

From that, it would follow that free lists as such are gone in ASSM tablespaces and are replaced by bitmaps. As Richard Foote has shown, PCTFREE is not ignored, but without free lists, it doesn't make much sense. Does any of the gurus (Cary, Steve, Jonathan, Wolfgang, Pete Sharman) have any

RE: (looong) PCTFREE, PCTUSED and ASSM

Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -Original Message- Sent: Tuesday, November 11,

Re: Multithreaded server - effect of POOLING=ON option

Hi Peter, There are many parameters for this particular option: ON, OFF, YES, NO, IN, OUT, TRUE, FALSE, BOTH (not even sure I've exhausted the entire list here) Used for connection pooling, the values you choose for this parameter impact your idle network connections. For more info, feel free

Clean temporary tablespace

Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com