date:20030827


Re the annoying leading whitespace:

If you're doing this with shell, run it through this filter:

   sed -e 's/^ *//g' -e 's/^ *//g'

( those blanks are a tab and a space, respectively )

If you are doing it in perl simply use s/^\s+//

  eg. $line =~ s/^\s+//;

HTH

Jared








"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 03:44 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Alert log


Be careful of grepping for "^ORA-", I occasionally get "     ORA-" (spaces)
when I use this.   Anjo gave me a call to make to attempt to get the line to
start at the beginning but I don't think it works.  Hard to test since this
situation is not recreatable.  AIX 64 bit 4.3 Oracle 8.1.4.

- E

-Original Message-
Sent: Wednesday, August 27, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L


> "Roger Xu" <[EMAIL PROTECTED]>

for the guy that asked for writing the the alert.log
file:

dbms_system.ksdwrt(2,'Test line...');

Will write the text to the alert log.

Use 1 instead of 2 to write to the trace file

Use 3 to write to both.

HTH

JL


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Shared Pool Utilization


So it was the MTS.  Hadn't thought of that.

Jared







"Tanel Poder" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 03:49 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Shared Pool Utilization


You're welcome!

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 1:34 AM


> Tanel
>  You were on target
>
> SQL> show parameter shared_serv
>
> NAME                                 TYPE        VALUE
>  ---
> --
> max_shared_servers                   integer     20
> shared_server_sessions               integer     0
> shared_servers                       integer     0
> SQL> show parameter dispatch
>
> NAME                                 TYPE        VALUE
>  ---
> --
> dispatchers                          string
> max_dispatchers                      integer     5
> mts_dispatchers                      string
> mts_max_dispatchers                  integer     5
> SQL>
>
> I corrected the script for non-MTS/DTS and got the result.
> SQL> @swt02a
> Object mem :   67.73 Mb
> Cursors    :   3.02 Mb
> MTS session/UGA memory max:   433.93 Mb
> Free memory:   105.98 Mb (105.98MB)
> Shared pool utilization (total):  96440007 bytes (91.97MB)
> Shared pool allocation (actual):  201326592bytes (192MB)
> Percentage Utilized:  48%
>
> PL/SQL procedure successfully completed.
>
> Thanks
>
>
> > Hi!
> >
> > I wonder whether you are running in dedicated server mode? That way UGA
> > isn't allocated from SGA and the calculation used_pool/shared_pool_size
is
> > gives wrong results.
> >
> > Tanel.
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 27, 2003 10:44 PM
> >
> >
> >> I have two databases, one in which the shared_pool utilization is not
> >> exceeded (development) and the other one in which it appears that the
> >> shared_pool utilization is exceeded.
> >> The queries i am using are
> >> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
> >> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
> >>  WHERE NAME = 'free memory'
> >>    AND POOL = 'shared pool'
> >> /
> >>
> >> 2. Metalink note
> >> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
> >> bytes--> Mb and nvl clauses)
> >>
> >> set serveroutput on size 100;
> >> DECLARE
> >>         object_mem     NUMBER;
> >>         shared_sql     NUMBER;
> >>         cursor_mem     NUMBER;
> >>         mts_mem        NUMBER;
> >>         used_pool_size NUMBER;
> >>         free_mem       NUMBER;
> >>         pool_size      VARCHAR2(512); -- same AS V$PARAMETER.VALUE
> >> BEGIN
> >>         -- Stored objects (PACKAGEs, views)
> >>         --V$DB_OBJECT_CACHE
> >>         --This view displays database objects that are cached in the
> >> library cache. Objects include
> >>         --tables, indexes, clusters, synonym definitions, PL/SQL
> >> procedures and packages, and triggers.
>
   --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96
> > 536/ch346.htm#1113348
> >>     SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
> > v$db_object_cache;
> >> --
> >> --
> >>         -- User Cursor Usage -- run this during peak usage.
> >>         -- assumes 250 bytes per open cursor, FOR each concurrent user.
> >>         -- V$SQLAREA lists statistics on shared SQL area and contains
> >> one
> >> row per SQL string.
> >>         -- It provides statistics on SQL statements that are in memory,
> >> parsed, and ready for execution.
> >>     SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
> >>
> >>     -- For a test system -- get usage FOR one user, multiply by # users
> >>     -- SELECT (250 * value) bytes_per_user
> >>     -- FROM v$sesstat s, v$statname n
> >>     -- WHERE s.statistic# = n.statistic#
> >>     -- AND n.name = 'opened cursors current'
> >>     -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
> >>
> >>     -- MTS memory needed to hold session inFORmation FOR shared server
> > users
> >>     -- This query computes a total FOR all currently logged on users
> >> (run
> >>     --  during peak period). Alternatively calculate FOR a single user
> >> and
> >>     --  multiply by # users.
> >> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
> >>        WHERE s.statistic#=n.statistic#
> >>        AND n.name='session uga memory max';
> >>
> >>     -- Free (unused) memory IN the SGA: gives an indication of how much
> >> memory
> >>     -- is being wasted OUT of the total allocated.
> >> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
> >>         WHERE name = 'free memory' AND pool='shared pool';
> >>     -- For non-MTS add up object, shared sql, cu

Re: International Language Support Experiences?

Great, in this case I wasn't thinking with my ass, I just remembered this
issue from ancient times :)

Tanel.


> You are correct except it is supported with 8i, make sure compatible
parameter is set to 8.1.x.
>
> -Original Message-
> Sent: Wednesday, August 27, 2003 5:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> IIRC, you can't store LOBs in UTF8 since it's a variable width charset?
>
> Tanel.
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 27, 2003 11:59 PM
>
>
> > For clients that do not support UTF8, you can set NLS_LANG on the client
> > server to the appropriate single byte character set.  The Oracle client
> > library will do the conversion to/from UTF8 when you store/retrieve data
> > to/from the Oracle server.
> >
> > In fact, using UTF8 on the Oracle server does not require _any_ of your
> > client apps to use UTF8 at all.  Suppose you have an Oracle server at
> > your corporate headquarters serving the needs of multiple client apps
> > around the world.  The app servers in Asia, Europe, Africa, S. America
> > etc. can each set NLS_LANG to their own _single byte_ character set and
> > still, because the Oracle server at corporate uses UTF8 which is MBCS,
> > the app servers can all share the same Oracle server.
> >
> > HTH,
> > Dave
> >
> >
> >
> >
> >
> > [EMAIL PROTECTED] wrote:
> > > David,
> > >
> > > I can share this from an Oracle Apps perspective - we upgraded to UTF8
> > > (a multi byte char set) from WE8ISO5599-1 (single byte Western Eur
> > > charset). Some of the biggest problems that we faced are:
> > >
> > > 1. Cut-and-paste produces incorrect characters which were acceptable
in
> > > WE8 but failed conversion. I.e. UTF8 is stricter in what it can
display
> > > as compared to WE8. This was pronounced in the umlaut and other Eur
> > > specific characters.
> > > 2. Quite a number of third-party applications do not support UTF8 -
when
> > > asked about Unicode support, many vendors didn't even know what it
would
> > > mean to support a MBCS such as UTF-8. This may also be the case with
> > > your own applications.
> > > 3. Middle-ware layers such as ODBC/JDBC don't work very well with UTF8
> > > in the sense that the rules have become stricter and so programs that
> > > used to work previously will now fail mysteriously with vague messages
> > > (or worse still silently!).
> > > 4. A column which supports text elements that may now handle MBCs will
> > > require more storage width than previously designed for. Thus you may
> > > have to look at schema changes to increase VARCHAR2/CHAR columns..
> > > 5. Oracle products themselves may need some patches - you mention
iAS -
> > > and have functional restrictions.
> > > 6. The
> > >
> > > You won't hit 1 because you are moving from US7ASCII (7 bit) but watch
> > > out for the rest! ML Note 158577.1 is a good starting point. I would
> > > read this one (and the related links) before the 450 pages - you seem
to
> > > like reading :)
> > >
> > >
> > > John Kanagaraj
> > > DB Soft Inc
> > > Phone: 408-970-7002 (W)
> > >
> > > Disappointment is inevitable, but Discouragement is optional!
> > >
> > > ** The opinions and facts contained in this message are entirely mine
> > > and do not reflect those of my employer or customers **
> > >
> > >
> > >
> > > -Original Message-
> > > From: David Wagoner [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, August 27, 2003 11:35 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: International Language Support Experiences?
> > >
> > > We have a new requirement to support multiple languages in at
least
> > > one of our databases.  I'm reading the Oracle 9iR2 Globalization
> > > Support Guide (450 pages), but wonder if any of you can share
> > > real-life experiences regarding:
> > >
> > > 1.  the conversion of existing DBs to broader character sets
> > > 2.  using Unicode
> > > 3.  implementing this with 9iAS
> > >
> > > Our databases currently use US7ASCII with the American character
> > > set, but we will likely need to support European, Southeast Asian,
> > > and South American languages.
> > >
> > >
> > > Thanks.
> > >
> > >
> > > Best regards,
> > >
> > > David B. Wagoner
> > > Database Administrator
> > > Arsenal Digital Solutions
> > >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Dave Hau
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of

Re: buffer_size parameter for import utility

use buffer size = 1045760 (10Mb with commit = Y).
If there of columns with LOB then it is going to be slow.

HTH



> Hello,
>
> I don't understand very well the buffer_size parameter and how to use  it.
> with imp tool.
>
> If I read the help:
>
> BUFFER
>
> Default: operating system-dependent
>
> The integer specified for BUFFER is the size, in bytes, of the buffer
> through which data rows are transferred.
>
> BUFFER determines the number of rows in the array inserted by Import.
> The following formula gives an approximation of the buffer size that
> inserts a given array of rows:
>
> buffer_size * rows_in_array * maximum_row_size
>
>
> I have a database with 3 big tables (each containing between 9 and 13
> billions rows).
> The others 60 tables contains about 5 and 2 rows.
>
> The biggest table is:
>
> SQL> describe gesten3.grandeur_mesure;
>  Nom   NULL ?   Type
>  -
> 
>  ID_GRANDEUR   NOT NULL NUMBER(15)
>  DATE_AQUISITION   NOT NULL DATE
>  VALEUR FLOAT(126)
>  VALIDITE   NUMBER(1)
>  ID_TYPE_ACQUISITIONNUMBER(15)
>  UTILISATIONNUMBER(15)
>  ID_COMPTEURNUMBER(15)
>  ID_TYPE_GRANDEUR   NUMBER(15)
>  ID_UNITE   NUMBER(15)
>  ID_HISTORISATION  NOT NULL NUMBER(15)
>
> SQL>
>
> Small tables, of course are imported very rapidly, but this table take
> several hour to finish import.
> How to improve that ?
>
> This database is running 8.1.7.2 under Solaris 8.
>
> Thanks for your help and have a nice day.
>
> Jean Berthold
>
> __
> Jean Berthold
> EOS - energie ouest suisse
> Chemin de Mornex 10 , CP 570
> CH-1001 Lausanne , Switzerland
> Tel. : +41 (0)21 341 24 58
> Fax : +41 (0)21 341 20 49
> E-Mail : [EMAIL PROTECTED]
> -
> UNIX is user friendly.
> It's just selective about who its friends are.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: BERTHOLD Jean
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Corniche Park
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Grid

10GB over Atlantic?

This does cost a lot. At least I assume so, why the heck am I sticking to
512kb in my home then?

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 1:54 AM


> i havent seen much about internet 2. i didnt realize there was anything in
> production yet. do you know where i can find more info on it?
> 2.3 GBs isnt really that much for a connect anymore. its not that
expensive
> to get 10GB connections or more.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 27, 2003 5:44 PM
>
>
> > > We've been talking of Grid computing here since either late 1999 or
> early
> > 2000.  The computing for our main experiment was designed before the
Grid
> > was contemplated.  Still we have implemented some of the middleware
> needed,
> > and build methods of authentication and authorization, and participated
in
> > Grid experiments. We have also been pushing the ability to transfer
large
> > amounts of data.  The latest effort: 2.3 GB per second between the local
> > internet hub and Geneva Switzerland over Internet 2.  This is vital to
> make
> > the Grid work.
> >
> > Yep, you'll probably have huge amounts of data coming in when CERN gets
> > their large hadron collider online in 2007 ;)
> > Btw, AFAIK, they're using Oracle...
> >
> > Tanel.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Tanel Poder
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ryan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OT: Hey Jared!!

> Still on the plus side I now have 1 days overtime clocked up in 2 days
> elapsed time dealing with a .ing worm that some .ing user
> decided to introduce to our systems at 4:35 am on a Sunday morning. This

Have you read this about Ohio nuclear plant and Slammer worm?

http://www.securityfocus.com/news/6767

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: VPN access to 9ias instance behind firewall

Title: RE: VPN access to 9ias instance behind firewall



The issue is, that when you ssh to your site, it 
uses probably port 22 or 22022. But when you just go to http://site.com , the browser actually connects to 
your site port 80, unless there's a proxy specified, then your browser connects 
to proxy server and hands the http request over to it. Now, could it be that 
port 22 is open in fiewall for your clients to connect, but port 80 isnt? You 
gotta ask from your network administrator about it. 
But a simple way to test it without a browser is 
just to telnet to your site's port 80. I think by "telnet isn't allowed" you 
mean that all telnet daemons are shut down in your servers. But that's ok, you 
actually can telnet to any webserver, just telnet to your sites port 80 and 
see what happens. 
* If you get a connection refused or like 
error then either some firewall blocks your access to webserver. 
* If your connection just hangs, even when and 
pressing enter in telnet window, then it's probably firewall again. 

* If your telnet connection seems to hang, but 
quits when you press enter (or spits out HTML when you type GET / in prompt) 
then the connection to webserver is available, but the problem is in browser or 
proxy. 
 
You can verify the proxy settings somewhere from 
tools->options->network...blah or smth like that, somebody should know it 
for sure in your office...
 
About point 3 - a good starting point would be to 
nslookup or ping the hostname which you're trying to connect to and see whether 
the net name is even resolved to ip address?
 
Tanel.
 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, August 28, 2003 1:34 
  AM
  Subject: RE: VPN access to 9ias instance 
  behind firewall
  
  Dear 
  Tanel,
   
  Thanks for the reply.  I have some questions:
  
-Original Message-From: Tanel Poder 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 
5:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: VPN access to 9ias instance behind 
firewall
Hi!
 
How is the "VPN" set up? Is it just a ssh 
tunnel or is it a real VPN with routing etc..?[Stankus, Paula 
G] 
SSH is allowed through the hosts.allow file in 
Unix 
 
1) check whether the url your users type 
in is directed through proxy. And proxy server isn't aware of this VPN. In 
this case disable the proxy or make it aware of vpn[Stankus, Paula G] How 
would I know this.   
2) if no proxy is used, then ask your users 
just to telnet to the url (for http://site.com 
they have to telnet site.com 80, and see if they get an error. If not (the 
telnet seems hanging, type GET / in it and see whether any html is 
returned). That way you should at least isolate whether the problem is in 
browser or not)[Stankus, Paula G] Can I have them do a ssh http.site.com 
 instead?  Telnet is not allowed at 
all. 
3) if you are dealing with local ssh 
tunnels, then you probably have to change your 
c:\winnt\system32\drivers\etc\hosts accordingly (if using windows), to set 
that the site.com where you want to connect, actually points to your own 
machine (127.0.0.1) and ssh directs your connections to the right point from 
there. I've used this mechanism for several customers support.[Stankus, Paula G] If 
client is coming from Texas and we are in Florida whose 
c:\winnt\system32\drivers\etc\hosts file needs to be setup (9ias is 
running under Unix) - we have localhost setup in our Unix host 
file.  Can you explain #3 in more detail or point me to a 
document?
 
Thanks,
Paula 
 
Tanel.
 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Wednesday, August 27, 2003 
  11:29 PM
  Subject: RE: VPN access to 9ias 
  instance behind firewall
  
  Guys, 
  When user trys to run our application through a VPN behind 
  the firewall in a url they get an error.  They can use ssh to get to 
  host where I installed the application server but not run the application 
  through their browser.  Anyone deal with this issue 
before?
  Thanks, Paula

Re: Shared Pool Utilization

You're welcome!

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 1:34 AM


> Tanel
>  You were on target
>
> SQL> show parameter shared_serv
>
> NAME TYPEVALUE
>  ---
> --
> max_shared_servers   integer 20
> shared_server_sessions   integer 0
> shared_servers   integer 0
> SQL> show parameter dispatch
>
> NAME TYPEVALUE
>  ---
> --
> dispatchers  string
> max_dispatchers  integer 5
> mts_dispatchers  string
> mts_max_dispatchers  integer 5
> SQL>
>
> I corrected the script for non-MTS/DTS and got the result.
> SQL> @swt02a
> Object mem :   67.73 Mb
> Cursors:   3.02 Mb
> MTS session/UGA memory max:   433.93 Mb
> Free memory:   105.98 Mb (105.98MB)
> Shared pool utilization (total):  96440007 bytes (91.97MB)
> Shared pool allocation (actual):  201326592bytes (192MB)
> Percentage Utilized:  48%
>
> PL/SQL procedure successfully completed.
>
> Thanks
>
>
> > Hi!
> >
> > I wonder whether you are running in dedicated server mode? That way UGA
> > isn't allocated from SGA and the calculation used_pool/shared_pool_size
is
> > gives wrong results.
> >
> > Tanel.
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 27, 2003 10:44 PM
> >
> >
> >> I have two databases, one in which the shared_pool utilization is not
> >> exceeded (development) and the other one in which it appears that the
> >> shared_pool utilization is exceeded.
> >> The queries i am using are
> >> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
> >> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
> >>  WHERE NAME = 'free memory'
> >>AND POOL = 'shared pool'
> >> /
> >>
> >> 2. Metalink note
> >> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
> >> bytes--> Mb and nvl clauses)
> >>
> >> set serveroutput on size 100;
> >> DECLARE
> >> object_mem NUMBER;
> >> shared_sql NUMBER;
> >> cursor_mem NUMBER;
> >> mts_memNUMBER;
> >> used_pool_size NUMBER;
> >> free_mem   NUMBER;
> >> pool_size  VARCHAR2(512); -- same AS V$PARAMETER.VALUE
> >> BEGIN
> >> -- Stored objects (PACKAGEs, views)
> >> --V$DB_OBJECT_CACHE
> >> --This view displays database objects that are cached in the
> >> library cache. Objects include
> >> --tables, indexes, clusters, synonym definitions, PL/SQL
> >> procedures and packages, and triggers.
>
   --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96
> > 536/ch346.htm#1113348
> >> SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
> > v$db_object_cache;
> >> --
> >> --
> >> -- User Cursor Usage -- run this during peak usage.
> >> -- assumes 250 bytes per open cursor, FOR each concurrent user.
> >> -- V$SQLAREA lists statistics on shared SQL area and contains
> >> one
> >> row per SQL string.
> >> -- It provides statistics on SQL statements that are in memory,
> >> parsed, and ready for execution.
> >> SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
> >>
> >> -- For a test system -- get usage FOR one user, multiply by # users
> >> -- SELECT (250 * value) bytes_per_user
> >> -- FROM v$sesstat s, v$statname n
> >> -- WHERE s.statistic# = n.statistic#
> >> -- AND n.name = 'opened cursors current'
> >> -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
> >>
> >> -- MTS memory needed to hold session inFORmation FOR shared server
> > users
> >> -- This query computes a total FOR all currently logged on users
> >> (run
> >> --  during peak period). Alternatively calculate FOR a single user
> >> and
> >> --  multiply by # users.
> >> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
> >>WHERE s.statistic#=n.statistic#
> >>AND n.name='session uga memory max';
> >>
> >> -- Free (unused) memory IN the SGA: gives an indication of how much
> >> memory
> >> -- is being wasted OUT of the total allocated.
> >> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
> >> WHERE name = 'free memory' AND pool='shared pool';
> >> -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
> >> --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
> >>
> >> -- For MTS mts contribution needs to be included (comment OUT
> >> previous
> >> line)
> >> used_pool_size :=
> >> ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));
> >>
> >> SELECT NVL(value,0) INTO pool_size

RE: perl/shell script for alert log

Yeah, I log those.  Some of the db's I support run with very small redo logs
and I can't change.  They get those quite frequently at times so I pretty
much ignore them.  My script also reacts (log,email,page, or run some
script) in the event of startups, shutdowns and alter database structure.
It also sends everything through a filter of "known" patterns and anything
that is not recognized falls out.  I call this the paranoid switch "-p".
One best practice I recommend is to automate control file backups anytime a
ALTER TABLESPACE, ALTER DATABASE etc...is in the alert log. 

-Original Message-
Sent: Wednesday, August 27, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L


Hi!

I would add a check for "Checkpoint not complete" in alert just in case as
well.

Tanel.

> One enhancement I suggest to every script is to configure the a
SERVERERROR
> trigger to throw certain errors out to the alert log.  ORA-1555 is one
that
> will show up at the session level but not at the database level.  Out of
> TEMP space is another that is frequent at the session level but not the
> database level.  This way you know who is causing some important errors.
> Overtime I find more and more session errors that are really critical
> database errors.  Try DDL on a table with an unusable index.  Pretty big
> deal on most production databases but this is a session error and would
not
> typically show up in the alert log.  The risk of course is some huge loop
> throwing 1000's of lines into the alert log.  I would suggest a governor
of
> some sort in your servererror trigger.
>
> - Ethan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Grid

2003-08-27 Thread Ryan

i havent seen much about internet 2. i didnt realize there was anything in
production yet. do you know where i can find more info on it?
2.3 GBs isnt really that much for a connect anymore. its not that expensive
to get 10GB connections or more.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 5:44 PM


> > We've been talking of Grid computing here since either late 1999 or
early
> 2000.  The computing for our main experiment was designed before the Grid
> was contemplated.  Still we have implemented some of the middleware
needed,
> and build methods of authentication and authorization, and participated in
> Grid experiments. We have also been pushing the ability to transfer large
> amounts of data.  The latest effort: 2.3 GB per second between the local
> internet hub and Geneva Switzerland over Internet 2.  This is vital to
make
> the Grid work.
>
> Yep, you'll probably have huge amounts of data coming in when CERN gets
> their large hadron collider online in 2007 ;)
> Btw, AFAIK, they're using Oracle...
>
> Tanel.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT: Hey Jared!!

