date:20020115


We don't use OEM.

We have SQLab from Quest.
We have TOAD from Quest.
We have SpotLight from Quest. 
We have StorageXpert from Quest (it does not work with Oracle Names and
Oracle 9i client, yet. I am waiting for Gaja to return from his much
deserved vacation to fix this problem, now that we are a paying Customer ;-)


We have PATROL from BMC. 


And...
we have a bunch of our own scripts... that we can very easily change when
new Oracle versions or features are installed or utilized. I hate being the
'tester' for these high priced 3rd party tools that do not keep up with new
features/versions of Oracle. Although almost all say that they are 'business
partners' with Oracle and have access to new releases before us peasants get
it...but... 

- Kirti 
 

-Original Message-
Sent: Tuesday, January 15, 2002 5:35 PM
To: Multiple recipients of list ORACLE-L


 DBA gurus,

   I am just curious about what the performance tuning and monitoring
tools you are using besides OEM. Your sharing is highly appreciated.

Chuan Zhang

Oracle DBA



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: How to set DBWR_WRITE_PROCESSES in Oracle8i?

2002-01-15 Thread Paul Drake

CC Harvest wrote:

> Hi, gurus:
>The database is oracle8.1.7.2.1 on win2k machine 
> with 1 CPU and two hard drives.  When I query
> v$waitstat, I got the following:
> 
> CLASS   COUNT   TIME
> -- -- --
> data block  246901435  132690159
> segment header   4869   8018
> undo block  20986  38476
> undo header  1895   1556
> 
> seems like I need to set DBWR_WRITE_PROCESSES to a
> higher number, what number should I choose, 2 or
> bigger?
> 
> Also, what other problems can you see from the last
> query, other than we need to add some more RBS?
> 
> Thanks,
> 
> Chris Harvest.

Chris,

Is most of the I/O to the datafiles reads or writes.
DBWR will not help with the waits on disk reads.

Do you mean that the entire server has only 2 hard drives?
If so, adding a 2nd DBWR process will at best be a wash.
With a single CPU, it is not a good idea.
What are your other wait events relating to I/O?
I'll bet that you also see waits in the LGWR process.
Assume the following config:

drive 0
C:  4.0GB   OS, swap (pagefile is after 1 GB of OS files)
D:  4.7GB   OraHome, online redo (redo logs are after 1 GB)
drive 1
E:  8.7 GB  Oradata

All datafiles here are on the 2nd hard drive, OS, Oracle binaries and 
online redo are on the first hard drive. NOARCHIVELOG mode is used.

If the system is accessing any files on C: (like the pagefile) you have 
a seek operation on the drive of at least half the drive radius (>4GB) 
before you can write to the online redo logs.

Lets also assume that you have 5 GB of datafiles, with system being 
outermost (created first), and your index tablespaces being innermost, 
(created last) rbs and user_data in between. Anytime you have to access 
the system datafile, you're into a half drive radius seek again. These 
waits would be on the order of 1 centisecond for a queue depth of 1. 
Multiply that value by your average queue depth for the device.

What you need to determine is:

Is it waiting on mostly reads or writes?
- If reads, increasing db_block_buffers may be of some help, but not it 
it leads to swapping.
- If reads, is it due to full table scans (excessive block fetches)?
Maybe your code selects all columns from all tables involved in a query, 
when a smaller number of columns selected could be included in an index.

So you'll want to examine the I/O by datafile and by read/write 
characteristics. If you cannot add any hard drives (this seems like a 
home learning system) then you can at least put the most accessed files 
together on the fastest part of the hard drive (to minimize seek time). 
If you are not producing much redo, you might want to move some 
datafiles to the first hard drive, but this is likely to drive your wait 
events for LGWR up. If you are using the pagefile, this will not likely 
help performance (see above).

Back in 8.1.7.1.5 - I experienced ORA-00600s with a DBWR crash with 
multple DBWRn processes. I have seen both "Its supported" and "Its not 
supported" posts for mulitple DBWRn processes on NT/W2K - but I would 
refrain from using them. With only 2 hard drives - you're not solving 
the problem increasing the number of DBWRs.

Add drives, segregate datafiles or stripe.
Your waits on RBS headers are likely due to simple I/O waits on an 
over-utilized storage subsystem. Different symptom, same problem.

Btw, are your statistics up to date?

hth,

Paul

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

[no subject]

2002-01-15 Thread Evan Tate

Nah, "Zen in the Art of Archery" was the real deal - it predates ZATAOMM by 
quite a few years...

"Mohan, Ross" <[EMAIL PROTECTED]> wrote:

you oughta apologize to Robert Pirsig, the guy who started the whole thing.

-Original Message-
Sent: Tuesday, January 15, 2002 12:35 PM
To: Multiple recipients of list ORACLE-L

[EMAIL PROTECTED] wrote:

>oh, now I owe you a royalty for naming a new book "Zen and the Art of
>Database Administration" (my apologies to the author of Zen and the Art
>of Archery)
>
somehow i don't think he'll mind.;-)

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: How to set DBWR_WRITE_PROCESSES in Oracle8i?


How long has the instance been up?

It appears that the application is trying to read the same data blocks &/or
more sessions are trying to update the same data block or the free lists may
need to be set properly to support concurrent INSERTs. 
 
So, before changing anything for DBWR process, I would suggest to check the
top wait events from V$SYSTEM_EVENT view. You may see high waits for 'buffer
busy wait' event. If so, I would trace it further using V$SESSION_EVENT and
V$SESSION_WAIT (P1, P2 values) to find out the 'hot' segment and the file.
You may have to review the pctfree, freelists, extent sizes etc. to address
'buffer busy waits'. 

For all you know, it could be just an application issue in scheduling the
processes properly.

And to answer your question about setting DBWR_WRITE_PROCESSES(actually the
parameter is DB_WRITER_PROCESSES) you may want to check out Note# 97291.1 on
Metalink. It has some good information. 

HTH,

- Kirti 


-Original Message-
Sent: Tuesday, January 15, 2002 7:16 PM
To: Multiple recipients of list ORACLE-L


Hi, gurus:
   The database is oracle8.1.7.2.1 on win2k machine 
with 1 CPU and two hard drives.  When I query
v$waitstat, I got the following:

CLASS   COUNT   TIME
-- -- --
data block  246901435  132690159
segment header   4869   8018
undo block  20986  38476
undo header  1895   1556

seems like I need to set DBWR_WRITE_PROCESSES to a
higher number, what number should I choose, 2 or
bigger?

Also, what other problems can you see from the last
query, other than we need to add some more RBS?

Thanks,

Chris Harvest.

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Role Privileges


Actually, one of the ones I was looking at had no privileges, it was there 
as an application check only, didn't need privileges.  The other ones 
really do have privileges, though.

At 05:50 PM 1/15/02 -0800, you wrote:
>or maybe it got its privs from a role that was granted to it?
>
>--- "Johnston, Tim" <[EMAIL PROTECTED]> wrote:
> > "Maybe the role your are concerned with has do privs granted to
> > it???"
> >
> > Oops...  Make that no privs granted to it...
> >
> > :-)
> >
> > -Original Message-
> > Sent: Tuesday, January 15, 2002 7:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > You are either encountering a bug or doing it incorrectly...  If it
> > is a
> > bug, you should call support...  But, I'm guessing that you are doing
> > it
> > incorrectly...  Run the following test...
> >
> > Log on as system...
> >
> > Create Role DeleteMe;
> >
> > Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;
> >
> > Log on as a different dba id...
> >
> > Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';
> >
> > You should see the following...
> >
> > SQL>
> > SQL> connect system/system_pass@yourdb
> > Connected.
> > SQL> Create Role DeleteMe;
> >
> > Role created.
> >
> > SQL>
> > SQL> Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;
> >
> > Grant succeeded.
> >
> > SQL>
> > SQL> connect other_dba_id/other_dba_id_pass@yourdb
> > Connected.
> > SQL>
> > SQL> Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';
> >
> > GRANTEEOWNER
> > -- --
> > TABLE_NAME GRANTOR
> > -- --
> > PRIVILEGEGRA
> >  ---
> > DELETEME   SYSTEM
> > SQLPLUS_PRODUCT_PROFILESYSTEM
> > SELECT   NO
> >
> >
> > SQL>
> >
> > In this case, the table owned by system is granted to the DELETEME
> > role but
> > you can see it from another dba account...  If you do not get these
> > results,
> > then you are encountering a bug of some sort...  If you do see these
> > results, you are probably doing something wrong with your other
> > lookup...
> > Maybe the role your are concerned with has do privs granted to it???
> >
> > Tim
> >
> > PS - FYI...  This assumes you have run pupbld.sql...  And, don't
> > forget to
> > drop the DELETEME role when you are done...
> >
> >
> > -Original Message-
> > Sent: Tuesday, January 15, 2002 6:31 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > At 02:51 PM 1/15/02 -0800, you wrote:
> > >Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to
> > the
> > >grantee you specify...
> >
> > I'm sure it's supposed to, but it does not.  I need another way.
> >
> > >-Original Message-
> > >Sent: Tuesday, January 15, 2002 5:29 PM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >At 12:25 PM 1/15/02 -0800, you wrote:
> > > >dba_tab_privs will show you privileges granted to anyone,
> > including
> > > >roles
> > >
> > >Yes, it will show privileges granted TO anyone, but only those
> > privileges
> > >granted BY me (or whoever I am logged in as).  I need to know how to
> > see
> > >the privileges granted even when I don't know who they were granted
> > by.
> > >
> > >
> > > >select table_name, privilege from dba_tab_privs where
> > grantee='';
> > > >
> > > >
> > > >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > > > Okay, I knew this was going to happen one day, but I kept
> > hoping as
> > > > > we
> > > > > upgraded the problem would be corrected eventually.
> > > > >
> > > > > ROLE_TAB_PRIVS will only show me tables privileges granted to a
> > role
> > > > > by the
> > > > > logged on user.  It wasn't such a problem before because I
> > created
> > > > > most of
> > > > > the roles and knew who was doing the granting.  Now I have a
> > couple
> > > > > of
> > > > > roles I didn't create and need to know what has been granted to
> > them.
> > > > >  How
> > > > > do I find out without knowing who did the granting?
> > > > >
> > > > > Thank you, any help will be appreciated.
> > > > >
> > > > > Regina
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > --
> > > > > Author: Regina Harter
> > > > >   INET: [EMAIL PROTECTED]
> > > > >
> > > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> > 538-5051
> > > > > San Diego, California-- Public Internet access /
> > Mailing
> > > > > Lists
> > > > >
> > 
> > > > > 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

Re: DBA Experiences with Oracle and RAID 0+1

2002-01-15 Thread Jared Still



Mogens,

Attachments don't make it to the list. so you may just need to 
send it to Jon directly, or put it somewhere publicly accessible.

Jared

On Tuesday 15 January 2002 17:25, Mogens Nørgaard wrote:
> Jon,
>
> It's one of those "how many bags will I need in the supermarket?"
> questions - it depends.
>
> Consider:
>
> - RAID 1+0 is much better than 0+1.
> - Three disks is not much w.r.t. IO capability. If you have three
> concurrent users you'll be OK :)
> - Size doesn't matter (who cares if it's 10, 36 or 73 Gig disks? It's
> the IO capabilitity that counts)
> - I'm new to this list, so I don't know if this will work, but I've
> attached a brilliant presentation by our old friend James Morle (check
> out www.ScaleAbilities.com) regarding SAN, NAS and RAS (Random Acronym
> Seminar).
> - If you're only striping across three disks (is that really a SAN?)
> just SAME (Stripe And Mirror Everything). It might not be good, but it's
> simple.
>
> Jon Behnke wrote:
> >We are in the process of setting up a SAN using RAID 0+1 for our database.
> >In our current environment, we are able to separate our tables, indexes,
> >rollback segments, and archive logs on different disks.  On the SAN we
> > would have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of
> > usable space (3 disks worth of space).
> >
> >Some white papers that I have read suggest attempting to separate the
> > data, indexes, and rollback segments on separate RAID volumes, and others
> > simply suggest that the performance boost of striping will supercede the
> > separation of these items.
> >
> >Can anyone offer any comments or suggestions?
> >
> >Jon Behnke
> >Applications Development Manager
> >Industrial Electric Wire & Cable
> >Phone (262) 957-1147  Fax (262) 957-1647
> >[EMAIL PROTECTED]


Content-Type: application/pdf; charset="us-ascii"; name="Sane_SAN_WP.pdf"
Content-Transfer-Encoding: 7bit
Content-Description: 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: DBA Experiences with Oracle and RAID 0+1

2002-01-15 Thread Mogens Nørgaard


Jon,

It's one of those "how many bags will I need in the supermarket?" 
questions - it depends.

Consider:

- RAID 1+0 is much better than 0+1.
- Three disks is not much w.r.t. IO capability. If you have three 
concurrent users you'll be OK :)
- Size doesn't matter (who cares if it's 10, 36 or 73 Gig disks? It's 
the IO capabilitity that counts)
- I'm new to this list, so I don't know if this will work, but I've 
attached a brilliant presentation by our old friend James Morle (check 
out www.ScaleAbilities.com) regarding SAN, NAS and RAS (Random Acronym 
Seminar).
- If you're only striping across three disks (is that really a SAN?) 
just SAME (Stripe And Mirror Everything). It might not be good, but it's 
simple.

Jon Behnke wrote:

>We are in the process of setting up a SAN using RAID 0+1 for our database.
>In our current environment, we are able to separate our tables, indexes,
>rollback segments, and archive logs on different disks.  On the SAN we would
>have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable
>space (3 disks worth of space). 
>
>Some white papers that I have read suggest attempting to separate the data,
>indexes, and rollback segments on separate RAID volumes, and others simply
>suggest that the performance boost of striping will supercede the separation
>of these items.
>
>Can anyone offer any comments or suggestions?
>
>Jon Behnke
>Applications Development Manager
>Industrial Electric Wire & Cable
>Phone (262) 957-1147  Fax (262) 957-1647 
>[EMAIL PROTECTED] 
>




Sane_SAN_WP.pdf
Description: Adobe PDF document

RE: Role Privileges


or maybe it got its privs from a role that was granted to it?

