Re: Partitioning question (duplicate?)

[Wolfgang Breitling]

The only way I see is using a system-maintained ( through a before-insert 
and if necessary before-update trigger ) field that is set to 
to_char(,'mm') and then range partition on that.

At 03:24 PM 1/14/2004, you wrote:
Pardon if this is a duplicate, but the original has not shown up
on the list after 3 hours...
Is it possible in 9.2 to partition on a function?

I have a table with a date column and I would like to partition
by month, regardless of the year. For example, data from January
2003 or January 2004 would go into the same partition. Any
sneaky ideas on how to accomplish this without changing the data
structures.
Daniel Fink
--
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

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

Re: Partitioning question (duplicate?)

[Tim Gorman]

Dan,

Good question, but unless I'm misinterpreting the results, the answer is
no...

SQL> show release
release 902000100
SQL> create table test
  2  (a date, b number, c number)
  3  partition by list (to_char(a, 'MON'))
  4  (partition pJAN values ('JAN')),
  5  (partition pFEB values ('FEB'))
  6  (partition pMAR values ('MAR'))
  7  (partition pAPR values ('APR'))
  8  (partition pMAY values ('MAY'));

partition by list (to_char(a, 'MON'))
  *
ERROR at line 3:
ORA-00907: missing right parenthesis

..seems to clearly be interpreting the phrase "to_char" as a column name...

Hope this helps...

-Tim

on 1/14/04 3:24 PM, Daniel Fink at [EMAIL PROTECTED] wrote:

> Pardon if this is a duplicate, but the original has not shown up
> on the list after 3 hours...
> 
> Is it possible in 9.2 to partition on a function?
> 
> I have a table with a date column and I would like to partition
> by month, regardless of the year. For example, data from January
> 2003 or January 2004 would go into the same partition. Any
> sneaky ideas on how to accomplish this without changing the data
> structures.
> 
> Daniel Fink

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

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

RE: Hi!!

[Goulet, Dick]

Teresita,
 
    What your 
DBA is talking about is Oracle's RMAN backup utility.  There us an 
interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian 
for the backups.  The first thing I'd suggest is finding out what version 
of Oracle your using.  There are significant differences in using and 
setting up the RMAN and Veritas software between the two.  Check out the 
documentation CD on RMAN that shipped with your database.
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original 
  Message-From: Teresita Castro 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 
  2004 8:14 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Hi!!
  Hi!!
  My name is Tere Castro I am from Mexico I am not a DBA, I 
  uses ORacle just to make queries, funtions some updates and create indexes or 
  tables, that all.
   
  Now I am in a little difficult situation, here we have a DBA 
  that do not have much experience. He has been working 
  with Veritas NetBackup  4.5 for Windows  for 
  three moths with out results. We still can not make a backup of our data 
  bases. 
  The situation is that because of that my boss make 
  me work with him in this task, of course I don't know anything about the 
  issue and my priority for tomorrow is to make and investigation of how other 
  people make their backups with Veritas.
  Our DBA explain us that it was a way that he saw in a book, 
  first make a complete backup of our databases on Sunday then from Monday thru 
  Wednesday made a incremental backup, then from Thursday thru Saturday 
  make another incremental backup, but this one will be done from the last 
  incremental backup of Wednesday to the day we are.
   
  -
  —--
  —--
   
  —
   
  —-
   
  —-
     
  Complete backup
  1  2   3    4    5  
    6    7 
   
  1-Monday
  7- Sunday
   
  I am really lost in this task because the person that is 
  suppose to teach about Veritas is really reluctant , but my boss what 
  results.
  If any one can help me telling was is the better way to do a 
  backup using Veritas that will be great. I also need to learn Veritas so if 
  you have any page or document that can help I will appreciate it.
  We really need to make this work because in the last weeks 
  we are having troubles with our server, with out explication it gets 
  crushes.
  I am using Oracle 9.2.0.2  in a Windows Server with 
  Windows 2000 SP3
  and 
  And the veritas is VERITAS NetBackup 4.5 for Windows 
  in  a Windows Server with Windows 2000 SP4
   
   

Re: Veritas Backup Question

[Mladen Gogala]

OK,  Teresita, what is your question? Do you have MLM? Did you put the database in the 
backup
mode? Did you save archives? How about the control files? Did you backup control  
files? I doubt that
this forum is an appropriate place for a backup & recovery course, but it seems that 
you have a good incentive 
to learn. First advice is to try to restore database and see whether you can actually 
recover. If you can, 
well, you're a pro. If you can't  get backup and recovery book, one of Rama 
Velpuri's, if possible. My 
favorite is V7 book, because it's not too thick, it's very clear and well written and 
I like the color of copper.
The most important thing about backup and recovery is never to allow yourself to run 
out of coffee. 




On 2004.01.14 21:14, Teresita Castro wrote:
>  
> Hi!!
> My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make 
> queries, funtions some updates and create indexes or tables, that all.
> 
> Now I am in a little difficult situation, here we have a DBA that do not have much 
> experience. He has been working with Veritas NetBackup  4.5 for Windows  for three 
> moths with out results. We still can not make a backup of our data bases. 
> The situation is that because of that my boss make me work with him in this task, of 
> course I don't know anything about the issue and my priority for tomorrow is to make 
> and investigation of how other people make their backups with Veritas.
> Our DBA explain us that it was a way that he saw in a book, first make a complete 
> backup of our databases on Sunday then from Monday thru Wednesday made a incremental 
> backup, then from Thursday thru Saturday make another incremental backup, but this 
> one will be done from the last incremental backup of Wednesday to the day we are.
> 
> -
> â--
> â--
>  â
>  â-
>  â-
>Complete backup
> 1  2   34567 
> 
> 1-Monday
> 7- Sunday
> 
> I am really lost in this task because the person that is suppose to teach about 
> Veritas is really reluctant , but my boss what results.
> If any one can help me telling was is the better way to do a backup using Veritas 
> that will be great. I also need to learn Veritas so if you have any page or document 
> that can help I will appreciate it.
> We really need to make this work because in the last weeks we are having troubles 
> with our server, with out explication it gets crushes.
> I am using Oracle 9.2.0.2  in a Windows Server with Windows 2000 SP3
> and 
> And the veritas is VERITAS NetBackup 4.5 for Windows in  a Windows Server with 
> Windows 2000 SP4
> 

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

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

RE: kill session privilage

[Jacques Kilchoer]