2003-08-27 Thread Niall Litchfield

Rachel opined
> c'mon... any virus named "SoBig" has to have been written by a man :)
> 
> (yes, sexist, I know)

I think the word you are looking for is "True" not "sexist". 

Still on the plus side I now have 1 days overtime clocked up in 2 days
elapsed time dealing with a .ing worm that some .ing user
decided to introduce to our systems at 4:35 am on a Sunday morning. This
time has been spent engineering a fix for client side operating systems
- but hey I can't do my real DR work because the DR site and the prod
site won't talk to each other because of the ing Worm.  By March we
will have ripped out all our non-ms stuff, Oh good. 

For those who may be affected by nachi/blaster/sobig this is the field
checklist

1, Remove from servers that escaped patching (easy)
2, Remove from client workstations ( a bugger if they are all laptops
connected via dial-up once a month that user conveniently hasn't patched
for 2 years)
3, Insert decommissioned kit into user who connected unauthorised pc to
office LAN (this serves merely to boost morale by 'patching your
organisations hole'

:(

Niall 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Shared Pool Utilization

Tanel did. Thanks for the input and time.

> Ah, I see.   What you have to keep in mind is that these messages need to
> be simplified
> for us poor overworked DBA's.  We have short attention spans.  :)
>
> That script is too complex for what you're trying to do, which is track
> memory usages.
>
> Throw it away and write one more to your liking, and is also
> understandable.
>
> Really.
>
> I wouldn't troubleshoot it for my own use, so I'm not too likely to do it
> for someone else.  :)
>
> Maybe someone else here will take a go at it.
>
>
> Jared
>
>
>
>
>
> "Corniche Park" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  08/27/2003 03:04 PM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:Re: Shared Pool Utilization
>
>
> I ran the query given, but that doesnot answer my question.
> I am asking what is wrong with the script(s)?
>
>> I don't trust scripts I didn't write myself, and not even some of those.
>> ;)
>>
>> What does this reveal?
>>
>> select a.value + ( b.value * c.value )
>> from
>> ( select sum(value) value from v$parameter
>>   where name like '%pool%'
>> ) a
>>  , v$parameter b
>>  , v$parameter c
>> where b.name = 'db_block_buffers'
>> and c.name = 'db_block_size'
>>
>> As long as you're not using some of the newer 9i memory allocation
>> parameters, this
>> should be pretty close to the amount of memory you've allocated in
>> init.ora.
>>
>> Now see how much is in the SGA:
>>
>> select sum(value) from v$sga;
>>
>> Should be fairly close to the first number.
>>
>> Jared
>>
>>
>>
>>
>>
>>
>> "Corniche Park" <[EMAIL PROTECTED]>
>> Sent by: [EMAIL PROTECTED]
>>  08/27/2003 12:44 PM
>>  Please respond to ORACLE-L
>>
>>
>> To: Multiple recipients of list ORACLE-L
>> <[EMAIL PROTECTED]>
>> cc:
>> Subject:Shared Pool Utilization
>>
>>
>> I have two databases, one in which the shared_pool utilization is not
>> exceeded (development) and the other one in which it appears that the
>> shared_pool utilization is exceeded.
>> The queries i am using are
>> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
>> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
>>  WHERE NAME = 'free memory'
>>AND POOL = 'shared pool'
>> /
>>
>> 2. Metalink note
>> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
>> bytes--> Mb and nvl clauses)
>>
>> set serveroutput on size 100;
>> DECLARE
>> object_mem NUMBER;
>> shared_sql NUMBER;
>> cursor_mem NUMBER;
>> mts_memNUMBER;
>> used_pool_size NUMBER;
>> free_mem   NUMBER;
>> pool_size  VARCHAR2(512); -- same AS V$PARAMETER.VALUE
>> BEGIN
>> -- Stored objects (PACKAGEs, views)
>> --V$DB_OBJECT_CACHE
>> --This view displays database objects that are cached in the
>> library cache. Objects include
>> --tables, indexes, clusters, synonym definitions, PL/SQL
>> procedures and packages, and triggers.
>>
>>
> --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch346.htm#1113348
>> SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
>> v$db_object_cache;
>> --
>> --
>> -- User Cursor Usage -- run this during peak usage.
>> -- assumes 250 bytes per open cursor, FOR each concurrent user.
>> -- V$SQLAREA lists statistics on shared SQL area and contains
> one
>> row per SQL string.
>> -- It provides statistics on SQL statements that are in memory,
>> parsed, and ready for execution.
>> SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
>>
>> -- For a test system -- get usage FOR one user, multiply by # users
>> -- SELECT (250 * value) bytes_per_user
>> -- FROM v$sesstat s, v$statname n
>> -- WHERE s.statistic# = n.statistic#
>> -- AND n.name = 'opened cursors current'
>> -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
>>
>> -- MTS memory needed to hold session inFORmation FOR shared server
>> users
>> -- This query computes a total FOR all currently logged on users
> (run
>> --  during peak period). Alternatively calculate FOR a single user
> and
>> --  multiply by # users.
>> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
>>WHERE s.statistic#=n.statistic#
>>AND n.name='session uga memory max';
>>
>> -- Free (unused) memory IN the SGA: gives an indication of how much
>> memory
>> -- is being wasted OUT of the total allocated.
>> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
>> WHERE name = 'free memory' AND pool='shared pool';
>> -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
>> --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
>>
>> -- For MTS mts contribution needs to be included (comment OUT
> previous
>> line)
>> used_pool_size :=
>> ROUND(1.3*(object_mem+NVL(shared_sql

RE: Alert log....

Be careful of grepping for "^ORA-", I occasionally get " ORA-" (spaces)
when I use this.   Anjo gave me a call to make to attempt to get the line to
start at the beginning but I don't think it works.  Hard to test since this
situation is not recreatable.  AIX 64 bit 4.3 Oracle 8.1.4.

- E

-Original Message-
Sent: Wednesday, August 27, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L


> "Roger Xu" <[EMAIL PROTECTED]>

for the guy that asked for writing the the alert.log
file:

dbms_system.ksdwrt(2,'Test line...');

Will write the text to the alert log.

Use 1 instead of 2 to write to the trace file

Use 3 to write to both.

HTH

JL


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: perl/shell script for alert log

Hey, awesome tip!  Been here, lurking.  Does that generate a trace file with
more than just session id and serial# in it?  Nice thing about SERVERERROR
is I can get machinename, username, osuser etc and stuff it in alert log
so I see who caused the error when I get the email, but your way is clearly
easier to implement.

- Ethan

-Original Message-
Sent: Wednesday, August 27, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


Welcome back Ethan!

An alternative is using the following lines in init.ora:

event="1555 trace name errorstack level 3"
event="4031 trace name errorstack level 3"
event="1652 trace name processstate level 10"

This catches the dreaded 01555, out of TEMP, and shared pool allocation
errors *along* with the SQL/Stack from the offending process (and thus time
of occurrence).

And keep *all* the event lines together ;-)

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Shared Pool Utilization


Ah, I see.   What you have to keep in mind is that these messages need to be simplified
for us poor overworked DBA's.  We have short attention spans.  :)

That script is too complex for what you're trying to do, which is track memory usages.

Throw it away and write one more to your liking, and is also understandable.

Really.  

I wouldn't troubleshoot it for my own use, so I'm not too likely to do it for someone else.  :)

Maybe someone else here will take a go at it.


Jared







"Corniche Park" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 03:04 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Shared Pool Utilization


I ran the query given, but that doesnot answer my question.
I am asking what is wrong with the script(s)?

> I don't trust scripts I didn't write myself, and not even some of those.
> ;)
>
> What does this reveal?
>
> select a.value + ( b.value * c.value )
> from
> ( select sum(value) value from v$parameter
>   where name like '%pool%'
> ) a
>  , v$parameter b
>  , v$parameter c
> where b.name = 'db_block_buffers'
> and c.name = 'db_block_size'
>
> As long as you're not using some of the newer 9i memory allocation
> parameters, this
> should be pretty close to the amount of memory you've allocated in
> init.ora.
>
> Now see how much is in the SGA:
>
> select sum(value) from v$sga;
>
> Should be fairly close to the first number.
>
> Jared
>
>
>
>
>
>
> "Corniche Park" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  08/27/2003 12:44 PM
>  Please respond to ORACLE-L
>
>
>         To:     Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
>         cc:
>         Subject:        Shared Pool Utilization
>
>
> I have two databases, one in which the shared_pool utilization is not
> exceeded (development) and the other one in which it appears that the
> shared_pool utilization is exceeded.
> The queries i am using are
> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
>  WHERE NAME = 'free memory'
>    AND POOL = 'shared pool'
> /
>
> 2. Metalink note
> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
> bytes--> Mb and nvl clauses)
>
> set serveroutput on size 100;
> DECLARE
>         object_mem     NUMBER;
>         shared_sql     NUMBER;
>         cursor_mem     NUMBER;
>         mts_mem        NUMBER;
>         used_pool_size NUMBER;
>         free_mem       NUMBER;
>         pool_size      VARCHAR2(512); -- same AS V$PARAMETER.VALUE
> BEGIN
>         -- Stored objects (PACKAGEs, views)
>         --V$DB_OBJECT_CACHE
>         --This view displays database objects that are cached in the
> library cache. Objects include
>         --tables, indexes, clusters, synonym definitions, PL/SQL
> procedures and packages, and triggers.
>
> --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch346.htm#1113348
>     SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
> v$db_object_cache;
> --
> --
>         -- User Cursor Usage -- run this during peak usage.
>         -- assumes 250 bytes per open cursor, FOR each concurrent user.
>         -- V$SQLAREA lists statistics on shared SQL area and contains one
> row per SQL string.
>         -- It provides statistics on SQL statements that are in memory,
> parsed, and ready for execution.
>     SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
>
>     -- For a test system -- get usage FOR one user, multiply by # users
>     -- SELECT (250 * value) bytes_per_user
>     -- FROM v$sesstat s, v$statname n
>     -- WHERE s.statistic# = n.statistic#
>     -- AND n.name = 'opened cursors current'
>     -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
>
>     -- MTS memory needed to hold session inFORmation FOR shared server
> users
>     -- This query computes a total FOR all currently logged on users (run
>     --  during peak period). Alternatively calculate FOR a single user and
>     --  multiply by # users.
> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
>        WHERE s.statistic#=n.statistic#
>        AND n.name='session uga memory max';
>
>     -- Free (unused) memory IN the SGA: gives an indication of how much
> memory
>     -- is being wasted OUT of the total allocated.
> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
>         WHERE name = 'free memory' AND pool='shared pool';
>     -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
>     --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
>
>     -- For MTS mts contribution needs to be included (comment OUT previous
> line)
>     used_pool_size :=
> ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));
>
> SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
> name='shared_pool_size';
>
>    -- Display results
> DBMS_OUTPUT.PUT_LINE ('Object mem :
> '||TO_CHAR(ROUND(object_me

Re: Shared Pool Utilization

Tanel
 You were on target

SQL> show parameter shared_serv

NAME TYPEVALUE
 ---
--
max_shared_servers   integer 20
shared_server_sessions   integer 0
shared_servers   integer 0
SQL> show parameter dispatch

NAME TYPEVALUE
 ---
--
dispatchers  string
max_dispatchers  integer 5
mts_dispatchers  string
mts_max_dispatchers  integer 5
SQL>

I corrected the script for non-MTS/DTS and got the result.
SQL> @swt02a
Object mem :   67.73 Mb
Cursors:   3.02 Mb
MTS session/UGA memory max:   433.93 Mb
Free memory:   105.98 Mb (105.98MB)
Shared pool utilization (total):  96440007 bytes (91.97MB)
Shared pool allocation (actual):  201326592bytes (192MB)
Percentage Utilized:  48%

PL/SQL procedure successfully completed.

Thanks


> Hi!
>
> I wonder whether you are running in dedicated server mode? That way UGA
> isn't allocated from SGA and the calculation used_pool/shared_pool_size is
> gives wrong results.
>
> Tanel.
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 27, 2003 10:44 PM
>
>
>> I have two databases, one in which the shared_pool utilization is not
>> exceeded (development) and the other one in which it appears that the
>> shared_pool utilization is exceeded.
>> The queries i am using are
>> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
>> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
>>  WHERE NAME = 'free memory'
>>AND POOL = 'shared pool'
>> /
>>
>> 2. Metalink note
>> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
>> bytes--> Mb and nvl clauses)
>>
>> set serveroutput on size 100;
>> DECLARE
>> object_mem NUMBER;
>> shared_sql NUMBER;
>> cursor_mem NUMBER;
>> mts_memNUMBER;
>> used_pool_size NUMBER;
>> free_mem   NUMBER;
>> pool_size  VARCHAR2(512); -- same AS V$PARAMETER.VALUE
>> BEGIN
>> -- Stored objects (PACKAGEs, views)
>> --V$DB_OBJECT_CACHE
>> --This view displays database objects that are cached in the
>> library cache. Objects include
>> --tables, indexes, clusters, synonym definitions, PL/SQL
>> procedures and packages, and triggers.
>> --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96
> 536/ch346.htm#1113348
>> SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
> v$db_object_cache;
>> --
>> --
>> -- User Cursor Usage -- run this during peak usage.
>> -- assumes 250 bytes per open cursor, FOR each concurrent user.
>> -- V$SQLAREA lists statistics on shared SQL area and contains
>> one
>> row per SQL string.
>> -- It provides statistics on SQL statements that are in memory,
>> parsed, and ready for execution.
>> SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
>>
>> -- For a test system -- get usage FOR one user, multiply by # users
>> -- SELECT (250 * value) bytes_per_user
>> -- FROM v$sesstat s, v$statname n
>> -- WHERE s.statistic# = n.statistic#
>> -- AND n.name = 'opened cursors current'
>> -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
>>
>> -- MTS memory needed to hold session inFORmation FOR shared server
> users
>> -- This query computes a total FOR all currently logged on users
>> (run
>> --  during peak period). Alternatively calculate FOR a single user
>> and
>> --  multiply by # users.
>> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
>>WHERE s.statistic#=n.statistic#
>>AND n.name='session uga memory max';
>>
>> -- Free (unused) memory IN the SGA: gives an indication of how much
>> memory
>> -- is being wasted OUT of the total allocated.
>> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
>> WHERE name = 'free memory' AND pool='shared pool';
>> -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
>> --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
>>
>> -- For MTS mts contribution needs to be included (comment OUT
>> previous
>> line)
>> used_pool_size :=
>> ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));
>>
>> SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
>> name='shared_pool_size';
>>
>>-- Display results
>> DBMS_OUTPUT.PUT_LINE ('Object mem :
>> '||TO_CHAR(ROUND(object_mem/(1024*1024),2)) || ' Mb');
>> DBMS_OUTPUT.PUT_LINE ('Cursors:
>> '||TO_CHAR(ROUND(cursor_mem/(1024*1024),2)) || ' Mb');
>> DBMS_OUTPUT.PUT_LINE ('MTS session:
>> '||TO_CHAR(ROUND(mts_mem/(1024*1024),2)) || ' Mb');
>> DBMS_OUTPUT.PUT_LINE ('Free me

RE: International Language Support Experiences?

2003-08-27 Thread Richard Ji

Tanel,

You are correct except it is supported with 8i, make sure compatible parameter is set 
to 8.1.x.

-Original Message-
Sent: Wednesday, August 27, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L


IIRC, you can't store LOBs in UTF8 since it's a variable width charset?

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 11:59 PM


> For clients that do not support UTF8, you can set NLS_LANG on the client
> server to the appropriate single byte character set.  The Oracle client
> library will do the conversion to/from UTF8 when you store/retrieve data
> to/from the Oracle server.
>
> In fact, using UTF8 on the Oracle server does not require _any_ of your
> client apps to use UTF8 at all.  Suppose you have an Oracle server at
> your corporate headquarters serving the needs of multiple client apps
> around the world.  The app servers in Asia, Europe, Africa, S. America
> etc. can each set NLS_LANG to their own _single byte_ character set and
> still, because the Oracle server at corporate uses UTF8 which is MBCS,
> the app servers can all share the same Oracle server.
>
> HTH,
> Dave
>
>
>
>
>
> [EMAIL PROTECTED] wrote:
> > David,
> >
> > I can share this from an Oracle Apps perspective - we upgraded to UTF8
> > (a multi byte char set) from WE8ISO5599-1 (single byte Western Eur
> > charset). Some of the biggest problems that we faced are:
> >
> > 1. Cut-and-paste produces incorrect characters which were acceptable in
> > WE8 but failed conversion. I.e. UTF8 is stricter in what it can display
> > as compared to WE8. This was pronounced in the umlaut and other Eur
> > specific characters.
> > 2. Quite a number of third-party applications do not support UTF8 - when
> > asked about Unicode support, many vendors didn't even know what it would
> > mean to support a MBCS such as UTF-8. This may also be the case with
> > your own applications.
> > 3. Middle-ware layers such as ODBC/JDBC don't work very well with UTF8
> > in the sense that the rules have become stricter and so programs that
> > used to work previously will now fail mysteriously with vague messages
> > (or worse still silently!).
> > 4. A column which supports text elements that may now handle MBCs will
> > require more storage width than previously designed for. Thus you may
> > have to look at schema changes to increase VARCHAR2/CHAR columns..
> > 5. Oracle products themselves may need some patches - you mention iAS -
> > and have functional restrictions.
> > 6. The
> >
> > You won't hit 1 because you are moving from US7ASCII (7 bit) but watch
> > out for the rest! ML Note 158577.1 is a good starting point. I would
> > read this one (and the related links) before the 450 pages - you seem to
> > like reading :)
> >
> >
> > John Kanagaraj
> > DB Soft Inc
> > Phone: 408-970-7002 (W)
> >
> > Disappointment is inevitable, but Discouragement is optional!
> >
> > ** The opinions and facts contained in this message are entirely mine
> > and do not reflect those of my employer or customers **
> >
> >
> >
> > -Original Message-
> > From: David Wagoner [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 27, 2003 11:35 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: International Language Support Experiences?
> >
> > We have a new requirement to support multiple languages in at least
> > one of our databases.  I'm reading the Oracle 9iR2 Globalization
> > Support Guide (450 pages), but wonder if any of you can share
> > real-life experiences regarding:
> >
> > 1.  the conversion of existing DBs to broader character sets
> > 2.  using Unicode
> > 3.  implementing this with 9iAS
> >
> > Our databases currently use US7ASCII with the American character
> > set, but we will likely need to support European, Southeast Asian,
> > and South American languages.
> >
> >
> > Thanks.
> >
> >
> > Best regards,
> >
> > David B. Wagoner
> > Database Administrator
> > Arsenal Digital Solutions
> >
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dave Hau
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California

RE: VPN access to 9ias instance behind firewall

2003-08-27 Thread Paula_Stankus

Title: RE: VPN access to 9ias instance behind firewall



Dear 
Tanel,
 
Thanks 
for the reply.  I have some questions:

  -Original Message-From: Tanel Poder 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 
  5:49 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: VPN access to 9ias instance behind firewall
  Hi!
   
  How is the "VPN" set up? Is it just a ssh 
  tunnel or is it a real VPN with routing etc..?[Stankus, Paula 
  G] 
  SSH is allowed through the hosts.allow file in 
  Unix 
   
  1) check whether the url your users type in 
  is directed through proxy. And proxy server isn't aware of this VPN. In this 
  case disable the proxy or make it aware of vpn[Stankus, Paula G] How would 
  I know this.   
  2) if no proxy is used, then ask your users just 
  to telnet to the url (for http://site.com they have to 
  telnet site.com 80, and see if they get an error. If not (the telnet seems 
  hanging, type GET / in it and see whether any html is returned). That way you 
  should at least isolate whether the problem is in browser or not)[Stankus, Paula G] Can I 
  have them do a ssh http.site.com  instead?  Telnet is not 
  allowed at all. 
  3) if you are dealing with local ssh 
  tunnels, then you probably have to change your 
  c:\winnt\system32\drivers\etc\hosts accordingly (if using windows), to set 
  that the site.com where you want to connect, actually points to your own 
  machine (127.0.0.1) and ssh directs your connections to the right point from 
  there. I've used this mechanism for several customers support.[Stankus, Paula G] If client 
  is coming from Texas and we are in Florida whose 
  c:\winnt\system32\drivers\etc\hosts file needs to be setup (9ias is 
  running under Unix) - we have localhost setup in our Unix host 
  file.  Can you explain #3 in more detail or point me to a 
  document?
   
  Thanks,
  Paula 
   
  Tanel.
   
  
- Original Message - 
From: 
[EMAIL PROTECTED] 

To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, August 27, 2003 11:29 
PM
Subject: RE: VPN access to 9ias 
instance behind firewall

Guys, 
When user trys to run our application through a VPN behind 
the firewall in a url they get an error.  They can use ssh to get to 
host where I installed the application server but not run the application 
through their browser.  Anyone deal with this issue before?
Thanks, Paula

Re: International Language Support Experiences?


Then you would use NLOB's, IIRC.








"Tanel Poder" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 02:54 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: International Language Support Experiences?


IIRC, you can't store LOBs in UTF8 since it's a variable width charset?

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 11:59 PM


> For clients that do not support UTF8, you can set NLS_LANG on the client
> server to the appropriate single byte character set.  The Oracle client
> library will do the conversion to/from UTF8 when you store/retrieve data
> to/from the Oracle server.
>
> In fact, using UTF8 on the Oracle server does not require _any_ of your
> client apps to use UTF8 at all.  Suppose you have an Oracle server at
> your corporate headquarters serving the needs of multiple client apps
> around the world.  The app servers in Asia, Europe, Africa, S. America
> etc. can each set NLS_LANG to their own _single byte_ character set and
> still, because the Oracle server at corporate uses UTF8 which is MBCS,
> the app servers can all share the same Oracle server.
>
> HTH,
> Dave
>
>
>
>
>
> [EMAIL PROTECTED] wrote:
> > David,
> >
> > I can share this from an Oracle Apps perspective - we upgraded to UTF8
> > (a multi byte char set) from WE8ISO5599-1 (single byte Western Eur
> > charset). Some of the biggest problems that we faced are:
> >
> > 1. Cut-and-paste produces incorrect characters which were acceptable in
> > WE8 but failed conversion. I.e. UTF8 is stricter in what it can display
> > as compared to WE8. This was pronounced in the umlaut and other Eur
> > specific characters.
> > 2. Quite a number of third-party applications do not support UTF8 - when
> > asked about Unicode support, many vendors didn't even know what it would
> > mean to support a MBCS such as UTF-8. This may also be the case with
> > your own applications.
> > 3. Middle-ware layers such as ODBC/JDBC don't work very well with UTF8
> > in the sense that the rules have become stricter and so programs that
> > used to work previously will now fail mysteriously with vague messages
> > (or worse still silently!).
> > 4. A column which supports text elements that may now handle MBCs will
> > require more storage width than previously designed for. Thus you may
> > have to look at schema changes to increase VARCHAR2/CHAR columns..
> > 5. Oracle products themselves may need some patches - you mention iAS -
> > and have functional restrictions.
> > 6. The
> >
> > You won't hit 1 because you are moving from US7ASCII (7 bit) but watch
> > out for the rest! ML Note 158577.1 is a good starting point. I would
> > read this one (and the related links) before the 450 pages - you seem to
> > like reading :)
> >
> >
> > John Kanagaraj
> > DB Soft Inc
> > Phone: 408-970-7002 (W)
> >
> > Disappointment is inevitable, but Discouragement is optional!
> >
> > ** The opinions and facts contained in this message are entirely mine
> > and do not reflect those of my employer or customers **
> >
> >
> >
> >     -Original Message-
> >     From: David Wagoner [mailto:[EMAIL PROTECTED]
> >     Sent: Wednesday, August 27, 2003 11:35 AM
> >     To: Multiple recipients of list ORACLE-L
> >     Subject: International Language Support Experiences?
> >
> >     We have a new requirement to support multiple languages in at least
> >     one of our databases.  I'm reading the Oracle 9iR2 Globalization
> >     Support Guide (450 pages), but wonder if any of you can share
> >     real-life experiences regarding:
> >
> >     1.  the conversion of existing DBs to broader character sets
> >     2.  using Unicode
> >     3.  implementing this with 9iAS
> >
> >     Our databases currently use US7ASCII with the American character
> >     set, but we will likely need to support European, Southeast Asian,
> >     and South American languages.
> >
> >
> >     Thanks.
> >
> >
> >     Best regards,
> >
> >     David B. Wagoner
> >     Database Administrator
> >     Arsenal Digital Solutions
> >
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dave Hau
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [

Re: OT: Hey Jared!!

Women are also particularily good at remembering small nasty things from
past which you've already forgotten long time ago. Especially during
fights...
:)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 12:59 AM


> Not being sexist in any way, but it's my experience that Women are much
> better "generalists" than men, but that men are much better specialists.
> Thats why I think women do better in school early on, but once we men get
> into the University level and pick our speciality, we kick butt.
>
> My soon to be ex-wife was frequently much better remembering overall
things
> than I was
>
> RF
>
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 8/27/2003 6:44 AM
>
> c'mon... any virus named "SoBig" has to have been written by a man :)
>
> (yes, sexist, I know)
>
>
> --- Tanel Poder <[EMAIL PROTECTED]> wrote:
> > I've seen only one female in my life who would be capable of writing
> > such
> > virus. But that is not the issue (no offence, really). Women just
> > don't
> > waste their time on stuff like this.
> >
> > Tanel.
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 27, 2003 4:54 AM
> >
> >
> > > "Guy"?  You've eliminated 50% of all possible suspects...
> > >
> > >
> > >
> > > on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote:
> > >
> > > > I doubt they will ever find the real guy behind this.
> > > >
> > > > Tanel.
> > > >
> > > > - Original Message -
> > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, August 26, 2003 10:19 PM
> > > >
> > > >
> > > >> For all you virus/worm lovers out there, justice do come:
> > > >>
> > > >> FBI Subpoenas Arizona ISP In Sobig Probe
> > > >> Easynews says it's cooperating with the bureau to find the
> > person
> > > >> who uploaded the virus to a Usenet group it hosts.
> > > >> informationweek.com/story/showArticle.jhtml?articleID=13800091
> > > >>
> > > >>
> > > >>
> > > >> Dick Goulet
> > > >> Senior Oracle DBA
> > > >> Oracle Certified 8i DBA
> > > >> -- 
> > > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > >> -- 
> > > >> Author: Goulet, Dick
> > > >>   INET: [EMAIL PROTECTED]
> > > >>
> > > >> Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > >> San Diego, California-- Mailing list and web hosting
> > services
> > > >>
> > -
> > > >> To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > > >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> > in
> > > >> the message BODY, include a line containing: UNSUB ORACLE-L
> > > >> (or the name of mailing list you want to be removed from).  You
> > may
> > > >> also send the HELP command for other information (like
> > subscribing).
> > > >>
> > >
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Tim Gorman
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> > services
> > >
> > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like
> > subscribing).
> > >
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Tanel Poder
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this