--- "Johnston, Tim" <[EMAIL PROTECTED]> wrote:
> "Maybe the role your are concerned with has do privs granted to
> it???"
> 
> Oops...  Make that no privs granted to it...
> 
> :-)
> 
> -Original Message-
> Sent: Tuesday, January 15, 2002 7:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> You are either encountering a bug or doing it incorrectly...  If it
> is a
> bug, you should call support...  But, I'm guessing that you are doing
> it
> incorrectly...  Run the following test...
> 
> Log on as system...
> 
> Create Role DeleteMe;
> 
> Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;
> 
> Log on as a different dba id...
> 
> Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';
> 
> You should see the following...
> 
> SQL> 
> SQL> connect system/system_pass@yourdb
> Connected.
> SQL> Create Role DeleteMe;
> 
> Role created.
> 
> SQL> 
> SQL> Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;
> 
> Grant succeeded.
> 
> SQL> 
> SQL> connect other_dba_id/other_dba_id_pass@yourdb
> Connected.
> SQL> 
> SQL> Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';
> 
> GRANTEEOWNER
> -- --
> TABLE_NAME GRANTOR
> -- --
> PRIVILEGEGRA
>  ---
> DELETEME   SYSTEM
> SQLPLUS_PRODUCT_PROFILESYSTEM
> SELECT   NO
> 
> 
> SQL> 
> 
> In this case, the table owned by system is granted to the DELETEME
> role but
> you can see it from another dba account...  If you do not get these
> results,
> then you are encountering a bug of some sort...  If you do see these
> results, you are probably doing something wrong with your other
> lookup...
> Maybe the role your are concerned with has do privs granted to it???
> 
> Tim
> 
> PS - FYI...  This assumes you have run pupbld.sql...  And, don't
> forget to
> drop the DELETEME role when you are done...
> 
> 
> -Original Message-
> Sent: Tuesday, January 15, 2002 6:31 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> At 02:51 PM 1/15/02 -0800, you wrote:
> >Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to
> the
> >grantee you specify...
> 
> I'm sure it's supposed to, but it does not.  I need another way.
> 
> >-Original Message-
> >Sent: Tuesday, January 15, 2002 5:29 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >At 12:25 PM 1/15/02 -0800, you wrote:
> > >dba_tab_privs will show you privileges granted to anyone,
> including
> > >roles
> >
> >Yes, it will show privileges granted TO anyone, but only those
> privileges
> >granted BY me (or whoever I am logged in as).  I need to know how to
> see
> >the privileges granted even when I don't know who they were granted
> by.
> >
> >
> > >select table_name, privilege from dba_tab_privs where
> grantee='';
> > >
> > >
> > >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > > Okay, I knew this was going to happen one day, but I kept
> hoping as
> > > > we
> > > > upgraded the problem would be corrected eventually.
> > > >
> > > > ROLE_TAB_PRIVS will only show me tables privileges granted to a
> role
> > > > by the
> > > > logged on user.  It wasn't such a problem before because I
> created
> > > > most of
> > > > the roles and knew who was doing the granting.  Now I have a
> couple
> > > > of
> > > > roles I didn't create and need to know what has been granted to
> them.
> > > >  How
> > > > do I find out without knowing who did the granting?
> > > >
> > > > Thank you, any help will be appreciated.
> > > >
> > > > Regina
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Regina Harter
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > > San Diego, California-- Public Internet access /
> Mailing
> > > > Lists
> > > >
> 
> > > > 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!?
> > >Send FREE video emails in Yahoo! Mail!
> > >http://promo.yahoo.com/videomail/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Rachel Carmichael
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > >San Diego, California-- Publ

RE: Role Privileges


Regina,

are you logged into the database with an account that has dba privs? I
just logged into an 8.1.6 database, as system

  1* select distinct grantor from dba_tab_privs
SQL> /

GRANTOR
--
ORACLE
RC
REPORTS
SYS
SYSTEM
TEMPUSER
UREG

so I got everyone.


--- Regina Harter <[EMAIL PROTECTED]> wrote:
> At 02:51 PM 1/15/02 -0800, you wrote:
> >Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to
> the
> >grantee you specify...
> 
> I'm sure it's supposed to, but it does not.  I need another way.
> 
> >-Original Message-
> >Sent: Tuesday, January 15, 2002 5:29 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >At 12:25 PM 1/15/02 -0800, you wrote:
> > >dba_tab_privs will show you privileges granted to anyone,
> including
> > >roles
> >
> >Yes, it will show privileges granted TO anyone, but only those
> privileges
> >granted BY me (or whoever I am logged in as).  I need to know how to
> see
> >the privileges granted even when I don't know who they were granted
> by.
> >
> >
> > >select table_name, privilege from dba_tab_privs where
> grantee='';
> > >
> > >
> > >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > > Okay, I knew this was going to happen one day, but I kept
> hoping as
> > > > we
> > > > upgraded the problem would be corrected eventually.
> > > >
> > > > ROLE_TAB_PRIVS will only show me tables privileges granted to a
> role
> > > > by the
> > > > logged on user.  It wasn't such a problem before because I
> created
> > > > most of
> > > > the roles and knew who was doing the granting.  Now I have a
> couple
> > > > of
> > > > roles I didn't create and need to know what has been granted to
> them.
> > > >  How
> > > > do I find out without knowing who did the granting?
> > > >
> > > > Thank you, any help will be appreciated.
> > > >
> > > > Regina
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Regina Harter
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > > San Diego, California-- Public Internet access /
> Mailing
> > > > Lists
> > > >
> 
> > > > 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!?
> > >Send FREE video emails in Yahoo! Mail!
> > >http://promo.yahoo.com/videomail/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Rachel Carmichael
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >
> > >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.com
> >--
> >Author: Regina Harter
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >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.com
> >--
> >Author: Johnston, Tim
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >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: htt

Re: dynamic views in 8.1.6

2002-01-15 Thread Mogens Nørgaard

I'm afraid that's the easy answer. I happened to work on an 11i thing 
recently. It might be just in Denmark that you have set all sorts of 
_-parameters for Apps 11i, but then again it might not :-)))

Khedr, Waleed wrote:

>I'm happy that something stopped working!
>
>Do you really enjoy changing the undocumented parameters?
>
>-Original Message-
>Sent: Monday, January 14, 2002 7:45 AM
>To: Multiple recipients of list ORACLE-L
>
>
>we have added these parameters in the init.ORA file .
>query_rewrite_enabled=true
>_complex_view_merging=true
>_push_join_predicate=true
>optimizer_max_permutations=79000
>_use_column_stats_for_function=true
>_like_with_bind_as_equality=true
>_push_join_union_view=true
>_ordered_nested_loop=true
>_or_expand_nvl_predicate=true
>
>after these changes all the dynamic views created by developers have stopped
>working .
>
>our database is running on aix 4.3.3 and its in MTS mode .
>
>Will appreciate quick response.
>
>thanks in advance .
>
>brajesh jaiswal
>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: dynamic views in 8.1.6

2002-01-15 Thread Mogens Nørgaard




_might_be_running_apps = true

commit;

Mogens

Stephane Faroult wrote:

  Oracle DBA wrote:
  
we have added these parameters in the init.ORA file .query_rewrite_enabled=true_complex_view_merging=true_push_join_predicate=trueoptimizer_max_permutations=79000_use_column_stats_for_function=true_like_with_bind_as_equality=true_push_join_union_view=true_ordered_nested_loop=true_or_expand_nvl_predicate=trueafter these changes all the dynamic views created by developers have stoppedworking .our database is running on aix 4.3.3 and its in MTS mode .Will appreciate quick response.thanks in advance .brajesh jaiswal

_stop_messing_with_undocumented_parameters=TRUE

How to set DBWR_WRITE_PROCESSES in Oracle8i?

2002-01-15 Thread CC Harvest


Hi, gurus:
   The database is oracle8.1.7.2.1 on win2k machine 
with 1 CPU and two hard drives.  When I query
v$waitstat, I got the following:

CLASS   COUNT   TIME
-- -- --
data block  246901435  132690159
segment header   4869   8018
undo block  20986  38476
undo header  1895   1556

seems like I need to set DBWR_WRITE_PROCESSES to a
higher number, what number should I choose, 2 or
bigger?

Also, what other problems can you see from the last
query, other than we need to add some more RBS?

Thanks,

Chris Harvest.

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Role Privileges


I'm sorry, I apologize.  Someone else was messing with the role I was 
testing with, which is why it returned only some of the roles I expected to 
see.Testing it again, it seems to return exactly what I need.  Thank 
you, everyone.


At 04:15 PM 1/15/02 -0800, you wrote:
>You are either encountering a bug or doing it incorrectly...  If it is a
>bug, you should call support...  But, I'm guessing that you are doing it
>incorrectly...  Run the following test...
>
>Log on as system...
>
>Create Role DeleteMe;
>
>Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;
>
>Log on as a different dba id...
>
>Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';
>
>You should see the following...
>
>SQL>
>SQL> connect system/system_pass@yourdb
>Connected.
>SQL> Create Role DeleteMe;
>
>Role created.
>
>SQL>
>SQL> Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;
>
>Grant succeeded.
>
>SQL>
>SQL> connect other_dba_id/other_dba_id_pass@yourdb
>Connected.
>SQL>
>SQL> Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';
>
>GRANTEEOWNER
>-- --
>TABLE_NAME GRANTOR
>-- --
>PRIVILEGEGRA
> ---
>DELETEME   SYSTEM
>SQLPLUS_PRODUCT_PROFILESYSTEM
>SELECT   NO
>
>
>SQL>
>
>In this case, the table owned by system is granted to the DELETEME role but
>you can see it from another dba account...  If you do not get these results,
>then you are encountering a bug of some sort...  If you do see these
>results, you are probably doing something wrong with your other lookup...
>Maybe the role your are concerned with has do privs granted to it???
>
>Tim
>
>PS - FYI...  This assumes you have run pupbld.sql...  And, don't forget to
>drop the DELETEME role when you are done...
>
>
>-Original Message-
>Sent: Tuesday, January 15, 2002 6:31 PM
>To: Multiple recipients of list ORACLE-L
>
>
>At 02:51 PM 1/15/02 -0800, you wrote:
> >Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to the
> >grantee you specify...
>
>I'm sure it's supposed to, but it does not.  I need another way.
>
> >-Original Message-
> >Sent: Tuesday, January 15, 2002 5:29 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >At 12:25 PM 1/15/02 -0800, you wrote:
> > >dba_tab_privs will show you privileges granted to anyone, including
> > >roles
> >
> >Yes, it will show privileges granted TO anyone, but only those privileges
> >granted BY me (or whoever I am logged in as).  I need to know how to see
> >the privileges granted even when I don't know who they were granted by.
> >
> >
> > >select table_name, privilege from dba_tab_privs where grantee='';
> > >
> > >
> > >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > > Okay, I knew this was going to happen one day, but I kept hoping as
> > > > we
> > > > upgraded the problem would be corrected eventually.
> > > >
> > > > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > > > by the
> > > > logged on user.  It wasn't such a problem before because I created
> > > > most of
> > > > the roles and knew who was doing the granting.  Now I have a couple
> > > > of
> > > > roles I didn't create and need to know what has been granted to them.
> > > >  How
> > > > do I find out without knowing who did the granting?
> > > >
> > > > Thank you, any help will be appreciated.
> > > >
> > > > Regina
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Regina Harter
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
> > > > Lists
> > > > 
> > > > 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!?
> > >Send FREE video emails in Yahoo! Mail!
> > >http://promo.yahoo.com/videomail/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Rachel Carmichael
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note

RE: Role Privileges


"Maybe the role your are concerned with has do privs granted to it???"

Oops...  Make that no privs granted to it...

:-)

-Original Message-
Sent: Tuesday, January 15, 2002 7:15 PM
To: Multiple recipients of list ORACLE-L


You are either encountering a bug or doing it incorrectly...  If it is a
bug, you should call support...  But, I'm guessing that you are doing it
incorrectly...  Run the following test...

Log on as system...

Create Role DeleteMe;

Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;

Log on as a different dba id...

Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';

You should see the following...

SQL> 
SQL> connect system/system_pass@yourdb
Connected.
SQL> Create Role DeleteMe;

Role created.

SQL> 
SQL> Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;

Grant succeeded.

SQL> 
SQL> connect other_dba_id/other_dba_id_pass@yourdb
Connected.
SQL> 
SQL> Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';

GRANTEEOWNER
-- --
TABLE_NAME GRANTOR
-- --
PRIVILEGEGRA
 ---
DELETEME   SYSTEM
SQLPLUS_PRODUCT_PROFILESYSTEM
SELECT   NO


SQL> 

In this case, the table owned by system is granted to the DELETEME role but
you can see it from another dba account...  If you do not get these results,
then you are encountering a bug of some sort...  If you do see these
results, you are probably doing something wrong with your other lookup...
Maybe the role your are concerned with has do privs granted to it???

Tim

PS - FYI...  This assumes you have run pupbld.sql...  And, don't forget to
drop the DELETEME role when you are done...


-Original Message-
Sent: Tuesday, January 15, 2002 6:31 PM
To: Multiple recipients of list ORACLE-L


At 02:51 PM 1/15/02 -0800, you wrote:
>Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to the
>grantee you specify...

I'm sure it's supposed to, but it does not.  I need another way.

>-Original Message-
>Sent: Tuesday, January 15, 2002 5:29 PM
>To: Multiple recipients of list ORACLE-L
>
>
>At 12:25 PM 1/15/02 -0800, you wrote:
> >dba_tab_privs will show you privileges granted to anyone, including
> >roles
>
>Yes, it will show privileges granted TO anyone, but only those privileges
>granted BY me (or whoever I am logged in as).  I need to know how to see
>the privileges granted even when I don't know who they were granted by.
>
>
> >select table_name, privilege from dba_tab_privs where grantee='';
> >
> >
> >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > Okay, I knew this was going to happen one day, but I kept hoping as
> > > we
> > > upgraded the problem would be corrected eventually.
> > >
> > > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > > by the
> > > logged on user.  It wasn't such a problem before because I created
> > > most of
> > > the roles and knew who was doing the granting.  Now I have a couple
> > > of
> > > roles I didn't create and need to know what has been granted to them.
> > >  How
> > > do I find out without knowing who did the granting?
> > >
> > > Thank you, any help will be appreciated.
> > >
> > > Regina
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Regina Harter
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > > 
> > > 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!?
> >Send FREE video emails in Yahoo! Mail!
> >http://promo.yahoo.com/videomail/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >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: new to DBA

2002-01-15 Thread Eric D. Pierce


ORACLE-L Digest -- Volume 2002, Number 015
> --
> 
>  From: Dwayne Cox <[EMAIL PROTECTED]>
>  Date: Mon, 14 Jan 2002 10:45:07 -0500
>  Subject: Re: new to DBA
...

> Oh, and have fun!

something you might need for meetings with damagement:

http://www.fishock.com/catalog/5prods.htm


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Possible SA issue


I got this from an MCSE. I thought I should share
with you, in case you are running oracle on NT. 

I am not too technical, so I'll leave it to your better
judgement whether or not to worry about it!



##

EXTREMELY IMPORTANT INFORMATION FOR SYSTEM ADMINISTRATORS

***READ CAREFULLY***

=

Many colleges and businesses tend to strip the last 
name down to 6 characters and add the first and last 
initial to either the beginning or end to make up an 
E-Mail address.  For  example, Mary L. Ferguson would 
make mlfergus or fergusml.  They are just now 
beginning to realize the problems that may happen when 
you have a large and diverse pool of people to choose 
from.  Add to that a large database of company/college 
acronyms and you have some very funny addresses.  

Probably not funny to the individual involved, however:


 TOP TEN Actual E-mail Addresses

10. Hellen Thomas Eatons (Duke University) - 

[EMAIL PROTECTED]

 9. Martha Elizibeth Cummins (Fresno University) -

[EMAIL PROTECTED]

 8. George David Blowmer (Drop Front Drawers &Cabinets Inc.)-

   [EMAIL PROTECTED]

 7. Mary Ellen Dickinson (Indiana University of Pennsylvania)-

   [EMAIL PROTECTED]

 6. Francis Kevin Kissinger (Las Verdes University) - 

   [EMAIL PROTECTED]

 5. Barbara Joan Beeranger (Myplace Home Decorating)-

   [EMAIL PROTECTED]

 4. Amanda Sue Pickering (Purdue University) - 

   [EMAIL PROTECTED]

 3. Ida Beatrice Ballinger (Ball State University) - 

   [EMAIL PROTECTED]

 2. Bradley Thomas Kissering (Brady Electrical, Northern Division, Overton
Canada) - 

   [EMAIL PROTECTED]

 1. Isabelle Haydon Adcock (Toys "R" Us) - 

   [EMAIL PROTECTED]

=
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Why doesn't Oracle kill dead connections?

2002-01-15 Thread Sona




Hi
I have a Reporting appliaction. The reports are run 
from the browser . The reports are basically Pl/SQL packages .the request is 
made from the browser and then communicated to the database thru  OAS 
.(oracle application server) which acts as web server.
The problem is when a user executes a report (i.e. 
hits the RUN button) and then closes the broser before the execution of the 
report is completed.Oracle still contimues running the query in the database. 
The session still remains ACTIVE in the database even though the client has 
closed the connection (i.e. the user has closed the browser).
Is there any way to force Oracle to kill the 
session when the user closes the browser?
 
TIA

RE: Role Privileges


You are either encountering a bug or doing it incorrectly...  If it is a
bug, you should call support...  But, I'm guessing that you are doing it
incorrectly...  Run the following test...

Log on as system...