create procedure kill_your_session (in_sid in sys.v_$session.sid%type,
in_serial# in sys.v_$session.serial#%type)
as
   row_count pls_integer ;
begin
   select count (*)
into row_count
from v$session
where username = user and sid = in_sid and serial# = in_serial# ;
   if row_count > 0
   then
  execute immediate 'alter system kill session ''' ||
to_char (in_sid) || ', ' || to_char (in_serial#) ||  ;
   end if ;
end ;
/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

Veritas Backup Question

[Teresita Castro]

 
Hi!!
My name is Tere Castro I am from Mexico I am not a DBA, I uses 
ORacle just to make queries, funtions some updates and create indexes or tables, 
that all.
 
Now I am in a little difficult situation, here we have a DBA 
that do not have much experience. He has been working 
with Veritas NetBackup  4.5 for Windows  for 
three moths with out results. We still can not make a backup of our data bases. 

The situation is that because of that my boss make 
me work with him in this task, of course I don't know anything about the 
issue and my priority for tomorrow is to make and investigation of how other 
people make their backups with Veritas.
Our DBA explain us that it was a way that he saw in a book, 
first make a complete backup of our databases on Sunday then from Monday thru 
Wednesday made a incremental backup, then from Thursday thru Saturday make 
another incremental backup, but this one will be done from the last 
incremental backup of Wednesday to the day we are.
 
-
?--
?--
 
?
 
?-
 
?-
   
Complete backup
1  2   3    4    5  
  6    7 
 
1-Monday
7- Sunday
 
I am really lost in this task because the person that is 
suppose to teach about Veritas is really reluctant , but my boss what 
results.
If any one can help me telling was is the better way to do a 
backup using Veritas that will be great. I also need to learn Veritas so if you 
have any page or document that can help I will appreciate it.
We really need to make this work because in the last weeks we 
are having troubles with our server, with out explication it gets 
crushes.
I am using Oracle 9.2.0.2  in a Windows Server with 
Windows 2000 SP3
and 
And the veritas is VERITAS NetBackup 4.5 for Windows in  
a Windows Server with Windows 2000 SP4
 

Hi!!

[Teresita Castro]

Hi!!
My name is Tere Castro I am from Mexico I am not a DBA, I uses 
ORacle just to make queries, funtions some updates and create indexes or tables, 
that all.
 
Now I am in a little difficult situation, here we have a DBA 
that do not have much experience. He has been working 
with Veritas NetBackup  4.5 for Windows  for 
three moths with out results. We still can not make a backup of our data bases. 

The situation is that because of that my boss make 
me work with him in this task, of course I don't know anything about the 
issue and my priority for tomorrow is to make and investigation of how other 
people make their backups with Veritas.
Our DBA explain us that it was a way that he saw in a book, 
first make a complete backup of our databases on Sunday then from Monday thru 
Wednesday made a incremental backup, then from Thursday thru Saturday make 
another incremental backup, but this one will be done from the last 
incremental backup of Wednesday to the day we are.
 
-
?--
?--
 
?
 
?-
 
?-
   
Complete backup
1  2   3    4    5  
  6    7 
 
1-Monday
7- Sunday
 
I am really lost in this task because the person that is 
suppose to teach about Veritas is really reluctant , but my boss what 
results.
If any one can help me telling was is the better way to do a 
backup using Veritas that will be great. I also need to learn Veritas so if you 
have any page or document that can help I will appreciate it.
We really need to make this work because in the last weeks we 
are having troubles with our server, with out explication it gets 
crushes.
I am using Oracle 9.2.0.2  in a Windows Server with 
Windows 2000 SP3
and 
And the veritas is VERITAS NetBackup 4.5 for Windows in  
a Windows Server with Windows 2000 SP4
 
 

Re: Partitioning question (duplicate?)

[Rachel Carmichael]

First time I've seen this post. And from the fine Data Warehousing
manual:

here's an example of range partitioning. Note the "to_date" in the
values clause. I don't see why you couldn't use
to_date(date_column,'MONTH')

Rachel


CREATE TABLE sales
  (s_productid  NUMBER,
   s_saledate   DATE,
   s_custid NUMBER,
   s_totalprice NUMBER)
PARTITION BY RANGE(s_saledate)
 (PARTITION sal99q1 VALUES LESS THAN 
(TO_DATE('01-APR-1999','DD-MON-')),
  PARTITION sal99q2 VALUES LESS THAN 
(TO_DATE('01-JUL-1999','DD-MON-')),
  PARTITION sal99q3 VALUES LESS THAN
(TO_DATE('01-OCT-1999', 'DD-MON-')),
  PARTITION sal99q4 VALUES LESS THAN 
(TO_DATE('01-JAN-2000', 'DD-MON-')),
  PARTITION sal00q1 VALUES LESS THAN
(TO_DATE('01-APR-2000', 'DD-MON-')),
  PARTITION sal00q2 VALUES LESS THAN 
(TO_DATE('01-JUL-2000', 'DD-MON-')),
  PARTITION sal00q3 VALUES LESS THAN 
(TO_DATE('01-OCT-2000', 'DD-MON-')),
  PARTITION sal00q4 VALUES LESS THAN 
(TO_DATE('01-JAN-2001', 'DD-MON-')));


--- Daniel Fink <[EMAIL PROTECTED]> wrote:
> Pardon if this is a duplicate, but the original has not shown up
> on the list after 3 hours...
> 
> Is it possible in 9.2 to partition on a function?
> 
> I have a table with a date column and I would like to partition
> by month, regardless of the year. For example, data from January
> 2003 or January 2004 would go into the same partition. Any
> sneaky ideas on how to accomplish this without changing the data
> structures.
> 
> Daniel Fink
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Daniel Fink
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: Application Server Caching

[Mark Richard]

Just to elaborate - I did a poor job of explaining the sequence trick.

If the sequence returns a value of 12345 then the application knows it has
a range from 12345000 to 12345999 to use.  The next process will get the
sequence value 12346, providing a range from 12346000 to 12346999.  The
long numbers are used in the database to be unique but having the
application do a multiplication by 1000 certainly reduced load on the
sequence.



   
   
  Mark Richard 
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  ban.com.au>  cc: 
   
  Sent by: Subject:  Re: Application Server 
Caching   
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  15/01/2004 10:49 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   








Ryan,

Our application does a certain amount of application server caching, and
infact has a pretty advanced cache mechanism to deal with out of date
objects, etc.
On a more simple level - Common reference records are loaded at start up
and cached, error messages are cached, etc.  In a similar fashion we a a
sequence providing GUID values (global across our application at least) -
Obviously the application chews through these very fast (millions per day).
So, to reduce load each time the application gets a new value from the
sequence it treats it as a range of 1000 values.  If the app crashes we
only loose a few thousand sequence numbers (several processes each have
their own store of 1000 values) but access to the sequence is reduced by a
factor of 1000.  After three years of running the sequence is around
10,000,000 instead of 10,000,000,000!

It's all a matter of knowing what to cache and how to ensure it's still
current.  If you were populating a list of State Codes for a drop down list
then I would cache that result but something like a StockOnHandQuantity
figure probably changes so often that caching is of little use.

If you have the same query (ficticious eg: select statename, statecode from
states) constantly firing in your database then I guess it's a sign that
caching would help.  Even sub-second queries can quickly add up in a busy
system.

Cheers,
  Mark.





  "Ryan"

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

  Sent by: Subject:  Application Server
Caching
  [EMAIL PROTECTED]

  .com



  15/01/2004 09:14

  Please respond to

  ORACLE-L







I heard a presentation from a front end performance analyst last night from
www.tangasol.com (im not associated with them at all). He was pretty
impressive.

He argued that accessing the database is expensive. He also argued in favor
of caching data at the application server level. Have any of you worked
with this? What are your opinions? His opinion was that people go back to
the database to ask the same question way too often and cause a botteneck,
if you can cache these frequently asked questions at the front end, it will
significantly scale better.




<<>>

Privileged/Confidential information may be contained in this message.
If you are not the addressee indic

RAC on Win2K using RMAN to Create Standby

[jwiegand]

Good Day.

Has anyone succeeded in this and care to share? I've tried sharing out
the directory containing the Oracle backup, tried setting the Oracle
services to run under a Windows domain user, but continue to get
failures. 

Thanks,

Jeff

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

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

RE: read-only simple snapshot/materialised view refresh

[Kaing, Leng]

Hi Jared,

Frequency is currently 15 minutes. We'll need to reduce it to about 5 I guess.

ORA-1555 is from the master. As master tables are being updated, snapshot fails with 
its read consistent image. 

Once we get really far behind there's no way we can catch up. It fails with ORA-1555

Ta,

Leng.

--
Leng Kaing
Email: [EMAIL PROTECTED]
Phone: +61-3-9203-7589
Mobile: +61-417-371-348

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, 15 January 2004 4:27 am
> To:   [EMAIL PROTECTED]
> Cc:   Kaing, Leng
> Subject:  Re: read-only simple snapshot/materialised view refresh
> Importance:   High
> 
> 
> Leng, 
> 
> You didn't mention the frequency of the refresh. 
> 
> I also don't see mention of which database is generating 
> the ora-1555 errors. 
> 
> Jared 
> 
> 
> 
> 
>   "Kaing, Leng" <[EMAIL PROTECTED]> 
> Sent by: [EMAIL PROTECTED] 
> 
>  01/13/2004 09:34 PM 
>  Please respond to ORACLE-L 
> 
> To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
> cc: 
> Subject:read-only simple snapshot/materialised view refresh
> 
> 
> 
> Hello everyone,
> 
> We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 
> slave. master and slave are on different servers. Snapshots are refreshed by the 
> "FAST" method using dbms_refresh.refresh. However, do to the extremely high 
> transaction rates on our database, we're getting ORA-1555 when trying to refresh the 
> snapshots. The mlog$ tables builds up and the slave just keeps on falling behind. 
> From what I can see, snapshots are refreshed as a single large transaction. So if 
> there are 500K rows in the mlog$ table, all 500K will be processed in one go. There 
> are no intermediate commits. 
> 
> So my question is: how do you specify a commit point with snapshots? I'm looking for 
> parameters similar to that of the exp and sqlldr utility where you can specify 
> commit points. I've logged an iTAR with Oracle Support and there answer is that it's 
> not possible. ARGH!! 
> 
> Here's another crazy question is - has anyone updated the dbms_refresh package to 
> add a commit point? 
> 
> Or, have you tried to interogate the mlog$ and write a PL/SQL procedure to process 
> the rows in there, thereby having your own commit points? mlog$ provides the primary 
> keys and the DML type. So surely it's just a matter of going through each one of the 
> row and applying it to the slave?
> 
> 
> TIA,
> 
> Leng,
> 
> 
> --
> Leng Kaing
> Email: [EMAIL PROTECTED]
> Phone: +61-3-9203-7589
> Mobile: +61-417-371-348
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Kaing, Leng
>  INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kaing, Leng
  INET: [EMAIL PROTECTED]

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

Re: Oracle vs Mysql

[Tanel Poder]

One more thing which you can tell your boss: MySQL 
and Oracle are not comparable, at least not with any trustworthy results. (the 
same goes with MySQL and DB2 or Access and SQL server...)
 
Tanel.
 

  - Original Message - 
  From: 
  Mujeeb Chowdhry 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 14, 2004 7:04 
  PM
  Subject: Oracle vs Mysql
  
  Hi,
   
  I've been asked by management to explore the pros and cons 
  of Mysql vs Oracle. The database in question will be a web based text and 
  multimedia retrieval  system. The size will be around 100 Gb. Can 
  someone let me know the advantages of Oracle over Mysql or the problems 
  we can face using Mysql for example support issues or 
  availability/performance issues. Thanks in advance
   
  Mujeeb

Re: Application Server Caching

[Mark Richard]

Ryan,

Our application does a certain amount of application server caching, and
infact has a pretty advanced cache mechanism to deal with out of date
objects, etc.
On a more simple level - Common reference records are loaded at start up
and cached, error messages are cached, etc.  In a similar fashion we a a
sequence providing GUID values (global across our application at least) -
Obviously the application chews through these very fast (millions per day).
So, to reduce load each time the application gets a new value from the
sequence it treats it as a range of 1000 values.  If the app crashes we
only loose a few thousand sequence numbers (several processes each have
their own store of 1000 values) but access to the sequence is reduced by a
factor of 1000.  After three years of running the sequence is around
10,000,000 instead of 10,000,000,000!

It's all a matter of knowing what to cache and how to ensure it's still
current.  If you were populating a list of State Codes for a drop down list
then I would cache that result but something like a StockOnHandQuantity
figure probably changes so often that caching is of little use.

If you have the same query (ficticious eg: select statename, statecode from
states) constantly firing in your database then I guess it's a sign that
caching would help.  Even sub-second queries can quickly add up in a busy
system.

Cheers,
  Mark.




   
   
  "Ryan"   
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  .net>cc: 
   
  Sent by: Subject:  Application Server Caching
   
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  15/01/2004 09:14 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




I heard a presentation from a front end performance analyst last night from
www.tangasol.com (im not associated with them at all). He was pretty
impressive.

He argued that accessing the database is expensive. He also argued in favor
of caching data at the application server level. Have any of you worked
with this? What are your opinions? His opinion was that people go back to
the database to ask the same question way too often and cause a botteneck,
if you can cache these frequently asked questions at the front end, it will
significantly scale better.




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<>>

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

Fat City Network Services-- 858-538-5051 http://

RE: Oracle vs Mysql

[Grant Allen]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Ryan
> Sent: Thursday, 15 January 2004 09:05
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle vs Mysql
> 
> 
> i thought postgre was a for profit company? how do they 
> generate revenues?

Don't confuse the PostgreSQL dev team with PostgreSQL Inc.  The latter makes some 
commercially licenced add-ons for PostgreSQL, but the db itself is released under the 
Berkeley licence.  Completely free for commercial use.  Unlike MySQL, where you need 
to licence the server, AND licence the connectivity for commercial use.

Ciao
Fuzzy
:-)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

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

RE: Oracle vs Mysql

[Jesse, Rich]

There is a commercial arm of PostgreSQL (or at least a partner) for
businesses that require support.  Surf on over to:

http://www.pgsql.com

Expect to pay about the same for PostgreSQL support as you would for Oracle.

I don't know of any support for DBI other than the Perl DBI mailing list
(which, like this list, is excellent!).  Traffic is about the same as
ORACLE-L.  To subscribe to the list, send a message to:
<[EMAIL PROTECTED]>

Better yet, head to http://www.oreilly.com and find the books, then over to
http://www.bookpool.com and order 'em.

HTH!  :)

Rich

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


-Original Message-
Sent: Wednesday, January 14, 2004 3:20 PM
To: Multiple recipients of list ORACLE-L


1) DBI is a perl module to handle the communication with various databases.
2) Postgres is free. I believe that you can buy commercial support, but I
don't know
   where. May be Rich can jump in with that.
3) DBI is free and so is perl. I'm cheap & easy, but not free.


On 01/14/2004 02:34:52 PM, Ryan wrote:
> what is DBI?
> 
> is postgre free? Is it like linux where you pay for support? I cant find
any
> licensing info on the website. Most shops dont need oracle, sql server,
> sybase, or DB2.
> 
> Most applications are small. I was on a project where the government had
an
> Oracle EE license on windows. They didnt even use foreign key constraints.
> Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free
database
> could have handled that.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Partitioning question (duplicate?)

[Daniel Fink]

Pardon if this is a duplicate, but the original has not shown up
on the list after 3 hours...

Is it possible in 9.2 to partition on a function?

I have a table with a date column and I would like to partition
by month, regardless of the year. For example, data from January
2003 or January 2004 would go into the same partition. Any
sneaky ideas on how to accomplish this without changing the data
structures.

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

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

Re: Oracle vs Mysql

[Ryan]

i thought postgre was a for profit company? how do they generate revenues?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 4:19 PM