RE: Nature of Oracle-l has changed

2003-08-27 Thread Pete Sharman

But I thought you were already married?  :)


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Freeman Robert - IL
Sent: Thursday, August 28, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L


Rachel

I thought everyone who worked in a bank was at least a Vice
President...?

:-))

Robert
(Vice President of myself, looking for a President).

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/27/2003 6:44 AM

HR also doesn't have a "technical track" in many companies and the
highest salaries usually go to those on the "management track"... so you
either get promoted out of technical work and into management to get the
salary you deserve (which kind of defeats the purpose) or the technical
person sits at a lower pay level.

When I left Citibank, I was a Vice President... not because I was an
executive or management... but so that they could pay me what I was
worth.


--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Part of the problem lies with the old human vices - jealousy comes 
> into mind, first. The problem is mostly not with companies but 
> immediate supervisers, who often struggle with the prospect that the
> subordinate will
> get more money - and they resent it to very core. They would rather
> hire
> someone off the street with more money than give the old failthful
> the due
> share.
> 
> The other problem is the HR departments magic wand yardstick of salary

> and compensation which dictates, often incorrectly, how much a 
> particular job's
> adequate compensation is. Never mind the fact that a regular HR joe
> doesn't
> understand DBAs from Developers - so the highly paid "specialist"
> boils it
> dall own to a simple yardstick - number of years of experience!
> 
> Several years ago I rose to the postition of the lead DBA at a company

> when I was 24, but my salary was less than the lowest of the 15 DBAs 
> in the team.
> Reason - my years of experience was simply didn't show high enough in
> the
> yardstick to warrant a higher salary. It was even more painful when I
> was
> the fail-over contact for all members of the team. When the pager
> goes off
> in the middle of the night, out I go to fix the problem in the HR
> database
> and just making sure all is well, especially in the salary table,
> where the
> "indisposed" team member's pay glares, almost mockingly! I left; the
> new
> person was almost myage, but the negotiated salary was higher. The HR
> department's magic yardstick was broken by the departmental manager.
> Similarly, the in the new place I went, there was no problem in
> getting a
> much fatter paycheck. Morale - when you stick around, you become "hoi
> poloi"; the knight in the shining armor is the one who comes from
> outside!
> 
> Regards,
> 
> Arup
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 26, 2003 9:49 PM
> 
> 
> > Partially true.
> >
> > I've seen the IT cutbacks at a company where people almost never 
> > leave.  Many IT folk have been there 10+ year, a surprising number 
> > of them 20+ years.
> >
> > The flip side to the salary story is something of a paradox.
> >
> > As a person became more experienced, learned new technologies, and 
> > as the company embraced more technologies, the employees at times 
> > may not be paid commensurate with their abilities.
> >
> > I experienced that once. The only way to increase my earning power 
> > was to leave.  My salary jumped 50% immediately.  This has no doubt 
> > happened to a number of folks.
> >
> > The silly side of this is that the former employer then had to hire 
> > a replacement at the going rate, or get a contractor in.
> >
> > Bottom line, they lose an experienced employee, and end up paying as

> > much or more as if they had tried to retain said employee.
> >
> > Jared
> >
> >
> > Jared
> >
> >
> > On Tue, 2003-08-26 at 18:04,
> [EMAIL PROTECTED]
> > wrote:
> > > I think a lot of IT people "abused" the situation during the boom
> days.
> > > Company loyalty meant nothing ... we'll go wherever the biggest
> paychecks
> > > are.  Don't stay anywhere too long. that's for losers.  Change
> jobs if
> we
> > > felt the least bit abused and unappreciated.  That'll teach them
> to
> screw
> > > with me!  In general a holier-than-thou attitude.  The times
> allowed us
> to
> > > do that.
> > >
> > > But it also means a lot of non-IT people developed an opinion of
> IT folk
> as
> > > not being team players, only out for themselves, not committed to
> the
> > > company, etc.
> > >
> > > So when the chance comes to cut back, where are you going to
> look?  :-)
> > >
> > > Dave
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051

OCI wrapper library




I'm sending this post here, because got no response 
in c.d.o.s.
 
Does anyone have an example how to write an OCI wrapper library, that 
Icould replace the Oracle OCI library with my own (renaming original 
one).Then whatever OCI call is made, it ends up to my library where from I 
can passit on, or modify it before that?
 
Also, any information on doing the same thing using TCP sockets 
(mediatingbetween client & server sql*net connection), is welcome as 
well.Any pointers are welcome, or otherwise... I'll have to figure it 
out myself...
Tanel.

Re: Shared Pool Utilization

I ran the query given, but that doesnot answer my question.
I am asking what is wrong with the script(s)?

> I don't trust scripts I didn't write myself, and not even some of those.
> ;)
>
> What does this reveal?
>
> select a.value + ( b.value * c.value )
> from
> ( select sum(value) value from v$parameter
>   where name like '%pool%'
> ) a
>  , v$parameter b
>  , v$parameter c
> where b.name = 'db_block_buffers'
> and c.name = 'db_block_size'
>
> As long as you're not using some of the newer 9i memory allocation
> parameters, this
> should be pretty close to the amount of memory you've allocated in
> init.ora.
>
> Now see how much is in the SGA:
>
> select sum(value) from v$sga;
>
> Should be fairly close to the first number.
>
> Jared
>
>
>
>
>
>
> "Corniche Park" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  08/27/2003 12:44 PM
>  Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:Shared Pool Utilization
>
>
> I have two databases, one in which the shared_pool utilization is not
> exceeded (development) and the other one in which it appears that the
> shared_pool utilization is exceeded.
> The queries i am using are
> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
>  WHERE NAME = 'free memory'
>AND POOL = 'shared pool'
> /
>
> 2. Metalink note
> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
> bytes--> Mb and nvl clauses)
>
> set serveroutput on size 100;
> DECLARE
> object_mem NUMBER;
> shared_sql NUMBER;
> cursor_mem NUMBER;
> mts_memNUMBER;
> used_pool_size NUMBER;
> free_mem   NUMBER;
> pool_size  VARCHAR2(512); -- same AS V$PARAMETER.VALUE
> BEGIN
> -- Stored objects (PACKAGEs, views)
> --V$DB_OBJECT_CACHE
> --This view displays database objects that are cached in the
> library cache. Objects include
> --tables, indexes, clusters, synonym definitions, PL/SQL
> procedures and packages, and triggers.
>
> --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch346.htm#1113348
> SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
> v$db_object_cache;
> --
> --
> -- User Cursor Usage -- run this during peak usage.
> -- assumes 250 bytes per open cursor, FOR each concurrent user.
> -- V$SQLAREA lists statistics on shared SQL area and contains one
> row per SQL string.
> -- It provides statistics on SQL statements that are in memory,
> parsed, and ready for execution.
> SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
>
> -- For a test system -- get usage FOR one user, multiply by # users
> -- SELECT (250 * value) bytes_per_user
> -- FROM v$sesstat s, v$statname n
> -- WHERE s.statistic# = n.statistic#
> -- AND n.name = 'opened cursors current'
> -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
>
> -- MTS memory needed to hold session inFORmation FOR shared server
> users
> -- This query computes a total FOR all currently logged on users (run
> --  during peak period). Alternatively calculate FOR a single user and
> --  multiply by # users.
> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
>WHERE s.statistic#=n.statistic#
>AND n.name='session uga memory max';
>
> -- Free (unused) memory IN the SGA: gives an indication of how much
> memory
> -- is being wasted OUT of the total allocated.
> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
> WHERE name = 'free memory' AND pool='shared pool';
> -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
> --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
>
> -- For MTS mts contribution needs to be included (comment OUT previous
> line)
> used_pool_size :=
> ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));
>
> SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
> name='shared_pool_size';
>
>-- Display results
> DBMS_OUTPUT.PUT_LINE ('Object mem :
> '||TO_CHAR(ROUND(object_mem/(1024*1024),2)) || ' Mb');
> DBMS_OUTPUT.PUT_LINE ('Cursors:
> '||TO_CHAR(ROUND(cursor_mem/(1024*1024),2)) || ' Mb');
> DBMS_OUTPUT.PUT_LINE ('MTS session:
> '||TO_CHAR(ROUND(mts_mem/(1024*1024),2)) || ' Mb');
> DBMS_OUTPUT.PUT_LINE ('Free memory:
> '||TO_CHAR(ROUND(free_mem/(1024*1024),2)) || ' Mb ' ||
> '('|| TO_CHAR(ROUND(free_mem/1024/1024,2)) || 'MB)');
> DBMS_OUTPUT.PUT_LINE ('Shared pool utilization (total):  '||
> TO_CHAR(used_pool_size) || ' bytes ' || '(' ||
> TO_CHAR(ROUND(used_pool_size/1024/1024,2)) || 'MB)');
> DBMS_OUTPUT.PUT_LINE ('Shared pool allocation (actual):  '|| pool_size
> ||'bytes ' || '(' || TO_CHAR(ROUND(pool_size/1024/1024,2)) || 'MB)');
> DBMS_OUTPUT.PUT_LINE ('Percentage Utilized:  '||TO_CHAR
> (ROUND(used_pool_size/p

RE: Veritas and disks

2003-08-27 Thread Aponte, Tony

Title: RE: Veritas and disks






This note may describe the behavior you are observing. 


www.sun.com/blueprints/0400/ram-vxfs.pdf 


HTH

Tony Aponte


-Original Message-

From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]

Sent: Monday, August 25, 2003 3:34 PM

To: Multiple recipients of list ORACLE-L

Subject: Veritas and disks



Anyone have any experience with Veritas CFS (running RAC) and disk IO? We

are seeing some interesting things here with regards to available memory and

disk throughput. We get great throughput when there is sufficient memory.

But, as we load up DD processes, we find available memory decreasing

rapidly, like the copies are being cached to free memory by veritas first.

Then, after the copies appear to be done from the OS, we see consistant disk

activity afterwards.


I suspect that veritas is caching these cp's into memory and then writing to

disk. This works great until I run out of memory, at which time the cp

starts to perform terribly. Is this how Veritas works and is there any way

to configure this behavor? 


RF


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 

Author: Freeman Robert - IL

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

San Diego, California    -- Mailing list and web hosting services

-

To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Re: International Language Support Experiences?

IIRC, you can't store LOBs in UTF8 since it's a variable width charset?

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 11:59 PM


> For clients that do not support UTF8, you can set NLS_LANG on the client
> server to the appropriate single byte character set.  The Oracle client
> library will do the conversion to/from UTF8 when you store/retrieve data
> to/from the Oracle server.
>
> In fact, using UTF8 on the Oracle server does not require _any_ of your
> client apps to use UTF8 at all.  Suppose you have an Oracle server at
> your corporate headquarters serving the needs of multiple client apps
> around the world.  The app servers in Asia, Europe, Africa, S. America
> etc. can each set NLS_LANG to their own _single byte_ character set and
> still, because the Oracle server at corporate uses UTF8 which is MBCS,
> the app servers can all share the same Oracle server.
>
> HTH,
> Dave
>
>
>
>
>
> [EMAIL PROTECTED] wrote:
> > David,
> >
> > I can share this from an Oracle Apps perspective - we upgraded to UTF8
> > (a multi byte char set) from WE8ISO5599-1 (single byte Western Eur
> > charset). Some of the biggest problems that we faced are:
> >
> > 1. Cut-and-paste produces incorrect characters which were acceptable in
> > WE8 but failed conversion. I.e. UTF8 is stricter in what it can display
> > as compared to WE8. This was pronounced in the umlaut and other Eur
> > specific characters.
> > 2. Quite a number of third-party applications do not support UTF8 - when
> > asked about Unicode support, many vendors didn't even know what it would
> > mean to support a MBCS such as UTF-8. This may also be the case with
> > your own applications.
> > 3. Middle-ware layers such as ODBC/JDBC don't work very well with UTF8
> > in the sense that the rules have become stricter and so programs that
> > used to work previously will now fail mysteriously with vague messages
> > (or worse still silently!).
> > 4. A column which supports text elements that may now handle MBCs will
> > require more storage width than previously designed for. Thus you may
> > have to look at schema changes to increase VARCHAR2/CHAR columns..
> > 5. Oracle products themselves may need some patches - you mention iAS -
> > and have functional restrictions.
> > 6. The
> >
> > You won't hit 1 because you are moving from US7ASCII (7 bit) but watch
> > out for the rest! ML Note 158577.1 is a good starting point. I would
> > read this one (and the related links) before the 450 pages - you seem to
> > like reading :)
> >
> >
> > John Kanagaraj
> > DB Soft Inc
> > Phone: 408-970-7002 (W)
> >
> > Disappointment is inevitable, but Discouragement is optional!
> >
> > ** The opinions and facts contained in this message are entirely mine
> > and do not reflect those of my employer or customers **
> >
> >
> >
> > -Original Message-
> > From: David Wagoner [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 27, 2003 11:35 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: International Language Support Experiences?
> >
> > We have a new requirement to support multiple languages in at least
> > one of our databases.  I'm reading the Oracle 9iR2 Globalization
> > Support Guide (450 pages), but wonder if any of you can share
> > real-life experiences regarding:
> >
> > 1.  the conversion of existing DBs to broader character sets
> > 2.  using Unicode
> > 3.  implementing this with 9iAS
> >
> > Our databases currently use US7ASCII with the American character
> > set, but we will likely need to support European, Southeast Asian,
> > and South American languages.
> >
> >
> > Thanks.
> >
> >
> > Best regards,
> >
> > David B. Wagoner
> > Database Administrator
> > Arsenal Digital Solutions
> >
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dave Hau
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelli

RE: OT: Hey Jared!!

2003-08-27 Thread Freeman Robert - IL

Not being sexist in any way, but it's my experience that Women are much
better "generalists" than men, but that men are much better specialists.
Thats why I think women do better in school early on, but once we men get
into the University level and pick our speciality, we kick butt.

My soon to be ex-wife was frequently much better remembering overall things
than I was 

RF


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/27/2003 6:44 AM

c'mon... any virus named "SoBig" has to have been written by a man :)

(yes, sexist, I know)


--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> I've seen only one female in my life who would be capable of writing
> such
> virus. But that is not the issue (no offence, really). Women just
> don't
> waste their time on stuff like this.
> 
> Tanel.
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 27, 2003 4:54 AM
> 
> 
> > "Guy"?  You've eliminated 50% of all possible suspects...
> >
> >
> >
> > on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote:
> >
> > > I doubt they will ever find the real guy behind this.
> > >
> > > Tanel.
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, August 26, 2003 10:19 PM
> > >
> > >
> > >> For all you virus/worm lovers out there, justice do come:
> > >>
> > >> FBI Subpoenas Arizona ISP In Sobig Probe
> > >> Easynews says it's cooperating with the bureau to find the
> person
> > >> who uploaded the virus to a Usenet group it hosts.
> > >> informationweek.com/story/showArticle.jhtml?articleID=13800091
> > >>
> > >>
> > >>
> > >> Dick Goulet
> > >> Senior Oracle DBA
> > >> Oracle Certified 8i DBA
> > >> -- 
> > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > >> -- 
> > >> Author: Goulet, Dick
> > >>   INET: [EMAIL PROTECTED]
> > >>
> > >> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > >> San Diego, California-- Mailing list and web hosting
> services
> > >>
> -
> > >> To REMOVE yourself from this mailing list, send an E-Mail
> message
> > >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > >> the message BODY, include a line containing: UNSUB ORACLE-L
> > >> (or the name of mailing list you want to be removed from).  You
> may
> > >> also send the HELP command for other information (like
> subscribing).
> > >>
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Tim Gorman
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin

Re: perl/shell script for alert log

Hi!

I would add a check for "Checkpoint not complete" in alert just in case as
well.

Tanel.

> One enhancement I suggest to every script is to configure the a
SERVERERROR
> trigger to throw certain errors out to the alert log.  ORA-1555 is one
that
> will show up at the session level but not at the database level.  Out of
> TEMP space is another that is frequent at the session level but not the
> database level.  This way you know who is causing some important errors.
> Overtime I find more and more session errors that are really critical
> database errors.  Try DDL on a table with an unusable index.  Pretty big
> deal on most production databases but this is a session error and would
not
> typically show up in the alert log.  The risk of course is some huge loop
> throwing 1000's of lines into the alert log.  I would suggest a governor
of
> some sort in your servererror trigger.
>
> - Ethan
>
> -Original Message-
> Sent: Wednesday, August 27, 2003 2:49 PM
> To: Multiple recipients of list ORACLE-L
>
>
> When I grep something from the alert log,
> it never tell me the date and time of the error.
> Is there a setting for appending a timestamp on each error?
>
> -Original Message-
> Sent: Wednesday, August 27, 2003 1:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> HTH
>
> #!/bin/sh
> # This Script search for Oracle error messages in last
> 100 lines in the alert log file ,
> # keep log to a file.
>
> # You should pass name of ORACLE_SID as a parameter.
>
> #!/usr/bin/sh
> #
> # Comments: Script checks last 100 lines of
> # the alert log for specific
> # Oracle errors,  e-mails depending on the error.
>
> # Parameter: ORACLE_SID
> # ---
> #
> #
>
> DIR=/u01/app/oracle/admin
> ORACLE_SID=$1
> export ORACLE_SID
> ORACLE_HOME=/u01/app/oracle/product/8.1.7
> export ORACLE_HOME
>
> ALERT_DEST=/u01/app/oracle/admin/${ORACLE_SID}/bdump
> LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
> export LD_LIBRARY_PATH
> PATH=$PATH:$ORACLE_HOME/bin
> export PATH
>
> COLLECTOR=`tail -100
> $ALERT_DEST/alert_${ORACLE_SID}.log |grep "ORA-"`
> if [ "$COLLECTOR" <> "" ]
> then
> echo ""
> echo " Errors found in:   >
> $ALERT_DEST/alert_${ORACLE_SID}.log"
> echo ""
> echo $COLLECTOR
> echo ""
> fi;
>
>
> --- AK <[EMAIL PROTECTED]> wrote:
> >  I am sure you guys might have some nice perl/shell
> > script to analyze alert log for errors or potential
> > problem . Can you share it with me /list .
> >
> > Ohh thanks in advance guys .
> >
> > -ak
> >
>
>
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jose Luis Delgado
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> For technical support please email [EMAIL PROTECTED] or you can
> call (972)721-8257.
> This email has been scanned for all viruses by the MessageLabs Email
> Security System.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Roger Xu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.ora

RE: Nature of Oracle-l has changed

2003-08-27 Thread Freeman Robert - IL

Rachel

I thought everyone who worked in a bank was at least a Vice President...?

:-))

Robert
(Vice President of myself, looking for a President).

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/27/2003 6:44 AM

HR also doesn't have a "technical track" in many companies and the
highest salaries usually go to those on the "management track"... so
you either get promoted out of technical work and into management to
get the salary you deserve (which kind of defeats the purpose) or the
technical person sits at a lower pay level.

When I left Citibank, I was a Vice President... not because I was an
executive or management... but so that they could pay me what I was
worth.


--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Part of the problem lies with the old human vices - jealousy comes
> into
> mind, first. The problem is mostly not with companies but immediate
> supervisers, who often struggle with the prospect that the
> subordinate will
> get more money - and they resent it to very core. They would rather
> hire
> someone off the street with more money than give the old failthful
> the due
> share.
> 
> The other problem is the HR departments magic wand yardstick of
> salary and
> compensation which dictates, often incorrectly, how much a particular
> job's
> adequate compensation is. Never mind the fact that a regular HR joe
> doesn't
> understand DBAs from Developers - so the highly paid "specialist"
> boils it
> dall own to a simple yardstick - number of years of experience!
> 
> Several years ago I rose to the postition of the lead DBA at a
> company when
> I was 24, but my salary was less than the lowest of the 15 DBAs in
> the team.
> Reason - my years of experience was simply didn't show high enough in
> the
> yardstick to warrant a higher salary. It was even more painful when I
> was
> the fail-over contact for all members of the team. When the pager
> goes off
> in the middle of the night, out I go to fix the problem in the HR
> database
> and just making sure all is well, especially in the salary table,
> where the
> "indisposed" team member's pay glares, almost mockingly! I left; the
> new
> person was almost myage, but the negotiated salary was higher. The HR
> department's magic yardstick was broken by the departmental manager.
> Similarly, the in the new place I went, there was no problem in
> getting a
> much fatter paycheck. Morale - when you stick around, you become "hoi
> poloi"; the knight in the shining armor is the one who comes from
> outside!
> 
> Regards,
> 
> Arup
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 26, 2003 9:49 PM
> 
> 
> > Partially true.
> >
> > I've seen the IT cutbacks at a company where people almost
> > never leave.  Many IT folk have been there 10+ year, a
> > surprising number of them 20+ years.
> >
> > The flip side to the salary story is something of a paradox.
> >
> > As a person became more experienced, learned new technologies,
> > and as the company embraced more technologies, the employees
> > at times may not be paid commensurate with their abilities.
> >
> > I experienced that once. The only way to increase my earning
> > power was to leave.  My salary jumped 50% immediately.  This
> > has no doubt happened to a number of folks.
> >
> > The silly side of this is that the former employer then had
> > to hire a replacement at the going rate, or get a contractor in.
> >
> > Bottom line, they lose an experienced employee, and end up paying
> > as much or more as if they had tried to retain said employee.
> >
> > Jared
> >
> >
> > Jared
> >
> >
> > On Tue, 2003-08-26 at 18:04,
> [EMAIL PROTECTED]
> > wrote:
> > > I think a lot of IT people "abused" the situation during the boom
> days.
> > > Company loyalty meant nothing ... we'll go wherever the biggest
> paychecks
> > > are.  Don't stay anywhere too long. that's for losers.  Change
> jobs if
> we
> > > felt the least bit abused and unappreciated.  That'll teach them
> to
> screw
> > > with me!  In general a holier-than-thou attitude.  The times
> allowed us
> to
> > > do that.
> > >
> > > But it also means a lot of non-IT people developed an opinion of
> IT folk
> as
> > > not being team players, only out for themselves, not committed to
> the
> > > company, etc.
> > >
> > > So when the chance comes to cut back, where are you going to
> look?  :-)
> > >
> > > Dave
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> services
> > >
> -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include

Re: VPN access to 9ias instance behind firewall

Title: RE: VPN access to 9ias instance behind firewall



Hi!
 
How is the "VPN" set up? Is it just a ssh tunnel or 
is it a real VPN with routing etc..?
 
1) check whether the url your users type in is 
directed through proxy. And proxy server isn't aware of this VPN. In this case 
disable the proxy or make it aware of vpn
2) if no proxy is used, then ask your users just to 
telnet to the url (for http://site.com they have 
to telnet site.com 80, and see if they get an error. If not (the telnet seems 
hanging, type GET / in it and see whether any html is returned). That way you 
should at least isolate whether the problem is in browser or not)
3) if you are dealing with local ssh tunnels, then 
you probably have to change your c:\winnt\system32\drivers\etc\hosts accordingly 
(if using windows), to set that the site.com where you want to connect, actually 
points to your own machine (127.0.0.1) and ssh directs your connections to the 
right point from there. I've used this mechanism for several customers 
support.
 