Create Role DeleteMe;

Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;

Log on as a different dba id...

Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';

You should see the following...

SQL> 
SQL> connect system/system_pass@yourdb
Connected.
SQL> Create Role DeleteMe;

Role created.

SQL> 
SQL> Grant Select On SQLPLUS_PRODUCT_PROFILE To DeleteMe;

Grant succeeded.

SQL> 
SQL> connect other_dba_id/other_dba_id_pass@yourdb
Connected.
SQL> 
SQL> Select * From Dba_Tab_Privs Where Grantee = 'DELETEME';

GRANTEEOWNER
-- --
TABLE_NAME GRANTOR
-- --
PRIVILEGEGRA
 ---
DELETEME   SYSTEM
SQLPLUS_PRODUCT_PROFILESYSTEM
SELECT   NO


SQL> 

In this case, the table owned by system is granted to the DELETEME role but
you can see it from another dba account...  If you do not get these results,
then you are encountering a bug of some sort...  If you do see these
results, you are probably doing something wrong with your other lookup...
Maybe the role your are concerned with has do privs granted to it???

Tim

PS - FYI...  This assumes you have run pupbld.sql...  And, don't forget to
drop the DELETEME role when you are done...


-Original Message-
Sent: Tuesday, January 15, 2002 6:31 PM
To: Multiple recipients of list ORACLE-L


At 02:51 PM 1/15/02 -0800, you wrote:
>Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to the
>grantee you specify...

I'm sure it's supposed to, but it does not.  I need another way.

>-Original Message-
>Sent: Tuesday, January 15, 2002 5:29 PM
>To: Multiple recipients of list ORACLE-L
>
>
>At 12:25 PM 1/15/02 -0800, you wrote:
> >dba_tab_privs will show you privileges granted to anyone, including
> >roles
>
>Yes, it will show privileges granted TO anyone, but only those privileges
>granted BY me (or whoever I am logged in as).  I need to know how to see
>the privileges granted even when I don't know who they were granted by.
>
>
> >select table_name, privilege from dba_tab_privs where grantee='';
> >
> >
> >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > Okay, I knew this was going to happen one day, but I kept hoping as
> > > we
> > > upgraded the problem would be corrected eventually.
> > >
> > > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > > by the
> > > logged on user.  It wasn't such a problem before because I created
> > > most of
> > > the roles and knew who was doing the granting.  Now I have a couple
> > > of
> > > roles I didn't create and need to know what has been granted to them.
> > >  How
> > > do I find out without knowing who did the granting?
> > >
> > > Thank you, any help will be appreciated.
> > >
> > > Regina
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Regina Harter
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > > 
> > > 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!?
> >Send FREE video emails in Yahoo! Mail!
> >http://promo.yahoo.com/videomail/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >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.com
>--
>Author: Regina Harter
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Inte

RE: SAME, WAFL and RAID

Title: RE: SAME, WAFL and RAID

Yea,
they were talking about clustering all right.
sure
uh
huh
right

Whatever!

-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002
6:26 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SAME, WAFL and RAID
New
one I heard at our local Oracle office :
RAIP = Redundant Array of Independent
Processors
(Those guys were talking about NT Clustering...
)
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002 4:41
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SAME, WAFL and RAID
SAME
= 'stripe and mirror everthing'
BHT
= 'butylated hydroxytoluene'

-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15,
2002 5:29 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: SAME, WAFL and RAID
Great ! Thanks for the info..
-
Kirti
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002
3:49 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: SAME, WAFL and RAID
good question... RAID and WALF -- see
below. SAME... no idea...
RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html
) What does RAID stand for ? In 1987, Patterson, Gibson and Katz at the University of California
Berkeley, published a paper entitled "A Case for Redundant Arrays of
Inexpensive Disks (RAID)" . This paper described various types of disk
arrays, referred to by the acronym RAID. The basic idea of RAID was to
combine multiple small, inexpensive disk drives into an array of disk drives
which yields performance exceeding that of a Single Large Expensive Drive
(SLED). Additionally, this array of drives appears to the computer as a
single logical storage unit or drive.
The Mean Time Between Failure (MTBF) of the array will be
equal to the MTBF of an individual drive, divided by the number of drives in
the array. Because of this, the MTBF of an array of drives would be too low
for many application requirements. However, disk arrays can be made
fault-tolerant by redundantly storing information in various
ways.
Five types of array architectures, RAID-1 through RAID-5,
were defined by the Berkeley paper, each providing disk fault-tolerance and
each offering different trade-offs in features and performance. In addition
to these five redundant array architectures, it has become popular to refer
to a non-redundant array of disk drives as a RAID-0 array.
WAFL (from the NetApp website) The
WAFL (Write Anywhere File Layout) file system and the following features
deliver enterprise-class availability:
Consistency points. Always a consistent file-system image on disk,
even after unplanned shutdowns. Virtually eliminates the need to run
time-consuming file-system checks.
Snapshot
technology. Snapshots are near-instantaneous, transparent, read-only, online
copies of the active file systems. Up to 31 Snapshots can be maintained for
each data volume. Users can quickly recover deleted or modified files
without administrative assistance or restore from tape backup. The Snapshot
function requires minimal disk space and causes no disruption of service.
Snapshots can be backed up to other media while users are modifying the
active file system to minimize business disruption.
SnapRestore
software. Allows any system to revert back to a specified data volume
Snapshot for instant file-system recovery. Terabytes can be
recovered in minutes, rather than hours, without going to tape. The software
also greatly facilitates scenario testing as well as providing disaster
recovery and virus protection.
Easy, cost-effective clustering. Safeguards against hardware
failures by automatic filer takeover. Gives users continuous access to data.

SnapMirror software. Provides remote mirroring at high
speeds over a LAN or WAN. The asynchronous mirroring can be used for
disaster recovery, replication, backup, or testing on a nonproduction
system.
-Original Message- From:
Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID
Good idea..
All I know about WAFL is the House where breakfast is served
;)
- Kirti
-Original Message- Sent:
Tuesday, January 15, 2002 2:57 PM To: Multiple
recipients of list ORACLE-L
May I make a suggestion? It would be helpful if
posters would expand acronyms the first time they
use them. I, at least, have no idea what WAFL
is. Thanks.

RE: Oracle Performance monitoring tools.

2002-01-15 Thread Suhen Pather


Chuan,

Mamba is a good tool, that can be downloaded from www.luminate.com

Also check out Spotlight from www.quest.com

Regards
$uhen

 DBA gurus,

   I am just curious about what the performance tuning and monitoring
tools you are using besides OEM. Your sharing is highly appreciated.

Chuan Zhang

Oracle DBA



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Suhen Pather
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle8i and LDAP

2002-01-15 Thread Jared Still



Take a look at this article on using OID with older
versions of Oracle:

http://www.oracle.com/oramag/oracle/01-jan/index.html?o11o8i.html

Jared

On Tuesday 15 January 2002 15:00, Ben Poels wrote:
> Hi
>
> Well I have partially answered my own question. I see in the Net8 manual
> that it can use an LDAP server to replace Oracle Names and lookup connect
> strings for service names. However I am still not sure if Oracle8i can
> authenticate a username and password in an LDAP. If it can, does anyone
> know how it queries the LDAP.
>
> What I really want to know is whether Oracle has any specific requirements
> that an LDAP server would need to be able to handle. This will help us
> choose an Oracle compatible
> LDAP.
>
> I have found a chart indicating that OID is included with Oracle9iAS EE.
>
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 4:02 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
>
> Does Oracle8i come with any built in LDAP functions or
> do you have to write your own functions to search and
> update an LDAP directory?
> Does the Oracle Internet Directory come with Oracle8i
> or is purchased separately?
>
> Thanks.
>
> Ben
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ben Poels
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Performance monitoring tools.

2002-01-15 Thread Chuan Zhang


 DBA gurus,

   I am just curious about what the performance tuning and monitoring
tools you are using besides OEM. Your sharing is highly appreciated.

Chuan Zhang

Oracle DBA



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Role Privileges


At 02:51 PM 1/15/02 -0800, you wrote:
>Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to the
>grantee you specify...

I'm sure it's supposed to, but it does not.  I need another way.

>-Original Message-
>Sent: Tuesday, January 15, 2002 5:29 PM
>To: Multiple recipients of list ORACLE-L
>
>
>At 12:25 PM 1/15/02 -0800, you wrote:
> >dba_tab_privs will show you privileges granted to anyone, including
> >roles
>
>Yes, it will show privileges granted TO anyone, but only those privileges
>granted BY me (or whoever I am logged in as).  I need to know how to see
>the privileges granted even when I don't know who they were granted by.
>
>
> >select table_name, privilege from dba_tab_privs where grantee='';
> >
> >
> >--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > > Okay, I knew this was going to happen one day, but I kept hoping as
> > > we
> > > upgraded the problem would be corrected eventually.
> > >
> > > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > > by the
> > > logged on user.  It wasn't such a problem before because I created
> > > most of
> > > the roles and knew who was doing the granting.  Now I have a couple
> > > of
> > > roles I didn't create and need to know what has been granted to them.
> > >  How
> > > do I find out without knowing who did the granting?
> > >
> > > Thank you, any help will be appreciated.
> > >
> > > Regina
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Regina Harter
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > > 
> > > 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!?
> >Send FREE video emails in Yahoo! Mail!
> >http://promo.yahoo.com/videomail/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >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.com
>--
>Author: Regina Harter
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
>--
>Author: Johnston, Tim
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
-- 
Author: Regina Harter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

Title: RE: SAME, WAFL and RAID

New
one I heard at our local Oracle office :
RAIP = Redundant Array of Independent
Processors
(Those guys were talking about NT Clustering...
)
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002 4:41
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SAME, WAFL and RAID
SAME =
'stripe and mirror everthing'
BHT =
'butylated hydroxytoluene'

-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002
5:29 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SAME, WAFL and RAID
Great ! Thanks for the info..
-
Kirti
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002 3:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SAME, WAFL and RAID
good question... RAID and WALF -- see below.
SAME... no idea...
RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html
) What does RAID stand for ? In 1987, Patterson, Gibson and Katz at the University of California
Berkeley, published a paper entitled "A Case for Redundant Arrays of
Inexpensive Disks (RAID)" . This paper described various types of disk arrays,
referred to by the acronym RAID. The basic idea of RAID was to combine
multiple small, inexpensive disk drives into an array of disk drives which
yields performance exceeding that of a Single Large Expensive Drive (SLED).
Additionally, this array of drives appears to the computer as a single logical
storage unit or drive.
The Mean Time Between Failure (MTBF) of the array will be
equal to the MTBF of an individual drive, divided by the number of drives in
the array. Because of this, the MTBF of an array of drives would be too low
for many application requirements. However, disk arrays can be made
fault-tolerant by redundantly storing information in various ways.
Five types of array architectures, RAID-1 through RAID-5, were
defined by the Berkeley paper, each providing disk fault-tolerance and each
offering different trade-offs in features and performance. In addition to
these five redundant array architectures, it has become popular to refer to a
non-redundant array of disk drives as a RAID-0 array.
WAFL (from the NetApp website) The
WAFL (Write Anywhere File Layout) file system and the following features
deliver enterprise-class availability:
Consistency
points. Always a consistent file-system image on disk, even after unplanned
shutdowns. Virtually eliminates the need to run time-consuming file-system
checks.
Snapshot
technology. Snapshots are near-instantaneous, transparent, read-only, online
copies of the active file systems. Up to 31 Snapshots can be maintained for
each data volume. Users can quickly recover deleted or modified files without
administrative assistance or restore from tape backup. The Snapshot function
requires minimal disk space and causes no disruption of service. Snapshots can
be backed up to other media while users are modifying the active file system
to minimize business disruption.
SnapRestore
software. Allows any system to revert back to a specified data volume Snapshot
for instant file-system recovery. Terabytes can be recovered in
minutes, rather than hours, without going to tape. The software also greatly
facilitates scenario testing as well as providing disaster recovery and virus
protection.
Easy, cost-effective clustering. Safeguards against hardware
failures by automatic filer takeover. Gives users continuous access to data.

-Original Message- From:
Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID
Good idea..
All I know about WAFL is the House where breakfast is served
;)
- Kirti
-Original Message- Sent:
Tuesday, January 15, 2002 2:57 PM To: Multiple
recipients of list ORACLE-L
May I make a suggestion? It would be helpful if posters
would expand acronyms the first time they use
them. I, at least, have no idea what WAFL
is. Thanks.
--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello, > > I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID
__
Do You Yahoo!? Send FREE video emails
in Yahoo! Mail! http://promo.yahoo.com/videomail/ --
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fa

RE: Oracle8i and LDAP

2002-01-15 Thread Ben Poels


Hi

Well I have partially answered my own question. I see in the Net8 manual
that it can use an LDAP server to replace Oracle Names and lookup connect
strings for service names. However I am still not sure if Oracle8i can
authenticate a username and password in an LDAP. If it can, does anyone know
how it queries the LDAP.

What I really want to know is whether Oracle has any specific requirements
that an LDAP server would need to be able to handle. This will help us
choose an Oracle compatible
LDAP.

I have found a chart indicating that OID is included with Oracle9iAS EE.


-Original Message-
Sent: Tuesday, January 15, 2002 4:02 PM
To: Multiple recipients of list ORACLE-L


Hi

Does Oracle8i come with any built in LDAP functions or
do you have to write your own functions to search and
update an LDAP directory?
Does the Oracle Internet Directory come with Oracle8i
or is purchased separately?

Thanks.

Ben


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Ben Poels
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pin object into shared pool

2002-01-15 Thread Wong, Bing


Agreed.  I would use the buffer pool "KEEP".

-Original Message-
Sent: Tuesday, January 15, 2002 2:45 PM
To: Multiple recipients of list ORACLE-L


and/or the "new" buffer pool features found in oracle 6.

- Jaded DBA

-Original Message-

Mitchell:

You don't pin tables;  you pin functions, packages, and procedures.  If
you want a table to stay in the buffer cache for as long as possible,
you use 'ALTER TABLE ... CACHE'.

HTH,
Mike













-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Role Privileges


Wrong...  DBA_TAB_PRIVS will show you ANYONE who granted privs to the
grantee you specify...

-Original Message-
Sent: Tuesday, January 15, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L


At 12:25 PM 1/15/02 -0800, you wrote:
>dba_tab_privs will show you privileges granted to anyone, including
>roles

Yes, it will show privileges granted TO anyone, but only those privileges 
granted BY me (or whoever I am logged in as).  I need to know how to see 
the privileges granted even when I don't know who they were granted by.


>select table_name, privilege from dba_tab_privs where grantee='';
>
>
>--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > Okay, I knew this was going to happen one day, but I kept hoping as
> > we
> > upgraded the problem would be corrected eventually.
> >
> > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > by the
> > logged on user.  It wasn't such a problem before because I created
> > most of
> > the roles and knew who was doing the granting.  Now I have a couple
> > of
> > roles I didn't create and need to know what has been granted to them.
> >  How
> > do I find out without knowing who did the granting?
> >
> > Thank you, any help will be appreciated.
> >
> > Regina
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Regina Harter
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > 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!?
>Send FREE video emails in Yahoo! Mail!
>http://promo.yahoo.com/videomail/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
-- 
Author: Regina Harter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle8i and LDAP

2002-01-15 Thread Eswar the MAD


Hi,

Oracle 8i Doesnt have (at least I dont know) any LDAP functions inside it. 
We have to write it(i wrote it using perl).

OID is a seperate product as far as i know. If u r getting one i will 
recommend iPlanet or Openldap (IBM has one, but it works on DB2, better dont 
get DB2).

Regards

OraETM!!


>From: "Ben Poels" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle8i and LDAP
>Date: Tue, 15 Jan 2002 13:01:52 -0800
>
>Hi
>
>Does Oracle8i come with any built in LDAP functions or
>do you have to write your own functions to search and
>update an LDAP directory?
>Does the Oracle Internet Directory come with Oracle8i
>or is purchased separately?
>
>Thanks.
>
>Ben
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ben Poels
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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).