> 1) DBI is a perl module to handle the communication with various
databases.
> 2) Postgres is free. I believe that you can buy commercial support, but I
don't know
>where. May be Rich can jump in with that.
> 3) DBI is free and so is perl. I'm cheap & easy, but not free.
>
>
> On 01/14/2004 02:34:52 PM, Ryan wrote:
> > what is DBI?
> >
> > is postgre free? Is it like linux where you pay for support? I cant find
any
> > licensing info on the website. Most shops dont need oracle, sql server,
> > sybase, or DB2.
> >
> > Most applications are small. I was on a project where the government had
an
> > Oracle EE license on windows. They didnt even use foreign key
constraints.
> > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free
database
> > could have handled that.
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, January 14, 2004 1:44 PM
> >
> >
> > >
> > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > > > If you have the choice, look at PostgreSQL in addition to MySQL.
From
> > what
> > > > I've seen, it's more mature than MySQL.
> > >
> > > I second that. PostgresSQL supports transactions and uses perl as its
> > > scripting language. From what little I read and saw (just a little
pilot
> > > project with the goal to see "what the heck is Postgres"), it's a very
> > > decent database, with a decent performance and capabilities sufficient
> > > for a small, departmental database server. I know nothing of
clustering,
> > > distributed database, database links, replication and alike. In other
> > words,
> > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,
but
> > > it can be quite a convenient storage space for a small corner shop or
a
> > > small department. Because of perl and DBI, exchanging  data with other
> > > servers like oracle or UDB (DB2) is easy.
> > >
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Mladen Gogala
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ryan
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

RE: Application Server Caching

[Goulet, Dick]

Ryan,
 
    He has a point.  If you look at 9IAS's architecture 
there is a cache database at the apps server.  The trick is to know when 
the data your looking for in cache is no longer valid.  A certain 
children's apparel/toys site did that to me back in October.  I'm still 
torqued at them.
 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Ryan 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 5:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Application Server Caching
  
  I heard a presentation from a front end 
  performance analyst last night from www.tangasol.com (im not associated with 
  them at all). He was pretty impressive.
   
  He argued that accessing the database is 
  expensive. He also argued in favor of caching data at the application server 
  level. Have any of you worked with this? What are your opinions? His opinion 
  was that people go back to the database to ask the same question way too often 
  and cause a botteneck, if you can cache these frequently asked questions at 
  the front end, it will significantly scale better. 

Application Server Caching

[Ryan]

I heard a presentation from a front end performance 
analyst last night from www.tangasol.com 
(im not associated with them at all). He was pretty impressive.
 
He argued that accessing the database is expensive. 
He also argued in favor of caching data at the application server level. Have 
any of you worked with this? What are your opinions? His opinion was that people 
go back to the database to ask the same question way too often and cause a 
botteneck, if you can cache these frequently asked questions at the front end, 
it will significantly scale better. 

Re: Oracle vs Mysql

[Tanel Poder]

I'm suspicious about using MySQL or Postgres with a database 100 gigabytes
in size.
(Especially, when their main website appeared to be down when I wanted to
check some of their recent references).