Tanel.
 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, August 27, 2003 11:29 
  PM
  Subject: RE: VPN access to 9ias instance 
  behind firewall
  
  Guys, 
  When user trys to run our application through a VPN behind the 
  firewall in a url they get an error.  They can use ssh to get to host 
  where I installed the application server but not run the application through 
  their browser.  Anyone deal with this issue before?
  Thanks, Paula

RE: VPN access to 9ias instance behind firewall

Title: Message



Yes, 
there is a way of doing that through a SSH tunnel. I have the bookmark at home, 
I'll send it
to you 
as soon as I get there (~7 P.M. EST, it is 4:41 EST now). Jared also has it, so 
he may be 
so 
nice to send it to you.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 
  5:34 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: VPN access to 9ias instance behind firewall
  Any 
  suggestions?
  
-Original Message-From: Dong, Ping - Raleigh, NC 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 4:54 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
VPN access to 9ias instance behind firewall
 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 
  27, 2003 4:30 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: VPN access to 9ias instance behind 
  firewall
  Guys, 
  When user trys to run our application through a VPN behind 
  the firewall in a url they get an error.  They can use ssh to get to 
  host where I installed the application server but not run the application 
  through their browser.  Anyone deal with this issue 
before?
  Thanks, Paula 

 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

Re: Grid

> We've been talking of Grid computing here since either late 1999 or early
2000.  The computing for our main experiment was designed before the Grid
was contemplated.  Still we have implemented some of the middleware needed,
and build methods of authentication and authorization, and participated in
Grid experiments. We have also been pushing the ability to transfer large
amounts of data.  The latest effort: 2.3 GB per second between the local
internet hub and Geneva Switzerland over Internet 2.  This is vital to make
the Grid work.

Yep, you'll probably have huge amounts of data coming in when CERN gets
their large hadron collider online in 2007 ;)
Btw, AFAIK, they're using Oracle...

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: VPN access to 9ias instance behind firewall

2003-08-27 Thread Paula_Stankus

Title: RE: VPN access to 9ias instance behind firewall



Any 
suggestions?

  -Original Message-From: Dong, Ping - Raleigh, NC 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 4:54 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  VPN access to 9ias instance behind firewall
   
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 
2003 4:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: VPN access to 9ias instance behind 
firewall
Guys, 
When user trys to run our application through a VPN behind 
the firewall in a url they get an error.  They can use ssh to get to 
host where I installed the application server but not run the application 
through their browser.  Anyone deal with this issue before?
Thanks, Paula

Re: Shared Pool Utilization


I don't trust scripts I didn't write myself, and not even some of those.  ;)

What does this reveal?

select a.value + ( b.value * c.value )
from
( select sum(value) value from v$parameter
  where name like '%pool%'
) a
 , v$parameter b
 , v$parameter c
where b.name = 'db_block_buffers'
and c.name = 'db_block_size'

As long as you're not using some of the newer 9i memory allocation parameters, this
should be pretty close to the amount of memory you've allocated in init.ora.

Now see how much is in the SGA:

select sum(value) from v$sga;

Should be fairly close to the first number.

Jared








"Corniche Park" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 12:44 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Shared Pool Utilization


I have two databases, one in which the shared_pool utilization is not
exceeded (development) and the other one in which it appears that the
shared_pool utilization is exceeded.
The queries i am using are
1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
 WHERE NAME = 'free memory'
   AND POOL = 'shared pool'
/

2. Metalink note
SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
bytes--> Mb and nvl clauses)

set serveroutput on size 100;
DECLARE
        object_mem     NUMBER;
        shared_sql     NUMBER;
        cursor_mem     NUMBER;
        mts_mem        NUMBER;
        used_pool_size NUMBER;
        free_mem       NUMBER;
        pool_size      VARCHAR2(512); -- same AS V$PARAMETER.VALUE
BEGIN
        -- Stored objects (PACKAGEs, views)
        --V$DB_OBJECT_CACHE
        --This view displays database objects that are cached in the
library cache. Objects include
        --tables, indexes, clusters, synonym definitions, PL/SQL
procedures and packages, and triggers.
        --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch346.htm#1113348
    SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM v$db_object_cache;
--
--
        -- User Cursor Usage -- run this during peak usage.
        -- assumes 250 bytes per open cursor, FOR each concurrent user.
        -- V$SQLAREA lists statistics on shared SQL area and contains one
row per SQL string.
        -- It provides statistics on SQL statements that are in memory,
parsed, and ready for execution.
    SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;

    -- For a test system -- get usage FOR one user, multiply by # users
    -- SELECT (250 * value) bytes_per_user
    -- FROM v$sesstat s, v$statname n
    -- WHERE s.statistic# = n.statistic#
    -- AND n.name = 'opened cursors current'
    -- AND s.sid = 25;  -- WHERE 25 is the sid of the process

    -- MTS memory needed to hold session inFORmation FOR shared server users
    -- This query computes a total FOR all currently logged on users (run
    --  during peak period). Alternatively calculate FOR a single user and
    --  multiply by # users.
SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
       WHERE s.statistic#=n.statistic#
       AND n.name='session uga memory max';

    -- Free (unused) memory IN the SGA: gives an indication of how much
memory
    -- is being wasted OUT of the total allocated.
SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
        WHERE name = 'free memory' AND pool='shared pool';
    -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
    --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));

    -- For MTS mts contribution needs to be included (comment OUT previous
line)
    used_pool_size :=
ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));

SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
name='shared_pool_size';

   -- Display results
DBMS_OUTPUT.PUT_LINE ('Object mem :  
'||TO_CHAR(ROUND(object_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('Cursors    :  
'||TO_CHAR(ROUND(cursor_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('MTS session:  
'||TO_CHAR(ROUND(mts_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('Free memory:  
'||TO_CHAR(ROUND(free_mem/(1024*1024),2)) || ' Mb ' ||
'('|| TO_CHAR(ROUND(free_mem/1024/1024,2)) || 'MB)');
DBMS_OUTPUT.PUT_LINE ('Shared pool utilization (total):  '||
TO_CHAR(used_pool_size) || ' bytes ' || '(' ||
TO_CHAR(ROUND(used_pool_size/1024/1024,2)) || 'MB)');
DBMS_OUTPUT.PUT_LINE ('Shared pool allocation (actual):  '|| pool_size
||'bytes ' || '(' || TO_CHAR(ROUND(pool_size/1024/1024,2)) || 'MB)');
DBMS_OUTPUT.PUT_LINE ('Percentage Utilized:  '||TO_CHAR
(ROUND(used_pool_size/pool_size*100)) || '%');
END;
/

The dev instance shows properly  (Free Mem seems to be tallying)

(F) Approx = (B) - (A)

                                             Free
                                              Mem
POOL        NAME                             (Mb)
--- --

RE: International Language Support Experiences?

2003-08-27 Thread Freeman Robert - IL

The main problem I ran into was the fact that we were already supporting a
non-supported set of language characters, and nobody told us of the
requirement! Made the conversion interesting.

RF
 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/27/2003 1:34 PM

We have a new requirement to support multiple languages in at least one
of our databases.  I'm reading the Oracle 9iR2 Globalization Support
Guide (450 pages), but wonder if any of you can share real-life
experiences regarding:

1.  the conversion of existing DBs to broader character sets 
2.  using Unicode 
3.  implementing this with 9iAS 

Our databases currently use US7ASCII with the American character set,
but we will likely need to support European, Southeast Asian, and South
American languages.


Thanks. 


Best regards, 

David B. Wagoner 
Database Administrator 
Arsenal Digital Solutions 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Shared Pool Utilization

Hi!

I wonder whether you are running in dedicated server mode? That way UGA
isn't allocated from SGA and the calculation used_pool/shared_pool_size is
gives wrong results.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 10:44 PM