_
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pin object into shared pool


and/or the "new" buffer pool features found in oracle 6.

- Jaded DBA

-Original Message-

Mitchell:

You don't pin tables;  you pin functions, packages, and procedures.  If
you want a table to stay in the buffer cache for as long as possible,
you use 'ALTER TABLE ... CACHE'.

HTH,
Mike













-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

Title: RE: SAME, WAFL and RAID

SAME =
'stripe and mirror everthing'
BHT =
'butylated hydroxytoluene'

-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002
5:29 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SAME, WAFL and RAID
Great ! Thanks for the info..
-
Kirti
-Original Message-From: Nick Wagner
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002 3:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SAME, WAFL and RAID
good question... RAID and WALF -- see below.
SAME... no idea...
RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html
) What does RAID stand for ? In 1987, Patterson, Gibson and Katz at the University of California
Berkeley, published a paper entitled "A Case for Redundant Arrays of
Inexpensive Disks (RAID)" . This paper described various types of disk arrays,
referred to by the acronym RAID. The basic idea of RAID was to combine
multiple small, inexpensive disk drives into an array of disk drives which
yields performance exceeding that of a Single Large Expensive Drive (SLED).
Additionally, this array of drives appears to the computer as a single logical
storage unit or drive.
The Mean Time Between Failure (MTBF) of the array will be
equal to the MTBF of an individual drive, divided by the number of drives in
the array. Because of this, the MTBF of an array of drives would be too low
for many application requirements. However, disk arrays can be made
fault-tolerant by redundantly storing information in various ways.
Five types of array architectures, RAID-1 through RAID-5, were
defined by the Berkeley paper, each providing disk fault-tolerance and each
offering different trade-offs in features and performance. In addition to
these five redundant array architectures, it has become popular to refer to a
non-redundant array of disk drives as a RAID-0 array.
WAFL (from the NetApp website) The
WAFL (Write Anywhere File Layout) file system and the following features
deliver enterprise-class availability:
Consistency
points. Always a consistent file-system image on disk, even after unplanned
shutdowns. Virtually eliminates the need to run time-consuming file-system
checks.
Snapshot
technology. Snapshots are near-instantaneous, transparent, read-only, online
copies of the active file systems. Up to 31 Snapshots can be maintained for
each data volume. Users can quickly recover deleted or modified files without
administrative assistance or restore from tape backup. The Snapshot function
requires minimal disk space and causes no disruption of service. Snapshots can
be backed up to other media while users are modifying the active file system
to minimize business disruption.
SnapRestore
software. Allows any system to revert back to a specified data volume Snapshot
for instant file-system recovery. Terabytes can be recovered in
minutes, rather than hours, without going to tape. The software also greatly
facilitates scenario testing as well as providing disaster recovery and virus
protection.
Easy, cost-effective clustering. Safeguards against hardware
failures by automatic filer takeover. Gives users continuous access to data.

-Original Message- From:
Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: SAME, WAFL and RAID
Good idea..
All I know about WAFL is the House where breakfast is served
;)
- Kirti
-Original Message- Sent:
Tuesday, January 15, 2002 2:57 PM To: Multiple
recipients of list ORACLE-L
May I make a suggestion? It would be helpful if posters
would expand acronyms the first time they use
them. I, at least, have no idea what WAFL
is. Thanks.
--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello, > > I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID
__
Do You Yahoo!? Send FREE video emails
in Yahoo! Mail! http://promo.yahoo.com/videomail/
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED]
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051 San Diego,
California -- Public Internet access
/ Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru

RE: SAME, WAFL and RAID

2002-01-15 Thread Eswar the MAD


Hi,

WAFL is Write Anywhere File Layout...

Its the file lay out used by snapshot supported storege Devices(NetApp 
Storege Etc), This is completely different from a RAID. A RAID is a system 
which may or maynot be h/w controlled. But WAFL is the Low level file layout 
of the Storege system. In any one wants i hv the paper or Hutchinston with 
me on WAFL which i can give u

Regards

OraEtM!!



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pin object into shared pool

2002-01-15 Thread Vergara, Michael (TEM)


Mitchell:

You don't pin tables;  you pin functions, packages, and procedures.  If
you want a table to stay in the buffer cache for as long as possible,
you use 'ALTER TABLE ... CACHE'.

HTH,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304


-Original Message-
Sent: Tuesday, January 15, 2002 2:07 PM
To: Multiple recipients of list ORACLE-L


Hi  DBAs

I try on my test database to pin the table into shared pool and got error
message.  (I already pin the most used packages and procedures in to shared
pool  and it is ok ).

Is there anyway we can put table into memory.

Mitchell


SVRMGR> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')

ORA-06564: object ARDB.SKILL_MAPPING does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at line 2


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 1:50 PM


> Hi DBAs
>
> It is recommend by Oracle to pin frequenly  used packages into shared
pool,
> I had a table (read only) and mostly used,. Can I pin it into shared pool.
> What kind of objects could I pin into shared pool area?
>
>
>
> Thanks in advance
>
> like this:
>
> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
>
> Mitchell
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pin object into shared pool

2002-01-15 Thread Joe Raube


alter table tablename cache;

CACHE | NOCACHE

CACHE Clause

For data that is accessed frequently, this clause indicates that the blocks 
retrieved for this table are placed at the most recently used end of the 
least recently used (LRU) list in the buffer cache when a full table scan 
is performed. This attribute is useful for small lookup tables.

-Joe

At 05:07 PM 1/15/02, you wrote:
>Hi  DBAs
>
>I try on my test database to pin the table into shared pool and got error
>message.  (I already pin the most used packages and procedures in to shared
>pool  and it is ok ).
>
>Is there anyway we can put table into memory.
>
>Mitchell
>
>
>SVRMGR> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
>
>ORA-06564: object ARDB.SKILL_MAPPING does not exist
>ORA-06512: at "SYS.DBMS_UTILITY", line 68
>ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
>ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
>ORA-06512: at line 2
>
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Tuesday, January 15, 2002 1:50 PM
>
>
> > Hi DBAs
> >
> > It is recommend by Oracle to pin frequenly  used packages into shared
>pool,
> > I had a table (read only) and mostly used,. Can I pin it into shared pool.
> > What kind of objects could I pin into shared pool area?
> >
> >
> >
> > Thanks in advance
> >
> > like this:
> >
> > execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
> >
> > Mitchell
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: mitchell
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > 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.com
>--
>Author: mitchell
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

Title: RE: SAME, WAFL and RAID



Great 
! Thanks for the info..
 
- 
Kirti
 
-Original Message-From: Nick Wagner 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 15, 2002 3:49 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
SAME, WAFL and RAID
good question...  RAID and WALF -- see below.   
SAME... no idea... 
RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html 
) What does RAID stand for ? In 
1987, Patterson, Gibson and Katz at the University of California Berkeley, 
published a paper entitled "A Case for Redundant Arrays of Inexpensive Disks 
(RAID)" . This paper described various types of disk arrays, referred to by the 
acronym RAID. The basic idea of RAID was to combine multiple small, inexpensive 
disk drives into an array of disk drives which yields performance exceeding that 
of a Single Large Expensive Drive (SLED). Additionally, this array of drives 
appears to the computer as a single logical storage unit or drive.
The Mean Time Between Failure (MTBF) of the array will be equal 
to the MTBF of an individual drive, divided by the number of drives in the 
array. Because of this, the MTBF of an array of drives would be too low for many 
application requirements. However, disk arrays can be made fault-tolerant by 
redundantly storing information in various ways.
Five types of array architectures, RAID-1 through RAID-5, were 
defined by the Berkeley paper, each providing disk fault-tolerance and each 
offering different trade-offs in features and performance. In addition to these 
five redundant array architectures, it has become popular to refer to a 
non-redundant array of disk drives as a RAID-0 array.
WAFL (from the NetApp website) The WAFL 
(Write Anywhere File Layout) file system and the following features deliver 
enterprise-class availability: 
    Consistency 
points. Always a consistent file-system image on disk, even after unplanned 
shutdowns. Virtually eliminates the need to run time-consuming file-system 
checks. 
    Snapshot technology. 
Snapshots are near-instantaneous, transparent, read-only, online copies of the 
active file systems. Up to 31 Snapshots can be maintained for each data volume. 
Users can quickly recover deleted or modified files without administrative 
assistance or restore from tape backup. The Snapshot function requires minimal 
disk space and causes no disruption of service. Snapshots can be backed up to 
other media while users are modifying the active file system to minimize 
business disruption. 
    SnapRestore software. 
Allows any system to revert back to a specified data volume Snapshot for instant 
file-system recovery.    Terabytes can be recovered in minutes, rather 
than hours, without going to tape. The software also greatly facilitates 
scenario testing as well as providing disaster recovery and virus protection. 

Easy, cost-effective clustering. Safeguards against hardware 
failures by automatic filer takeover. Gives users continuous access to data. 

SnapMirror software. Provides remote mirroring at high speeds 
over a LAN or WAN. The asynchronous mirroring can be used for disaster recovery, 
replication, backup, or testing on a nonproduction system. 
-Original Message- From: 
Deshpande, Kirti [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 15, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Subject: 
RE: SAME, WAFL and RAID 
Good idea.. 
All I know about WAFL is the House where breakfast is served ;) 

- Kirti 
-Original Message- Sent: 
Tuesday, January 15, 2002 2:57 PM To: Multiple 
recipients of list ORACLE-L 
May I make a suggestion?  It would be helpful if posters 
would expand acronyms the first time they use 
them.  I, at least, have no idea what WAFL 
is.  Thanks. 
--- Bill Becker <[EMAIL PROTECTED]> wrote: 
> Hello, > > I am looking for any pointers to white papers, etc. > that discuss the differences/similarities among > WAFL, SAME and RAID 
__ 
Do You Yahoo!? Send FREE video emails 
in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- Author: Paul Baumgartel 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 
Mailing Lists  
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.com 
-- Author: Deshpande, Kirti 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet

Re: Role Privileges


At 12:25 PM 1/15/02 -0800, you wrote:
>dba_tab_privs will show you privileges granted to anyone, including
>roles

Yes, it will show privileges granted TO anyone, but only those privileges 
granted BY me (or whoever I am logged in as).  I need to know how to see 
the privileges granted even when I don't know who they were granted by.


>select table_name, privilege from dba_tab_privs where grantee='';
>
>
>--- Regina Harter <[EMAIL PROTECTED]> wrote:
> > Okay, I knew this was going to happen one day, but I kept hoping as
> > we
> > upgraded the problem would be corrected eventually.
> >
> > ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> > by the
> > logged on user.  It wasn't such a problem before because I created
> > most of
> > the roles and knew who was doing the granting.  Now I have a couple
> > of
> > roles I didn't create and need to know what has been granted to them.
> >  How
> > do I find out without knowing who did the granting?
> >
> > Thank you, any help will be appreciated.
> >
> > Regina
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Regina Harter
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> > 
> > 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!?
>Send FREE video emails in Yahoo! Mail!
>http://promo.yahoo.com/videomail/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
-- 
Author: Regina Harter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pin object into shared pool

2002-01-15 Thread mitchell


Hi  DBAs

I try on my test database to pin the table into shared pool and got error
message.  (I already pin the most used packages and procedures in to shared
pool  and it is ok ).

Is there anyway we can put table into memory.

Mitchell


SVRMGR> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')

ORA-06564: object ARDB.SKILL_MAPPING does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at line 2


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 1:50 PM


> Hi DBAs
>
> It is recommend by Oracle to pin frequenly  used packages into shared
pool,
> I had a table (read only) and mostly used,. Can I pin it into shared pool.
> What kind of objects could I pin into shared pool area?
>
>
>
> Thanks in advance
>
> like this:
>
> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
>
> Mitchell
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mitchell
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: mitchell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

2002-01-15 Thread Nick Wagner

Title: RE: SAME, WAFL and RAID

good question...  RAID and WALF -- see below.   SAME... no idea...

RAID - (from http://www.uni-mainz.de/~neuffer/scsi/what_is_raid.html )
What does RAID stand for ? 
In 1987, Patterson, Gibson and Katz at the University of California Berkeley, published a paper entitled "A Case for Redundant Arrays of Inexpensive Disks (RAID)" . This paper described various types of disk arrays, referred to by the acronym RAID. The basic idea of RAID was to combine multiple small, inexpensive disk drives into an array of disk drives which yields performance exceeding that of a Single Large Expensive Drive (SLED). Additionally, this array of drives appears to the computer as a single logical storage unit or drive.

The Mean Time Between Failure (MTBF) of the array will be equal to the MTBF of an individual drive, divided by the number of drives in the array. Because of this, the MTBF of an array of drives would be too low for many application requirements. However, disk arrays can be made fault-tolerant by redundantly storing information in various ways.

Five types of array architectures, RAID-1 through RAID-5, were defined by the Berkeley paper, each providing disk fault-tolerance and each offering different trade-offs in features and performance. In addition to these five redundant array architectures, it has become popular to refer to a non-redundant array of disk drives as a RAID-0 array.

WAFL (from the NetApp website)
The WAFL (Write Anywhere File Layout) file system and the following features deliver enterprise-class availability: 
    Consistency points. Always a consistent file-system image on disk, even after unplanned shutdowns. Virtually eliminates the need to run time-consuming file-system checks. 

    Snapshot technology. Snapshots are near-instantaneous, transparent, read-only, online copies of the active file systems. Up to 31 Snapshots can be maintained for each data volume. Users can quickly recover deleted or modified files without administrative assistance or restore from tape backup. The Snapshot function requires minimal disk space and causes no disruption of service. Snapshots can be backed up to other media while users are modifying the active file system to minimize business disruption. 

    SnapRestore software. Allows any system to revert back to a specified data volume Snapshot for instant file-system recovery.    Terabytes can be recovered in minutes, rather than hours, without going to tape. The software also greatly facilitates scenario testing as well as providing disaster recovery and virus protection. 

Easy, cost-effective clustering. Safeguards against hardware failures by automatic filer takeover. Gives users continuous access to data. 

SnapMirror software. Provides remote mirroring at high speeds over a LAN or WAN. The asynchronous mirroring can be used for disaster recovery, replication, backup, or testing on a nonproduction system. 

-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SAME, WAFL and RAID

Good idea..

All I know about WAFL is the House where breakfast is served ;) 

- Kirti

-Original Message-
Sent: Tuesday, January 15, 2002 2:57 PM
To: Multiple recipients of list ORACLE-L

May I make a suggestion?  It would be helpful if posters would expand
acronyms the first time they use them.  I, at least, have no idea what
WAFL is.  Thanks.

--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID 

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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 contain

RE: Using procedures instead of coding update/insert

2002-01-15 Thread Gogala, Mladen


Kevin, you're missing the point: the first statement
was that prepared SQL is much faster then stored PL/SQL procedures.
In my opinion, one cannot make such a general statement.

-Original Message-
Sent: Tuesday, January 15, 2002 3:41 PM
To: Multiple recipients of list ORACLE-L


Actually, we have many procedures that use the FORALL syntax. And, yes I am
the guy that tested the difference between the Java code sending a bulk
insert v.s., using PL/SQL FORALL. And Yes, there was a significant (10-25%)
improvement when using PL/SQL. The code was as close as we could get it.