Anyway, if you have availability requirements which don't allow you to take
down your system for backup, then you have to use replication (about which
quality I'm suspicious again) in order to take "online" backups from a clone
db. For that you need another 100GB of storage.

Anyway, if I was persuaded to go with MySQL or Postgres for large databases,
I'd try to split them up somehow (kind of partitioning), if possible, to
have separate databases with separate server processes serving them. That
way taking down or crashing of one server wouldn't affect other data that
much...

Tanel.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 8:44 PM


>
> On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > If you have the choice, look at PostgreSQL in addition to MySQL.  From
what
> > I've seen, it's more mature than MySQL.
>
> I second that. PostgresSQL supports transactions and uses perl as its
> scripting language. From what little I read and saw (just a little pilot
> project with the goal to see "what the heck is Postgres"), it's a very
> decent database, with a decent performance and capabilities sufficient
> for a small, departmental database server. I know nothing of clustering,
> distributed database, database links, replication and alike. In other
words,
> I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but
> it can be quite a convenient storage space for a small corner shop or a
> small department. Because of perl and DBI, exchanging  data with other
> servers like oracle or UDB (DB2) is easy.
>
> --
> Mladen Gogala
> Oracle DBA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


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

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

RE: Shared Pool fragmentation

[Goulet, Dick]

Humm, Missed the middle post here.  It's a time & labor tracking system.  They have 
what they call a large package (28K from Brian post) that they claim must be loaded 
multiple times & is giving them an intermittent ORA-4031 and/or ORA-4045 on the web 
server.  Problem is that the wall clocks and the PowerBuilder admin tool don't have 
the problem.  What I also need with this app is a good book on MicroSlop Transaction 
server and Distributed Transaction Coordinator.  These folks are using it with the web 
server & they are clueless.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 14, 2004 4:30 PM
To: Multiple recipients of list ORACLE-L


Hmm..reminds me of a MetaLink thread where I actually saw an Oracle
Support analyst claim that it's not uncommon for large OLTP systems to
have 2-4GB shared poolsyes, that's 2-4 Gigabytes.  I wasn't actually
sure how to respond to that, so, I just sort of let it drop.  I mean,
what do you say?

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Wednesday, January 14, 2004 4:09 PM
To: Multiple recipients of list ORACLE-L


wa! what kind of application is it?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 3:29 PM


> John,
>
> THANKS A TON!!!  I've got a vendor trying to convince my boss that
their
application needs to be on a separate server with a 1GB shared pool.
Now I
know these guys are blowing snow better than any SnowKing, but I needed
some
help proving it.
>
> BTW: For you southern, snow unaware, a SnowKing is a snow blower of
the
highest degree.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
> Sent: Tuesday, January 13, 2004 6:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Rick,
>
> I forgot about shared_pool_reserved_size and the min_alloc parameter
(hidden
> since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
>
> John
>
> >-Original Message-
> >From: John Kanagaraj [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 13, 2004 2:59 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: Shared Pool fragmentation
> >
> >
> >Rick,
> >
> >I think the best answer is 'know thy application'. And in
> >this, knowledge of
> >bind var vs hardcoded value usage, looking at V$SQL and
> >V$SQLAREA, the ratio
> >(!!) of 'parse count (hard)' to 'parse count (total)', pinning of
> >packages/sequences, etc., can help...
> >
> >You cannot actually 'catch' a 4031 before it occurs, but you can
always
> >straighten things out before it occurs. I have found that a
> >combination of
> >pinning Packages/Sequences followed by judicious (once in a
> >while) use of
> >shared pool flush helps. Of course, the shared pool has to be
correctly
> >sized - too much and you waste time latching and memory, too
> >little and you
> >_might_ run into 4031. Sizing shared pool is an art that has a little
> >science behind it - science that involves understanding and
> >using values
> >from X$KGLOB and X$KSMSP and your application
> >
> >OTOH, I have seen good results with a flush shared pool during
> >quiet times
> >for non-bind hungry 3rd party apps... See below (script
> >courtersy Steve!) -
> >the number of chunks has dropped dramatically freeing up
> >largish globs of
> >shared pool that would otherwise have to be freed up when a
> >largish object
> >(in this case > 15456 bytes) has to load. As well, you will
> >see that the
> >number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down
> >drastically as the
> >system frees up 'freeable' chunks ahead of time, reducing the chance
of
> >4031s
> >
> >My (very limited) understanding is that when a package/cursor
> >has to load
> >and a large-enough chunk of shared pool memory is not free,
> >then the kernel
> >will try and flush out the 'freeable' (not in use) memory and
> >merge adjacent
> >free chunks. If this still does not staisfy the memory
> >requirements, then a
> >4031 is signalled/ The 'alter system flush shared pool'
> >performs a manual
> >flush instead, ahead of time and could (possibly) prevent a 4031 ...
> >
> >John Kanagaraj
> >DB Soft Inc
> >Phone: 408-970-7002 (W)
> >
> >Listen to great, commercial-free christian music 24x7x365 at
> >http://www.klove.com
> >
> >** The opinions and facts contained in this message are
> >entirely mine and do
> >not reflect those of my employer or customers **
> >
> >08:35:00 SQL> @shared_pool_free_lists
> >
> >BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
> >-- -- ---  --
> > 01089784   23488   46 76
> > 1 3941364656   84140
> > 2 6812843678

Re: Oracle vs Mysql

[eric king]

I don't think MySQL is free for commercial application, for dev and test
purpose it is free.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 4:29 PM


> DBI is an extension to perl language which can then be used by perl to
talk with various databases.  DBI stands for "database interface". With DBI
you also have to load in a specific database driver which is called DBD.
For instance for oracle you have to install DBI and DBD::Oracle.  Its really
cool to use and very fast.  I wrote a poor man's replication built on
DBI/DBD::Oracle/DBD::Sybase.
>
> I like mysql but the sql is just not that rich as it is in oracle.  They
are fixing some of the shortcomings soon so it will be pretty competitive is
basic database usage with Oracle.  BTW, I agree that a lot of people only
need a simple db and for them mysql/postgres is appropriate.
>
> As far as I know, Postgres is free to use, so you don't have to worry
about licensing at all.
>
> Hope this helps
>
> Masroor
>
>
> -Original Message-
> Ryan
> Sent: Wednesday, January 14, 2004 12:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> what is DBI?
>
> is postgre free? Is it like linux where you pay for support? I cant find
any
> licensing info on the website. Most shops dont need oracle, sql server,
> sybase, or DB2.
>
> Most applications are small. I was on a project where the government had
an
> Oracle EE license on windows. They didnt even use foreign key constraints.
> Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free
database
> could have handled that.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 14, 2004 1:44 PM
>
>
> >
> > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > > If you have the choice, look at PostgreSQL in addition to MySQL.  From
> what
> > > I've seen, it's more mature than MySQL.
> >
> > I second that. PostgresSQL supports transactions and uses perl as its
> > scripting language. From what little I read and saw (just a little pilot
> > project with the goal to see "what the heck is Postgres"), it's a very
> > decent database, with a decent performance and capabilities sufficient
> > for a small, departmental database server. I know nothing of clustering,
> > distributed database, database links, replication and alike. In other
> words,
> > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but
> > it can be quite a convenient storage space for a small corner shop or a
> > small department. Because of perl and DBI, exchanging  data with other
> > servers like oracle or UDB (DB2) is easy.
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ryan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Masroor Farooqi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: eric king
  INET: [EMAIL PROTECTED]

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

RE: Shared Pool fragmentation

[Bobak, Mark]

Hmm..reminds me of a MetaLink thread where I actually saw an Oracle
Support analyst claim that it's not uncommon for large OLTP systems to
have 2-4GB shared poolsyes, that's 2-4 Gigabytes.  I wasn't actually
sure how to respond to that, so, I just sort of let it drop.  I mean,
what do you say?

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is."  --Unknown


-Original Message-
Sent: Wednesday, January 14, 2004 4:09 PM
To: Multiple recipients of list ORACLE-L


wa! what kind of application is it?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 3:29 PM


> John,
>
> THANKS A TON!!!  I've got a vendor trying to convince my boss that
their
application needs to be on a separate server with a 1GB shared pool.
Now I
know these guys are blowing snow better than any SnowKing, but I needed
some
help proving it.
>
> BTW: For you southern, snow unaware, a SnowKing is a snow blower of
the
highest degree.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
> Sent: Tuesday, January 13, 2004 6:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Rick,
>
> I forgot about shared_pool_reserved_size and the min_alloc parameter
(hidden
> since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
>
> John
>
> >-Original Message-
> >From: John Kanagaraj [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 13, 2004 2:59 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: Shared Pool fragmentation
> >
> >
> >Rick,
> >
> >I think the best answer is 'know thy application'. And in
> >this, knowledge of
> >bind var vs hardcoded value usage, looking at V$SQL and
> >V$SQLAREA, the ratio
> >(!!) of 'parse count (hard)' to 'parse count (total)', pinning of
> >packages/sequences, etc., can help...
> >
> >You cannot actually 'catch' a 4031 before it occurs, but you can
always
> >straighten things out before it occurs. I have found that a
> >combination of
> >pinning Packages/Sequences followed by judicious (once in a
> >while) use of
> >shared pool flush helps. Of course, the shared pool has to be
correctly
> >sized - too much and you waste time latching and memory, too
> >little and you
> >_might_ run into 4031. Sizing shared pool is an art that has a little
> >science behind it - science that involves understanding and
> >using values
> >from X$KGLOB and X$KSMSP and your application
> >
> >OTOH, I have seen good results with a flush shared pool during
> >quiet times
> >for non-bind hungry 3rd party apps... See below (script
> >courtersy Steve!) -
> >the number of chunks has dropped dramatically freeing up
> >largish globs of
> >shared pool that would otherwise have to be freed up when a
> >largish object
> >(in this case > 15456 bytes) has to load. As well, you will
> >see that the
> >number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down
> >drastically as the
> >system frees up 'freeable' chunks ahead of time, reducing the chance
of
> >4031s
> >
> >My (very limited) understanding is that when a package/cursor
> >has to load
> >and a large-enough chunk of shared pool memory is not free,
> >then the kernel
> >will try and flush out the 'freeable' (not in use) memory and
> >merge adjacent
> >free chunks. If this still does not staisfy the memory
> >requirements, then a
> >4031 is signalled/ The 'alter system flush shared pool'
> >performs a manual
> >flush instead, ahead of time and could (possibly) prevent a 4031 ...
> >
> >John Kanagaraj
> >DB Soft Inc
> >Phone: 408-970-7002 (W)
> >
> >Listen to great, commercial-free christian music 24x7x365 at
> >http://www.klove.com
> >
> >** The opinions and facts contained in this message are
> >entirely mine and do
> >not reflect those of my employer or customers **
> >
> >08:35:00 SQL> @shared_pool_free_lists
> >
> >BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
> >-- -- ---  --
> > 01089784   23488   46 76
> > 1 3941364656   84140
> > 2 6812843678  185268
> > 3 315504 875  360524
> > 449019527300  671   1036
> > 561588964099 1502   2060
> > 655465161966 2821   4048
> > 71125720 263 4280   7624
> > 8 989584 101 9797  15456
> >
> >9 rows selected.
> >
> >08:35:29 SQL> alter system flush shared_pool;
> >
> >System altered.
> >
> >08:36:32 SQL> @shared_pool_free_lists
> >
> >BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
> >-- -- ---  --
> > 0  14364 330   4

RE: Oracle vs Mysql

[Masroor Farooqi]

DBI is an extension to perl language which can then be used by perl to talk with 
various databases.  DBI stands for "database interface". With DBI you also have to 
load in a specific database driver which is called DBD.  For instance for oracle you 
have to install DBI and DBD::Oracle.  Its really cool to use and very fast.  I wrote a 
poor man's replication built on DBI/DBD::Oracle/DBD::Sybase.

I like mysql but the sql is just not that rich as it is in oracle.  They are fixing 
some of the shortcomings soon so it will be pretty competitive is basic database usage 
with Oracle.  BTW, I agree that a lot of people only need a simple db and for them 
mysql/postgres is appropriate.  

As far as I know, Postgres is free to use, so you don't have to worry about licensing 
at all.

Hope this helps

Masroor


-Original Message-
Ryan
Sent: Wednesday, January 14, 2004 12:35 PM
To: Multiple recipients of list ORACLE-L


what is DBI?

is postgre free? Is it like linux where you pay for support? I cant find any
licensing info on the website. Most shops dont need oracle, sql server,
sybase, or DB2.

Most applications are small. I was on a project where the government had an
Oracle EE license on windows. They didnt even use foreign key constraints.
Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database
could have handled that.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 1:44 PM


>
> On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > If you have the choice, look at PostgreSQL in addition to MySQL.  From
what
> > I've seen, it's more mature than MySQL.
>
> I second that. PostgresSQL supports transactions and uses perl as its
> scripting language. From what little I read and saw (just a little pilot
> project with the goal to see "what the heck is Postgres"), it's a very
> decent database, with a decent performance and capabilities sufficient
> for a small, departmental database server. I know nothing of clustering,
> distributed database, database links, replication and alike. In other
words,
> I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but
> it can be quite a convenient storage space for a small corner shop or a
> small department. Because of perl and DBI, exchanging  data with other
> servers like oracle or UDB (DB2) is easy.
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: Oracle vs Mysql

[Mladen Gogala]

1) DBI is a perl module to handle the communication with various databases.
2) Postgres is free. I believe that you can buy commercial support, but I don't know
   where. May be Rich can jump in with that.
3) DBI is free and so is perl. I'm cheap & easy, but not free.


On 01/14/2004 02:34:52 PM, Ryan wrote:
> what is DBI?
> 
> is postgre free? Is it like linux where you pay for support? I cant find any
> licensing info on the website. Most shops dont need oracle, sql server,
> sybase, or DB2.
> 
> Most applications are small. I was on a project where the government had an
> Oracle EE license on windows. They didnt even use foreign key constraints.
> Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database
> could have handled that.
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 14, 2004 1:44 PM
> 
> 
> >
> > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > > If you have the choice, look at PostgreSQL in addition to MySQL.  From
> what
> > > I've seen, it's more mature than MySQL.
> >
> > I second that. PostgresSQL supports transactions and uses perl as its
> > scripting language. From what little I read and saw (just a little pilot
> > project with the goal to see "what the heck is Postgres"), it's a very
> > decent database, with a decent performance and capabilities sufficient
> > for a small, departmental database server. I know nothing of clustering,
> > distributed database, database links, replication and alike. In other
> words,
> > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but
> > it can be quite a convenient storage space for a small corner shop or a
> > small department. Because of perl and DBI, exchanging  data with other
> > servers like oracle or UDB (DB2) is easy.
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ryan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

Re: Shared Pool fragmentation

[eric king]

wa! what kind of application is it?

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 3:29 PM


> John,
>
> THANKS A TON!!!  I've got a vendor trying to convince my boss that their
application needs to be on a separate server with a 1GB shared pool.  Now I
know these guys are blowing snow better than any SnowKing, but I needed some
help proving it.
>
> BTW: For you southern, snow unaware, a SnowKing is a snow blower of the
highest degree.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
> Sent: Tuesday, January 13, 2004 6:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Rick,
>
> I forgot about shared_pool_reserved_size and the min_alloc parameter
(hidden
> since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
>
> John
>
> >-Original Message-
> >From: John Kanagaraj [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 13, 2004 2:59 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: Shared Pool fragmentation
> >
> >
> >Rick,
> >
> >I think the best answer is 'know thy application'. And in
> >this, knowledge of
> >bind var vs hardcoded value usage, looking at V$SQL and
> >V$SQLAREA, the ratio
> >(!!) of 'parse count (hard)' to 'parse count (total)', pinning of
> >packages/sequences, etc., can help...
> >
> >You cannot actually 'catch' a 4031 before it occurs, but you can always
> >straighten things out before it occurs. I have found that a
> >combination of
> >pinning Packages/Sequences followed by judicious (once in a
> >while) use of
> >shared pool flush helps. Of course, the shared pool has to be correctly
> >sized - too much and you waste time latching and memory, too
> >little and you
> >_might_ run into 4031. Sizing shared pool is an art that has a little
> >science behind it - science that involves understanding and
> >using values
> >from X$KGLOB and X$KSMSP and your application
> >
> >OTOH, I have seen good results with a flush shared pool during
> >quiet times
> >for non-bind hungry 3rd party apps... See below (script
> >courtersy Steve!) -
> >the number of chunks has dropped dramatically freeing up
> >largish globs of
> >shared pool that would otherwise have to be freed up when a
> >largish object
> >(in this case > 15456 bytes) has to load. As well, you will
> >see that the
> >number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down
> >drastically as the
> >system frees up 'freeable' chunks ahead of time, reducing the chance of
> >4031s
> >
> >My (very limited) understanding is that when a package/cursor
> >has to load
> >and a large-enough chunk of shared pool memory is not free,
> >then the kernel
> >will try and flush out the 'freeable' (not in use) memory and
> >merge adjacent
> >free chunks. If this still does not staisfy the memory
> >requirements, then a
> >4031 is signalled/ The 'alter system flush shared pool'
> >performs a manual
> >flush instead, ahead of time and could (possibly) prevent a 4031 ...
> >
> >John Kanagaraj
> >DB Soft Inc
> >Phone: 408-970-7002 (W)
> >
> >Listen to great, commercial-free christian music 24x7x365 at
> >http://www.klove.com
> >
> >** The opinions and facts contained in this message are
> >entirely mine and do
> >not reflect those of my employer or customers **
> >
> >08:35:00 SQL> @shared_pool_free_lists
> >
> >BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
> >-- -- ---  --
> > 01089784   23488   46 76
> > 1 3941364656   84140
> > 2 6812843678  185268
> > 3 315504 875  360524
> > 449019527300  671   1036
> > 561588964099 1502   2060
> > 655465161966 2821   4048
> > 71125720 263 4280   7624
> > 8 989584 101 9797  15456
> >
> >9 rows selected.
> >
> >08:35:29 SQL> alter system flush shared_pool;
> >
> >System altered.
> >
> >08:36:32 SQL> @shared_pool_free_lists
> >
> >BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
> >-- -- ---  --
> > 0  14364 330   43 76
> > 1   6528  76   85140
> > 6   3964   1 3964   3964
> > 9  29580   129580  29580
> >105028636 10348821  65436
> >11   13860744 15092404 130872
> >12   32192980 173   186086 261016
> >13   64490864 172   374946 522764
> >14   83609184 112   7465101048432
> >15   79829220  57  14005122068384
> >16   38149220  14  2724944370532

Re: Oracle vs Mysql

[Ryan]

what is DBI?

is postgre free? Is it like linux where you pay for support? I cant find any
licensing info on the website. Most shops dont need oracle, sql server,
sybase, or DB2.

Most applications are small. I was on a project where the government had an
Oracle EE license on windows. They didnt even use foreign key constraints.
Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database
could have handled that.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 1:44 PM


>
> On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> > If you have the choice, look at PostgreSQL in addition to MySQL.  From
what
> > I've seen, it's more mature than MySQL.
>
> I second that. PostgresSQL supports transactions and uses perl as its
> scripting language. From what little I read and saw (just a little pilot
> project with the goal to see "what the heck is Postgres"), it's a very
> decent database, with a decent performance and capabilities sufficient
> for a small, departmental database server. I know nothing of clustering,
> distributed database, database links, replication and alike. In other
words,
> I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but
> it can be quite a convenient storage space for a small corner shop or a
> small department. Because of perl and DBI, exchanging  data with other
> servers like oracle or UDB (DB2) is easy.
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

RE: oaktable people

[Gary Goodman]

I'm going to make Mogens clean my garage ... I'm sorry, I meant further
team building ... when he visits for the Symposium in March!

Gary

(817)424-3443  Office
(817)296-8000  Cell



-Original Message-
Mogens Nørgaard
Sent: Tuesday, January 13, 2004 10:39 PM
To: Multiple recipients of list ORACLE-L

Lies, lies and viscious rumors. It was only the loft of the Garage, and 
the idea was to create a new, exciting space for the Oracle Museum, 
complete with webcams.

I had planned the Miracle Master Class Teambuilding Exercise as follows:

1. On Sunday evening we would (slowly!) move the stuff from the loft 
downstairs and stack it carefully.
2. On Monday evening we would put in the new flooring.
3. On Tuesday evening we would put the stacked stuff back up on the
loft.

As it turned out, it ended up a bit different from the original plan:

1. On Sunday it took the Oakies about 42 minutes to remove everything 
from the loft. Most of it was thrown out, and Peter Gram even had to 
rent a new trailer for the junk.
2. Lex and Carel-Jan and Gary Goodman and James Morle and Jon (from 
Miracle Iceland) were un-stopable and made 80% of the flooring on
Sunday.
3. On Monday Lex got the bright idea of doing some heavy changes to the 
whole construction of the Garage. Which he and Carel-Jan and helpers 
then did.
4. On Tuesday evening nobody did anything except participate in the Gala

Dinner and visit the famous hotdog stand Bjarne's Poelser.
5. I don't know when the stuff is going up there again. I'm afraid.

Mogens

PS: The Oakies rock. Nothing beats having 18 of them in your house.

Gudmundur Josepsson wrote:

>Onkel Mogens wrote:
>
>  
>
>>All to stay in my house (except Gaja - don't know what he's up to).
>>Rock'n'roll. And none of them know what I meant when I asked them to
>>bring some old clothes for some unusual teambuilding...
>>
>>
>
>You're not having them do construction work on your house again, are
you?
>Gaja is probably the smart one, he knows what you're up to!  My guess
is
>that 'teambuilding' is Danish for 'dig me a 12 x 25 m swimming pool in
my
>back yard and paint my house while you're at it.'
>
>Gummi
>
>  
>

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

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

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

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

RE: Shared Pool fragmentation

[Goulet, Dick]

John,

THANKS A TON!!!  I've got a vendor trying to convince my boss that their 
application needs to be on a separate server with a 1GB shared pool.  Now I know these 
guys are blowing snow better than any SnowKing, but I needed some help proving it.

BTW: For you southern, snow unaware, a SnowKing is a snow blower of the highest degree.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, January 13, 2004 6:34 PM
To: Multiple recipients of list ORACLE-L


Rick,

I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden
since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.

John

>-Original Message-
>From: John Kanagaraj [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, January 13, 2004 2:59 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Shared Pool fragmentation
>
>
>Rick,
>
>I think the best answer is 'know thy application'. And in 
>this, knowledge of
>bind var vs hardcoded value usage, looking at V$SQL and 
>V$SQLAREA, the ratio
>(!!) of 'parse count (hard)' to 'parse count (total)', pinning of
>packages/sequences, etc., can help...
>
>You cannot actually 'catch' a 4031 before it occurs, but you can always
>straighten things out before it occurs. I have found that a 
>combination of
>pinning Packages/Sequences followed by judicious (once in a 
>while) use of
>shared pool flush helps. Of course, the shared pool has to be correctly
>sized - too much and you waste time latching and memory, too 
>little and you
>_might_ run into 4031. Sizing shared pool is an art that has a little
>science behind it - science that involves understanding and 
>using values
>from X$KGLOB and X$KSMSP and your application
>
>OTOH, I have seen good results with a flush shared pool during 
>quiet times
>for non-bind hungry 3rd party apps... See below (script 
>courtersy Steve!) -
>the number of chunks has dropped dramatically freeing up 
>largish globs of
>shared pool that would otherwise have to be freed up when a 
>largish object
>(in this case > 15456 bytes) has to load. As well, you will 
>see that the
>number of 'freeabl' chunks (x$ksmsp.ksmchcls) comes down 
>drastically as the
>system frees up 'freeable' chunks ahead of time, reducing the chance of
>4031s 
>
>My (very limited) understanding is that when a package/cursor 
>has to load
>and a large-enough chunk of shared pool memory is not free, 
>then the kernel
>will try and flush out the 'freeable' (not in use) memory and 
>merge adjacent
>free chunks. If this still does not staisfy the memory 
>requirements, then a
>4031 is signalled/ The 'alter system flush shared pool' 
>performs a manual
>flush instead, ahead of time and could (possibly) prevent a 4031 ...
>
>John Kanagaraj
>DB Soft Inc
>Phone: 408-970-7002 (W)
>
>Listen to great, commercial-free christian music 24x7x365 at
>http://www.klove.com
>
>** The opinions and facts contained in this message are 
>entirely mine and do
>not reflect those of my employer or customers **
>
>08:35:00 SQL> @shared_pool_free_lists
>
>BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
>-- -- ---  --
> 01089784   23488   46 76
> 1 3941364656   84140
> 2 6812843678  185268
> 3 315504 875  360524
> 449019527300  671   1036
> 561588964099 1502   2060
> 655465161966 2821   4048
> 71125720 263 4280   7624
> 8 989584 101 9797  15456
>
>9 rows selected.
>
>08:35:29 SQL> alter system flush shared_pool;
>
>System altered.
>
>08:36:32 SQL> @shared_pool_free_lists
>
>BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST
>-- -- ---  --
> 0  14364 330   43 76
> 1   6528  76   85140
> 6   3964   1 3964   3964
> 9  29580   129580  29580
>105028636 10348821  65436
>11   13860744 15092404 130872
>12   32192980 173   186086 261016
>13   64490864 172   374946 522764
>14   83609184 112   7465101048432
>15   79829220  57  14005122068384
>16   38149220  14  27249443705320
>
>11 rows selected.
>
>-Original Message-
>Sent: Tuesday, January 13, 2004 9:34 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Is there a way to catch shared_pool fragmentation before you 
>get the 4031
>errors?  I have looked at Steve Adams site which has scripts 
>to show the
>free lists chunks in the shared pool.  At what point do I know 
>that it is
>fragmented t

RE: ** OCP for 9i requirements -- Instructor Led Class is a

[DENNIS WILLIAMS]

I heard from an Oracle instructor that some idiots were bragging about how
they passed the OCP without logging in once. This distressed some important
people, so this requirement was added. I asked if this meant each instructor
was tasked with ensuring each student logged in, and he just smiled.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, January 14, 2004 8:09 AM
To: Multiple recipients of list ORACLE-L



Sure.

Read 
"Important Program Announcement: Oracle University Hands-On Course
Requirement
Oracle customers and business partners are demanding hands-on experience -
with all aspects of Oracle's database - from their Oracle Certified
Professionals. In order to meet our commitment to our customers and
constituents, Oracle University has recently made a significant investment
in its Certification Program. Three distinct changes are being rolled out
with the goal of increasing the level of quality of our certification skill
and ability benchmarks: 
Scenario-based testing in all Oracle9i DBA Certified Professional
exams . 
Instructor-led class requirement for candidates starting on the
Oracle9i DBA Certified Professional credential exam path. 
A new hands-on Masters Practicum Exam for the Oracle9i Database
Administrator Certified Master credential. 
"

at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
 

"Instructure-led class" is a requirement.

You CAN take the Online Training to _prepare_ for the Exams.  But you MUST
attend at least one Instructor-led class
to qualify for the certification.
Hemant
At 10:34 AM 13-01-04 -0800, you wrote:


why dont you just read what is on the oracle website?
 
www.oracle.com  
 
do a search for certification. 

- Original Message - 


To: Multiple recipients of   list ORACLE-L 

Sent: Tuesday, January 13, 2004 9:34 AM 






Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ?  I thought that 

the pre-requisite is "at least one Instructor Led Training".



Hemant 

At 12:04 AM 13-01-04 -0800, you wrote: 


At 06:14 PM 1/12/2004, Ryan wrote: 



www.oracle.com   

  

do a search for certification. Its all explained there. You can take an
online course for $300. If your company is an oracle partner the course is
free. 

My understanding is that you need to take a class that corresponds to one of
the four OCP exams, which are all 5-day classes.  The in-classroom versions
run $2500 and the on-line versions run $1250.  Oracle partners get a 35%
discount (advantage and certified advantage partners may get a larger
discount).



http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.
html
 



Justin Cave 


- Original Message - 


To: Multiple recipients of   list ORACLE-L 

Sent: Monday, January 12, 2004 7:34 PM 




Hi, 

  For taking Oracle9i OCP exam is it necessary to have attended a Oracle
course by Oracle University. What is the minimum?  Is any small course good
enough? Can someone who has gone through this provide details? Thank you







Do you Yahoo!? 

Yahoo! Hotjobs: Enter
 the "Signing Bonus"
Sweepstakes 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com   {last updated
05-Jan-04}

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

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com    {last updated
05-Jan-04}

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services --
858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list
and web hosting services
- To
REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling

Re:RE: Re: A STRANGE QUERY

[system manager]

Thanks Brad,  Thanks Steve, The problem fixed after our DBA drop and
rebuild the primary key. It is so great to have people like you on this
list.

Thanks again,

--
Original Message
Date: Tue, 13 Jan 2004 08:59:24 -0800

>At first stab...I would guess that there is something foobarred with the
>primary key index.
>
>I would rebuild the primary key and try again. 
>
>Brad O.
>
>
>-Original Message-
>Sent: Monday, January 12, 2004 4:45 PM
>To: Multiple recipients of list ORACLE-L
>
>
>It is not an expensive query.It runs really fast without the primary
>key in production but
>we dont have this problem in the test instance. 
>--
>Original Message
>Date: Mon, 12 Jan 2004 14:04:42 -0800
>
>>Even stranger is, that you expect us to solve your problem without knowing
>>what exactly the problem is!
>>Does your query consist of a SQL statement? Does it have an execution
plan?
>>
>>Very strange, indeed.
>>
>>Tanel.
>>
>>
>>> Dear List,
>>>
>>> I have a very strange query:
>>>
>>> The table, data, indexes, constraints are set up exactly same
>>> The query was running ok in the test database but paused the production
>>> system.
>>> It is also running ok in production if the primary key disabled.
>>> Any ideas?   Any input will be greatly appreciated.
>>>
>>
>>
>>-- 
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>-- 
>>Author: Tanel Poder
>>  INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>>San Diego, California-- Mailing list and web hosting services
>>-
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from).  You may
>>also send the HELP command for other information (like subscribing).
>>
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>Looking for friendships,romance and more?
>http://www.MyOwnFriends.com
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: system manager
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Odland, Brad
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

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

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

Re: Sorta OT: Uncle Larry's no longer Chairman!

[eric king]

Title: RE: Sorta OT: Uncle Larry's no longer Chairman!



Why does he quit? I thought he likes to 
fight...

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 14, 2004 1:59 
  PM
  Subject: RE: Sorta OT: Uncle Larry's no 
  longer Chairman!
  
  Very True ...
   
  Raj
   
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  
-Original Message-From: Whittle Jerome Contr NCI 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 
2004 1:51 PMTo: [EMAIL PROTECTED]Cc: Jamadagni, 
RajendraSubject: RE: Sorta OT: Uncle Larry's no longer 
Chairman!
Raj, 

If Uncle Larry's 
other 3 marriages are any indication of a trend, he won't be sharing your 
wedding anniversary for long
Jerry Whittle ASIFICS DBA NCI Information Systems Inc. 
[EMAIL PROTECTED] 618-622-4145 

  -Original 
  Message- From:   Jamadagni, 
  Rajendra [SMTP:[EMAIL PROTECTED] 
  Dang ... he now shares my 
  wedding anniversary (not the year) ... 
  Raj 
  **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.**4 

RE: Sorta OT: Uncle Larry's no longer Chairman!

[Boivin, Patrice J]

I guess jokes about Preferred Oracle Partners would be in bad taste...

Patrice.

-Original Message-
Sent: January 14, 2004 2:24 PM
To: Multiple recipients of list ORACLE-L


Dang ... he now shares my wedding anniversary (not the year) ... 

Raj


Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, January 14, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L


And he apparently got hitched, too.  Wondering if Wall Street has any
thoughts on this...

http://www.eweek.com/article2/0,4149,1435093,00.asp

Rich


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

**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

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

Re: Reset sequence at midnight

[Jared . Still]

Interesting, I've actually had to do this before.

Be forewarned that this is not a good method to use for a very busy
app, as it does introduce some level of serialization.

control access to the sequence through a package

Within the package use a function that sets a lock via dbms_lock.request
and then immediately release the lock.

The purpose of this will become clear in a moment.

Create a procedure within the package that will be used to reset the
sequence to 0.  It is not necessary to drop the sequence to do this.

eg.

drop sequence s;

create sequence s start with 100;

select s.nextval from dual;

declare
   vs integer;
   inc integer;
   junk integer;
begin
   select s.nextval into vs from dual;
   inc := 0 - vs;
   execute immediate 'alter sequence s minvalue ' || inc;
   execute immediate 'alter sequence s increment by '||inc;
   select s.nextval into junk from dual;
   execute immediate 'alter sequence s increment by 1';
end;
/

select s.nextval from dual;


The procedure that does this just needs to take the same  dbms_lock.request
that the function mentioned earlier takes.  The difference is that it does not
release the lock until the modification of the sequence is completed.

This forces any requests for new sequence numbers to wait for the modification
to the sequence to complete.

Jared








"Oracle" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/14/2004 09:04 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Reset sequence at midnight


Hi,

I have a sequence which i want to reset to 0 at midnight everyday.

What is the best way to do this?

Db version - 9.2.0.1.0
Thanks

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

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

RE: Sorta OT: Uncle Larry's no longer Chairman!

[Jamadagni, Rajendra]

Title: RE: Sorta OT: Uncle Larry's no longer Chairman!



Very True ...
 
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Whittle Jerome Contr NCI 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 
  2004 1:51 PMTo: [EMAIL PROTECTED]Cc: Jamadagni, 
  RajendraSubject: RE: Sorta OT: Uncle Larry's no longer 
  Chairman!
  Raj, 
  
  If Uncle Larry's 
  other 3 marriages are any indication of a trend, he won't be sharing your 
  wedding anniversary for long
  Jerry Whittle ASIFICS DBA NCI Information Systems Inc. 
  [EMAIL PROTECTED] 618-622-4145 
  
-Original 
Message- From:   Jamadagni, 
Rajendra [SMTP:[EMAIL PROTECTED] 
Dang ... he now shares my 
wedding anniversary (not the year) ... 
Raj 
**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.**4

Re: Oracle vs Mysql

[Mladen Gogala]

On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> If you have the choice, look at PostgreSQL in addition to MySQL.  From what
> I've seen, it's more mature than MySQL.

I second that. PostgresSQL supports transactions and uses perl as its 
scripting language. From what little I read and saw (just a little pilot 
project with the goal to see "what the heck is Postgres"), it's a very
decent database, with a decent performance and capabilities sufficient
for a small, departmental database server. I know nothing of clustering,
distributed database, database links, replication and alike. In other words,
I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but 
it can be quite a convenient storage space for a small corner shop or a
small department. Because of perl and DBI, exchanging  data with other
servers like oracle or UDB (DB2) is easy.

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

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

RE: Sorta OT: Uncle Larry's no longer Chairman!

[Whittle Jerome Contr NCI]

Title: RE: Sorta OT: Uncle Larry's no longer Chairman!






Raj,


If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]


Dang ... he now shares my wedding anniversary (not the year) ... 


Raj

RE: Sorta OT: Uncle Larry's no longer Chairman!

[Jamadagni, Rajendra]

Dang ... he now shares my wedding anniversary (not the year) ... 

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, January 14, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L


And he apparently got hitched, too.  Wondering if Wall Street has any
thoughts on this...

http://www.eweek.com/article2/0,4149,1435093,00.asp

Rich

**
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.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

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

Re: Reset sequence at midnight

[Rachel Carmichael]

drop sequence
create sequence

but why do you want to do that?


--- Oracle <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have a sequence which i want to reset to 0 at midnight everyday.
> 
> What is the best way to do this?
> 
> Db version - 9.2.0.1.0
> Thanks
> 
> Imran
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Oracle
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: where is Sort area size

[Paula_Stankus]

It comes out of the total memory of the server - separate from the shared pool - it is 
allocated per session - if running parallel processes in a DSS environ. can quickly 
consume memory avail.  be wary wary careful.

-Original Message-
Mladen Gogala
Sent: Wednesday, January 14, 2004 11:54 AM
To: Multiple recipients of list ORACLE-L


Yes. Note that when you use MTS, sort area is taken from the SGA,
specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not.
With a dedicated server, sort area is a part of the process address space.


On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote:
> Hi all , 
>  
>   is sort are size a part of PGA ? 
>  
> Rgds.
> Arslan.
>  
> 

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

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

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

Re: Reset sequence at midnight

[Mladen Gogala]

To use program which will supply numbers, possibly as an external routine, 
and not use an oracle sequence as it wasn't designed for that purpose.
On 01/14/2004 12:04:26 PM, Oracle wrote:
> Hi,
> 
> I have a sequence which i want to reset to 0 at midnight everyday.
> 
> What is the best way to do this?
> 
> Db version - 9.2.0.1.0
> Thanks
> 
> Imran
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Oracle
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

RE: Oracle vs Mysql

[Jesse, Rich]

If you have the choice, look at PostgreSQL in addition to MySQL.  From what
I've seen, it's more mature than MySQL.

My $.02,
Rich

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

-Original Message-
Sent: Wednesday, January 14, 2004 11:05 AM
To: Multiple recipients of list ORACLE-L


Hi,
 
I've been asked by management to explore the pros and cons of Mysql vs
Oracle. The database in question will be a web based text and multimedia
retrieval  system. The size will be around 100 Gb. Can someone let me know
the advantages of Oracle over Mysql or the problems we can face using Mysql
for example support issues or availability/performance issues. Thanks in
advance
 
Mujeeb
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: read-only simple snapshot/materialised view refresh

[Jared . Still]

Leng,

You didn't mention the frequency of the refresh.

I also don't see mention of which database is generating
the ora-1555 errors.

Jared







"Kaing, Leng" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 01/13/2004 09:34 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        read-only simple snapshot/materialised view refresh


Hello everyone,

We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 slave. master and slave are on different servers. Snapshots are refreshed by the "FAST" method using dbms_refresh.refresh. However, do to the extremely high transaction rates on our database, we're getting ORA-1555 when trying to refresh the snapshots. The mlog$ tables builds up and the slave just keeps on falling behind. From what I can see, snapshots are refreshed as a single large transaction. So if there are 500K rows in the mlog$ table, all 500K will be processed in one go. There are no intermediate commits. 

So my question is: how do you specify a commit point with snapshots? I'm looking for parameters similar to that of the exp and sqlldr utility where you can specify commit points. I've logged an iTAR with Oracle Support and there answer is that it's not possible. ARGH!! 

Here's another crazy question is - has anyone updated the dbms_refresh package to add a commit point? 

Or, have you tried to interogate the mlog$ and write a PL/SQL procedure to process the rows in there, thereby having your own commit points? mlog$ provides the primary keys and the DML type. So surely it's just a matter of going through each one of the row and applying it to the slave?


TIA,

Leng,


--
Leng Kaing
Email: [EMAIL PROTECTED]
Phone: +61-3-9203-7589
Mobile: +61-417-371-348

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

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

Oracle vs Mysql

[Mujeeb Chowdhry]

Hi,
 
I've been asked by management to explore the pros and cons of 
Mysql vs Oracle. The database in question will be a web based text and 
multimedia retrieval  system. The size will be around 100 Gb. Can 
someone let me know the advantages of Oracle over Mysql or the problems we 
can face using Mysql for example support issues or 
availability/performance issues. Thanks in advance
 
Mujeeb

Reset sequence at midnight

[Oracle]

Hi,

I have a sequence which i want to reset to 0 at midnight everyday.

What is the best way to do this?

Db version - 9.2.0.1.0
Thanks

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

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

Re: where is Sort area size

[Mladen Gogala]

Yes. Note that when you use MTS, sort area is taken from the SGA,
specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not.
With a dedicated server, sort area is a part of the process address space.


On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote:
> Hi all , 
>  
>   is sort are size a part of PGA ? 
>  
> Rgds.
> Arslan.
>  
> 

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

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

RE: JVM for DBA

[DENNIS WILLIAMS]

Bill - Will you be administering the server or do you need to talk to the
administrator?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, January 14, 2004 10:15 AM
To: Multiple recipients of list ORACLE-L



Hi all,

Does anyone have any good resources on the Oracle JVM from a DBA 
perspective?  (ie. Tuning java parameters, managing storage/validation of 
java objects, monitoring java pool performance, managing security... etc.)

I can find lots of stuff for developers but I don't write too much Java
code!

Thanks for any info.

- Bill.

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

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

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

JVM for DBA

[Bill Buchan]

Hi all,

Does anyone have any good resources on the Oracle JVM from a DBA 
perspective?  (ie. Tuning java parameters, managing storage/validation of 
java objects, monitoring java pool performance, managing security... etc.)

I can find lots of stuff for developers but I don't write too much Java code!

Thanks for any info.

- Bill.

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

Sorta OT: Uncle Larry's no longer Chairman!

[Jesse, Rich]

And he apparently got hitched, too.  Wondering if Wall Street has any
thoughts on this...

http://www.eweek.com/article2/0,4149,1435093,00.asp

Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

RE: kill session privilage

[Goulet, Dick]

Well, I guess I could agree with that.  But here if a duhveloper needs a session 
killed, he calls.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 14, 2004 3:24 AM
To: Multiple recipients of list ORACLE-L






I imagine the reason goes something along the lines of "Sometimes
developers fire off queries that are going to run for an exceptionally long
time, often accidentally"  If you are only talking about killing sessions
on a development machine then I think it's a fairly valid request - I can't
imagine why a developer would ever want to kill a production session.

The earlier suggestion of writing a procedure and granting execute rights
on that procedure is an approach I have heard of before.



   
   
  "Goulet, Dick"   
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  >cc: 
   
  Sent by: Subject:  RE: kill session privilage
   
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  14/01/2004 08:44 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




First question for the boss, WHY?



Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA


  -Original Message-
  From: AK [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, January 13, 2004 2:44 AM
  To: Multiple recipients of list ORACLE-L
  Subject: kill session privilage

  My boss want me to give kill session privilage one of the developer
  here . He doesn't have any dba privilage to see session or anything .
  Is there any way I can give likited access to him.

  Thanks,
  ak





<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<>>

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

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

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

RE: data file permissions --

[Goulet, Dick]

SyncSort is NOT a data unloader.  It's purpose, and it does a damned good job of it, 
is to sort large text files to improve data loading with tools like SQL*Loader.  Your 
user should have zero access to the datafiles, period.  They need to be -rw-r so 
that an ipc dedicated server process will work.  But under NO circumstances should 
that be changed.  Doing so can make for a VERY long night of recovering a database.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Tuesday, January 13, 2004 5:14 PM
To: Multiple recipients of list ORACLE-L


Oracle data files are read BY ORACLE SERVER PROCESSES ONLY!
The only unloader that reads files directly is the notorious
DUL. I haven't had any experiences with DUL, but according to
what I know, I wouldn't even want to have it. 
Now there is a system call named "chmod" and oracle takes
care that only oracle RDBMS can access files. Nobody but the DBA
can even sniff database files. Please, execute that user.

On 01/13/2004 04:19:25 PM, [EMAIL PROTECTED] wrote:
> Hello All,
> 
> I have a question on data file permissions.
> When i add a new data file, it gets created as -rw-r-
> Umask for oracle user is 022. 
> There is a unix user who wants read access to the data files since they
> are read by fastunload process (syncsort).
> When i do a touch on any  file in that same directory the permission
> reads as -rw-r--r-- which coincides with the umask set. 
> Could someone please tell me how the data files get -rw-r and NOT
> -rw-r--r--.
> 
> Oracle file permission reads -rwsr-s--x
> 
> Thank You,
> 
> Sathish.
> 
> -- 
> http://www.fastmail.fm - Choose from over 50 domains or use your own
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include 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).
> 

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

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

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

RE: ** OCP for 9i requirements -- Instructor Led Class is a

[Paula_Stankus]

If you 
go to the Update 9i exam listing - there are no course 
requirements.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Hemant K 
  ChitaleSent: Wednesday, January 14, 2004 9:09 AMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: ** OCP for 9i 
  requirements -- Instructor Led Class is 
  aSure.Read "Important Program 
  Announcement: Oracle University Hands-On Course RequirementOracle 
  customers and business partners are demanding hands-on experience - with all 
  aspects of Oracle's database - from their Oracle Certified Professionals. In 
  order to meet our commitment to our customers and constituents, Oracle 
  University has recently made a significant investment in its Certification 
  Program. Three distinct changes are being rolled out with the goal of 
  increasing the level of quality of our certification skill and ability 
  benchmarks: ·   Scenario-based 
  testing in all Oracle9i DBA Certified Professional exams . ·   Instructor-led 
  class requirement for candidates starting on the Oracle9i DBA Certified 
  Professional credential exam path. ·   A 
  new hands-on Masters Practicum Exam for the Oracle9i Database Administrator 
  Certified Master credential. "at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html"Instructure-led 
  class" is a requirement.You CAN take the Online Training to _prepare_ 
  for the Exams.  But you MUST attend at least one Instructor-led 
  classto qualify for the certification.HemantAt 10:34 AM 13-01-04 
  -0800, you wrote:
  why dont 
you just read what is on the oracle website? www.oracle.com do a search for certification. 

  - Original Message - 
  From: Hemant K 
  Chitale 
  To: Multiple recipients of 
  list ORACLE-L 
  Sent: Tuesday, January 13, 2004 9:34 AM 
  Subject: Re: ** OCP for 9i requirements
  Are you sure that the on-line version qualifies as fulfilling the 
  pre-requisite ?  I thought that 
  the pre-requisite is "at least one Instructor Led Training".
  Hemant 
  At 12:04 AM 13-01-04 -0800, you wrote:
  
At 06:14 PM 1/12/2004, Ryan wrote:

  www.oracle.com 
   
  do a search for certification. Its all explained there. You can 
  take an online course for $300. If your company is an oracle partner 
  the course is free. 
My understanding is that you need to take a class that corresponds 
to one of the four OCP exams, which are all 5-day classes.  The 
in-classroom versions run $2500 and the on-line versions run 
$1250.  Oracle partners get a 35% discount (advantage and certified 
advantage partners may get a larger discount).
http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html
Justin Cave 

  - Original Message - 
  From: A Joshi 
  To: Multiple recipients of 
  list ORACLE-L 
  Sent: Monday, January 12, 2004 7:34 PM 
  Subject: ** OCP for 9i requirements
  Hi, 
    For taking Oracle9i OCP exam is it necessary to have 
  attended a Oracle course by Oracle University. What is the 
  minimum?  Is any small course good enough? Can someone who has 
  gone through this provide details? Thank you
  Do you Yahoo!? 
  Yahoo! Hotjobs: Enter 
  the "Signing Bonus" Sweepstakes 
  Hemant K 
  ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 
  05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
  Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network 
  Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing 
  list and web hosting services 
  - To 
  REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
  you want to be removed from). You may also send the HELP command for other 
  information (like subscribing).
  
  
  Hemant K ChitaleOracle 9i Database Administrator Certified 
  Professionalhttp://hkchital.tripod.com  {last updated 
  05-Jan-04}-- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.net -- Author: Hemant K Chitale INET: 
  [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
  http://www.fatcity.com San Diego, California -- Mailing list and web hosting 
  services - 
  To REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of ma

List problems

[Jared Still]

Folks,

It seems that a fair number of emails are not
being retransmitted to the list.  Some of mine
and a few others have not appeared in list traffic
sent out to subscribers.

Searching by author at fatcity.com reveals that 
the posts made it there, but either are not being
sent out, or getting shanghaied along the way.

I'll let you know when I find out.

I am of course, assuming that some of you will
get this one...

Jared




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

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

where is Sort area size

[A.Bahar]

Hi all 
, 
 
  
is sort are size a part of PGA ? 
 
Rgds.
Arslan.
 

Re: Import foibles

[Hemant K Chitale]

Yes, I once imported a schema [Parametric Windchill] which had a few tables 
with LONG datatypes.
It was one particular table that took ggg to import.
Import does import one-row-at-a-time for tables with LONGs .  But I 
couldn't explain
why one table took so much longer than the others.
I just kept logs of the export and import sessions but didn't follow up as 
this was a
Development environment.

Hemant
At 06:24 PM 13-01-04 -0800, you wrote:
My apologies if there are multiple copies of this.

Something funky going on with email from work.



First, the basics:

System Configuration:  Sun Microsystems  sun4u SUN Enterprise 420R (2 X
UltraSPARC-II 450MHz)
System clock frequency: 113 MHz
Memory size: 1024 Megabytes
= CPUs =
Run   Ecache   CPUCPU
Brd  CPU   Module   MHz MBImpl.   Mask
---  ---  ---  -  --  --  
 0 2 2  450 4.0   US-II10.0
 0 3 3  450 4.0   US-II10.0
The CPU's are about 95% idle.  Not much memory paging activity.

The disk is (gasp!) a single RAID 5 volume.  As this is a mostly read
system, it (usually) doesn't matter.
Oracle is 8.1.7.2

Doing an import into the database with the following script:

imp userid=$USERNAME/[EMAIL PROTECTED] \
file=/u03/tmp/${OWNER}_dv01.dmp \
buffer=10485760 \
fromuser=$OWNER \
touser=$OWNER \
ignore=y \
commit=y \
constraints=n \
indexes=n \
grants=n \
log=imp_${OWNER}.log
Notice that the buffer is 10m and commit=y.

This job is running very  slowly.  Querying v$session_event reveals many
and
long waits for log file sync.
  TIMEAVG
 TOTAL TOTAL
WAITED   WAIT
USERNAME  SID EVENT  WAITS
TIMEOUTS  SECONDS 100ths
-- -- --- 
  --
JKSTILL12 latch free63 49   0
   1
  log buffer space4818 2 641
13
  log file switch completion 9 0  3
37
  log file sync 628432 6
212193 34
  db file sequential read   27 0  3
10
  file open  3 0  0  0
  SQL*Net message to client1257012 0  3  0
  SQL*Net message from client  1257012 0
211774 17
  SQL*Net more data from client 118572 0  9  0
9 rows selected.

Notice that the value for log file sync seems a bit high for a session
that has been connected for a little over 2 hours.
Even so, it does accumulate rapidly.  10 seconds of activity garners 8
seconds of log file sync waits.
This is not a terribly fast system, but it should not be this slow.

The following query shows that the average blocks per commit is about 4.5.

select blocks_changed, user_commits,
   blocks_changed / user_commits blocks_per_commit
from (
   select
  stat.value blocks_changed
   from v$sesstat stat, v$statname name, v$session sess
   where
  stat.sid = sess.sid
  and stat.statistic# = name.statistic#
  and name.name = 'db block changes'
  and stat.sid = 12
) r1,
(
   select
  stat.value user_commits
   from v$sesstat stat, v$statname name, v$session sess
   where
  stat.sid = sess.sid
  and stat.statistic# = name.statistic#
  and name.name = 'user commits'
  and stat.sid = 12
) r2
With an 8k block, that is about 36k per commit.  Somewhat less than the
10m per commit I expected.
Suspecting that the LONG datatype in some of the tables may be the
culprit, a quick perusal of TFM
reveals the following regarding the use of the LONG datatype with the imp
utility:

The integer specified for BUFFER is the size, in bytes, of the buffer
through which data rows are transferred.
BUFFER determines the number of rows in the array inserted by Import.
The following formula gives an approximation of the buffer size that
inserts a given array of rows:
buffer_size = rows_in_array * maximum_row_size
For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, or DATE
columns, rows are inserted individually.
The size of the buffer must be large enough to contain the entire row,
except for LOB and LONG columns.
If the buffer cannot hold the longest row in a table, Import attempts to
allocate a larger buffer.

So, the buffer parameter has no effect on tables containing columns of the
type long, lob, bfile, ref, rowid, urowid or date.
This seems rather limiting for such an important utility. This applies to
versions 8.1.7 and 9.2.0
I ran a test to load 90k rows into 2 different tables, the only difference
being t

9i OEM/tools to monitor 8i instances

[Nikhil Khimani]

L&G,

Has there been any issue monitoring and administering 8i databases using 9i
tools? I am seeing some strange behavior when using 9i OEM tools to monitor
8.1.7.0 database and unfortunately I can not reproduce on a consistent
basis.
TIA,

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

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

Re: ** OCP for 9i requirements -- Instructor Led Class is a

[Hemant K Chitale]

Sure.
Read 
"Important Program Announcement: Oracle University Hands-On Course
Requirement
Oracle customers and business partners are demanding hands-on experience
- with all aspects of Oracle's database - from their Oracle Certified
Professionals. In order to meet our commitment to our customers and
constituents, Oracle University has recently made a significant
investment in its Certification Program. Three distinct changes are being
rolled out with the goal of increasing the level of quality of our
certification skill and ability benchmarks: 
·   Scenario-based
testing in all Oracle9i DBA Certified Professional exams . 
·   Instructor-led
class requirement for candidates starting on the Oracle9i DBA Certified
Professional credential exam path. 
·   A
new hands-on Masters Practicum Exam for the Oracle9i Database
Administrator Certified Master credential. 
"
at
http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
"Instructure-led class" is a requirement.
You CAN take the Online Training to _prepare_ for the Exams.  But
you MUST attend at least one Instructor-led class
to qualify for the certification.
Hemant
At 10:34 AM 13-01-04 -0800, you wrote:
why dont
you just read what is on the oracle website?
 
www.oracle.com
 
do a search for certification. 

- Original Message - 
From: Hemant K
Chitale 
To: Multiple recipients of
list ORACLE-L 
Sent: Tuesday, January 13, 2004 9:34 AM
Subject: Re: ** OCP for 9i requirements


Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ?  I thought that
the pre-requisite is "at least one Instructor Led
Training".

Hemant
At 12:04 AM 13-01-04 -0800, you
wrote:
At 06:14 PM 1/12/2004, Ryan
wrote:
www.oracle.com
 
do a search for certification. Its all explained there. You can take
an online course for $300. If your company is an oracle partner the
course is free. 
My understanding is that you need to take a class that corresponds to
one of the four OCP exams, which are all 5-day classes.  The
in-classroom versions run $2500 and the on-line versions run $1250. 
Oracle partners get a 35% discount (advantage and certified advantage
partners may get a larger discount).

http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html

Justin Cave 
- Original Message - 
From: A Joshi 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, January 12, 2004 7:34 PM 
Subject: ** OCP for 9i requirements

Hi, 
  For taking Oracle9i OCP exam is it necessary to have attended
a Oracle course by Oracle University. What is the minimum?  Is any
small course good enough? Can someone who has gone through this provide
details? Thank you



Do you Yahoo!? 
Yahoo! Hotjobs:
Enter
the "Signing Bonus" Sweepstakes 
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
 {last updated 05-Jan-04}
-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}


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

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

RE: Table access

[Wendry]

Perhaps you can query dba_tab_privs.

-Original Message-
Tracy Rahmlow
Sent: Tuesday, January 13, 2004 10:19 PM
To: Multiple recipients of list ORACLE-L


I am looking for a script that I can supply a table name and it returns
all users that have access to it (either directly, thru system
priveleges or thru roles) and what the access is.  Does anybody have
something like this that I can use?  Thanks 
American Express made the following
annotations on 01/13/2004 08:16:14 AM

--

**

"This message and any attachments are solely for the intended recipient
and may contain confidential or privileged information. If you are not
the intended recipient, any disclosure, copying, use, or distribution of
the information included in this message and any attachments is
prohibited. If you have received this communication in error, please
notify us by reply e-mail and immediately and permanently delete this
message and any attachments. Thank you."


**



==

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

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

Setting up Windows 2000 for Oracle Parallel Server

[Wendry]

Hi all,

 

I’d like to ask you about how to prepare windows 2000
environment so I can set Oracle Parallel Server on it, aside from networking
problem. As I read the doc, I have to set up raw disk and prepare the OS by
installing some options to prepare for the parallel server. The question is I
don’t know what options or additional software to install on Windows 2000
for OPS. I have 2 servers running on windows 2000 and I plan to set multi
clustered environment. Can you help me, please? Thank you all in advance.

 

Regards,

 

Wendry.

 

 

Re: Read Only TBS Backup Confirmation

[Ron Rogers]

Gene,
 That's the purpose of read-only tablespaces. You make to changes you
need in the data, alter it to read only, and back it up to the backups
device(disk,tape) and but the backup on the shelf. That way your 500 Gig
datbase with 500 Meg active only requires the 500 Meg be backed up.
Ron

>>> [EMAIL PROTECTED] 01/13/2004 11:24:24 AM >>>
ENV:
- AIX 4.3.3 
- Oracle 8.1.7

I have one tablespace which is read only.  Can I just copy the
datafiles from a Read Only tablespace for a valid backup?  For the
rest
of the db, I backup hot or cold.  
 
Is anyone copying Read Only Tablespace datafiles for backups?  I
haven't found this method officially supported by Oracle, but have
read
that is safe to copy Read Only datafiles (makes sense), just wondering
if anyone is doing it?
 
Thanks,
Gene
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

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

Re: Import foibles

[Connor McDonald]

I the big motivation for the ol' SQL*Plus COPY command
was to improve upon this.

Of course COPY is disappearing as well isn't it?

Cheers
Connor

 --- Jared Still <[EMAIL PROTECTED]> wrote: > My
apologies if there are multiple copies of this.
> 
> Something funky going on with email from work.
> 
> 
>   
> First, the basics:
> 
> System Configuration:  Sun Microsystems  sun4u SUN
> Enterprise 420R (2 X 
> UltraSPARC-II 450MHz)
> System clock frequency: 113 MHz
> Memory size: 1024 Megabytes
> = CPUs
> =
> Run   Ecache   CPUCPU
> Brd  CPU   Module   MHz MBImpl.   Mask
> ---  ---  ---  -  --  --  
>  0 2 2  450 4.0   US-II10.0
>  0 3 3  450 4.0   US-II10.0
> 
> The CPU's are about 95% idle.  Not much memory
> paging activity.
> 
> The disk is (gasp!) a single RAID 5 volume.  As this
> is a mostly read
> system, it (usually) doesn't matter.
> 
> Oracle is 8.1.7.2
> 
> Doing an import into the database with the following
> script:
> 
> imp userid=$USERNAME/[EMAIL PROTECTED] \
> file=/u03/tmp/${OWNER}_dv01.dmp \
> buffer=10485760 \
> fromuser=$OWNER \
> touser=$OWNER \
> ignore=y \
> commit=y \
> constraints=n \
> indexes=n \
> grants=n \
> log=imp_${OWNER}.log
> 
> 
> Notice that the buffer is 10m and commit=y.
> 
> This job is running very  slowly.  Querying
> v$session_event reveals many 
> and
> long waits for log file sync.
> 
>   TIMEAVG
> 
> TOTAL TOTAL 
> WAITED   WAIT
> USERNAME  SID EVENT 
> WAITS 
> TIMEOUTS  SECONDS 100ths
> -- --
> ---  
>   --
> JKSTILL12 latch free
>63 49   0  
>1
>   log buffer space  
>  4818 2 641  
> 13
>   log file switch completion
> 9 0  3  
> 37
>   log file sync 
>628432 6 
> 212193 34
>   db file sequential read   
>27 0  3  
> 10
>   file open 
> 3 0  0  0
>   SQL*Net message to client 
>   1257012 0  3  0
>   SQL*Net message from client   
>   1257012 0 
> 211774 17
>   SQL*Net more data from client 
>118572 0  9  0
> 
> 
> 9 rows selected.
> 
> Notice that the value for log file sync seems a bit
> high for a session 
> that has been connected for a little over 2 hours.
> 
> Even so, it does accumulate rapidly.  10 seconds of
> activity garners 8 
> seconds of log file sync waits.
> 
> This is not a terribly fast system, but it should
> not be this slow. 
> 
> The following query shows that the average blocks
> per commit is about 4.5.
> 
> select blocks_changed, user_commits,
>blocks_changed / user_commits blocks_per_commit
> from (
>select
>   stat.value blocks_changed
>from v$sesstat stat, v$statname name, v$session
> sess
>where
>   stat.sid = sess.sid
>   and stat.statistic# = name.statistic#
>   and name.name = 'db block changes'
>   and stat.sid = 12
> ) r1,
> (
>select
>   stat.value user_commits
>from v$sesstat stat, v$statname name, v$session
> sess
>where
>   stat.sid = sess.sid
>   and stat.statistic# = name.statistic#
>   and name.name = 'user commits'
>   and stat.sid = 12
> ) r2
> 
> 
> With an 8k block, that is about 36k per commit. 
> Somewhat less than the 
> 10m per commit I expected.
> 
> Suspecting that the LONG datatype in some of the
> tables may be the 
> culprit, a quick perusal of TFM 
> reveals the following regarding the use of the LONG
> datatype with the imp 
> utility:
> 
> 
> The integer specified for BUFFER is the size, in
> bytes, of the buffer 
> through which data rows are transferred.
> BUFFER determines the number of rows in the array
> inserted by Import. 
> The following formula gives an approximation of the
> buffer size that 
> inserts a given array of rows:
> buffer_size = rows_in_array * maximum_row_size
> 
> For tables containing LONG, LOB, BFILE, REF, ROWID,
> UROWID, or DATE 
> columns, rows are inserted individually. 
> The size of the buffer must be large enough to
> contain the entire row, 
> except for LOB and LONG columns. 
> If the buffer cannot hold the longest row in a
> table, Import attempts to 
> allocate a larger buffer.
> 
> 
> So, the buffer parameter has no effect on tables
> containing columns of the 
> type long, lob, bfile, ref, rowid, urowid or date.
> 
> This seems rather limiting for such an important
> utility

Re: Should we stop analyzing?

[Nuno Souto]

Dunno how he does it.  But I'd settle for my
replies from my ISP to make it here...

Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message - 



> How do you know they're nodding if they call you on the phone?  Distinct
> rattling sound? :-)
> 

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

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

RE: kill session privilege

[Justin Cave]

At 01:24 AM 1/14/2004, Mark Richard wrote:

I imagine the reason goes something along the lines of "Sometimes
developers fire off queries that are going to run for an exceptionally long
time, often accidentally"  If you are only talking about killing sessions
on a development machine then I think it's a fairly valid request - I can't
imagine why a developer would ever want to kill a production session.
Well, sometimes developers are asked to generate ad-hoc reports for 
management.  In those cases, it's pretty easy to accidentally generate the 
"query from heck" and need to kill it.

The earlier suggestion of writing a procedure and granting execute rights
on that procedure is an approach I have heard of before.
What I've generally seen is a stored procedure that checks to make sure 
that the session the user is trying to kill is their own, probably logs the 
kill in some sort of audit table, etc.  I don't have much of a problem with 
a developer killing their own session even in production.

Justin Cave





  "Goulet, 
Dick" 

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

  Sent by: Subject:  RE: kill session 
privilage
  [EMAIL PROTECTED] 

  .com 





  14/01/2004 
08:44 

  Please respond 
to 

  ORACLE-L 









First question for the boss, WHY?



Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
  -Original Message-
  From: AK [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, January 13, 2004 2:44 AM
  To: Multiple recipients of list ORACLE-L
  Subject: kill session privilage
  My boss want me to give kill session privilage one of the developer
  here . He doesn't have any dba privilage to see session or anything .
  Is there any way I can give likited access to him.
  Thanks,
  ak




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for 
delivery of the message to such person), you may not copy or deliver this 
message to anyone.
In such a case, you should destroy this message and kindly notify the 
sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to 
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message that do not 
relate to the official business of Transurban Infrastructure Developments 
Limited and CityLink Melbourne Limited shall be understood as neither 
given nor endorsed by them.
<<>>

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

RE: kill session privilage

[Mark Richard]

I imagine the reason goes something along the lines of "Sometimes
developers fire off queries that are going to run for an exceptionally long
time, often accidentally"  If you are only talking about killing sessions
on a development machine then I think it's a fairly valid request - I can't
imagine why a developer would ever want to kill a production session.

The earlier suggestion of writing a procedure and granting execute rights
on that procedure is an approach I have heard of before.



   
   
  "Goulet, Dick"   
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  >cc: 
   
  Sent by: Subject:  RE: kill session privilage
   
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  14/01/2004 08:44 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




First question for the boss, WHY?



Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA


  -Original Message-
  From: AK [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, January 13, 2004 2:44 AM
  To: Multiple recipients of list ORACLE-L
  Subject: kill session privilage

  My boss want me to give kill session privilage one of the developer
  here . He doesn't have any dba privilage to see session or anything .
  Is there any way I can give likited access to him.

  Thanks,
  ak





<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<>>

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

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