> I have two databases, one in which the shared_pool utilization is not
> exceeded (development) and the other one in which it appears that the
> shared_pool utilization is exceeded.
> The queries i am using are
> 1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
> SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
>  WHERE NAME = 'free memory'
>AND POOL = 'shared pool'
> /
>
> 2. Metalink note
> SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
> bytes--> Mb and nvl clauses)
>
> set serveroutput on size 100;
> DECLARE
> object_mem NUMBER;
> shared_sql NUMBER;
> cursor_mem NUMBER;
> mts_memNUMBER;
> used_pool_size NUMBER;
> free_mem   NUMBER;
> pool_size  VARCHAR2(512); -- same AS V$PARAMETER.VALUE
> BEGIN
> -- Stored objects (PACKAGEs, views)
> --V$DB_OBJECT_CACHE
> --This view displays database objects that are cached in the
> library cache. Objects include
> --tables, indexes, clusters, synonym definitions, PL/SQL
> procedures and packages, and triggers.
> --http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96
536/ch346.htm#1113348
> SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
v$db_object_cache;
> --
> --
> -- User Cursor Usage -- run this during peak usage.
> -- assumes 250 bytes per open cursor, FOR each concurrent user.
> -- V$SQLAREA lists statistics on shared SQL area and contains one
> row per SQL string.
> -- It provides statistics on SQL statements that are in memory,
> parsed, and ready for execution.
> SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
>
> -- For a test system -- get usage FOR one user, multiply by # users
> -- SELECT (250 * value) bytes_per_user
> -- FROM v$sesstat s, v$statname n
> -- WHERE s.statistic# = n.statistic#
> -- AND n.name = 'opened cursors current'
> -- AND s.sid = 25;  -- WHERE 25 is the sid of the process
>
> -- MTS memory needed to hold session inFORmation FOR shared server
users
> -- This query computes a total FOR all currently logged on users (run
> --  during peak period). Alternatively calculate FOR a single user and
> --  multiply by # users.
> SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
>WHERE s.statistic#=n.statistic#
>AND n.name='session uga memory max';
>
> -- Free (unused) memory IN the SGA: gives an indication of how much
> memory
> -- is being wasted OUT of the total allocated.
> SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
> WHERE name = 'free memory' AND pool='shared pool';
> -- For non-MTS add up object, shared sql, cursors AND 30% overhead.
> --used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
>
> -- For MTS mts contribution needs to be included (comment OUT previous
> line)
> used_pool_size :=
> ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));
>
> SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
> name='shared_pool_size';
>
>-- Display results
> DBMS_OUTPUT.PUT_LINE ('Object mem :
> '||TO_CHAR(ROUND(object_mem/(1024*1024),2)) || ' Mb');
> DBMS_OUTPUT.PUT_LINE ('Cursors:
> '||TO_CHAR(ROUND(cursor_mem/(1024*1024),2)) || ' Mb');
> DBMS_OUTPUT.PUT_LINE ('MTS session:
> '||TO_CHAR(ROUND(mts_mem/(1024*1024),2)) || ' Mb');
> DBMS_OUTPUT.PUT_LINE ('Free memory:
> '||TO_CHAR(ROUND(free_mem/(1024*1024),2)) || ' Mb ' ||
> '('|| TO_CHAR(ROUND(free_mem/1024/1024,2)) || 'MB)');
> DBMS_OUTPUT.PUT_LINE ('Shared pool utilization (total):  '||
> TO_CHAR(used_pool_size) || ' bytes ' || '(' ||
> TO_CHAR(ROUND(used_pool_size/1024/1024,2)) || 'MB)');
> DBMS_OUTPUT.PUT_LINE ('Shared pool allocation (actual):  '|| pool_size
> ||'bytes ' || '(' || TO_CHAR(ROUND(pool_size/1024/1024,2)) || 'MB)');
> DBMS_OUTPUT.PUT_LINE ('Percentage Utilized:  '||TO_CHAR
> (ROUND(used_pool_size/pool_size*100)) || '%');
> END;
> /
>
> The dev instance shows properly  (Free Mem seems to be tallying)
>
> (F) Approx = (B) - (A)
>
>  Free
>   Mem
> POOLNAME (Mb)
> --- -- --
> shared pool free memory 18.27  (F)
>
> and
> Object mem :   10.5 Mb
> Cursors:   .07 Mb
> MTS session:   9.47 Mb
> Free memory:   18.29 Mb (18.29MB)  (F2) for Shared Pool
> Shared pool utilization (total):  27316566 bytes (26.05MB)  (A)
> Shared pool allocation (actual):  50331648bytes (48MB)  (B)
> Percentage Utilized:  54%
>

RE: 7.3.4 on hp-ux11 upgrade problem

2003-08-27 Thread M Rafiq

HP-UX 11 binaries are not compatible with 10.20. There is no upgrade path 
for 10.20 to HP 11 or 11.11 when you want to use Oracle.

As per Oracle Spoort sometimes in 2001-02 , install HP-11 on new box or 
existing box from scratch and apply all OS patches required for Oracle.

Install 7.3.4 binaries for HP-11. Copy over your 
datafiles/controlfiles/logfiles of 10.20 to HP11 and migrate first your 
7.3.4 database. We did this sometime in 2001 with Oracle Financials 10.7 at 
my last employer hence no paper work available now with me.

Then onward you can move to 8i or 9i whatever and follow upgrade/migration  
Oracle docs.

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 27 Aug 2003 07:34:26 -0800
I have read the manuals and conflicting posts on metalink
and have asked first oracle what to do and they're advice
was to take 10.20 cd's and install them on 11.11. This was done
before this post.
If you want to know where to find this in manuals let me know.

Jeroen

-Oorspronkelijk bericht-
Van: Jesse, Rich [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 27 augustus 2003 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: 7.3.4 on hp-ux11 upgrade problem
Among changes like nearly the whole data dictionary, the format of the
ROWIDs for every row in the DB is different.  You need to migrate the DB.
Kindly RTFM.
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Wednesday, August 27, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
Hi,

We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to
oracle 9.0.1.0 on a different hp-ux 11.11 box.
In order to be able to migrate we installed 7.3.4 on this machine,
copied datafiles and config.ora, init.ora and listener.ora
We only run the old listener (this starts correctly) and we try to bring up
our copy on this
machine. We encounter the following problem
pablo:oracle>/opt/oracle/product/7.3.4/dbs $svrmgrl

Oracle Server Manager Release 2.3.4.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

ORA-12547: TNS:lost contact
SVRMGR> connect internal;
Password:
ORA-12547: TNS:lost contact
SVRMGR> startup
LCC-00161: ORACLE error (possible syntax error) parameter [NULL]
ORA-12547: TNS:lost contact
Environment has been set to the right oracle_home, also tns_admin
Any idea what causes this? Installation or configuration problem?
Thnx in advance,

Jeroen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeroen van Sluisdam
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
_
MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: [Q] SQL Help!! How to make select left justify and fill space??


Mladen,

Even I use sqlplus for some reporting.

There's even a perl script in "Perl  for Oracle DBA's" that is a driver for sqlplus.

Why?  For the things that are missing in Perl that I needed for some reporting.

Mostly the column breaks.  There is no convenient module yet for doing that
in Perl. I started one for Perl, but never finished it.  Not enough oop experience
for the complexity of what I was trying to do ( breaks and sums ).  Have a working
prototype, but far from finished.  Just ran out of time for it.

Sqlplus does still have it's place.

Jared







"Mladen Gogala" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 12:59 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: [Q] SQL Help!! How to make select left justify and fill space??


Well, people are trying to use SQL*Plus as if it was a report generating tool, which it isn't. 
To tell the truth, I started using perl because of its formatting capabilities (I hope you still
do remember the old &ora_login stuff from perl4?) because my report looked so much nicer
then with sqlplus. I don't have running sums, but they're rarely needed. On the other hand,
I can do left and right justification, top of the page format, multiline fields (impossible to do
with sqlplus) and a lot of other good stuff, like conditional printing (that's why perl has
"if" statement). The ideal thing for generating pretty reports out of any database is called 
perl. It's cheap, it's well documented ("Learning Perl", "Perl Programming", "Perl Cookbook",
"Perl for Oracle DBA", "Advanced Perl Programming", "Perl for Sys Admins", "Perl Objects, 
References & Modules","Learning Perl Tk", "Object Oriented Perl Programming", I have a 
whole shelf devoted to perl.I have a hunch that when Cary's book gets into the circulation, 
there will be another book on that shelf. If that is not a well documented language, then I 
don't know what is) and is ideally suited for the purpose. Yet, people are still using sqlplus.
Why? It beats me.
 
 
--
Mladen Gogala
Oracle DBA 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: [Q] SQL Help!! How to make select left justify and fill space??


LOL! 







"Mladen Gogala" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 08/27/2003 10:04 AM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        RE: [Q] SQL Help!! How to make select left justify and fill space??



Use something like 

FORMAT STDOUT=
@  @>
$id,       $empname


 
Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.  Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such
  entity.

Re: International Language Support Experiences?

2003-08-27 Thread Dave Hau

For clients that do not support UTF8, you can set NLS_LANG on the client 
server to the appropriate single byte character set.  The Oracle client 
library will do the conversion to/from UTF8 when you store/retrieve data 
to/from the Oracle server.

In fact, using UTF8 on the Oracle server does not require _any_ of your 
client apps to use UTF8 at all.  Suppose you have an Oracle server at 
your corporate headquarters serving the needs of multiple client apps 
around the world.  The app servers in Asia, Europe, Africa, S. America 
etc. can each set NLS_LANG to their own _single byte_ character set and 
still, because the Oracle server at corporate uses UTF8 which is MBCS, 
the app servers can all share the same Oracle server.

HTH,
Dave




[EMAIL PROTECTED] wrote:
David,
 
I can share this from an Oracle Apps perspective - we upgraded to UTF8 
(a multi byte char set) from WE8ISO5599-1 (single byte Western Eur 
charset). Some of the biggest problems that we faced are:
 
1. Cut-and-paste produces incorrect characters which were acceptable in 
WE8 but failed conversion. I.e. UTF8 is stricter in what it can display 
as compared to WE8. This was pronounced in the umlaut and other Eur 
specific characters.
2. Quite a number of third-party applications do not support UTF8 - when 
asked about Unicode support, many vendors didn't even know what it would 
mean to support a MBCS such as UTF-8. This may also be the case with 
your own applications.
3. Middle-ware layers such as ODBC/JDBC don't work very well with UTF8 
in the sense that the rules have become stricter and so programs that 
used to work previously will now fail mysteriously with vague messages 
(or worse still silently!).
4. A column which supports text elements that may now handle MBCs will 
require more storage width than previously designed for. Thus you may 
have to look at schema changes to increase VARCHAR2/CHAR columns..
5. Oracle products themselves may need some patches - you mention iAS - 
and have functional restrictions.
6. The
 
You won't hit 1 because you are moving from US7ASCII (7 bit) but watch 
out for the rest! ML Note 158577.1 is a good starting point. I would 
read this one (and the related links) before the 450 pages - you seem to 
like reading :)
 

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Disappointment is inevitable, but Discouragement is optional!

** The opinions and facts contained in this message are entirely mine 
and do not reflect those of my employer or customers **

 

-Original Message-
From: David Wagoner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: International Language Support Experiences?
We have a new requirement to support multiple languages in at least
one of our databases.  I'm reading the Oracle 9iR2 Globalization
Support Guide (450 pages), but wonder if any of you can share
real-life experiences regarding:
1.  the conversion of existing DBs to broader character sets
2.  using Unicode
3.  implementing this with 9iAS
Our databases currently use US7ASCII with the American character
set, but we will likely need to support European, Southeast Asian,
and South American languages.
Thanks.

Best regards,

David B. Wagoner
Database Administrator
Arsenal Digital Solutions


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dave Hau
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: VPN access to 9ias instance behind firewall

2003-08-27 Thread Dong, Ping - Raleigh, NC

Title: RE: VPN access to 9ias instance behind firewall



 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 
  2003 4:30 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: VPN access to 9ias instance behind 
  firewall
  Guys, 
  When user trys to run our application through a VPN behind the 
  firewall in a url they get an error.  They can use ssh to get to host 
  where I installed the application server but not run the application through 
  their browser.  Anyone deal with this issue before?
  Thanks, Paula

RE: perl/shell script for alert log

2003-08-27 Thread John Kanagaraj

Welcome back Ethan!

An alternative is using the following lines in init.ora:

event="1555 trace name errorstack level 3"
event="4031 trace name errorstack level 3"
event="1652 trace name processstate level 10"

This catches the dreaded 01555, out of TEMP, and shared pool allocation
errors *along* with the SQL/Stack from the offending process (and thus time
of occurrence).

And keep *all* the event lines together ;-)

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-Original Message-
Sent: Wednesday, August 27, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L

If you use Connor's script you can modify it to send you the entire chunk of
file it is currently checking in the body of the email.  Ideally you are
checking at a frequent interval so the time of the alert is usually about
the same time you get the error message.

One enhancement I suggest to every script is to configure the a SERVERERROR
trigger to throw certain errors out to the alert log.  ORA-1555 is one that
will show up at the session level but not at the database level.  Out of
TEMP space is another that is frequent at the session level but not the
database level.  This way you know who is causing some important errors.
Overtime I find more and more session errors that are really critical
database errors.  Try DDL on a table with an unusable index.  Pretty big
deal on most production databases but this is a session error and would not
typically show up in the alert log.  The risk of course is some huge loop
throwing 1000's of lines into the alert log.  I would suggest a governor of
some sort in your servererror trigger.

- Ethan

-Original Message-
Sent: Wednesday, August 27, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L

When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?

-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L

HTH

#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.

# You should pass name of ORACLE_SID as a parameter.

#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors,  e-mails depending on the error.

# Parameter: ORACLE_SID
# ---
#
#

DIR=/u01/app/oracle/admin
ORACLE_SID=$1
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_HOME

ALERT_DEST=/u01/app/oracle/admin/${ORACLE_SID}/bdump
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin
export PATH

COLLECTOR=`tail -100
$ALERT_DEST/alert_${ORACLE_SID}.log |grep "ORA-"`
if [ "$COLLECTOR" <> "" ]
then
echo ""
echo " Errors found in:   >
$ALERT_DEST/alert_${ORACLE_SID}.log"
echo ""
echo $COLLECTOR
echo ""
fi;

--- AK <[EMAIL PROTECTED]> wrote:
>  I am sure you guys might have some nice perl/shell
> script to analyze alert log for errors or potential
> problem . Can you share it with me /list .
> 
> Ohh thanks in advance guys .
> 
> -ak
> 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email
Security System.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you wan

Re: sql optimization question

2003-08-27 Thread Dave Hau

select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubmedid = l.identifier
and externaldbid = 9
and l.identifier in
(select identifier from mt.externallink
where externaldbid = 9
group by identifier
having count(distinct objectid) < 6);
HTH,
Dave




[EMAIL PROTECTED] wrote:
Hi,

This query took a few minues to return 126K rows (fast):

select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubmedid = l.identifier
and externaldbid = 9;
But this query took hours and still no result, I had to kill it:

select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubmedid = l.identifier
and externaldbid = 9
and (select count(distinct objectid) from mt.externallink k
 where k.identifier = l.identifier
 and externaldbid = 9
 and l.objectid !=k.objectid)<5;
All the related columns are indexed and table are analyzed. Is there a way
to re-write the part
select count(distinct objectid) from mt.externallink k
 where k.identifier = l.identifier
 and externaldbid = 9
 and l.objectid !=k.objectid)<5
to make the whole thing faster?

TIA.

Guang



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dave Hau
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: VPN access to 9ias instance behind firewall

2003-08-27 Thread Paula_Stankus

Title: RE: VPN access to 9ias instance behind firewall





Guys,


When user trys to run our application through a VPN behind the firewall in a url they get an error.  They can use ssh to get to host where I installed the application server but not run the application through their browser.  Anyone deal with this issue before?

Thanks,
Paula

RE: perl/shell script for alert log

If you use Connor's script you can modify it to send you the entire chunk of
file it is currently checking in the body of the email.  Ideally you are
checking at a frequent interval so the time of the alert is usually about
the same time you get the error message.

One enhancement I suggest to every script is to configure the a SERVERERROR
trigger to throw certain errors out to the alert log.  ORA-1555 is one that
will show up at the session level but not at the database level.  Out of
TEMP space is another that is frequent at the session level but not the
database level.  This way you know who is causing some important errors.
Overtime I find more and more session errors that are really critical
database errors.  Try DDL on a table with an unusable index.  Pretty big
deal on most production databases but this is a session error and would not
typically show up in the alert log.  The risk of course is some huge loop
throwing 1000's of lines into the alert log.  I would suggest a governor of
some sort in your servererror trigger.

- Ethan

-Original Message-
Sent: Wednesday, August 27, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L

When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?

-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L

HTH

#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.

# You should pass name of ORACLE_SID as a parameter.

#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors,  e-mails depending on the error.

# Parameter: ORACLE_SID
# ---
#
#

DIR=/u01/app/oracle/admin
ORACLE_SID=$1
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_HOME

ALERT_DEST=/u01/app/oracle/admin/${ORACLE_SID}/bdump
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin
export PATH

COLLECTOR=`tail -100
$ALERT_DEST/alert_${ORACLE_SID}.log |grep "ORA-"`
if [ "$COLLECTOR" <> "" ]
then
echo ""
echo " Errors found in:   >
$ALERT_DEST/alert_${ORACLE_SID}.log"
echo ""
echo $COLLECTOR
echo ""
fi;

--- AK <[EMAIL PROTECTED]> wrote:
>  I am sure you guys might have some nice perl/shell
> script to analyze alert log for errors or potential
> problem . Can you share it with me /list .
> 
> Ohh thanks in advance guys .
> 
> -ak
> 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email
Security System.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: perl/shell script for alert log

2003-08-27 Thread Roger Xu

When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?

-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L

HTH

#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.

# You should pass name of ORACLE_SID as a parameter.

#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors,  e-mails depending on the error.

# Parameter: ORACLE_SID
# ---
#
#

DIR=/u01/app/oracle/admin
ORACLE_SID=$1
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_HOME

ALERT_DEST=/u01/app/oracle/admin/${ORACLE_SID}/bdump
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin
export PATH

COLLECTOR=`tail -100
$ALERT_DEST/alert_${ORACLE_SID}.log |grep "ORA-"`
if [ "$COLLECTOR" <> "" ]
then
echo ""
echo " Errors found in:   >
$ALERT_DEST/alert_${ORACLE_SID}.log"
echo ""
echo $COLLECTOR
echo ""
fi;

--- AK <[EMAIL PROTECTED]> wrote:
>  I am sure you guys might have some nice perl/shell
> script to analyze alert log for errors or potential
> problem . Can you share it with me /list .
> 
> Ohh thanks in advance guys .
> 
> -ak
> 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email Security System.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Alert log....

2003-08-27 Thread Jose Luis Delgado

> "Roger Xu" <[EMAIL PROTECTED]>

for the guy that asked for writing the the alert.log
file:

dbms_system.ksdwrt(2,'Test line...');

Will write the text to the alert log.

Use 1 instead of 2 to write to the trace file

Use 3 to write to both.

HTH

JL


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: [Q] SQL Help!! How to make select left justify and fill space??

Title: Message



Well, 
people are trying to use SQL*Plus as if it was a report generating tool, which 
it isn't. 
To 
tell the truth, I started using perl because of its formatting capabilities (I 
hope you still
do 
remember the old &ora_login stuff from perl4?) because my report looked so 
much nicer
then 
with sqlplus. I don't have running sums, but they're rarely needed. On the other 
hand,
I can 
do left and right justification, top of the page format, multiline fields 
(impossible to do
with 
sqlplus) and a lot of other good stuff, like conditional printing (that's why 
perl has
"if" 
statement). The ideal thing for generating pretty reports out of any database is 
called 
perl. 
It's cheap, it's well documented ("Learning Perl", "Perl Programming", "Perl 
Cookbook",
"Perl 
for Oracle DBA", "Advanced Perl Programming", "Perl for Sys Admins", "Perl 
Objects, 
References & Modules","Learning Perl 
Tk", "Object Oriented Perl Programming", I have a 
whole 
shelf devoted to perl.I have a hunch that when Cary's book gets into 
the circulation, 
there 
will be another book on that shelf. If that is not a well documented 
language, then I 
don't 
know what is) and is ideally suited for the purpose. Yet, people are still using 
sqlplus.
Why? 
It beats me.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 3:00 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  [Q] SQL Help!! How to make select left justify and fill 
  space??LOL! 
  
  


  
  "Mladen Gogala" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 08/27/2003 10:04 AM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        RE: [Q] SQL Help!! How to 
make select left justify and fill 
  space??Use something like FORMAT 
  STDOUT=@ 
   @>$id, 
        $empname
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

RE: International Language Support Experiences?

2003-08-27 Thread John Kanagaraj

Title: Message



David,
 
I can 
share this from an Oracle Apps perspective - we upgraded to UTF8 (a multi byte 
char set) from WE8ISO5599-1 (single byte Western Eur charset). Some of the 
biggest problems that we faced are:
 
1. 
Cut-and-paste produces incorrect characters which were acceptable in WE8 but 
failed conversion. I.e. UTF8 is stricter in what it can display as compared to 
WE8. This was pronounced in the umlaut and other Eur specific 
characters.
2. 
Quite a number of third-party applications do not support UTF8 - when asked 
about Unicode support, many vendors didn't even know what it would mean to 
support a MBCS such as UTF-8. This may also be the case with your own 
applications.
3. 
Middle-ware layers such as ODBC/JDBC don't work very well with UTF8 in the sense 
that the rules have become stricter and so programs that used to work previously 
will now fail mysteriously with vague messages (or worse still 
silently!).
4. A 
column which supports text elements that may now handle MBCs will 
require more storage width than previously designed for. Thus you may have to 
look at schema changes to increase VARCHAR2/CHAR columns..
5. 
Oracle products themselves may need some patches - you mention iAS - and have 
functional restrictions.
6. The 

 
You 
won't hit 1 because you are moving from US7ASCII (7 bit) but watch out for the 
rest! ML Note 158577.1 is a good starting point. I would read this one (and the 
related links) before the 450 pages - you seem to like reading 
:)
 

John KanagarajDB Soft IncPhone: 408-970-7002 
(W)Disappointment is inevitable, but Discouragement is 
optional!** The opinions and facts contained in this message are 
entirely mine and do not reflect those of my employer or customers 
**
 

  
  -Original Message-From: David Wagoner 
  [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 
  2003 11:35 AMTo: Multiple recipients of list 
  ORACLE-LSubject: International Language Support 
  Experiences?
  We have a new requirement to support multiple 
  languages in at least one of our databases.  I'm reading the Oracle 9iR2 
  Globalization Support Guide (450 pages), but wonder if any of you can share 
  real-life experiences regarding:
  1.  the conversion of existing DBs to broader 
  character sets 2.  using 
  Unicode 3.  implementing this with 
  9iAS 
  Our databases currently use US7ASCII with the 
  American character set, but we will likely need to support European, Southeast 
  Asian, and South American languages.
  Thanks. 
  Best regards, 
  David B. Wagoner Database Administrator Arsenal 
  Digital Solutions

RE: perl/shell script for alert log

2003-08-27 Thread DENNIS WILLIAMS

AK - Go to Google and search on oracle alert log monitor script. This will
give you an array to select from. What you want will depend to a large
extent on your requirements:
 - Something you can easily modify?
 - What platforms should it run on?
 - Email you alerts?
 - Which errors do you wish to be alerted to?
 - Do you want to be able to modify the list of errors?



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, August 27, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L


 I am sure you guys might have some nice perl/shell script to analyze alert
log for errors or potential problem . Can you share it with me /list .
 
Ohh thanks in advance guys .
 
-ak
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Shared Pool Utilization

I have two databases, one in which the shared_pool utilization is not
exceeded (development) and the other one in which it appears that the
shared_pool utilization is exceeded.
The queries i am using are
1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
 WHERE NAME = 'free memory'
   AND POOL = 'shared pool'
/

2. Metalink note
SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
bytes--> Mb and nvl clauses)

set serveroutput on size 100;
DECLARE
object_mem NUMBER;
shared_sql NUMBER;
cursor_mem NUMBER;
mts_memNUMBER;
used_pool_size NUMBER;
free_mem   NUMBER;
pool_size  VARCHAR2(512); -- same AS V$PARAMETER.VALUE
BEGIN
-- Stored objects (PACKAGEs, views)
--V$DB_OBJECT_CACHE
--This view displays database objects that are cached in the
library cache. Objects include
--tables, indexes, clusters, synonym definitions, PL/SQL
procedures and packages, and triggers.

--http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch346.htm#1113348
SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM v$db_object_cache;
--
--
-- User Cursor Usage -- run this during peak usage.
-- assumes 250 bytes per open cursor, FOR each concurrent user.
-- V$SQLAREA lists statistics on shared SQL area and contains one
row per SQL string.
-- It provides statistics on SQL statements that are in memory,
parsed, and ready for execution.
SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;

-- For a test system -- get usage FOR one user, multiply by # users
-- SELECT (250 * value) bytes_per_user
-- FROM v$sesstat s, v$statname n
-- WHERE s.statistic# = n.statistic#
-- AND n.name = 'opened cursors current'
-- AND s.sid = 25;  -- WHERE 25 is the sid of the process

-- MTS memory needed to hold session inFORmation FOR shared server users
-- This query computes a total FOR all currently logged on users (run
--  during peak period). Alternatively calculate FOR a single user and
--  multiply by # users.
SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
   WHERE s.statistic#=n.statistic#
   AND n.name='session uga memory max';

-- Free (unused) memory IN the SGA: gives an indication of how much
memory
-- is being wasted OUT of the total allocated.
SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
WHERE name = 'free memory' AND pool='shared pool';
-- For non-MTS add up object, shared sql, cursors AND 30% overhead.
--used_pool_size := ROUND(1.3*(object_mem+cursor_mem));

-- For MTS mts contribution needs to be included (comment OUT previous
line)
used_pool_size :=
ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));

SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
name='shared_pool_size';

   -- Display results
DBMS_OUTPUT.PUT_LINE ('Object mem :  
'||TO_CHAR(ROUND(object_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('Cursors:  
'||TO_CHAR(ROUND(cursor_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('MTS session:  
'||TO_CHAR(ROUND(mts_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('Free memory:  
'||TO_CHAR(ROUND(free_mem/(1024*1024),2)) || ' Mb ' ||
'('|| TO_CHAR(ROUND(free_mem/1024/1024,2)) || 'MB)');
DBMS_OUTPUT.PUT_LINE ('Shared pool utilization (total):  '||
TO_CHAR(used_pool_size) || ' bytes ' || '(' ||
TO_CHAR(ROUND(used_pool_size/1024/1024,2)) || 'MB)');
DBMS_OUTPUT.PUT_LINE ('Shared pool allocation (actual):  '|| pool_size
||'bytes ' || '(' || TO_CHAR(ROUND(pool_size/1024/1024,2)) || 'MB)');
DBMS_OUTPUT.PUT_LINE ('Percentage Utilized:  '||TO_CHAR
(ROUND(used_pool_size/pool_size*100)) || '%');
END;
/

The dev instance shows properly  (Free Mem seems to be tallying)

(F) Approx = (B) - (A)

 Free
  Mem
POOLNAME (Mb)
--- -- --
shared pool free memory 18.27  (F)

and
Object mem :   10.5 Mb
Cursors:   .07 Mb
MTS session:   9.47 Mb
Free memory:   18.29 Mb (18.29MB)  (F2) for Shared Pool
Shared pool utilization (total):  27316566 bytes (26.05MB)  (A)
Shared pool allocation (actual):  50331648bytes (48MB)  (B)
Percentage Utilized:  54%

BUT in Prodn it does not seem to be the case.



 Free
  Mem
POOLNAME (Mb)
--- -- --
shared pool free memory120.17 (F)


Object mem :   59.43 Mb
Cursors:   2.14 Mb
MTS session:   302.59 Mb
Free memory:   120.13 Mb (120.13MB) (F2) for Shared Pool
Shared pool utilization (total):  496410073 bytes (473.41MB) (A)
Shared pool allocation

RE: [UBE?] Re: Nature of Oracle-l has changed


Yes, my bad.  And I'm supposed to keep an eye on this stuff.

This thread has gone so far astray we should end it.

Jared







"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 12:14 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: [UBE?] Re: Nature of Oracle-l has changed


wait - is this OT??
 

We once had a principal named Peter in grade school. 

I think he reached that position through the Peter Principle. 

Jared 






"Henry Poras" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 08/27/2003 06:39 AM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        RE: [UBE?] Re: Nature of Oracle-l has changed



Reminds me of "The Peter Principal". Promoted to your level of incompetance.

Henry


-Original Message-
Rachel Carmichael
Sent: Wednesday, August 27, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L


HR also doesn't have a "technical track" in many companies and the
highest salaries usually go to those on the "management track"... so
you either get promoted out of technical work and into management to
get the salary you deserve (which kind of defeats the purpose) or the
technical person sits at a lower pay level.

When I left Citibank, I was a Vice President... not because I was an
executive or management... but so that they could pay me what I was
worth.


--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Part of the problem lies with the old human vices - jealousy comes
> into
> mind, first. The problem is mostly not with companies but immediate
> supervisers, who often struggle with the prospect that the
> subordinate will
> get more money - and they resent it to very core. They would rather
> hire
> someone off the street with more money than give the old failthful
> the due
> share.
> 
> The other problem is the HR departments magic wand yardstick of
> salary and
> compensation which dictates, often incorrectly, how much a particular
> job's
> adequate compensation is. Never mind the fact that a regular HR joe
> doesn't
> understand DBAs from Developers - so the highly paid "specialist"
> boils it
> dall own to a simple yardstick - number of years of experience!
> 
> Several years ago I rose to the postition of the lead DBA at a
> company when
> I was 24, but my salary was less than the lowest of the 15 DBAs in
> the team.
> Reason - my years of experience was simply didn't show high enough in
> the
> yardstick to warrant a higher salary. It was even more painful when I
> was
> the fail-over contact for all members of the team. When the pager
> goes off
> in the middle of the night, out I go to fix the problem in the HR
> database
> and just making sure all is well, especially in the salary table,
> where the
> "indisposed" team member's pay glares, almost mockingly! I left; the
> new
> person was almost myage, but the negotiated salary was higher. The HR
> department's magic yardstick was broken by the departmental manager.
> Similarly, the in the new place I went, there was no problem in
> getting a
> much fatter paycheck. Morale - when you stick around, you become "hoi
> poloi"; the knight in the shining armor is the one who comes from
> outside!
> 
> Regards,
> 
> Arup
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 26, 2003 9:49 PM
> 
> 
> > Partially true.
> >
> > I've seen the IT cutbacks at a company where people almost
> > never leave.  Many IT folk have been there 10+ year, a
> > surprising number of them 20+ years.
> >
> > The flip side to the salary story is something of a paradox.
> >
> > As a person became more experienced, learned new technologies,
> > and as the company embraced more technologies, the employees
> > at times may not be paid commensurate with their abilities.
> >
> > I experienced that once. The only way to increase my earning
> > power was to leave.  My salary jumped 50% immediately.  This
> > has no doubt happened to a number of folks. 
> >
> > The silly side of this is that the former employer then had
> > to hire a replacement at the going rate, or get a contractor in.
> >
> > Bottom line, they lose an experienced employee, and end up paying
> > as much or more as if they had tried to retain said employee.
> >
> > Jared
> >
> >
> > Jared
> >
> >
> > On Tue, 2003-08-26 at 18:04,
> [EMAIL PROTECTED]
> > wrote:
> > > I think a lot of IT people "abused" the situation during the boom
> days.
> > > Company loyalty meant nothing ... we'll go wherever the biggest
> paychecks
> > > are.  Don't stay anywhere too long. that's for losers.  Change
> jobs if
> we
> > > felt the least bit abused and unappreciated.  That'll teach them
> to
> screw
> > > with me!  In general a holier-than-thou attitude.  The times
> allowed us
> to
> > > do