I'll agree that the code isn't simple (it was a b*&%#) or concise but we
were after performance.

-Original Message-
Sent: Tuesday, January 15, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L


They are possible, all right, with forall statement
and/or with passing an array as a parameter. How many
of your procedures do actually use that feature? Are you sure
that the guy who has tested the difference between prepared
SQL and PL/SQL procedure has done the necessary coding in order 
to compare apples to apples. 
Second, do not confuse array binds with passing an array.
To pass an array, you have to define a type, define parameter 
of that type and pass the array as an object type. Not very intuitive
or simple. 

-Original Message-
Sent: Tuesday, January 15, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L


You must be using Oracle 8.0 or earlier. Bulk/array binds are possible in
PL/SQL (stored procedures) starting with Oracle 8i

-Original Message-
Sent: Tuesday, January 15, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L


The reason for that is the fact that with prepared statements you 
can do array binds while that isn't possible with the stored procedures.
I don't like this kind of comparisons. I judge on case by case basis.


-Original Message-
Sent: Tuesday, January 15, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L


We have done some preliminary testing and found prepared statements about
20% faster than stored procedures. We inserted 200,000 records at a time
(28-50 columns in a table ) using stored procedures and then used prepared
statements for the same dataset. Both of them were called from java using
JDBC thin drivers and interestingly found prepared statements faster.
Similarly, deletes were also about 15%-20% faster using prepared statements.
For some reasons, updates to the same tables gave almost identical
performance.

Rakesh

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 ORAC

RE: SAME, WAFL and RAID

2002-01-15 Thread Kevin Lange


Absolutely good idea.   

-Original Message-
Sent: Tuesday, January 15, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L


Good idea..

All I know about WAFL is the House where breakfast is served ;) 

- Kirti

-Original Message-
Sent: Tuesday, January 15, 2002 2:57 PM
To: Multiple recipients of list ORACLE-L


May I make a suggestion?  It would be helpful if posters would expand
acronyms the first time they use them.  I, at least, have no idea what
WAFL is.  Thanks.


--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID 

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: limit user CPU usage

2002-01-15 Thread kevin wang


Thanks, Ron, I will try it.

Kevin  Wang


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 11:55 AM


Kevin,
You could try creating a profile with the cpu_per_call and
cpu_per_session set ta a particular value. It will limit the amount of
time in hundredths of a second to the user assigned to the profile. I
woul experiment with the values before I assigned it to a user. The
manual does not say it will act as a choke on cpu usage other than
time.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 01/15/02 01:10PM >>>
Hi, Guys,

Is there some parameters or user-profile prometers in  Oracle can limit
user CPU usage?
I mean, make specific user or all users use less CPU, I has a SQL query
that use 100% CPU.
I know the SQL is bad, but before developer change it, Is there
something I can do?
Any suggestion will be highly appreciated.
My environment is Oracle8.1.6 on Win2000.

Thanks,

Kevin  Wang



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: kevin wang
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

2002-01-15 Thread Ken Janusz


You make WAFL's with a WAFL iron.

Ken

 -Original Message-
Sent:   Tuesday, January 15, 2002 2:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: SAME, WAFL and RAID

May I make a suggestion?  It would be helpful if posters would expand
acronyms the first time they use them.  I, at least, have no idea what
WAFL is.  Thanks.


--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID 

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID


Good idea..

All I know about WAFL is the House where breakfast is served ;) 

- Kirti

-Original Message-
Sent: Tuesday, January 15, 2002 2:57 PM
To: Multiple recipients of list ORACLE-L


May I make a suggestion?  It would be helpful if posters would expand
acronyms the first time they use them.  I, at least, have no idea what
WAFL is.  Thanks.


--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID 

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ORA-01555: snapshot too old: rollback segment number...


With Oracle 9i & Auto Undo Management, Oracle allocates a default
min_extents=2 for the undo segments. And there is nothing one can do to
change it (other than continue using the rollback segment approach). The
min_extents=20 guideline came about from Oracle's internal testing (a very
controlled environment) to find ways to minimize ORA-1555 error. 

- Kirti 


-Original Message-
Sent: Tuesday, January 15, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L


min extents = 20 is not carved in stone. You allocate them with the
number of extents that make sense for your database

the problem is, as new releases come out, old "facts" change and people
keep spreading them anyway

--- àãø_éçéàì <[EMAIL PROTECTED]> wrote:
> Hello Viktor
> 
> Regarding the rollback segments, I heard from Oracle that you need to
> allocate them
> with min extents=20. 
> This will cause users to get their own extents and the chance that a
> new
> update will overwrite 
> an old update that you need will decrease.
> Check metalink. they have a paper on this error (if I remember
> correctly)
> 
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From:   Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tue, January 15, 2002 8:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: ORA-01555: snapshot too old: rollback segment
> number...
> > 
> > You can export with CONSISTENT=N; a consistent view of the data
> will not
> > be
> > achieved.  You can also increase the size of your rollback segments
> to
> > accommodate large queries while updates are being performed.  There
> is not
> > much else you can do on this one.
> > 
> > Thank You
> > 
> > Stephen P. Karniotis
> > Technical Alliance Manager
> > Compuware Corporation
> > Direct: (248) 865-4350
> > Mobile: (248) 408-2918
> > Email:  [EMAIL PROTECTED]
> > Web:www.compuware.com
> > 
> > 
> >  -Original Message-
> > Sent:   Tuesday, January 15, 2002 12:20 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:ORA-01555: snapshot too old: rollback segment number...
> > 
> > Hi all,
> > 
> > Last nignt when we were expring data for one of our
> > databases, this error ocurred:
> > 
> > ORA-01555: snapshot too old: rollback segment number
> > 3 with name "R02") offset=(0).
> > 
> > Now, we were able to once again export and load data
> > this morning. And there was no error.
> > 
> > What is the best aproach to try to eliminate this
> > error in the future?
> > 
> > Any suggestions apreciated.
> > 
> > Thanks
> > 
> > Regards
> > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send FREE video emails in Yahoo! Mail!
> > http://promo.yahoo.com/videomail/
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Viktor
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > 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.com
> > -- 
> > Author: Karniotis, Stephen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > 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 was scanned by the eSafe Mail Gateway 
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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 l

Oracle8i and LDAP

2002-01-15 Thread Ben Poels


Hi

Does Oracle8i come with any built in LDAP functions or
do you have to write your own functions to search and
update an LDAP directory?
Does the Oracle Internet Directory come with Oracle8i
or is purchased separately?

Thanks.

Ben


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 : Table partition on part of a field

2002-01-15 Thread Khedr, Waleed



Make it two fields 6 & 3
Partition on 3
And create a view to concatenate the two fields into one

Regards,
Waleed

-Original Message-
Sent: Tuesday, January 15, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L


Hello All

I need to create a partitioned table base on the last three digits on 9
digits number.

Create table test (zip_and_city_code number(9));

The zip code is 6 digits and the city code is 3 digits.

The design is from an application that used btrieve and is now ported to
Oracle.
(I would not allow this design if it was a new system).

I want to group every city records into its own partition.

First I tried to use range partitioning based on a function on the field and
it does not work.

Then I thought about using hash partitioning using my own hash  function but
could not find 
where I can use my own hash function.

Any help to implement this @#$% design will be really appreciated.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Using procedures instead of coding update/insert

2002-01-15 Thread Toepke, Kevin M


Or, you could do what we do in once case (8.1.6 database)make 1000
procedure calls that populates a package index-by table. After 1000 calls,
it internally does another call that does the bulk insert. The first 999
calls take about 1 second.

-Original Message-
Sent: Tuesday, January 15, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L


That is correct, but, unfortunately, in most cases
scalars are passed as parameters. That option is
available only as of 8.1.7 when you can bind a 3GL 
array or a Java array to PL/SQL array.

-Original Message-
Sent: Tuesday, January 15, 2002 1:46 PM
To: Multiple recipients of list ORACLE-L


Nothing prohibits from using arrays as parameters, when calling stored
procedures.
So, there goes the advantage of 'prepared statements' in doing array binds.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:17 PM


> So what is the basis for the case by case judgement.  I'm not being flip -
> I really want to know.
>
> From the discussion so far it appears that the pros for PL/SQL procedures
> are:
>
>Uniform access method to the database for all applications
>Processing done on the more robust server machine
>Less impact on the SGA
>Ease of maintenance
>"Loosely couples" the application to the database in that database
>changes only impact the procedures, not the code
>
> The pros for prepared statements is that you can do array binds (which
give
> better performance).
>
> Anything else?  I'll be the first to admit that PL/SQL development is my
> short suit.
>
>
>
>
> "Gogala,
> Mladen"  To: Multiple recipients of
list ORACLE-L
> 
> @oxhp.com>   cc:
> Sent by: rootSubject: RE: Using procedures
instead of
>  coding update/insert
>
> 01/15/2002
> 11:40 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> The reason for that is the fact that with prepared statements you
> can do array binds while that isn't possible with the stored procedures.
> I don't like this kind of comparisons. I judge on case by case basis.
>
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We have done some preliminary testing and found prepared statements about
> 20% faster than stored procedures. We inserted 200,000 records at a time
> (28-50 columns in a table ) using stored procedures and then used prepared
> statements for the same dataset. Both of them were called from java using
> JDBC thin drivers and interestingly found prepared statements faster.
> Similarly, deletes were also about 15%-20% faster using prepared
> statements.
> For some reasons, updates to the same tables gave almost identical
> performance.
>
> Rakesh
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rakesh Gupta
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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 l

RE: Using procedures instead of coding update/insert

2002-01-15 Thread Toepke, Kevin M


Actually, we have many procedures that use the FORALL syntax. And, yes I am
the guy that tested the difference between the Java code sending a bulk
insert v.s., using PL/SQL FORALL. And Yes, there was a significant (10-25%)
improvement when using PL/SQL. The code was as close as we could get it.