RE: perl/shell script for alert log




http://www.oracledba.co.uk/
 
Check out the alert log script in the admin section.  Doesn't 
repeatedly check the same segment of the alert log file.
 
- Ethan

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 12:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  perl/shell script for alert log
   I am sure you guys might have some nice 
  perl/shell script to analyze alert log for errors or potential problem . Can 
  you share it with me /list .
   
  Ohh thanks in advance guys .
   
  -ak

RE: Grid

2003-08-27 Thread Odland, Brad

Commoditizing of IT resources, hardware, software, people requires reducing
the level of maintenance and knowledge required. A "grid" does just that.
The concept of a grid is to still function with the loss of one or more
members and can incorporate new resources easily. 

The electrical power grid is an example of a grid network. Unfortunately as
we have seen the system is vulnerable to a catastrophic failure that was
hidden from view. The system we believed to be flexible and capable of
modifying itself was unable to cope with the level of change and demands on
the system. The result was complete collapse of a large portion of the
system leaving millions without electricity. We should remember and learn
from failures such as this. Unfortunately, history has shown that our
collective memory is only the span of one generation. We continue to
repeated the same misery and mayhem over and over again.

Looking into the future one can theorize on the implications of distributed
grid infrastructure on computing. Suddenly the control and flexibility of
computing will be removed from the individual and placed in the hands of a
monolithic provider. Computing will become a utility that is metered and
paid for.

Microsoft has long been an advocate for pay for use software. Oracle and
Microsoft are aligning their business to exploit the ability of metered
software/hardware billing. Grid computing infrastructure will provide this
ability.

Is the is answer that people are looking for? Maybe. With software and
hardware purchasing decisions taken out of the hands of the business and
individual internal resources could be free to use the "brain" power spent
on index rebuilds, backups, patching and other routine maintenance on
something more advantageous or devious.

We have seen this in some recent sci-fi movies. Blade Runner, Minority
Report, Seventh Sign, AI and even Terminator displayed the possible impact
of a grid computing infrastructure on society. For many, including my self,
it was disturbing. Inevitably the local processor of a computer will be come
so powerful that future improvements to that processor will become
unnecessary. The key to increasing power of a grid system will be to add
more processors. The speed of development in processor technology will reach
a point very soon where the grid will become a reality.

Already our culture is changing to accept this reality. The lust we have for
information will drive the desire to extend the internet beyond a simple
information super highway* into the information super computer grid. We will
no longer wish to have simple access to information we will want it to be
processed, stored, manipulated and delivered by the same system.

Those of us steeped in the daily throws of technological nirvana sometimes
fail to look ahead to the implications and effects of technology on our
lives. Grid computing is one of those technologies that once unleashed may
never be able to be controlled. The potential for abuse and profit is as
great as the benefits to humanity that we can imagine. 

Grid computing is quite compelling. We have always taken our inventions
improved them made access to them easy and in essence taken the wonder out
of them. Pause to reflect that many of our Grandparents were the first
generation to experince running hot water, the glow of a light bulb or the
crackle of a voice over the telephone.

It will be important to be vigilant with security, privacy and ethics as we
begin to implement "grids" in our own computing environments. The failure to
do so could result in things more unpleasant than simple worms or annoying
spam in the future.


*Wow...How long has it been since anyone used those three words...?

(listening to too much ambient music lately)

Brad O.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: [UBE?] Re: Nature of Oracle-l has changed

2003-08-27 Thread Mercadante, Thomas F




wait - 
is this OT??
 
We once had a principal named Peter in grade school. I think he reached that position through the Peter 
Principle. Jared 


  
  

"Henry Poras" 
  <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
   08/27/2003 06:39 AM  Please 
  respond to ORACLE-L 
                To:     
     Multiple recipients of list ORACLE-L 
  <[EMAIL PROTECTED]>         cc:         
          Subject: 
         RE: [UBE?] Re: Nature of Oracle-l has 
  changedReminds me of "The Peter Principal". Promoted to your level of 
incompetance.Henry-Original Message-Rachel 
CarmichaelSent: Wednesday, August 27, 2003 7:44 AMTo: Multiple 
recipients of list ORACLE-LHR also doesn't have a "technical track" 
in many companies and thehighest salaries usually go to those on the 
"management track"... soyou either get promoted out of technical work and 
into management toget the salary you deserve (which kind of defeats the 
purpose) or thetechnical person sits at a lower pay level.When I 
left Citibank, I was a Vice President... not because I was anexecutive or 
management... but so that they could pay me what I wasworth.--- 
Arup Nanda <[EMAIL PROTECTED]> wrote:> Part of the problem lies 
with the old human vices - jealousy comes> into> mind, first. The 
problem is mostly not with companies but immediate> supervisers, who 
often struggle with the prospect that the> subordinate will> get 
more money - and they resent it to very core. They would rather> 
hire> someone off the street with more money than give the old 
failthful> the due> share.> > The other problem is 
the HR departments magic wand yardstick of> salary and> 
compensation which dictates, often incorrectly, how much a particular> 
job's> adequate compensation is. Never mind the fact that a regular HR 
joe> doesn't> understand DBAs from Developers - so the highly paid 
"specialist"> boils it> dall own to a simple yardstick - number of 
years of experience!> > Several years ago I rose to the postition 
of the lead DBA at a> company when> I was 24, but my salary was 
less than the lowest of the 15 DBAs in> the team.> Reason - my 
years of experience was simply didn't show high enough in> the> 
yardstick to warrant a higher salary. It was even more painful when I> 
was> the fail-over contact for all members of the team. When the 
pager> goes off> in the middle of the night, out I go to fix the 
problem in the HR> database> and just making sure all is well, 
especially in the salary table,> where the> "indisposed" team 
member's pay glares, almost mockingly! I left; the> new> person 
was almost myage, but the negotiated salary was higher. The HR> 
department's magic yardstick was broken by the departmental manager.> 
Similarly, the in the new place I went, there was no problem in> getting 
a> much fatter paycheck. Morale - when you stick around, you become 
"hoi> poloi"; the knight in the shining armor is the one who comes 
from> outside!> > Regards,> > Arup> 
> - Original Message - > To: "Multiple recipients of list 
ORACLE-L" <[EMAIL PROTECTED]>> Sent: Tuesday, August 26, 2003 
9:49 PM> > > > Partially true.> >> > 
I've seen the IT cutbacks at a company where people almost> > never 
leave.  Many IT folk have been there 10+ year, a> > surprising 
number of them 20+ years.> >> > The flip side to the salary 
story is something of a paradox.> >> > As a person became 
more experienced, learned new technologies,> > and as the company 
embraced more technologies, the employees> > at times may not be paid 
commensurate with their abilities.> >> > I experienced that 
once. The only way to increase my earning> > power was to leave. 
 My salary jumped 50% immediately.  This> > has no doubt 
happened to a number of folks. > 
>> > The silly side of this is that the former employer then 
had> > to hire a replacement at the going rate, or get a contractor 
in.> >> > Bottom line, they lose an experienced employee, 
and end up paying> > as much or more as if they had tried to retain 
said employee.> >> > Jared> >> >> 
> Jared> >> >> > On Tue, 2003-08-26 at 
18:04,> [EMAIL PROTECTED]> > 
wrote:> > > I think a lot of IT people "abused" the situation 
during the boom> days.> > > Company loyalty meant nothing 
... we'll go wherever the biggest> paychecks> > > are. 
 Don't stay anywhere too long. that's for losers.  Change> jobs 
if> we> > > felt the least bit abused and unappreciated. 
 That'll teach them> to> screw> > > with me! 
 In general a holier-than-thou attitude.  The times> allowed 
us> to> > > do that.> > >> > > But 
it also means a lot of non-IT people developed an opinion of> IT 
folk> as> > > not being team players, only out for 
themselves, not committed to> the> > > company, etc.> 
> >> > > So when the chance comes to cut back, where are you 
going to> look?  :-)> > >> > > 
Dave> > > -- > > > Please see the official ORACLE-L 
FAQ: http://www.orafaq.net> > > -- > > > 
Author:> > >   INET: 
[EMAIL PROTECTED]

RE: FW: Instance crash

2003-08-27 Thread Pena, Carol A

Sounds like you've been working with Support on this, I'd reopen the
Tar. 

Just FYI, you can always go to Metalink and search on ORA-600 Lookup (or
Doc.Id 153788.1), then cut and paste the call stack into Lookup utility
and do a Search CallStack on it.  In the call stack below it returned
items.

Carol

-Original Message-

Sent: Wednesday, August 27, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L

TAR is soft closed

-Original Message-
Sent: Wednesday, August 27, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L


oracle core dumped, call support

[EMAIL PROTECTED] wrote:

>  
>
>> -Original Message-
>>From: Maddali, Srinivas (Card Services)  
>>Sent: Wednesday, August 27, 2003 12:39 PM
>>To:   '[EMAIL PROTECTED]'
>>Subject:  Instance crash
>>
>>The database Instance Crashed with therrors captured by alert log
>>
>>Mon Aug 25 17:57:51 2003
>>ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8],
[], [], [], [], [], []
>>Mon Aug 25 17:57:52 2003
>>ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8],
[], [], [], [], [], []
>>Mon Aug 25 17:57:52 2003
>>ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8],
[], [], [], [], [], []
>>Mon Aug 25 17:57:58 2003
>>ORA-07445: exception encountered: core dump [] [] [] [] [] []
>>Mon Aug 25 17:58:07 2003
>>ORA-07445: exception encountered: core dump [] [] [] [] [] []
>>Mon Aug 25 18:01:07 2003
>>ORA-00600: internal error code, arguments: [ksfqsubmit1],
[0x11027CEB8], [], [], [], [], [], []
>>Mon Aug 25 18:01:08 2003
>>ORA-00600: internal error code, arguments: [ksfqsubmit1],
[0x11027CEB8], [], [], [], [], [], []
>>Mon Aug 25 18:01:08 2003
>>ORA-00600: internal error code, arguments: [ksfqsubmit1],
[0x11027CEB8], [], [], [], [], [], []
>>Mon Aug 25 18:01:10 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [],
[], []
>>Mon Aug 25 18:01:10 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [],
[], []
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [],
[], []
>>Mon Aug 25 18:01:18 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [],
[], []
>>Mon Aug 25 18:01:28 2003
>>ORA-07445: exception encountered: core dump [] [] [] [] [] []
>>Mon Aug 25 18:10:38 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [],
[], []
>>
>>
>>What this means to me
>>
>>Pl let me know
>>Thanks
>>Srinivas
>>
>>
>
>
>**
>This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you

>**
>
>  
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


**
This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling o

Re: International Language Support Experiences?

2003-08-27 Thread AK

Title: International Language Support Experiences?



we have been using utf8 char set for international 
support in the database .
 
-ak
 

  - Original Message - 
  From: 
  David Wagoner 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, August 27, 2003 11:34 
  AM
  Subject: International Language Support 
  Experiences?
  
  We have a new requirement to support multiple 
  languages in at least one of our databases.  I'm reading the Oracle 9iR2 
  Globalization Support Guide (450 pages), but wonder if any of you can share 
  real-life experiences regarding:
  1.  the conversion of existing DBs to broader 
  character sets 2.  using 
  Unicode 3.  implementing this with 
  9iAS 
  Our databases currently use US7ASCII with the 
  American character set, but we will likely need to support European, Southeast 
  Asian, and South American languages.
  Thanks. 
  Best regards, 
  David B. Wagoner Database Administrator Arsenal 
  Digital Solutions

RE: Grid

2003-08-27 Thread Jesse, Rich

I know the folks here are using distcc
http://dev.gentoo.org/~hanno/distcc.html to compile their gentoo stuff
(desktop only).


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA

> -Original Message-
> From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 27, 2003 12:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Grid
> 
> 
> We've been talking of Grid computing here since either late 
> 1999 or early 2000.  The computing for our main experiment 
> was designed before the Grid was contemplated.  Still we have 
> implemented some of the middleware needed, and build methods 
> of authentication and authorization, and participated in Grid 
> experiments. We have also been pushing the ability to 
> transfer large amounts of data.  The latest effort: 2.3 GB 
> per second between the local internet hub and Geneva 
> Switzerland over Internet 2.  This is vital to make the Grid work.
> 
> I was looking at the papers from the last Computing in High 
> Energy Physics conference.  I'd estimate that over half dealt 
> with the Grid.  Nearly all had to do with test beds or 
> implementation standards.  But the AMANDA experiment, 
> Antarctic Muon and Neutrino Detector Array, is using the Grid 
> in production.  The AMANDA  instrument is situated at the South Pole.
> 
> In 1990 if had mentioned the web very few would have heard of 
> it, but within a few years URL's were ubiquitous.  Oracle was 
> very slow in adapting to the web.Perhaps this time they 
> want to be avant garde.  I don't know how the Grid is to work 
> in the business environment.  Major scientific collaborations 
> include universities and HEP labs from numerous countries 
> working towards the same goals including the sharing of 
> computer resources.  I doubt Pepsi would share its resources 
> with Coke.  Will we have the cokegrid, the pepsigrid, etc.
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 2:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Although I haven't got into the technical details of 'The 
> Grid' (and thanks for this article - I shall read it), but 
> nevertheless I have a haunting sense of deja vu. Remember all 
> the hype over distributed computing that Oracle generated? 
> Remember the key part client-server was of that? Remember 
> what Ellison said about that? ('The biggest mistake we ever 
> made' - I was there, I heard him say it). So. I'm just 
> wondering how this particular circle is going to be squared...
> 
> peter
> edinburgh
> 
> 
> -Original Message-
> Sent: Monday, August 25, 2003 7:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> While I was cleaning up the other day, I noticed a magazine 
> sticking out of the middle (sadly, closer to the top) of my 
> still-to-be-read list. The cover story of Physics Today (Feb. 
> 2002) is "The Power of Grid Computing". It is a pretty good 
> review article on the subject. If anyone is interested, the 
> URL is http://www.aip.org/pt/vol-55/iss-2/p42.html
> 
> The major point seems to be that the grid is simply just a 
> way to share distributed resources. However, utilizing these 
> resources needs an infrastructure in place. It "requires 
> uniform mechanisms for such critical tasks as creating and 
> managing services on remote computers, supporting single 
> sign-on to distributed resources, transferring large datasets 
> at high speeds, forming large distributed virtual 
> communities, and maintaining information about the existence, 
> state, and usage policies of community resources...Providing 
> the infrastructure and tools that make large-scale, secure 
> resource sharing possible and straight-forward is the Grid's 
> raison d'etre."
> 
> In addition, this means that computing resources can be 
> parcelled out like a utility. If you need extra CPU, buy it 
> and use it from your utility when you need it. You don't need 
> to own the hardware for your peak load. It also becomes 
> easier to share data and applications between colleagues at 
> different locations.
> 
> I can see how databases are part of this picture, but I am 
> not sure how Oracle will try and place itself at the center 
> of this trend (unless they mangle the concept of Grid in the process).
> 
> Henry
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want

RE: Instance crash

2003-08-27 Thread Odland, Brad

A quick look shows it could be bug related to JavaVM and shared server
connections or something completly different...

Better pay up the $$$ for Oracle support

ORA-00600 errors are difficult to troubleshoot without Oracle Support.



-Original Message-
Sent: Wednesday, August 27, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L




>  -Original Message-
> From: Maddali, Srinivas (Card Services)  
> Sent: Wednesday, August 27, 2003 12:39 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  Instance crash
> 
> The database Instance Crashed with therrors captured by alert log
> 
> Mon Aug 25 17:57:51 2003
> ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [],
[], [], [], [], []
> Mon Aug 25 17:57:52 2003
> ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [],
[], [], [], [], []
> Mon Aug 25 17:57:52 2003
> ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [],
[], [], [], [], []
> Mon Aug 25 17:57:58 2003
> ORA-07445: exception encountered: core dump [] [] [] [] [] []
> Mon Aug 25 17:58:07 2003
> ORA-07445: exception encountered: core dump [] [] [] [] [] []
> Mon Aug 25 18:01:07 2003
> ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8],
[], [], [], [], [], []
> Mon Aug 25 18:01:08 2003
> ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8],
[], [], [], [], [], []
> Mon Aug 25 18:01:08 2003
> ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8],
[], [], [], [], [], []
> Mon Aug 25 18:01:10 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [],
[]
> Mon Aug 25 18:01:10 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [],
[]
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [],
[]
> Mon Aug 25 18:01:18 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [],
[]
> Mon Aug 25 18:01:28 2003
> ORA-07445: exception encountered: core dump [] [] [] [] [] []
> Mon Aug 25 18:10:38 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [],
[]
> 
> 
> What this means to me
> 
> Pl let me know
> Thanks
> Srinivas


**
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Virtual Circuit Status

2003-08-27 Thread Cary Millsap

There is no such thing as an "idle event." If it consumes someone's
response time, then you have to deal with it. If it tallies time that's
not part of someone's response time, then ignore it.

The key is to collect session-level data for exactly the time interval
during which the observed session is having a performance problem.

The ambiguous answers you're finding all boil down to whether you've
collected your data "properly" or not. If you've collected your data
improperly, then it's an idle event. If you've collected your data
properly (re: paragraph 2), then it's not.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Erik Williams
Sent: Wednesday, August 27, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L

Has anyone run into excessive waits on this event? After running my
statspack through oraperf.com, I see that I am waiting ~80% of response
time
on this event. I have read on metalink that this is NOT an idle event,
and
on asktom.oracle.com that it IS an idle event. We have MTS configured,
but
all the clients are set to use dedicated server. Should I try reduce
this
event by tuning MTS or is it truely an idle event?

Thanks
Erik
 




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Bounced from the list

Getting bounced from the list is due to emails sent to your address being returned as undeliverable.

Nothing we can do about it from our end.

Could be that the recent proliferation of virusii and the consequential overloading of email servers
is causing a lot of mail to bounce.

Jared

GL2Z/ INF DBA BENLATRECHE <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/27/2003 08:29 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Bounced from the list

Hi all,

I have been bounced twice from the list since July.
I don't know the reason why ?.
I re-subscribe this morning and I am afraid to be bounced again ?

The listmaster have been contacted without a feedback.

Is this happened to someone else ?

And what to do ???

Regards
Kamel Benlatreche

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GL2Z/ INF DBA BENLATRECHE
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

RE: [UBE?] Re: Nature of Oracle-l has changed


We once had a principal named Peter in grade school.

I think he reached that position through the Peter Principle.

Jared







"Henry Poras" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 06:39 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: [UBE?] Re: Nature of Oracle-l has changed


Reminds me of "The Peter Principal". Promoted to your level of incompetance.

Henry


-Original Message-
Rachel Carmichael
Sent: Wednesday, August 27, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L


HR also doesn't have a "technical track" in many companies and the
highest salaries usually go to those on the "management track"... so
you either get promoted out of technical work and into management to
get the salary you deserve (which kind of defeats the purpose) or the
technical person sits at a lower pay level.

When I left Citibank, I was a Vice President... not because I was an
executive or management... but so that they could pay me what I was
worth.


--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Part of the problem lies with the old human vices - jealousy comes
> into
> mind, first. The problem is mostly not with companies but immediate
> supervisers, who often struggle with the prospect that the
> subordinate will
> get more money - and they resent it to very core. They would rather
> hire
> someone off the street with more money than give the old failthful
> the due
> share.
> 
> The other problem is the HR departments magic wand yardstick of
> salary and
> compensation which dictates, often incorrectly, how much a particular
> job's
> adequate compensation is. Never mind the fact that a regular HR joe
> doesn't
> understand DBAs from Developers - so the highly paid "specialist"
> boils it
> dall own to a simple yardstick - number of years of experience!
> 
> Several years ago I rose to the postition of the lead DBA at a
> company when
> I was 24, but my salary was less than the lowest of the 15 DBAs in
> the team.
> Reason - my years of experience was simply didn't show high enough in
> the
> yardstick to warrant a higher salary. It was even more painful when I
> was
> the fail-over contact for all members of the team. When the pager
> goes off
> in the middle of the night, out I go to fix the problem in the HR
> database
> and just making sure all is well, especially in the salary table,
> where the
> "indisposed" team member's pay glares, almost mockingly! I left; the
> new
> person was almost myage, but the negotiated salary was higher. The HR
> department's magic yardstick was broken by the departmental manager.
> Similarly, the in the new place I went, there was no problem in
> getting a
> much fatter paycheck. Morale - when you stick around, you become "hoi
> poloi"; the knight in the shining armor is the one who comes from
> outside!
> 
> Regards,
> 
> Arup
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 26, 2003 9:49 PM
> 
> 
> > Partially true.
> >
> > I've seen the IT cutbacks at a company where people almost
> > never leave.  Many IT folk have been there 10+ year, a
> > surprising number of them 20+ years.
> >
> > The flip side to the salary story is something of a paradox.
> >
> > As a person became more experienced, learned new technologies,
> > and as the company embraced more technologies, the employees
> > at times may not be paid commensurate with their abilities.
> >
> > I experienced that once. The only way to increase my earning
> > power was to leave.  My salary jumped 50% immediately.  This
> > has no doubt happened to a number of folks.
> >
> > The silly side of this is that the former employer then had
> > to hire a replacement at the going rate, or get a contractor in.
> >
> > Bottom line, they lose an experienced employee, and end up paying
> > as much or more as if they had tried to retain said employee.
> >
> > Jared
> >
> >
> > Jared
> >
> >
> > On Tue, 2003-08-26 at 18:04,
> [EMAIL PROTECTED]
> > wrote:
> > > I think a lot of IT people "abused" the situation during the boom
> days.
> > > Company loyalty meant nothing ... we'll go wherever the biggest
> paychecks
> > > are.  Don't stay anywhere too long. that's for losers.  Change
> jobs if
> we
> > > felt the least bit abused and unappreciated.  That'll teach them
> to
> screw
> > > with me!  In general a holier-than-thou attitude.  The times
> allowed us
> to
> > > do that.
> > >
> > > But it also means a lot of non-IT people developed an opinion of
> IT folk
> as
> > > not being team players, only out for themselves, not committed to
> the
> > > company, etc.
> > >
> > > So when the chance comes to cut back, where are you going to
> look?  :-)
> > >
> > > Dave
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author:
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Networ