I'll agree that the code isn't simple (it was a b*&%#) or concise but we
were after performance.

-Original Message-
Sent: Tuesday, January 15, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L


They are possible, all right, with forall statement
and/or with passing an array as a parameter. How many
of your procedures do actually use that feature? Are you sure
that the guy who has tested the difference between prepared
SQL and PL/SQL procedure has done the necessary coding in order 
to compare apples to apples. 
Second, do not confuse array binds with passing an array.
To pass an array, you have to define a type, define parameter 
of that type and pass the array as an object type. Not very intuitive
or simple. 

-Original Message-
Sent: Tuesday, January 15, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L


You must be using Oracle 8.0 or earlier. Bulk/array binds are possible in
PL/SQL (stored procedures) starting with Oracle 8i

-Original Message-
Sent: Tuesday, January 15, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L


The reason for that is the fact that with prepared statements you 
can do array binds while that isn't possible with the stored procedures.
I don't like this kind of comparisons. I judge on case by case basis.


-Original Message-
Sent: Tuesday, January 15, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L


We have done some preliminary testing and found prepared statements about
20% faster than stored procedures. We inserted 200,000 records at a time
(28-50 columns in a table ) using stored procedures and then used prepared
statements for the same dataset. Both of them were called from java using
JDBC thin drivers and interestingly found prepared statements faster.
Similarly, deletes were also about 15%-20% faster using prepared statements.
For some reasons, updates to the same tables gave almost identical
performance.

Rakesh

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services

Re: SAME, WAFL and RAID

2002-01-15 Thread Paul Baumgartel

May I make a suggestion?  It would be helpful if posters would expand
acronyms the first time they use them.  I, at least, have no idea what
WAFL is.  Thanks.

--- Bill Becker <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I am looking for any pointers to white papers, etc.
> that discuss the differences/similarities among
> WAFL, SAME and RAID 

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

TNSPING

2002-01-15 Thread Seema Singh


Hi
When I run tnsping servername on web server .Some of server shoe at bottom
OK (10 msec)
some of them are
OK (50 msec) and some of them are
OK (100 msec)
What this meaning is?
Which server is faster one?
Thanks
-Seema



_
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Using procedures instead of coding update/insert

2002-01-15 Thread Igor Neyman


There are standard (oracle supplied) predefined types like:

DBMS_SQL.NUMBER_TABLE
DBMS_SQL.DATE_TABLE
DBMS_SQL.VARCHAR2_TABLE


Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 2:05 PM


> They are possible, all right, with forall statement
> and/or with passing an array as a parameter. How many
> of your procedures do actually use that feature? Are you sure
> that the guy who has tested the difference between prepared
> SQL and PL/SQL procedure has done the necessary coding in order
> to compare apples to apples.
> Second, do not confuse array binds with passing an array.
> To pass an array, you have to define a type, define parameter
> of that type and pass the array as an object type. Not very intuitive
> or simple.
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 12:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> You must be using Oracle 8.0 or earlier. Bulk/array binds are possible in
> PL/SQL (stored procedures) starting with Oracle 8i
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 11:40 AM
> To: Multiple recipients of list ORACLE-L
>
>
> The reason for that is the fact that with prepared statements you
> can do array binds while that isn't possible with the stored procedures.
> I don't like this kind of comparisons. I judge on case by case basis.
>
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We have done some preliminary testing and found prepared statements about
> 20% faster than stored procedures. We inserted 200,000 records at a time
> (28-50 columns in a table ) using stored procedures and then used prepared
> statements for the same dataset. Both of them were called from java using
> JDBC thin drivers and interestingly found prepared statements faster.
> Similarly, deletes were also about 15%-20% faster using prepared
statements.
> For some reasons, updates to the same tables gave almost identical
> performance.
>
> Rakesh
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rakesh Gupta
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Toepke, Kevin M
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 5

RE: sniped sessions

2002-01-15 Thread Srini . Chavali



To clean up the sniped sessions faster, you can also use the IMMEDIATE
clause (new with 8i, I believe) in the ALTER SYSTEM KILL SESSION command.
See docs for details.
HTH
Srini Chavali
Oracle DBA
Cummins Inc




[EMAIL PROTECTED]@fatcity.com on 01/15/2002 02:05:23 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



appreciate you help guys..

-Original Message-
Sent: Tuesday, January 15, 2002 9:06 AM
To: Multiple recipients of list ORACLE-L


Attached are the scripts we use to kill sniped sessions.  This is part of a
series of monitoring scripts we developed for our Oracle databases.  The
scripts are scheduled through Cron and run every 15 minutes.  A logonid or
an email address is passed to the scripts for either paging or email.  In
this case an accum of sniped sessions is maintained on a 'flat' file just
so
we can go back and check to see how many sniped sessions are being killed.
I will attach a zip file.  If that doesn't get through I will also list the
scripts below.

Ron Smith
Kerr-McGee Corp

SNIPED.SH

#! /bin/sh
#  DBA MONITORING SCRIPTS
# **
#
# Author: Ron Smith
# Date:   06/18/98
# Funtion:Checks for sessions that have been "Sniped".
#
# **
#
# CHANGE HISTORY
#
# DATEWHO   Reason for Change

# 03/03/00Ron Smith   New Prog

#
# **
#
# FUNCTION

#
# This script calls sniped.sql.
# The function of this script is to report sessions that have
# been "sniped" by Oracle through the use of resource limits.
#
# If the id of the DBA is a Zid, a page will be sent.  If the
# id of the DBA is an email address (determined by looking for
# an "@" ) , an EMAIL will be sent.
#
# **
#
# PREREQUISITES
#
# The OPS$ORACLE user must exist in the instance.  This can be
# created by running the opsuer.sql script in SQLPLUS while
# logged on as SYSTEM.
#
# The cdmonitoring script must exist in the home/oracle
# directory.
#
# **
#
# RUN SYNTAX
#
# sniped.sh (sid) (oncall dba)
#
#
# **

# cd to the monitoring script directory
. $HOME/cdmonitoring.sh

ORACLE_SID=$1
export ORACLE_SID
DBA=$2
export DBA
echo $DBA
ATCNT=`echo $DBA | grep @ |  wc -l`
export ATCNT

ORACLE_HOME=`grep "^$ORACLE_SID:" /etc/oratab | head -1 | cut -d: -f2`
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:.
export PATH

# Delete the old list file if it exists

if [ -e sniped_$ORACLE_SID.lst ]
 then rm sniped_$ORACLE_SID.lst
fi

# Delete the old error file if it exists

if [ -e sniped_$ORACLE_SID.err ]
 then rm sniped_$ORACLE_SID.err
fi

# Delete the old kill file if it exists

if [ -e sniped_kill_$ORACLE_SID.sh ]
 then rm sniped_kill_$ORACLE_SID.sh
fi

# If sending to EMAIL address, run sql with headings on else run with
headings off

if [ "$ATCNT" -gt "0" ]
 then
 sqlplus / @sniped.sql on
 else
 sqlplus / @sniped.sql off
fi

# If there is anything in the lst file then kill the user processes and
send
a message

if [ -s sniped_$ORACLE_SID.lst ]
 then cat sniped_$ORACLE_SID.lst >> sniped_accum.lst

 sqlplus / @sniped2.sql

 if [ -s sniped_kill_$ORACLE_SID.sh ]
then chmod +x sniped_kill_$ORACLE_SID.sh;
  cat sniped_kill_$ORACLE_SID.sh >> sniped_kill_accum.lst
 ./sniped_kill_$ORACLE_SID.sh;
fi

 echo "-DBA- Sniped sessions killed " > sniped_$ORACLE_SID.err
 echo "SID=" $ORACLE_SID " " >> sniped_$ORACLE_SID.err
 cat sniped_$ORACLE_SID.lst >> sniped_$ORACLE_SID.err

 if [ "$ATCNT" -gt "0" ]
  then
  echo "email sent"
  elm -s "-DBA- $ORACLE_SID Sniped sessions exist" $DBA <
sniped_$ORACLE_SID.err
 else
  LC=`cat sniped_$ORACLE_SID.lst | sed -e 's/  */ /g' | wc -c`
  echo $LC
  if [ "$LC" -gt "160" ]
   then echo "Sniped sessions killed. Check
sniped_$ORACLE_SID.lst" >> sniped_$ORACLE_SID.err
   else
   cat sniped_$ORACLE_SID.lst >> sniped_$ORACLE_SID.err
  fi
  echo "page sent"
  pager $DBA "`cat sniped_$ORACLE_SID.err`"
 fi
fi


SNIPED.SQL

set pause off
SET ECHO off
set verify off
set feedback off
set linesize 132
set heading &1
col "User Name"  format a10;
alter session set nls_date_format = 'dd-MON- hh24:mi:ss';
spool sniped_$ORACLE_SID.lst

select s.username "User Name",
 s.osuser "OS User",
 s.status "Status",
 s.logon_time "Connect Time",

RE: Using procedures instead of coding update/insert

2002-01-15 Thread Jamadagni, Rajendra


Chris,

It is not that difficult to generate the code.

I recently wrote a procedure that generates code to insert into a table, you
provide the owner and table name. I wanted to create generic audit triggers
... but that is too much of work, so I wrote some code that would generate
the audit trigger.

1. The procedure GENTRIGREC accepts owner and table name and a optional
parameter (more on that later).
2. It generates code required for auditing, 
   2.1 it declares two records of table%rowtype, calls them NEW and OLD to
hold appropriate values.
   2.2 based on what the action is, it populates NEW and/or OLD records with
appropriate values.
   2.3 based on action that fired the trigger, it defines a variable called
action.
   2.4 if optional parameter (as in 1) is set to true, it generates code
that lets you capture a list of ALL the changed columns in the current table
into a variable. 
3. Then it is up to you to pass the records, the action variable and list of
updated columns (in case of update statement) to a procedure to insert into
a audit statement. 

Then you call GENAUDPROC procedure with name of the intended procedure and
it generates generic procedure code. This you can then tweak to suit your
needs. This actually will reduce a whole lot of work for developers. 

Our idea is to audit DML and DDL on core tables for the applications. The
audit table will be owned by a special audit_user. Everyone else will have
select and insert privilege on the audit tables (no update and delete
privileges will be granted).

If anyone would like to test this, let me know, that would help me too to
improve my code. In the next release of this code I am planning to provide
some checks that can identify if the table structure has been modified so
appropriate trigger and associated audit procedure can be regenerated to
accommodate the table change.

Cheers
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, January 15, 2002 1:20 PM
To: Multiple recipients of list ORACLE-L


A small con for the PL/SQL procedures is that I have to rebuild the
procedure for a table when the table structure changes(column
added/dropped).  Granted, I could probably build a more dynamic upd/del/ins
procedure for each table, but then I am trying to keep the procedure code
tight.

Also, I noticed that the current version does some basic checks before
executing the INSERT/UPDATE/DELETE SQL.  For example, it checks to see if
the record exists before executing the INSERT sql.



*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

RE: sniped sessions

2002-01-15 Thread david hill


here is a little script i wrote
simpliefied a little
it first kills the session within oracle then generates the unix commands to
kill the session
so there can never a mistake about killing the wrong pid
and i also insert into an oracle table all killed sessions so you can query
them a litlle easier
---kill_sniped_session.ksh---
#!/bin/sh
#CREATE TABLE killed_sessions
# (
#   SID   NUMBER,
#   SERIAL#   NUMBER,
#   SPID VARCHAR2(9),
#   USERNAME  VARCHAR2(30),
#   TIMESTAMP DATE
# ) tablespace DBA   
#   STORAGE ( INITIAL 1M NEXT 1M PCTINCREASE 0); 

tmpfile=/tmp/kill_sniped.$$
su - superman -c "sqlplus -s /@mer << 'EOF' 
whenever sqlerror exit 1
whenever oserror  exit 1
set serveroutput on
set feedback off 
spool $tmpfile
DECLARE
Stmt_StrVARCHAR2(200);
v_Sid   v\$session.sid%TYPE;
v_Serialv\$session.serial#%TYPE;
v_Username  v\$session.username%TYPE;
v_spid  v\$process.spid%TYPE;
CURSOR c_list IS
select a.SID, a.SERIAL#, a.USERNAME, b.SPID
from v\$session a, v\$process b
where a.paddr = b.addr
and a.STATUS = 'SNIPED';
BEGIN
FOR user in c_list
LOOP
v_sid := user.sid;
v_serial := user.serial#;
v_username := user.username;
v_spid := user.spid;
stmt_str := 'alter system kill session ''' || v_sid || ',' ||
v_serial || ;
insert into sys.killed_sessions values(v_sid, v_serial, v_spid,
v_username, sysdate);
DBMS_OUTPUT.PUT_LINE('kill -9 '|| v_spid);
Execute Immediate(stmt_str);
END LOOP;
END;
/
EOF" >>/dev/null 2>&1

cat $tmpfile |while read line ; do
cmd=$line
eval $cmd
done

rm -f $tmpfile


Thanks 
David Hill
DBA
Le Chateau Stores


-Original Message-
Sent: Tuesday, January 15, 2002 10:06 AM
To: Multiple recipients of list ORACLE-L


Attached are the scripts we use to kill sniped sessions.  This is part of a
series of monitoring scripts we developed for our Oracle databases.  The
scripts are scheduled through Cron and run every 15 minutes.  A logonid or
an email address is passed to the scripts for either paging or email.  In
this case an accum of sniped sessions is maintained on a 'flat' file just so
we can go back and check to see how many sniped sessions are being killed.
I will attach a zip file.  If that doesn't get through I will also list the
scripts below.

Ron Smith
Kerr-McGee Corp

SNIPED.SH

#! /bin/sh
#  DBA MONITORING SCRIPTS 
# **
#
# Author: Ron Smith
# Date:   06/18/98
# Funtion:Checks for sessions that have been "Sniped".
#
# **
#
# CHANGE HISTORY
#
# DATEWHO Reason for Change

# 03/03/00Ron Smith   New Prog

#
# **
#
# FUNCTION

#
# This script calls sniped.sql.
# The function of this script is to report sessions that have
# been "sniped" by Oracle through the use of resource limits.
#
# If the id of the DBA is a Zid, a page will be sent.  If the 
# id of the DBA is an email address (determined by looking for
# an "@" ) , an EMAIL will be sent.
#
# **
#
# PREREQUISITES
#
# The OPS$ORACLE user must exist in the instance.  This can be 
# created by running the opsuer.sql script in SQLPLUS while
# logged on as SYSTEM. 
#
# The cdmonitoring script must exist in the home/oracle
# directory.
#
# **
#
# RUN SYNTAX
#  
# sniped.sh (sid) (oncall dba)   
#  
#  
# **

# cd to the monitoring script directory
. $HOME/cdmonitoring.sh

ORACLE_SID=$1
export ORACLE_SID
DBA=$2
export DBA
echo $DBA
ATCNT=`echo $DBA | grep @ |  wc -l`
export ATCNT

ORACLE_HOME=`grep "^$ORACLE_SID:" /etc/oratab | head -1 | cut -d: -f2`
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:.
export PATH

# Delete the old list file if it exists

if [ -e sniped_$ORACLE_SID.lst ]
then rm sniped_$ORACLE_SID.lst
fi

# Delete the old error file if it exists

if [ -e sniped_$ORACLE_SID.err ]
then rm sniped_$ORACLE_SID.err
fi

# Delete the old kill file if it exists

if [ -e sniped_kill_$ORACLE_SID.sh ]
then rm sniped_kill_$ORACLE_SID.sh
fi

# If sending to EMAIL address, run sql with headings on else run with
headings off

if [ "$ATCNT" -gt "0" ]
then
sqlplus / @sniped.sql on  
else 
sqlplus / @sniped.sql off  
fi

# If there is anything i

Re: Role Privileges


dba_tab_privs will show you privileges granted to anyone, including
roles

select table_name, privilege from dba_tab_privs where grantee='';


--- Regina Harter <[EMAIL PROTECTED]> wrote:
> Okay, I knew this was going to happen one day, but I kept hoping as
> we 
> upgraded the problem would be corrected eventually.
> 
> ROLE_TAB_PRIVS will only show me tables privileges granted to a role
> by the 
> logged on user.  It wasn't such a problem before because I created
> most of 
> the roles and knew who was doing the granting.  Now I have a couple
> of 
> roles I didn't create and need to know what has been granted to them.
>  How 
> do I find out without knowing who did the granting?
> 
> Thank you, any help will be appreciated.
> 
> Regina
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Regina Harter
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Table partition on part of a field

2002-01-15 Thread Ron Rogers


That should not work because you have to give a value that the partition
can compare against such as 1 ,2 ,3, etc to define the limits of the
partition. In this case the limits would be undefined as you do not know
the value in the field you are using. The only function allowed in
partitioning is the to_date because it is used to convert a particular
value incomming to a range value "12-01-2001"
 How many 3 digit codes are you talking about? The easiest was sounds
like the 2 column description and then you couls partition on the 3
digit fiels.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 01/15/02 01:45PM >>>
Why can't you just use substr(your_key,8,3) as the partition key?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:50 PM


> Hello All
>
> I Received: from CONNECT-MTA by galotterneed to create a partitioned table base on 
>the last three digits on
9
> digits number.
>
> Create table test (zip_and_city_code number(9));
>
> The zip code is 6 digits and the city code is 3 digits.
>
> The design is from an application that used btrieve and is now ported
to
> Oracle.
> (I would not allow this design if it was a new system).
>
> I want to group every city records into its own partition.
>
> First I tried to use range partitioning based on a function on the
field
and
> it does not work.
>
> Then I thought about using hash partitioning using my own hash 
function
but
> could not find
> where I can use my own hash function.
>
> Any help to implement this @#$% design will be really appreciated.
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED] 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
Lists
> 
> 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.com 
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ORA-01555: snapshot too old: rollback segment number...


min extents = 20 is not carved in stone. You allocate them with the
number of extents that make sense for your database

the problem is, as new releases come out, old "facts" change and people
keep spreading them anyway

--- àãø_éçéàì <[EMAIL PROTECTED]> wrote:
> Hello Viktor
> 
> Regarding the rollback segments, I heard from Oracle that you need to
> allocate them
> with min extents=20. 
> This will cause users to get their own extents and the chance that a
> new
> update will overwrite 
> an old update that you need will decrease.
> Check metalink. they have a paper on this error (if I remember
> correctly)
> 
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
> 
> > -Original Message-
> > From:   Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tue, January 15, 2002 8:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: ORA-01555: snapshot too old: rollback segment
> number...
> > 
> > You can export with CONSISTENT=N; a consistent view of the data
> will not
> > be
> > achieved.  You can also increase the size of your rollback segments
> to
> > accommodate large queries while updates are being performed.  There
> is not
> > much else you can do on this one.
> > 
> > Thank You
> > 
> > Stephen P. Karniotis
> > Technical Alliance Manager
> > Compuware Corporation
> > Direct: (248) 865-4350
> > Mobile: (248) 408-2918
> > Email:  [EMAIL PROTECTED]
> > Web:www.compuware.com
> > 
> > 
> >  -Original Message-
> > Sent:   Tuesday, January 15, 2002 12:20 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:ORA-01555: snapshot too old: rollback segment number...
> > 
> > Hi all,
> > 
> > Last nignt when we were expring data for one of our
> > databases, this error ocurred:
> > 
> > ORA-01555: snapshot too old: rollback segment number
> > 3 with name "R02") offset=(0).
> > 
> > Now, we were able to once again export and load data
> > this morning. And there was no error.
> > 
> > What is the best aproach to try to eliminate this
> > error in the future?
> > 
> > Any suggestions apreciated.
> > 
> > Thanks
> > 
> > Regards
> > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send FREE video emails in Yahoo! Mail!
> > http://promo.yahoo.com/videomail/
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Viktor
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > 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.com
> > -- 
> > Author: Karniotis, Stephen
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > 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 was scanned by the eSafe Mail Gateway 
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-

Re: problem with 9i import

2002-01-15 Thread New2orcl


Hi,
 I guess i really don't understand. The way i did this import in the first 
place is in the command prompt I navigated to the folder that i had the 
exp.dat stored in and then I typed username/password then I typed imp 
expdat.dmp and then the rest came up on prompts. After seeing your reply I 
changed it to username\password@orcl then after that the rest doesn't give 
you much options. It came out the same.Could you please let me know the exact 
syntax to do this. i am just an Oracle student that wants to import all my 
tables and stuff from my Oracle 8i to Oracle 9i on my home PC. Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID


Thanks for the correction Steve.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com


 -Original Message-
Sent:   Tuesday, January 15, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SAME, WAFL and RAID

WAFL and SAME are not the same. WAFL stands for Write Anywhere File Layout.
It is a Network Appliance proprietary system and they've trade marked
"WAFL." Coincidentally it's a RAID 4 NFS implementation. See:
http://www.netapp.com/tech_library/3002.html#I3

Beware the marketing droids...


-Original Message-
Sent: Tuesday, January 15, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L

Bill:

  I believe that WAFL and SAME are variations on the technology implemented
for RAID.  WAFL and SAME are new technologies adopted by smaller disk
manufacturers as a way to complete against the RAID implementers like EMC,
Network Appliance, etc. 

  In my humble opinion, I would not bet the house on technology that you
have not test-driven.  I would suggest testing this stuff out and then
asking them for references.  As far as Gaja's paper, I have worked with Gaja
for at least 6 years and believe his paper to apply quite nicely.  It's not
the type of disk implemented, its how you implement it.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, January 15, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject:SAME, WAFL and RAID

Hello,

I am looking for any pointers to white papers, etc.
that discuss the differences/similarities among
WAFL, SAME and RAID (shake, rattle and roll? - sorry)
file systems. We have some systems people pushing a vendor 
(Procom) and their WAFL filesystem as a platform for an 
Oracle data warehouse; showing them parts of Gaja's paper 
"Implementing Raid on Oracle Systems"
resulted in the response of "WAFL is different from Raid - this
paper doesn't apply". I found a white paper "Optimal
Storage Configuration Made Easy" on Technet, which
advocates the SAME methodology, and am wondering about the
differences among these configurations.

Are WAFL and SAME the same(sic)?
Are WAFL and/or SAME just other variants of Raid, or are the
differences greater than the similarities?

As always, any advice/comments are appreciated. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RPAD problem

2002-01-15 Thread Seefelt, Beth



Use nvl also -

Newvalue = rpad(nvl(oldvalue,' '),9)