RE: NEXT_EXTENT and PCT_INCREASE

Please re-read Wolfgang's response.

Your uniform size on the tablespace is 8 megs.

With an initial extent size on the table of 64m, it will
be allocated 8 extents on creation.

With LMT's with UES, it is best to just skip the initial
and next storage parameters, as they are of no benefit.

Jared

"Roger Xu" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 11:34 AM
 Please respond to ORACLE-L

        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: NEXT_EXTENT and PCT_INCREASE

First of all, thank you all for replying.
Jared is right, extent_id 0 is the first extent and it is 64M.
And the tablespace is locally-managed and auto-allocate.
The size of the table is 9652 MB. And it has 250 extents.
extent_id   size
-  -
0          64 MB
1-113       8 MB
114-249    64 MB

I just do not under stand the way Oracle allocate extents.
Specially when the table was created with initial_extent=1700MB.
Another question: Is it hurting performance with so many extents?

-Original Message-
Sent: Tuesday, August 26, 2003 9:09 PM
To: Multiple recipients of list ORACLE-L

Try executing "SELECT EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM
DBA_TABLESPACES WHERE TABLESPACE_NAME = ''"...

You should probably see the responses "LOCAL" and "SYSTEM", indicating that
the tablespace is locally-managed and auto-allocate...

on 8/26/03 4:44 PM, Roger Xu at [EMAIL PROTECTED] wrote:

> 
> Why the table was created with initial extent as 1700M,
> but dba_extents says the first extent is 8M only?
> 
> SQL> select initial_extent from dba_tables where table_name='BSIS';
>   1782579200
> 
> SQL> select bytes from dba_extents where segment_name='BSIS' and extent_id=1;
>  8388608
> 
> SQL> select bytes,count(*) from dba_extents where segment_name='BSIS' group by
> bytes;
>  8388608        113
> 67108864        137
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Roger, 
> 
> 1. Space management can be specified for a tablespace, not a segment. Create
> ASSM tablespace and alter table ... move there.
> 
> 2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
> PCT_INCREASE then.
> 
> HTH
> Vadim
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 3:59 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> I have the following output when I querying dba_tables.
> 
> Question 1: This table is created using manual management method, right?
>           What do I do in order to turn it to Automatic segment-space
> management?
> 
> Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?
> 
> Thanks,
> 
> Roger Xu
> 
> 
> PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS
> -- -- -- --
>       10         40          1        255
> 
> INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
> -- --- --- --- 
>    527491072                       1  2147483645
> 
> FREELISTS FREELIST_GROUPS
> -- ---
>        1               1
> 
> LOGGING BACKED_UP   NUM_ROWS
> --- - --
> YES     N          216122635
> 
>   BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT
> --  -- --
>  7651115         4307        319          0
> 
> 
> AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS
> --- - ---
>       254                      4496                   2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email Security System.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You ma

RE: Onames and various connections scenarios


Bob,

I was doing this on a Win2k client connecting to onames on Solaris.

This was with 8.1.7.4 on the client and 8.1.7.2 on the client.

Better check MetaLink.

Jared







"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 09:44 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Onames and various connections scenarios


Hello Jared
 
    I did not know that the client could call the "default" name server... from sqlnet.ora...  pretty cool.
However, there now seems to be some bugs (no..)
 
It seems the namesctl ignores the arg to use a user defined path eg a file does *not*  gets created in C:\temp
 BUT an *empty*  tnsnames files does get created in the %oracle_home%\network\admin
PROVIDING there is *not* an existing tnsnames there, if there is, namesctl simply creates a copy of the *existing* tnsnames with a .sav extension
!
Ive tested this on my machine running 8.1.7.4 all our client/user pcs here are 8.17 0r 8.16
 
Im running w2k pro on all our client  machines
 
maybe I discoverd a bug in Oracle! 
 
thanks!
bob

examples
 
namesctl dump_tnsnames c:\temp\tnsnames.txt 
creates the above scenario
 
the output
 
C:\>namesctl dump_tnsnames c:\temp\tnsnames.txt
 
Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 27-AUG-2003 11:31:39
 
(c) Copyright 1997 Oracle Corporation.  All rights reserved.
 
Currently managing name server "NS_CPSDB2"
Version banner is "Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Production"
 
 
 
 

No need to do it quite the way you are attempting. 

c:>  namesctl dump_tnsnames c:\temp\tnsnames.txt 

worked fine for me.   The default server is ns_ns1 

Had I wanted to do this from another server, say ns2, I would 
have gone directly into namesctl, then issued the command 
'set server ns_ns2' 

Jared 






"Bob Metelsky" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 08/26/2003 03:04 PM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        RE: Onames and various connections scenarios



No doubt im in the wrong ball field here but this is what I have

Windows 2k
Server1 Ns1 on 8.1.7.4
Server2 Ns2 on 9.2.0.1.0

[server1]
C:\> start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt
It creates an empty file on my (remote) machine

>From the server C:\> namesctl  dump_tnsnames C:\mytnsnames.txt it creats
an empty C:\mytnsnames.txt


[server2]
C:\> start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txt
And it creates an empty file on my (remote) machine

>From the server itself it creats a full C:\mytnsnames.txt file with all
the connect discriptors

How is this supposed to be called?

Thanks!

> Bob,
> 
> I understand what you are saying (and your pain). My 
> suggestion would be to use the 'namesctl dump_tnsnames' 
> command to dump out the current Onames repository to the PC's 
> $TNS_ADMIN dir via a login script or SMS. You might want o 
> rename the current TNSNAMES.ORA file just prior to that as 
> dump_tnsnames adds to the end of the current one and doesn't 
> handle changes very well.
> 
> Hth,
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
> 
> Grace - Getting something we do NOT deserve
> Mercy - NOT getting something we DO deserve
> Click on 'http://www.needhim.org' for Grace and Mercy that is 
> freely available!
> 
> ** The opinions and facts contained in this message are 
> entirely mine and do not reflect those of my employer or customers **
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 6:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello All
> 
>                  Im back from the trenches to post a quick request for 
> help
> 
> Ive setup onames on 2 servers and standard applications, (our app and
> sqlplus) connect just fine, a problem situation manifests itself when:
> 
> 1 users need to connect (add a database) to dba studio. They 
> get a error to the effect "cant resolve host name" And the 
> other 2. Users connect to remote databases (via vpn) that are 
> in our onames but many  of these vpn connections once made do 
> not allow access to
> *our* network resources.
> 
> So basically almost all of oour users have one or more of 
> these secenarios which means they will need to maintain a 
> tnsnames file as well.
> 
> I'm managing about 70+ connect discriptors And I was 
> hoping onames could be a centralised answer
> 
> Is this common? Or is there a workaround?
> 
> Thanks!
> bob
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bob Metelsky
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
>

RE: [Q] SQL Help!! How to make select left justify and fill space??


LOL!








"Mladen Gogala" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/27/2003 10:04 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: [Q] SQL Help!! How to make select left justify and fill space??


Use something like 

FORMAT STDOUT=
@  @>
$id,       $empname

Virtual Circuit Status

2003-08-27 Thread Erik Williams

Has anyone run into excessive waits on this event? After running my
statspack through oraperf.com, I see that I am waiting ~80% of response time
on this event. I have read on metalink that this is NOT an idle event, and
on asktom.oracle.com that it IS an idle event. We have MTS configured, but
all the clients are set to use dedicated server. Should I try reduce this
event by tuning MTS or is it truely an idle event?

Thanks
Erik
 




Erik Williams (E-mail).vcf
Description: Binary data

RE: RE: ERD to O-O

2003-08-27 Thread rgaffuri

thanks. didnt know about that one. 
> 
> From: "TOMPKINS, MARGARET" <[EMAIL PROTECTED]>
> Date: 2003/08/27 Wed PM 02:34:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: ERD to O-O
> 
> You may want to check out the ODTUG-RULES-L list.  Maggie
> 
> Respectfully,
> > Maggie Tompkins - DCII Integration
> > Technology Services Organization - Kansas City
> > Defense Finance and Accounting Service
> > 816-926-1117 (DSN 465); [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, August 27, 2003 10:40 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> is there a listserv for design? i know all the business rules guys post to 
> odtug-dev2k and des2k forums? 
> 
> 
> > 
> > From: "TOMPKINS, MARGARET" <[EMAIL PROTECTED]>
> > Date: 2003/08/27 Wed AM 11:24:33 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: ERD to O-O
> > 
> > Paul Dorsey wrote a great article on this and it appears in the September issue of 
> > the ODTUG Technical Journal.  Maggie
> > 
> > Respectfully,
> > > Maggie Tompkins - DCII Integration
> > > Technology Services Organization - Kansas City
> > > Defense Finance and Accounting Service
> > > 816-926-1117 (DSN 465); [EMAIL PROTECTED]
> > 
> > -Original Message-
> > Sent: Wednesday, August 27, 2003 10:04 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Melissa - Paul Dorsey of Dulican, Inc. has spoken on tools they have
> > developed in this area. Dulican's web address should be www.dulican.com
> >  , but I don't get a response.
> > 
> > 
> > 
> > Dennis Williams 
> > DBA, 80%OCP, 100% DBA 
> > Lifetouch, Inc. 
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Wednesday, August 27, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > I working on a development project that I'm trying to take an ERD an convert
> > it to object oriented.  Does anyone know a tool or path to follow to
> > accomplish this?
> >  
> > TIA
> > 
> > 
> > Jared Still <[EMAIL PROTECTED]> wrote:
> > 
> > 
> > Has anyone else noticed?
> > 
> > Not so long ago, we saw quite a few more questions about
> > such things as data modeling, application security architecture,
> > physical database design, and Oracle Designer
> > 
> > Not so much anymore. 
> > 
> > Do you think it's because there are so few development projects
> > taking place? Seems like in house development died with the
> > dot bomb and has not begun to recover.
> > 
> > I know at my place of employment there is very little development,
> > but that is due more to the size and nature of this place, as 
> > well as the management. ( they don't like in house development :( )
> > 
> > Now I spend my days with stuff like making NetBackup work with Oracle,
> > migrating SAP all over the place and keeping things running.
> > 
> > Not that we haven't always done those things, but I miss some
> > not having a good development project. Ah, to do! some real 
> > data modeling again.
> > 
> > Just some food for thought.
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jared Still
> > INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > 
> > 
> > 
> >   _  
> > 
> > Do you Yahoo!?
> > The New  
> > Yahoo! Search - Faster. Easier. Bingo.
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: TOMPKINS, MARGARET
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting service

RE: NEXT_EXTENT and PCT_INCREASE

2003-08-27 Thread Roger Xu

First of all, thank you all for replying.
Jared is right, extent_id 0 is the first extent and it is 64M.
And the tablespace is locally-managed and auto-allocate.
The size of the table is 9652 MB. And it has 250 extents.
extent_id   size
-  -
0  64 MB
1-113   8 MB
114-24964 MB

I just do not under stand the way Oracle allocate extents.
Specially when the table was created with initial_extent=1700MB.
Another question: Is it hurting performance with so many extents?

-Original Message-
Sent: Tuesday, August 26, 2003 9:09 PM
To: Multiple recipients of list ORACLE-L

Try executing "SELECT EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM
DBA_TABLESPACES WHERE TABLESPACE_NAME = ''"...

You should probably see the responses "LOCAL" and "SYSTEM", indicating that
the tablespace is locally-managed and auto-allocate...

on 8/26/03 4:44 PM, Roger Xu at [EMAIL PROTECTED] wrote:

> 
> Why the table was created with initial extent as 1700M,
> but dba_extents says the first extent is 8M only?
> 
> SQL> select initial_extent from dba_tables where table_name='BSIS';
>   1782579200
> 
> SQL> select bytes from dba_extents where segment_name='BSIS' and extent_id=1;
>  8388608
> 
> SQL> select bytes,count(*) from dba_extents where segment_name='BSIS' group by
> bytes;
>  8388608113
> 67108864137
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Roger, 
> 
> 1. Space management can be specified for a tablespace, not a segment. Create
> ASSM tablespace and alter table ... move there.
> 
> 2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and
> PCT_INCREASE then.
> 
> HTH
> Vadim
> 
> -Original Message-
> Sent: Tuesday, August 26, 2003 3:59 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> I have the following output when I querying dba_tables.
> 
> Question 1: This table is created using manual management method, right?
>   What do I do in order to turn it to Automatic segment-space
> management?
> 
> Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE?
> 
> Thanks,
> 
> Roger Xu
> 
> 
> PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS
> -- -- -- --
>   10 40  1255
> 
> INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
> -- --- --- --- 
>527491072   1  2147483645
> 
> FREELISTS FREELIST_GROUPS
> -- ---
>1   1
> 
> LOGGING BACKED_UP   NUM_ROWS
> --- - --
> YES N  216122635
> 
>   BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT
> --  -- --
>  7651115 4307319  0
> 
> 
> AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS
> --- - ---
>   254  4496   2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

For technical support please email [EMAIL PROTECTED] or you can
call (972)721-8257. 
This email has been scanned for all viruses by the MessageLabs Email Security System.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: perl/shell script for alert log

2003-08-27 Thread Jose Luis Delgado

HTH

#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.

# You should pass name of ORACLE_SID as a parameter.

#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors,  e-mails depending on the error.

# Parameter: ORACLE_SID
# ---
#
#

DIR=/u01/app/oracle/admin
ORACLE_SID=$1
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_HOME

ALERT_DEST=/u01/app/oracle/admin/${ORACLE_SID}/bdump
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin
export PATH

COLLECTOR=`tail -100
$ALERT_DEST/alert_${ORACLE_SID}.log |grep "ORA-"`
if [ "$COLLECTOR" <> "" ]
then
echo ""
echo " Errors found in:   >
$ALERT_DEST/alert_${ORACLE_SID}.log"
echo ""
echo $COLLECTOR
echo ""
fi;

--- AK <[EMAIL PROTECTED]> wrote:
>  I am sure you guys might have some nice perl/shell
> script to analyze alert log for errors or potential
> problem . Can you share it with me /list .
> 
> Ohh thanks in advance guys .
> 
> -ak
> 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: ERD to O-O

2003-08-27 Thread TOMPKINS, MARGARET

You may want to check out the ODTUG-RULES-L list.  Maggie

Respectfully,
> Maggie Tompkins - DCII Integration
> Technology Services Organization - Kansas City
> Defense Finance and Accounting Service
> 816-926-1117 (DSN 465); [EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, August 27, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


is there a listserv for design? i know all the business rules guys post to odtug-dev2k 
and des2k forums? 


> 
> From: "TOMPKINS, MARGARET" <[EMAIL PROTECTED]>
> Date: 2003/08/27 Wed AM 11:24:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: ERD to O-O
> 
> Paul Dorsey wrote a great article on this and it appears in the September issue of 
> the ODTUG Technical Journal.  Maggie
> 
> Respectfully,
> > Maggie Tompkins - DCII Integration
> > Technology Services Organization - Kansas City
> > Defense Finance and Accounting Service
> > 816-926-1117 (DSN 465); [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Wednesday, August 27, 2003 10:04 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Melissa - Paul Dorsey of Dulican, Inc. has spoken on tools they have
> developed in this area. Dulican's web address should be www.dulican.com
>  , but I don't get a response.
> 
> 
> 
> Dennis Williams 
> DBA, 80%OCP, 100% DBA 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, August 27, 2003 9:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I working on a development project that I'm trying to take an ERD an convert
> it to object oriented.  Does anyone know a tool or path to follow to
> accomplish this?
>  
> TIA
> 
> 
> Jared Still <[EMAIL PROTECTED]> wrote:
> 
> 
> Has anyone else noticed?
> 
> Not so long ago, we saw quite a few more questions about
> such things as data modeling, application security architecture,
> physical database design, and Oracle Designer
> 
> Not so much anymore. 
> 
> Do you think it's because there are so few development projects
> taking place? Seems like in house development died with the
> dot bomb and has not begun to recover.
> 
> I know at my place of employment there is very little development,
> but that is due more to the size and nature of this place, as 
> well as the management. ( they don't like in house development :( )
> 
> Now I spend my days with stuff like making NetBackup work with Oracle,
> migrating SAP all over the place and keeping things running.
> 
> Not that we haven't always done those things, but I miss some
> not having a good development project. Ah, to do! some real 
> data modeling again.
> 
> Just some food for thought.
> 
> Jared
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jared Still
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
>   _  
> 
> Do you Yahoo!?
> The New  
> Yahoo! Search - Faster. Easier. Bingo.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: TOMPKINS, MARGARET
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PRO

International Language Support Experiences?

2003-08-27 Thread David Wagoner

Title: International Language Support Experiences?





We have a new requirement to support multiple languages in at least one of our databases.  I'm reading the Oracle 9iR2 Globalization Support Guide (450 pages), but wonder if any of you can share real-life experiences regarding:

1.  the conversion of existing DBs to broader character sets
2.  using Unicode
3.  implementing this with 9iAS


Our databases currently use US7ASCII with the American character set, but we will likely need to support European, Southeast Asian, and South American languages.


Thanks.



Best regards,


David B. Wagoner
Database Administrator
Arsenal Digital Solutions

RE: FW: Instance crash

2003-08-27 Thread Srinivas_Maddali

TAR is soft closed

-Original Message-
Sent: Wednesday, August 27, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L

oracle core dumped, call support

[EMAIL PROTECTED] wrote:

>  
>
>> -Original Message-
>>From: Maddali, Srinivas (Card Services)  
>>Sent: Wednesday, August 27, 2003 12:39 PM
>>To:   '[EMAIL PROTECTED]'
>>Subject:  Instance crash
>>
>>The database Instance Crashed with therrors captured by alert log
>>
>>Mon Aug 25 17:57:51 2003
>>ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], 
>>[], [], []
>>Mon Aug 25 17:57:52 2003
>>ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], 
>>[], [], []
>>Mon Aug 25 17:57:52 2003
>>ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], 
>>[], [], []
>>Mon Aug 25 17:57:58 2003
>>ORA-07445: exception encountered: core dump [] [] [] [] [] []
>>Mon Aug 25 17:58:07 2003
>>ORA-07445: exception encountered: core dump [] [] [] [] [] []
>>Mon Aug 25 18:01:07 2003
>>ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
>>[], [], []
>>Mon Aug 25 18:01:08 2003
>>ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
>>[], [], []
>>Mon Aug 25 18:01:08 2003
>>ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
>>[], [], []
>>Mon Aug 25 18:01:10 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
>>Mon Aug 25 18:01:10 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
>>Mon Aug 25 18:01:18 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
>>Mon Aug 25 18:01:28 2003
>>ORA-07445: exception encountered: core dump [] [] [] [] [] []
>>Mon Aug 25 18:10:38 2003
>>ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
>>
>>
>>What this means to me
>>
>>Pl let me know
>>Thanks
>>Srinivas
>>
>>
>
>
>**
>This transmission may contain information that is privileged, confidential and/or 
>exempt from disclosure under applicable law. If you are not the intended recipient, 
>you are hereby notified that any disclosure, copying, distribution, or use of the 
>information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. 
>If you received this transmission in error, please immediately contact the sender and 
>destroy the material in its entirety, whether in electronic or hard copy format. 
>Thank you
>**
>
>  
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

**
This transmission may contain information that is privileged, confidential and/or 
exempt from disclosure under applicable law. If you are not the intended recipient, 
you are hereby notified that any disclosure, copying, distribution, or use of the 
information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. 
If you received this transmission in error, please immediately contact the sender and 
destroy the material in its entirety, whether in electronic or hard copy format. Thank 
you
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Free Training

2003-08-27 Thread rgaffuri

its almost always really low grade stuff. 
> 
> From: "Post, Ethan" <[EMAIL PROTECTED]>
> Date: 2003/08/27 Wed PM 02:09:34 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Free Training
> 
> Anyone been contacted recently by Oracle with the offer of "free" training
> through their http://oracledirect.oracle.com/iccdocs/seminarList.shtml
>   website?
>  
> Is it all sales meterial?  Is this part of a bigger customer retention move?
>  
> Your thoughts.
>  
> Greatly appreciated,
> Ethan
> 
> 
Title: Message



Anyone been 
contacted recently by Oracle with the offer of "free" training through their http://oracledirect.oracle.com/iccdocs/seminarList.shtml website?
 
Is it all 
sales meterial?  Is this part of a bigger customer retention 
move?
 
Your 
thoughts.
 
Greatly 
appreciated,
Ethan

sql optimization question

2003-08-27 Thread Guang Mei

Hi,

This query took a few minues to return 126K rows (fast):

select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubmedid = l.identifier
and externaldbid = 9;

But this query took hours and still no result, I had to kill it:

select distinct n.cognateid, m.isirefid,4, linkdate
from mt.externallink l, refidmatch m, nametag n
where l.objectid = n.geneid
and m.pubmedid = l.identifier
and externaldbid = 9
and (select count(distinct objectid) from mt.externallink k
 where k.identifier = l.identifier
 and externaldbid = 9
 and l.objectid !=k.objectid)<5;


All the related columns are indexed and table are analyzed. Is there a way
to re-write the part

select count(distinct objectid) from mt.externallink k
 where k.identifier = l.identifier
 and externaldbid = 9
 and l.objectid !=k.objectid)<5

to make the whole thing faster?

TIA.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: FW: Instance crash

2003-08-27 Thread Joe Testa

oracle core dumped, call support

[EMAIL PROTECTED] wrote:

 

-Original Message-
From: 	Maddali, Srinivas (Card Services)  
Sent:	Wednesday, August 27, 2003 12:39 PM
To:	'[EMAIL PROTECTED]'
Subject:	Instance crash

The database Instance Crashed with therrors captured by alert log

Mon Aug 25 17:57:51 2003
ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], [], 
[], []
Mon Aug 25 17:57:52 2003
ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], [], 
[], []
Mon Aug 25 17:57:52 2003
ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], [], 
[], []
Mon Aug 25 17:57:58 2003
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Mon Aug 25 17:58:07 2003
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Mon Aug 25 18:01:07 2003
ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
[], [], []
Mon Aug 25 18:01:08 2003
ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
[], [], []
Mon Aug 25 18:01:08 2003
ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
[], [], []
Mon Aug 25 18:01:10 2003
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
Mon Aug 25 18:01:10 2003
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
Mon Aug 25 18:01:18 2003
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
Mon Aug 25 18:01:28 2003
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Mon Aug 25 18:10:38 2003
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
What this means to me