-Original Message-
Sent: Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L

I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query.  If the
person has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: limit user CPU usage

2002-01-15 Thread Ron Rogers


Kevin,
You could try creating a profile with the cpu_per_call and
cpu_per_session set ta a particular value. It will limit the amount of
time in hundredths of a second to the user assigned to the profile. I
woul experiment with the values before I assigned it to a user. The
manual does not say it will act as a choke on cpu usage other than
time.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 01/15/02 01:10PM >>>
Hi, Guys,

Is there some parameters or user-profile prometers in  Oracle can limit
user CPU usage?
I mean, make specific user or all users use less CPU, I has a SQL query
that use 100% CPU.
I know the SQL is bad, but before developer change it, Is there
something I can do?
Any suggestion will be highly appreciated.
My environment is Oracle8.1.6 on Win2000.

Thanks,

Kevin  Wang



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Role Privileges


Okay, I knew this was going to happen one day, but I kept hoping as we 
upgraded the problem would be corrected eventually.

ROLE_TAB_PRIVS will only show me tables privileges granted to a role by the 
logged on user.  It wasn't such a problem before because I created most of 
the roles and knew who was doing the granting.  Now I have a couple of 
roles I didn't create and need to know what has been granted to them.  How 
do I find out without knowing who did the granting?

Thank you, any help will be appreciated.

Regina

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RPAD problem


Use the NVL function...  i.e. RPAD(NVL(A.SSN,0),9)

-Original Message-
Sent: Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L


I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query.  If the
person has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

2002-01-15 Thread Kevin Lange


Bill;
  We are using the Netapp filler with the WAFL file system and, I must tell
you, I like it.  
It has some very good advantages.  The largest, in my mind, is the fact that
our downtime to do backups is only about 5 minutes a day.   We take the DBs
down , make a snapshot, then bring them back up.   After that, we make a
backup of the snapshot onto tape without interupting production any more.

I think its worth file for you to look into them.

NetApp has a technical library that might help you get some information on
it.  You can find it at http://www.netapp.com/tech_library/

Good luck.

Kevin

-Original Message-
Sent: Tuesday, January 15, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


Hello,

I am looking for any pointers to white papers, etc.
that discuss the differences/similarities among
WAFL, SAME and RAID (shake, rattle and roll? - sorry)
file systems. We have some systems people pushing a vendor 
(Procom) and their WAFL filesystem as a platform for an 
Oracle data warehouse; showing them parts of Gaja's paper 
"Implementing Raid on Oracle Systems"
resulted in the response of "WAFL is different from Raid - this
paper doesn't apply". I found a white paper "Optimal
Storage Configuration Made Easy" on Technet, which
advocates the SAME methodology, and am wondering about the
differences among these configurations.

Are WAFL and SAME the same(sic)?
Are WAFL and/or SAME just other variants of Raid, or are the
differences greater than the similarities?

As always, any advice/comments are appreciated. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread אדר יחיאל


Hello Viktor

Regarding the rollback segments, I heard from Oracle that you need to
allocate them
with min extents=20. 
This will cause users to get their own extents and the chance that a new
update will overwrite 
an old update that you need will decrease.
Check metalink. they have a paper on this error (if I remember correctly)

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, January 15, 2002 8:05 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: ORA-01555: snapshot too old: rollback segment number...
> 
> You can export with CONSISTENT=N; a consistent view of the data will not
> be
> achieved.  You can also increase the size of your rollback segments to
> accommodate large queries while updates are being performed.  There is not
> much else you can do on this one.
> 
> Thank You
> 
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
> 
> 
>  -Original Message-
> Sent: Tuesday, January 15, 2002 12:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ORA-01555: snapshot too old: rollback segment number...
> 
> Hi all,
> 
> Last nignt when we were expring data for one of our
> databases, this error ocurred:
> 
> ORA-01555: snapshot too old: rollback segment number
> 3 with name "R02") offset=(0).
> 
> Now, we were able to once again export and load data
> this morning. And there was no error.
> 
> What is the best aproach to try to eliminate this
> error in the future?
> 
> Any suggestions apreciated.
> 
> Thanks
> 
> Regards
> 
> 
> 
> __
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Viktor
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> -- 
> Author: Karniotis, Stephen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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 was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Using procedures instead of coding update/insert

2002-01-15 Thread Igor Neyman


Nothing prohibits from using arrays as parameters, when calling stored
procedures.
So, there goes the advantage of 'prepared statements' in doing array binds.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:17 PM


> So what is the basis for the case by case judgement.  I'm not being flip -
> I really want to know.
>
> From the discussion so far it appears that the pros for PL/SQL procedures
> are:
>
>Uniform access method to the database for all applications
>Processing done on the more robust server machine
>Less impact on the SGA
>Ease of maintenance
>"Loosely couples" the application to the database in that database
>changes only impact the procedures, not the code
>
> The pros for prepared statements is that you can do array binds (which
give
> better performance).
>
> Anything else?  I'll be the first to admit that PL/SQL development is my
> short suit.
>
>
>
>
> "Gogala,
> Mladen"  To: Multiple recipients of
list ORACLE-L
> 
> @oxhp.com>   cc:
> Sent by: rootSubject: RE: Using procedures
instead of
>  coding update/insert
>
> 01/15/2002
> 11:40 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> The reason for that is the fact that with prepared statements you
> can do array binds while that isn't possible with the stored procedures.
> I don't like this kind of comparisons. I judge on case by case basis.
>
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We have done some preliminary testing and found prepared statements about
> 20% faster than stored procedures. We inserted 200,000 records at a time
> (28-50 columns in a table ) using stored procedures and then used prepared
> statements for the same dataset. Both of them were called from java using
> JDBC thin drivers and interestingly found prepared statements faster.
> Similarly, deletes were also about 15%-20% faster using prepared
> statements.
> For some reasons, updates to the same tables gave almost identical
> performance.
>
> Rakesh
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rakesh Gupta
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 y

RE: Using procedures instead of coding update/insert

2002-01-15 Thread Gogala, Mladen


That is correct, but, unfortunately, in most cases
scalars are passed as parameters. That option is
available only as of 8.1.7 when you can bind a 3GL 
array or a Java array to PL/SQL array.

-Original Message-
Sent: Tuesday, January 15, 2002 1:46 PM
To: Multiple recipients of list ORACLE-L


Nothing prohibits from using arrays as parameters, when calling stored
procedures.
So, there goes the advantage of 'prepared statements' in doing array binds.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:17 PM


> So what is the basis for the case by case judgement.  I'm not being flip -
> I really want to know.
>
> From the discussion so far it appears that the pros for PL/SQL procedures
> are:
>
>Uniform access method to the database for all applications
>Processing done on the more robust server machine
>Less impact on the SGA
>Ease of maintenance
>"Loosely couples" the application to the database in that database
>changes only impact the procedures, not the code
>
> The pros for prepared statements is that you can do array binds (which
give
> better performance).
>
> Anything else?  I'll be the first to admit that PL/SQL development is my
> short suit.
>
>
>
>
> "Gogala,
> Mladen"  To: Multiple recipients of
list ORACLE-L
> 
> @oxhp.com>   cc:
> Sent by: rootSubject: RE: Using procedures
instead of
>  coding update/insert
>
> 01/15/2002
> 11:40 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> The reason for that is the fact that with prepared statements you
> can do array binds while that isn't possible with the stored procedures.
> I don't like this kind of comparisons. I judge on case by case basis.
>
>
> -Original Message-
> Sent: Tuesday, January 15, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We have done some preliminary testing and found prepared statements about
> 20% faster than stored procedures. We inserted 200,000 records at a time
> (28-50 columns in a table ) using stored procedures and then used prepared
> statements for the same dataset. Both of them were called from java using
> JDBC thin drivers and interestingly found prepared statements faster.
> Similarly, deletes were also about 15%-20% faster using prepared
> statements.
> For some reasons, updates to the same tables gave almost identical
> performance.
>
> Rakesh
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rakesh Gupta
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Ma

RE: Table partition on part of a field

2002-01-15 Thread Seefelt, Beth



Could you create another column that stores just the city_code.  Use insert
and update triggers to populate this field, and use it as the basis for the
partitioning?


-Original Message-
Sent: Tuesday, January 15, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L

Hello All

I need to create a partitioned table base on the last three digits on 9
digits number.

Create table test (zip_and_city_code number(9));

The zip code is 6 digits and the city code is 3 digits.

The design is from an application that used btrieve and is now ported to
Oracle.
(I would not allow this design if it was a new system).

I want to group every city records into its own partition.

First I tried to use range partitioning based on a function on the field and
it does not work.

Then I thought about using hash partitioning using my own hash  function but
could not find 
where I can use my own hash function.

Any help to implement this @#$% design will be really appreciated.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: sniped sessions

2002-01-15 Thread Sunil_Nookala


appreciate you help guys..

-Original Message-
Sent: Tuesday, January 15, 2002 9:06 AM
To: Multiple recipients of list ORACLE-L


Attached are the scripts we use to kill sniped sessions.  This is part of a
series of monitoring scripts we developed for our Oracle databases.  The
scripts are scheduled through Cron and run every 15 minutes.  A logonid or
an email address is passed to the scripts for either paging or email.  In
this case an accum of sniped sessions is maintained on a 'flat' file just so
we can go back and check to see how many sniped sessions are being killed.
I will attach a zip file.  If that doesn't get through I will also list the
scripts below.

Ron Smith
Kerr-McGee Corp

SNIPED.SH

#! /bin/sh
#  DBA MONITORING SCRIPTS 
# **
#
# Author: Ron Smith
# Date:   06/18/98
# Funtion:Checks for sessions that have been "Sniped".
#
# **
#
# CHANGE HISTORY
#
# DATEWHO Reason for Change

# 03/03/00Ron Smith   New Prog

#
# **
#
# FUNCTION

#
# This script calls sniped.sql.
# The function of this script is to report sessions that have
# been "sniped" by Oracle through the use of resource limits.
#
# If the id of the DBA is a Zid, a page will be sent.  If the 
# id of the DBA is an email address (determined by looking for
# an "@" ) , an EMAIL will be sent.
#
# **
#
# PREREQUISITES
#
# The OPS$ORACLE user must exist in the instance.  This can be 
# created by running the opsuer.sql script in SQLPLUS while
# logged on as SYSTEM. 
#
# The cdmonitoring script must exist in the home/oracle
# directory.
#
# **
#
# RUN SYNTAX
#  
# sniped.sh (sid) (oncall dba)   
#  
#  
# **

# cd to the monitoring script directory
. $HOME/cdmonitoring.sh

ORACLE_SID=$1
export ORACLE_SID
DBA=$2
export DBA
echo $DBA
ATCNT=`echo $DBA | grep @ |  wc -l`
export ATCNT

ORACLE_HOME=`grep "^$ORACLE_SID:" /etc/oratab | head -1 | cut -d: -f2`
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:.
export PATH

# Delete the old list file if it exists

if [ -e sniped_$ORACLE_SID.lst ]
then rm sniped_$ORACLE_SID.lst
fi

# Delete the old error file if it exists

if [ -e sniped_$ORACLE_SID.err ]
then rm sniped_$ORACLE_SID.err
fi

# Delete the old kill file if it exists

if [ -e sniped_kill_$ORACLE_SID.sh ]
then rm sniped_kill_$ORACLE_SID.sh
fi

# If sending to EMAIL address, run sql with headings on else run with
headings off

if [ "$ATCNT" -gt "0" ]
then
sqlplus / @sniped.sql on  
else 
sqlplus / @sniped.sql off  
fi

# If there is anything in the lst file then kill the user processes and send
a message

if [ -s sniped_$ORACLE_SID.lst ]
then cat sniped_$ORACLE_SID.lst >> sniped_accum.lst

sqlplus / @sniped2.sql

if [ -s sniped_kill_$ORACLE_SID.sh ]
   then chmod +x sniped_kill_$ORACLE_SID.sh;
cat sniped_kill_$ORACLE_SID.sh >> sniped_kill_accum.lst
./sniped_kill_$ORACLE_SID.sh;
fi

echo "-DBA- Sniped sessions killed " > sniped_$ORACLE_SID.err
echo "SID=" $ORACLE_SID " " >> sniped_$ORACLE_SID.err
cat sniped_$ORACLE_SID.lst >> sniped_$ORACLE_SID.err

if [ "$ATCNT" -gt "0" ]
then
echo "email sent"
elm -s "-DBA- $ORACLE_SID Sniped sessions exist" $DBA <
sniped_$ORACLE_SID.err
else
LC=`cat sniped_$ORACLE_SID.lst | sed -e 's/  */ /g' | wc -c`
echo $LC
if [ "$LC" -gt "160" ]
then echo "Sniped sessions killed. Check
sniped_$ORACLE_SID.lst" >> sniped_$ORACLE_SID.err
else
cat sniped_$ORACLE_SID.lst >> sniped_$ORACLE_SID.err
fi
echo "page sent"
pager $DBA "`cat sniped_$ORACLE_SID.err`"
fi
fi


SNIPED.SQL

set pause off
SET ECHO off
set verify off
set feedback off
set linesize 132
set heading &1
col "User Name"  format a10;
alter session set nls_date_format = 'dd-MON- hh24:mi:ss';
spool sniped_$ORACLE_SID.lst

select s.username "User Name",
s.osuser "OS User",
s.status "Status",
s.logon_time "Connect Time",
p.spid, p.pid, si.sid
from sys.v_$sess_io si, sys.v_$session s, sys.v_$process p
where s.username is not null and 
si.sid(+)=s.sid
and p.addr(+)=s.paddr
and  status = 'SNIPED';

spool off;
e

RE: limit user CPU usage

2002-01-15 Thread Carle, William T (Bill), ALINF










Hi,

 

    You can set up a profile to
set resource limits and have the user use that profile. This is explained in
the Oracle Administrator’s Guide.

 



Bill
Carle

AT&T

Database
Administrator

816-995-3922

[EMAIL PROTECTED]

 

-Original
Message-
From: kevin wang
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002
12:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: limit user CPU usage

 

Hi,
Guys,

 

Is
there some parameters or user-profile prometers in  Oracle can limit user
CPU usage?

I mean,
make specific user or all users use less CPU, I has a SQL query that use 100%
CPU.

I know
the SQL is bad, but before developer change it, Is there something I can
do?

Any
suggestion will be highly appreciated.

My
environment is Oracle8.1.6 on Win2000.

 

Thanks,

 

Kevin 
Wang

Re: Table partition on part of a field

2002-01-15 Thread Ruth Gramolini


Why can't you just use substr(your_key,8,3) as the partition key?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:50 PM


> Hello All
>
> I need to create a partitioned table base on the last three digits on 9
> digits number.
>
> Create table test (zip_and_city_code number(9));
>
> The zip code is 6 digits and the city code is 3 digits.
>
> The design is from an application that used btrieve and is now ported to
> Oracle.
> (I would not allow this design if it was a new system).
>
> I want to group every city records into its own partition.
>
> First I tried to use range partitioning based on a function on the field
and
> it does not work.
>
> Then I thought about using hash partitioning using my own hash  function
but
> could not find
> where I can use my own hash function.
>
> Any help to implement this @#$% design will be really appreciated.
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Microsoft Training


Anyone doing 

Oracle DBA
on NT boxes
with MS certifications (MCSE, e.g.)

who has recommendations on

what to take
what to avoid

?

any thoughts welcome. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RPAD problem

2002-01-15 Thread Kirsh, Gary


Are you concatenating the result by any chance?  That will remove duplicate
blanks?
Gary

Gary Kirsh
Next Extent, Inc.

-Original Message-
Sent: Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L


I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query.  If the
person has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kirsh, Gary
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RPAD problem

2002-01-15 Thread Mercadante, Thomas F


Rod,

RPAD, like all Oracle functions, will not work on a column that is null.

Your problem is easily fixed though:
RPAD(nvl(A.SSN,' '),9)