Pl let me know
Thanks
Srinivas
   



**
This transmission may contain information that is privileged, confidential and/or 
exempt from disclosure under applicable law. If you are not the intended recipient, 
you are hereby notified that any disclosure, copying, distribution, or use of the 
information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. 
If you received this transmission in error, please immediately contact the sender and 
destroy the material in its entirety, whether in electronic or hard copy format. Thank 
you
**
 

--
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Windows 2000 Server and processor recommendations

Title: Message



On the other hand, 32bit Oracle will never be able 
to use all of your 4GB of memory. Even on linux you have to play around with 
lowering the SGA base address manually when want to use more than 1,7GB for SGA. 
And you can't go past about 2,2-2,3GB anyway. So, rest of your memory will be 
spent on doublecaching on filesystem.
 
Tanel.
 

  - Original Message - 
  From: 
  Mladen 
  Gogala 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, August 27, 2003 8:54 
  PM
  Subject: RE: Windows 2000 Server and 
  processor recommendations
  
  Dual 2.4 GHZ would be better 
  because at that bus speed you cannot really use your RAM. Unless you have huge 
  CPU cache,  
  you're bound to experience 
  wait states while your CPU is fetching memory. RAM speeds are are around 
  50ns  and CPU cycles
  happen one in 0.3ns.  
  The difference in speed is approximately 100 times.  You must have very 
  smart on CPU board cache
  in order to atone for 
  that.  Furthermore, in order to help CA economy, I'd go with Red Hat, if 
  I had a choice. Using Apache/Tomcat
  on an NT box is half the fun 
  of running it on a Linux box. 
   
   
  --Mladen GogalaOracle DBA 
  

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Shannon St. 
DennisSent: Wednesday, August 27, 2003 1:30 PMTo: 
Multiple recipients of list ORACLE-LSubject: Windows 2000 Server 
and processor recommendations
We are going to be installing a small web application in our DMZ.  
The application was built using JSP, running on an Apache/tomcat 
configuration. The back end is small (< 1Gb) oracle standard edition 
database (v9.2.0)
 
We are going to run this on a dual-processor dell server.  There 
will be lots of OLTP (online lookups) but the actual transaction is very 
small (enter an address and it tells you where your polling station 
is).
 
We have several options for configuring the server.  What would be 
better?
 
a) Dual Xeon 3.06GHz w/1M cache and 2GB Ram: $8,423
d) Dual Zeon 2.4Ghz w/512K cache and 4Gb Ram : $8,872
 
is it better to skimp slightly on the cpu's and go for more ram (ie. 
caching more)?
 
 
Thanks for any info.
 
 
Shannon
 
Shannon St. DennisDatabase AdministratorCity of Regina(306) 
777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] 
 
The degree of normality in a database is inversely proportional to that 
of its DBA
   
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any mistransmission.  
  If you receive this message in error, please immediately delete it and 
  all copies of it from your system, destroy any hard copies of it and notify 
  the sender.  You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. Wang Trading 
  LLC and any of its subsidiaries each reserve the right to 
  monitor all e-mail communications through its networks.  Any views 
  expressed in this message are those of the individual sender, except where the 
  message states otherwise and the sender is authorized to state them to be the 
  views of any such entity.

RE: Windows 2000 Server and processor recommendations

2003-08-27 Thread Mercadante, Thomas F




Shannon.
 
How much is a Dual 
Xeon 3.06GHz w/1M cache and 4GB Ram?
 
Seems to me that if 
you can afford the higher priced but slower cpu model, that the additional Ram 
can not be that much more.  Basically, if you can afford $8800, can you 
afford an additional $x to add 2 GB of Ram to the 3.06GHz box?  Memory is 
cheap!
 
Otherwise, I would 
buy the faster machine in hopes that you can afford a memory upgrade sometime 
soon.
 
Hope this 
helps.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Shannon St. Dennis 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 1:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Windows 2000 Server and processor recommendations
  We are going to be installing a small web application in our DMZ.  
  The application was built using JSP, running on an Apache/tomcat 
  configuration. The back end is small (< 1Gb) oracle standard edition 
  database (v9.2.0)
   
  We are going to run this on a dual-processor dell server.  There 
  will be lots of OLTP (online lookups) but the actual transaction is very small 
  (enter an address and it tells you where your polling station is).
   
  We have several options for configuring the server.  What would be 
  better?
   
  a) Dual Xeon 3.06GHz w/1M cache and 2GB Ram: $8,423
  d) Dual Zeon 2.4Ghz w/512K cache and 4Gb Ram : $8,872
   
  is it better to skimp slightly on the cpu's and go for more ram (ie. 
  caching more)?
   
   
  Thanks for any info.
   
   
  Shannon
   
  Shannon St. DennisDatabase AdministratorCity of Regina(306) 
  777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] 
   
  The degree of normality in a database is inversely proportional to that 
  of its DBA

Free Training

Title: Message



Anyone been 
contacted recently by Oracle with the offer of "free" training through their http://oracledirect.oracle.com/iccdocs/seminarList.shtml website?
 
Is it all 
sales meterial?  Is this part of a bigger customer retention 
move?
 
Your 
thoughts.
 
Greatly 
appreciated,
Ethan

oracle sessions from term server

2003-08-27 Thread AK




Hi Guys ,
we have forms/report application installed on  
windows terminal servers and user access application from these terminal servers 
. When some session hangs on these term server  adminstrator resets those 
sessions . But the corresponding database session remains alive . 
Is it s problem with some sql*net setting ?? Any 
help in this regard is highly appreciated .
 
thanks,
-ak

FW: Instance crash

2003-08-27 Thread Srinivas_Maddali



>  -Original Message-
> From: Maddali, Srinivas (Card Services)  
> Sent: Wednesday, August 27, 2003 12:39 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  Instance crash
> 
> The database Instance Crashed with therrors captured by alert log
> 
> Mon Aug 25 17:57:51 2003
> ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], 
> [], [], []
> Mon Aug 25 17:57:52 2003
> ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], 
> [], [], []
> Mon Aug 25 17:57:52 2003
> ORA-00600: internal error code, arguments: [ksfq_cre2], [0x11027CEB8], [], [], [], 
> [], [], []
> Mon Aug 25 17:57:58 2003
> ORA-07445: exception encountered: core dump [] [] [] [] [] []
> Mon Aug 25 17:58:07 2003
> ORA-07445: exception encountered: core dump [] [] [] [] [] []
> Mon Aug 25 18:01:07 2003
> ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
> [], [], []
> Mon Aug 25 18:01:08 2003
> ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
> [], [], []
> Mon Aug 25 18:01:08 2003
> ORA-00600: internal error code, arguments: [ksfqsubmit1], [0x11027CEB8], [], [], [], 
> [], [], []
> Mon Aug 25 18:01:10 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
> Mon Aug 25 18:01:10 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
> Mon Aug 25 18:01:18 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
> Mon Aug 25 18:01:28 2003
> ORA-07445: exception encountered: core dump [] [] [] [] [] []
> Mon Aug 25 18:10:38 2003
> ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
> 
> 
> What this means to me
> 
> Pl let me know
> Thanks
> Srinivas


**
This transmission may contain information that is privileged, confidential and/or 
exempt from disclosure under applicable law. If you are not the intended recipient, 
you are hereby notified that any disclosure, copying, distribution, or use of the 
information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. 
If you received this transmission in error, please immediately contact the sender and 
destroy the material in its entirety, whether in electronic or hard copy format. Thank 
you
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Windows 2000 Server and processor recommendations

Title: Message



Dual 2.4 GHZ would be better 
because at that bus speed you cannot really use your RAM. Unless you have huge 
CPU cache,  
you're bound to experience wait 
states while your CPU is fetching memory. RAM speeds are are around 50ns  
and CPU cycles
happen one in 0.3ns.  The 
difference in speed is approximately 100 times.  You must have very smart 
on CPU board cache
in order to atone for 
that.  Furthermore, in order to help CA economy, I'd go with Red Hat, if I 
had a choice. Using Apache/Tomcat
on an NT box is half the fun of 
running it on a Linux box. 
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Shannon St. 
  DennisSent: Wednesday, August 27, 2003 1:30 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Windows 2000 Server 
  and processor recommendations
  We are going to be installing a small web application in our DMZ.  
  The application was built using JSP, running on an Apache/tomcat 
  configuration. The back end is small (< 1Gb) oracle standard edition 
  database (v9.2.0)
   
  We are going to run this on a dual-processor dell server.  There 
  will be lots of OLTP (online lookups) but the actual transaction is very small 
  (enter an address and it tells you where your polling station is).
   
  We have several options for configuring the server.  What would be 
  better?
   
  a) Dual Xeon 3.06GHz w/1M cache and 2GB Ram: $8,423
  d) Dual Zeon 2.4Ghz w/512K cache and 4Gb Ram : $8,872
   
  is it better to skimp slightly on the cpu's and go for more ram (ie. 
  caching more)?
   
   
  Thanks for any info.
   
   
  Shannon
   
  Shannon St. DennisDatabase AdministratorCity of Regina(306) 
  777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] 
   
  The degree of normality in a database is inversely proportional to that 
  of its DBA
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

Re: materialized views - please help

2003-08-27 Thread Sai Selvaganesan

arup
 
the bug says it is fixed in 9. i run 9.2.0.4 on windows 2k.
 
still having this issue. 
 
these invalid mvs affect the performance. 
 
thanks
saiArup Nanda <[EMAIL PROTECTED]> wrote:





Sai,
 
You may want to check bug# 1188948; it sounds like your case.
 
HTH.
 
Arup

- Original Message - 
From: Sai Selvaganesan 
To: Multiple recipients of list ORACLE-L 
Sent: Tuesday, August 26, 2003 9:04 PM
Subject: materialized views

hi
 
materialized views become invalid as soon as a complete or fast refresh of the mv is done. is this how it is supposed to work?
the status is invalid in dba_objects and is set to 'N' in dba_mview_analysis. i have been struggling to understand this. i read thru few docs on metalink which talk about query rewrite enabled blah..blah.. but nothing seems to work.
can some tell me what has to be done. it is mandatory for me to validate the mvs after every refresh..
 
thanks
sai

Windows 2000 Server and processor recommendations

2003-08-27 Thread Shannon St. Dennis




We are going to be installing a small web application in our DMZ.  The 
application was built using JSP, running on an Apache/tomcat configuration. The 
back end is small (< 1Gb) oracle standard edition database (v9.2.0)
 
We are going to run this on a dual-processor dell server.  There will 
be lots of OLTP (online lookups) but the actual transaction is very small (enter 
an address and it tells you where your polling station is).
 
We have several options for configuring the server.  What would be 
better?
 
a) Dual Xeon 3.06GHz w/1M cache and 2GB Ram: $8,423
d) Dual Zeon 2.4Ghz w/512K cache and 4Gb Ram : $8,872
 
is it better to skimp slightly on the cpu's and go for more ram (ie. 
caching more)?
 
 
Thanks for any info.
 
 
Shannon
 
Shannon St. DennisDatabase AdministratorCity of Regina(306) 
777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] 
 
The degree of normality in a database is inversely proportional to that of 
its DBA

RE: ERD to O-O

2003-08-27 Thread M.Godlewski

Thanks to all for your help.  I figured there was a way to do it, but didn't know where to look.Stephane Faroult <[EMAIL PROTECTED]> wrote:
dulcian, not dulican :-)>- --- Original Message --- ->From: DENNIS WILLIAMS <[EMAIL PROTECTED]>>To: Multiple recipients of list ORACLE-L><[EMAIL PROTECTED]>>Sent: Wed, 27 Aug 2003 07:04:28>>Melissa - Paul Dorsey of Dulican, Inc. has spoken>on tools they have>developed in this area. Dulican's web address>should be www.dulican.com> , but I don't get a>response.Dennis Williams >DBA, 80%OCP, 100% DBA >Lifetouch, Inc. >[EMAIL PROTECTED] >>-Original Message->Sent: Wednesday, August 27, 2003 9:44 AM>To: Multiple recipients of list ORACLE-L>>>I working on a development project that I'm trying>to take an ERD an convert>it t!
o object
 oriented. Does anyone know a tool or>path to follow to>accomplish this?> >TIA>>>Jared Still <[EMAIL PROTECTED]>wrote:>>>Has anyone else noticed?>>Not so long ago, we saw quite a few more questions>about>such things as data modeling, application security>architecture,>physical database design, and Oracle Designer>>Not so much anymore. >>Do you think it's because there are so few>development projects>taking place? Seems like in house development died>with the>dot bomb and has not begun to recover.>>I know at my place of employment there is very>little development,>but that is due more to the size and nature of this>place, as >well as the management. ( they don't like in house>development :( )>>Now I spend my days with stuff like making>NetBa!
ckup work
 with Oracle,>migrating SAP all over the place and keeping things>running.>>Not that we haven't always done those things, but I>miss some>not having a good development project. Ah, to do!>some real >data modeling again.>>Just some food for thought.>>Jared>-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane FaroultINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HE!
LP
 command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

RE: Grid

2003-08-27 Thread MacGregor, Ian A.

We've been talking of Grid computing here since either late 1999 or early 2000.  The 
computing for our main experiment was designed before the Grid was contemplated.  
Still we have implemented some of the middleware needed, and build methods of 
authentication and authorization, and participated in Grid experiments. We have also 
been pushing the ability to transfer large amounts of data.  The latest effort: 2.3 GB 
per second between the local internet hub and Geneva Switzerland over Internet 2.  
This is vital to make the Grid work.

I was looking at the papers from the last Computing in High Energy Physics conference. 
 I'd estimate that over half dealt with the Grid.  Nearly all had to do with test beds 
or implementation standards.  But the AMANDA experiment, Antarctic Muon and Neutrino 
Detector Array, is using the Grid in production.  The AMANDA  instrument is situated 
at the South Pole.

In 1990 if had mentioned the web very few would have heard of it, but within a few 
years URL's were ubiquitous.  Oracle was very slow in adapting to the web.Perhaps 
this time they want to be avant garde.  I don't know how the Grid is to work in the 
business environment.  Major scientific collaborations include universities and HEP 
labs from numerous countries working towards the same goals including the sharing of 
computer resources.  I doubt Pepsi would share its resources with Coke.  Will we have 
the cokegrid, the pepsigrid, etc.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, August 26, 2003 2:49 AM
To: Multiple recipients of list ORACLE-L


Although I haven't got into the technical details of 'The Grid' (and thanks for this 
article - I shall read it), but nevertheless I have a haunting sense of deja vu. 
Remember all the hype over distributed computing that Oracle generated? Remember the 
key part client-server was of that? Remember what Ellison said about that? ('The 
biggest mistake we ever made' - I was there, I heard him say it). So. I'm just 
wondering how this particular circle is going to be squared...

peter
edinburgh


-Original Message-
Sent: Monday, August 25, 2003 7:10 PM
To: Multiple recipients of list ORACLE-L


While I was cleaning up the other day, I noticed a magazine sticking out of the middle 
(sadly, closer to the top) of my still-to-be-read list. The cover story of Physics 
Today (Feb. 2002) is "The Power of Grid Computing". It is a pretty good review article 
on the subject. If anyone is interested, the URL is 
http://www.aip.org/pt/vol-55/iss-2/p42.html

The major point seems to be that the grid is simply just a way to share distributed 
resources. However, utilizing these resources needs an infrastructure in place. It 
"requires uniform mechanisms for such critical tasks as creating and managing services 
on remote computers, supporting single sign-on to distributed resources, transferring 
large datasets at high speeds, forming large distributed virtual communities, and 
maintaining information about the existence, state, and usage policies of community 
resources...Providing the infrastructure and tools that make large-scale, secure 
resource sharing possible and straight-forward is the Grid's raison d'etre."

In addition, this means that computing resources can be parcelled out like a utility. 
If you need extra CPU, buy it and use it from your utility when you need it. You don't 
need to own the hardware for your peak load. It also becomes easier to share data and 
applications between colleagues at different locations.

I can see how databases are part of this picture, but I am not sure how Oracle will 
try and place itself at the center of this trend (unless they mangle the concept of 
Grid in the process).

Henry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 
removed from).  You may also send the HELP command for other information (like 
subscribing).


*
This  e-mail  message,  and  any  files  transmitted  with  it, are confidential  and 
intended  solely for the  use of the  addressee. If this message was not addressed to  
you, you have received it in error and any  copying,  distribution  or  other use  of 
any part  of it is strictly prohibited. Any views or opinions presented are solely 
those of the sender and do not necessarily represent  those of the British Geological  
Survey. The  security of e-mail  commu

anybody got an improved 'DESC' procedure?

2003-08-27 Thread Pardee, Roy E

Does anybody have a sproc or script they'd care to share that improves on the DESCRIBE 
command?  Specifically, I would like to see table and column level comments.  Check 
constraint search conditions would be a bonus...

Thanks!

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: in case anyone missed it

2003-08-27 Thread April Wells

Title: RE: in case anyone missed it





You have to, Bill... I'm dying to meet you.


And as for the heckling... just be glad that no one slept through yours 


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 27, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: in case anyone missed it



Joe Testa  scribbled on the wall in glitter crayon:


> been there, done that, its not near as bad as it seems, the attendees
> dont want you to fail, they want to learn something, so most of them
> are quite supportive.


i was there for at least one of them.;-)  i think i might have even heckled
a little.;-)


i know, i'm even working on an outline to submit.  just don't know if i
really will or not.;-)


--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
    [EMAIL PROTECTED]

You can't get where you want to go if you don't know where you are.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: Bounced from the list

2003-08-27 Thread Igor Neyman

It happens, if your mail-server is unavailable/down for extended period
of time.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
GL2Z/ INF DBA BENLATRECHE
Sent: Wednesday, August 27, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L

Hi all,

I have been  bounced  twice from the list since  July. 
I don't know the reason why ?.

I re-subscribe this morning and I am afraid to be bounced again ?

The listmaster have been contacted  without a feedback.

Is this happened to someone else ?

And what to do ???

Regards
Kamel Benlatreche


  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ERD to O-O

2003-08-27 Thread M.Godlewski

Thanks! I'll check google for the link."TOMPKINS, MARGARET" <[EMAIL PROTECTED]> wrote:
Paul Dorsey wrote a great article on this and it appears in the September issue of the ODTUG Technical Journal. MaggieRespectfully,> Maggie Tompkins - DCII Integration> Technology Services Organization - Kansas City> Defense Finance and Accounting Service> 816-926-1117 (DSN 465); [EMAIL PROTECTED]-Original Message-Sent: Wednesday, August 27, 2003 10:04 AMTo: Multiple recipients of list ORACLE-LMelissa - Paul Dorsey of Dulican, Inc. has spoken on tools they havedeveloped in this area. Dulican's web address should be www.dulican.com, but I don't get a response.Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Wednesday, August 27, 2003 9:44 AMTo: Multiple recipients!
of list
ORACLE-LI working on a development project that I'm trying to take an ERD an convertit to object oriented. Does anyone know a tool or path to follow toaccomplish this?TIAJared Still <[EMAIL PROTECTED]>wrote:Has anyone else noticed?Not so long ago, we saw quite a few more questions aboutsuch things as data modeling, application security architecture,physical database design, and Oracle DesignerNot so much anymore. Do you think it's because there are so few development projectstaking place? Seems like in house development died with thedot bomb and has not begun to recover.I know at my place of employment there is very little development,but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( )Now I spend my days with stuff like making NetBackup work with Oracle,migrating SAP all over th!
e place
and keeping things running.Not that we haven't always done those things, but I miss somenot having a good development project. Ah, to do! some real data modeling again.Just some food for thought.Jared-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jared StillINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing)._ Do you Yahoo!?!
The New
Yahoo! Search - Faster. Easier. Bingo.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: TOMPKINS, MARGARETINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538!
-5051
http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

perl/shell script for alert log

2003-08-27 Thread AK




 I am sure you guys might have some nice 
perl/shell script to analyze alert log for errors or potential problem . Can you 
share it with me /list .
 
Ohh thanks in advance guys .
 
-ak

RE: in case anyone missed it

2003-08-27 Thread Loughmiller, Greg

Title: RE: in case anyone missed it

tell everyone "beer after the presentation"

-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 27, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: in case anyone missed it

been there, done that, its not near as bad as it seems, the attendees 
dont want you to fail, they want to learn something, so most of them are 
quite supportive.

joe

Thater, William wrote:

>Joe Testa  scribbled on the wall in glitter crayon:
>
>  
>
>>IOUG-2004 conference call for papers is open.
>>    
>>
>
>one just has to be crazy enough to stand in front of a room filled with
>people LOOKING AT YOU, and present.;-)
>
>--
>Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
>    [EMAIL PROTECTED]
>
>Nothing great was ever achieved without enthusiasm. - Ralph Waldo Emerson
>  
>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: [Q] SQL Help!! How to make select left justify and fill space??