Good Luck!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L


I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query.  If the
person has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Table partition on part of a field

2002-01-15 Thread Khedr, Waleed


Make it two fields 6 & 3
Partition on 3
And create a view to concatenate the two fields into one

Regards,
Waleed

-Original Message-
Sent: Tuesday, January 15, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L


Hello All

I need to create a partitioned table base on the last three digits on 9
digits number.

Create table test (zip_and_city_code number(9));

The zip code is 6 digits and the city code is 3 digits.

The design is from an application that used btrieve and is now ported to
Oracle.
(I would not allow this design if it was a new system).

I want to group every city records into its own partition.

First I tried to use range partitioning based on a function on the field and
it does not work.

Then I thought about using hash partitioning using my own hash  function but
could not find 
where I can use my own hash function.

Any help to implement this @#$% design will be really appreciated.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RPAD problem


If they have a null value in place of the SSN field, you can use NVL for
this and pad with one blank.  Also, check to make sure that the field is not
VARCHAR2.  If it is, blanks are chopped...

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com


 -Original Message-
Sent:   Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L
Subject:RPAD problem

I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query.  If the
person has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ora-00600 error

2002-01-15 Thread Glenn Stauffer

This comes up with an application that I manage.  The error is a generic one 
which indicates that there is a problem in the communication between the 
client and the server process.  In my situation, a Forms application, this 
occurs most often when a session gets timed out after being inactive for more 
than 10 hours.  When they try to continue working with the Forms application, 
they get an error message on their screen and the Ora-00600 [12333] error 
gets logged on the server.

Glenn

On Tuesday 15 January 2002 10:20 am, you wrote:
> I am getting an
> ORA-00600: internal error code, arguments: [12333],
> [0], [0], [0], [], [], [], []error.  How do I find out
> what is causing this problem?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Stauffer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: TOAD Software???

2002-01-15 Thread Steve McClure



>and what about the Irish versions?

Ahh the Irish.  Old Bushmills Single Malt I think the bottle says 10 years.
That is good sippin stuff, all the rest of the Irish are best in coffee.

I am surprised at the number of Scotch fans here.  All this talk of visiting
Distilleries is making me want to take a trip.  Well at least a drive to
Liqour Store.


Steve

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID

2002-01-15 Thread Orr, Steve


WAFL and SAME are not the same. WAFL stands for Write Anywhere File Layout.
It is a Network Appliance proprietary system and they've trade marked
"WAFL." Coincidentally it's a RAID 4 NFS implementation. See:
http://www.netapp.com/tech_library/3002.html#I3

Beware the marketing droids...


-Original Message-
Sent: Tuesday, January 15, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L

Bill:

  I believe that WAFL and SAME are variations on the technology implemented
for RAID.  WAFL and SAME are new technologies adopted by smaller disk
manufacturers as a way to complete against the RAID implementers like EMC,
Network Appliance, etc. 

  In my humble opinion, I would not bet the house on technology that you
have not test-driven.  I would suggest testing this stuff out and then
asking them for references.  As far as Gaja's paper, I have worked with Gaja
for at least 6 years and believe his paper to apply quite nicely.  It's not
the type of disk implemented, its how you implement it.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, January 15, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject:SAME, WAFL and RAID

Hello,

I am looking for any pointers to white papers, etc.
that discuss the differences/similarities among
WAFL, SAME and RAID (shake, rattle and roll? - sorry)
file systems. We have some systems people pushing a vendor 
(Procom) and their WAFL filesystem as a platform for an 
Oracle data warehouse; showing them parts of Gaja's paper 
"Implementing Raid on Oracle Systems"
resulted in the response of "WAFL is different from Raid - this
paper doesn't apply". I found a white paper "Optimal
Storage Configuration Made Easy" on Technet, which
advocates the SAME methodology, and am wondering about the
differences among these configurations.

Are WAFL and SAME the same(sic)?
Are WAFL and/or SAME just other variants of Raid, or are the
differences greater than the similarities?

As always, any advice/comments are appreciated. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Using procedures instead of coding update/insert

2002-01-15 Thread Gogala, Mladen


They are possible, all right, with forall statement
and/or with passing an array as a parameter. How many
of your procedures do actually use that feature? Are you sure
that the guy who has tested the difference between prepared
SQL and PL/SQL procedure has done the necessary coding in order 
to compare apples to apples. 
Second, do not confuse array binds with passing an array.
To pass an array, you have to define a type, define parameter 
of that type and pass the array as an object type. Not very intuitive
or simple. 

-Original Message-
Sent: Tuesday, January 15, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L


You must be using Oracle 8.0 or earlier. Bulk/array binds are possible in
PL/SQL (stored procedures) starting with Oracle 8i

-Original Message-
Sent: Tuesday, January 15, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L


The reason for that is the fact that with prepared statements you 
can do array binds while that isn't possible with the stored procedures.
I don't like this kind of comparisons. I judge on case by case basis.


-Original Message-
Sent: Tuesday, January 15, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L


We have done some preliminary testing and found prepared statements about
20% faster than stored procedures. We inserted 200,000 records at a time
(28-50 columns in a table ) using stored procedures and then used prepared
statements for the same dataset. Both of them were called from java using
JDBC thin drivers and interestingly found prepared statements faster.
Similarly, deletes were also about 15%-20% faster using prepared statements.
For some reasons, updates to the same tables gave almost identical
performance.

Rakesh

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RPAD problem

2002-01-15 Thread Nick Wagner

Title: RE: RPAD problem





try this...


RPAD(nvl(A.SSN,' '),9)


Nick


-Original Message-
From: Rod Clayton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 9:17 AM
To: Multiple recipients of list ORACLE-L
Subject: RPAD problem



I am trying to create fixed length records from Oracle variable length data.


I have the command RPAD(A.SSN,9) in the select statement of a query.  If the person has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?


Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: Using procedures instead of coding update/insert

2002-01-15 Thread Grabowy, Chris


A small con for the PL/SQL procedures is that I have to rebuild the
procedure for a table when the table structure changes(column
added/dropped).  Granted, I could probably build a more dynamic upd/del/ins
procedure for each table, but then I am trying to keep the procedure code
tight.

Also, I noticed that the current version does some basic checks before
executing the INSERT/UPDATE/DELETE SQL.  For example, it checks to see if
the record exists before executing the INSERT sql.

-Original Message-
Sent: Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L


So what is the basis for the case by case judgement.  I'm not being flip -
I really want to know.

>From the discussion so far it appears that the pros for PL/SQL procedures
are:

   Uniform access method to the database for all applications
   Processing done on the more robust server machine
   Less impact on the SGA
   Ease of maintenance
   "Loosely couples" the application to the database in that database
   changes only impact the procedures, not the code

The pros for prepared statements is that you can do array binds (which give
better performance).

Anything else?  I'll be the first to admit that PL/SQL development is my
short suit.



 

"Gogala,

Mladen"  To: Multiple recipients of list
ORACLE-L  


@oxhp.com>   cc:

Sent by: rootSubject: RE: Using procedures
instead of  
 coding update/insert

 

01/15/2002

11:40 AM

Please

respond to

ORACLE-L

 

 





The reason for that is the fact that with prepared statements you
can do array binds while that isn't possible with the stored procedures.
I don't like this kind of comparisons. I judge on case by case basis.


-Original Message-
Sent: Tuesday, January 15, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L


We have done some preliminary testing and found prepared statements about
20% faster than stored procedures. We inserted 200,000 records at a time
(28-50 columns in a table ) using stored procedures and then used prepared
statements for the same dataset. Both of them were called from java using
JDBC thin drivers and interestingly found prepared statements faster.
Similarly, deletes were also about 15%-20% faster using prepared
statements.
For some reasons, updates to the same tables gave almost identical
performance.

Rakesh

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of

RE: Using procedures instead of coding update/insert SQL...huh?

you oughta apologize to Robert Pirsig, the guy who started the whole thing. 

-Original Message-
Sent: Tuesday, January 15, 2002 12:35 PM
To: Multiple recipients of list ORACLE-L

[EMAIL PROTECTED] wrote:

>oh, now I owe you a royalty for naming a new book "Zen and the Art of
>Database Administration" (my apologies to the author of Zen and the Art
>of Archery)
>
somehow i don't think he'll mind.;-)

-- 
--
Bill "Shrek" Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

LISP: To call a spade a thpade.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

limit user CPU usage

2002-01-15 Thread kevin wang





Hi, Guys,
 
Is there some parameters or user-profile prometers 
in  Oracle can limit user CPU usage?
I mean, make specific user or all users use less 
CPU, I has a SQL query that use 100% CPU.
I know the SQL is bad, but before developer 
change it, Is there something I can do?
Any suggestion will be highly 
appreciated.
My environment is Oracle8.1.6 on 
Win2000.
 
Thanks,
 
Kevin  Wang

Re: Pin object into shared pool

2002-01-15 Thread mitchell


Hi DBAs

It is recommend by Oracle to pin frequenly  used packages into shared pool,
I had a table (read only) and mostly used,. Can I pin it into shared pool.
What kind of objects could I pin into shared pool area?



Thanks in advance

like this:

execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')

Mitchell




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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Using procedures instead of coding update/insert

2002-01-15 Thread Jim Hawkins


I would also add that since stored procedures are "stored" in the database, they are 
backed up in the database as well.  This has saved me a few times...

Jim

[EMAIL PROTECTED] wrote:

>So what is the basis for the case by case judgement.  I'm not being flip -
>I really want to know.
>
>From the discussion so far it appears that the pros for PL/SQL procedures
>are:
>
>   Uniform access method to the database for all applications
>   Processing done on the more robust server machine
>   Less impact on the SGA
>   Ease of maintenance
>   "Loosely couples" the application to the database in that database
>   changes only impact the procedures, not the code
>
>The pros for prepared statements is that you can do array binds (which give
>better performance).
>
>Anything else?  I'll be the first to admit that PL/SQL development is my
>short suit.
>
>
>
>  
> 
>"Gogala,  
> 
>Mladen"  To: Multiple recipients of list ORACLE-L 
> 
>   
> 
>@oxhp.com>   cc:  
> 
>Sent by: rootSubject: RE: Using procedures instead of 
> 
> coding update/insert 
> 
>  
> 
>01/15/2002
> 
>11:40 AM  
> 
>Please
> 
>respond to
> 
>ORACLE-L  
> 
>  
> 
>  
> 
>
>
>
>
>The reason for that is the fact that with prepared statements you
>can do array binds while that isn't possible with the stored procedures.
>I don't like this kind of comparisons. I judge on case by case basis.
>
>
>-Original Message-
>Sent: Tuesday, January 15, 2002 10:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>We have done some preliminary testing and found prepared statements about
>20% faster than stored procedures. We inserted 200,000 records at a time
>(28-50 columns in a table ) using stored procedures and then used prepared
>statements for the same dataset. Both of them were called from java using
>JDBC thin drivers and interestingly found prepared statements faster.
>Similarly, deletes were also about 15%-20% faster using prepared
>statements.
>For some reasons, updates to the same tables gave almost identical
>performance.
>
>Rakesh
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rakesh Gupta
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
>--
>Author: Gogala, Mladen
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
>-- 
>Author: 
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 mailin

RE: Using procedures instead of coding update/insert

2002-01-15 Thread Toepke, Kevin M


You must be using Oracle 8.0 or earlier. Bulk/array binds are possible in
PL/SQL (stored procedures) starting with Oracle 8i

-Original Message-
Sent: Tuesday, January 15, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L


The reason for that is the fact that with prepared statements you 
can do array binds while that isn't possible with the stored procedures.
I don't like this kind of comparisons. I judge on case by case basis.


-Original Message-
Sent: Tuesday, January 15, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L


We have done some preliminary testing and found prepared statements about
20% faster than stored procedures. We inserted 200,000 records at a time
(28-50 columns in a table ) using stored procedures and then used prepared
statements for the same dataset. Both of them were called from java using
JDBC thin drivers and interestingly found prepared statements faster.
Similarly, deletes were also about 15%-20% faster using prepared statements.
For some reasons, updates to the same tables gave almost identical
performance.

Rakesh

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ORA-01555: snapshot too old: rollback segment number...


You can export with CONSISTENT=N; a consistent view of the data will not be
achieved.  You can also increase the size of your rollback segments to
accommodate large queries while updates are being performed.  There is not
much else you can do on this one.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com


 -Original Message-
Sent:   Tuesday, January 15, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject:ORA-01555: snapshot too old: rollback segment number...

Hi all,

Last nignt when we were expring data for one of our
databases, this error ocurred:

ORA-01555: snapshot too old: rollback segment number
3 with name "R02") offset=(0).

Now, we were able to once again export and load data
this morning. And there was no error.

What is the best aproach to try to eliminate this
error in the future?

Any suggestions apreciated.

Thanks

Regards



__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Babich , Sergey


Hi, Viktor,
Have any long transactions been running parallel to the export when it
happened?
And do you specify the parameter CONSISTENT=Y for the export?
Regards,,
Sergey Babich

 -Original Message-
Sent:   Tuesday, January 15, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject:ORA-01555: snapshot too old: rollback segment number...

Hi all,

Last nignt when we were expring data for one of our
databases, this error ocurred:

ORA-01555: snapshot too old: rollback segment number
3 with name "R02") offset=(0).

Now, we were able to once again export and load data
this morning. And there was no error.

What is the best aproach to try to eliminate this
error in the future?

Any suggestions apreciated.

Thanks

Regards



__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Babich , Sergey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RPAD problem

2002-01-15 Thread Rod Clayton


I am trying to create fixed length records from Oracle variable length data.

I have the command RPAD(A.SSN,9) in the select statement of a query.  If the person 
has '' in the SSN field,  RPAD does not pad it out to 9 spaces.

Is there aother way to do this?

Thanks,
Rod
-- 
Rod Clayton KA3BHY
Systems Programmer
Howard County Public Schools
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rod Clayton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Locally Managed Tablespace

2002-01-15 Thread Wong, Bing


My question is do you excusively use up 5gig?  if so, does your SQL results
in Cartesian product?  My shop ran into this and I had developers corrected
the SQL and then never happen again.  I still left the TEMP tablespace which
is LMT to be 700MB.





-Original Message-
Sent: Tuesday, January 15, 2002 9:11 AM
To: Multiple recipients of list ORACLE-L


Please check whether tables involved/indexes involved have degree > 1. 
Please make it 1 if not and try. If it becomes HASH sort instead of SORT
this problem happens. You can check it degree from dba_tables or 
dba_indexes.

You may use following query while running your job to establsish what type 
of sort..
select user,segtype,extents from v$sort_usage;

Regards
Rafiq





Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 15 Jan 2002 07:15:31 -0800

Best possible solution: rewrite the query and try to avoid large sorts
... or split the query, and make use of temporary tables (by using CTAS)
to save results of the first part ...

HTH,  Remco

-Oorspronkelijk bericht-
Van: Sajid Iqbal [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 15 januari 2002 10:50
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Locally Managed Tablespace


Hi all

I am getting this error while running a large query, I recently created
this locally managed temp tablespace...

Any advice on possible solutions, the tablespace is 5 gig

ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL

TIA

--
Saj Iqbal




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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Daemen, Remco
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).




MOHAMMAD RAFIQ


_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Table partition on part of a field

2002-01-15 Thread אדר יחיאל


Hello All

I need to create a partitioned table base on the last three digits on 9
digits number.

Create table test (zip_and_city_code number(9));

The zip code is 6 digits and the city code is 3 digits.

The design is from an application that used btrieve and is now ported to
Oracle.
(I would not allow this design if it was a new system).

I want to group every city records into its own partition.

First I tried to use range partitioning based on a function on the field and
it does not work.

Then I thought about using hash partitioning using my own hash  function but
could not find 
where I can use my own hash function.

Any help to implement this @#$% design will be really appreciated.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: SAME, WAFL and RAID