Re: Suggestion reg. encryption ??

[Prem Khanna J]

Hi Pete,

Thanx a lot.

http://www.petefinnigan.com/orasec.htm

This URL of yours has a lot related to encryption.
As u said,i received "Best Practices for Securing Oracle"
from iDefense.com.Is this the paper u mentioned about ?

Hi Craig,

thanx a lot for your wonderful reply 
(and for your precious time spent to explain me).
u have given me surplus info'.
i need to look into the resources u had given me.

HSM would be the last option and many many thanx for 
letting me know that.

Hi Ranganath,

ton of thanx for your pretty example.
i am not able to reach http://www.protegrity.com/.
can u ? hope it's down.

thanx for your prompt reply..as u always do :)

Regards,
Jp.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna 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: shared_Pool

[zhu chao]

HI,
There is other inforation needed to be in the shared pool, like data buffer head, 
rac/ops specific inforation etc. This will make shared pool larger than specified.

zhu chao.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 30, 2003 4:59 AM


> List, will the following two queries give the same value for the
> shared_Pool-size ?
> 
> select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool';
> 
> and
> 
> show parameter shared_pool_size
> 
> I always get a difference , the first one gives a value greater than the
> second by 12MB
> I tried with different values of shared_pool_size .
> What am I doing wrong here ?
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  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).

Statspack Report!

[Gunnar Berglund]

Hi all,
 
could you please clarify me what these might mean (and how to tune the db in order to avoid those).
 
So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand:
 
Child  Get   Spin &Latch Name Num Requests  Misses Sleeps Sleeps 1->4-- ---  --- -- cache buffers chainsp;   609  750,125 572 58 0/0/0/0/0cache buffers chains   610  641,794 673 38 0/0/0/0/0cache buffers
 chains   611  508,147 246 23 0/0/0/0/0cache buffers chains   608  374,928  96 11 0/0/0/0/0
and
 
Top 5 Timed Events~~ % TotalEvent   Waits    Time (s) Ela Time  --- direct path write (lob)   &nbbsp;   101,116 
 13,637    38.23
 
and
 
Event   Waits   Timeouts   Time (s)   (ms) /txn  -- -- -- rdbms ipc message&nnbsp;    218,281    202,375    809,339   3708  0.8
Sorry for the mess, but please try to read...
 
TIA
gbWant to chat instantly with your online friends? Get the FREE Yahoo!
Messenger

Re: BAARF

[Tim Gorman]

I agree, though I'm not sure if it is because indexes are more susceptible
to corruption.  My guess is that given 50-50 odds, sometimes you get lucky.
Mixing tables and indexes together gives you 0% odds of losing data...  :-)

Well, to add another couple of pennies worth...

In my very first gig as a DBA ten years ago, we were faced with a 7.0.15
database that was doubling in size every few months.  Management had already
decided to scrap the system and migrate to another, so they refused to buy
more storage even though it was production.  Long story short, we were
forced to unmirror the RAID-1 volumes underneath the index tablespaces and
use the freed-up plexes to create new volumes for table tablespaces.
Indexes are ancillary structures and ultimately expendable;  tables are
*data*...



on 9/29/03 7:09 AM, Hitchman, Peter at [EMAIL PROTECTED] wrote:

> Hi,
> To add my two pennies worth. By design I create physical database lqyouts
> that seperate indexes and tables by tablespace for ease of management,
> unless the database is real small. My experience over the years with Oracle,
> has been the object corruptions in the database have occurred more frequenty
> with indexes than tables, and when it happens its good just to be able to
> scrap the index tablespaces datafiles and start again.
> 
> Regards
> 
> Pete
> 
> -Original Message-
> Sent: 29 September 2003 02:45
> To: Multiple recipients of list ORACLE-L
> 
> 
> Thomas,
> 
> Please pardon me, but you are off-target in your criticisms of OFA.
> 
> It has never advocated separating tables from indexes for performance
> purposes.  Ironically, your email starts to touch on the real reason for
> separating them (i.e. different types of I/O, different recovery
> requirements, etc).  Tables and indexes do belong in different tablespaces,
> but not for reasons of performance.
> 
> Cary first designed and implemented OFA in the early 90s and formalized it
> into a paper in 1995.  Quite frankly, it is a brilliant set of rules of how
> Oracle-based systems should be structured, and a breath of fresh air from
> the simplistic way that Oracle installers laid things out at the time.  It
> took several years for Oracle Development to see the light and become
> OFA-compliant, and not a moment too soon either.  Just imagine if everything
> were still installed into a single directory tree under ORACLE_HOME?   All
> of things you mention here have nothing to do with OFA.
> 
> Please read the paper.
> 
> Hope this helps...
> 
> -Tim
> 
> P.S.By the way, multiple block sizes are not intended for performance
>   optimization;  they merely enable transportable tablespaces between
>   databases with different block sizes.
> 
> 
> on 9/25/03 11:04 AM, Thomas Day at [EMAIL PROTECTED] wrote:
> 
>> 
>> I would love to have a definitive site that I could send all RAID-F
>> advocates to where it would be laid out clearly, unambiguously, and
>> definitively what storage types should be used for what purpose.
>> 
>> Redo logs on RAID 0 with Oracle duplexing (y/n)?
>> Rollback (or undo) ditto?
>> Write intensive tablespaces on RAID 1+0 (or should that be 0+1)?
>> Read intensive tablespaces on RAID ? (I guess 5 is OK since it's cheaper
>> than 1+0 and you won't have the write penalty)
>> 
>> While we're at it could we blow up the OFA myth?  Since you're tablespaces
>> are on datafiles that are on logical volumns that are on physical devices
>> which may contain one or many actual disks, does it really make sense to
>> worry (from a performance standpoint) about separating tables and indexes
>> into different tablespaces?
>> 
>> We have killed the "everything in one extent" myth haven't we?
> Everybody's
>> comfortable with tables that have 100's of extents?
>> 
>> And while we're at it, could we include the Oracle 9 multiple blocksizes
>> and how to use them.  The best that I've seen is indexes in big blocks,
>> tables in small blocks --- uh, oh, time to separate tables and indexes.
>> 
>> Maybe we will never get rid of the OFA myth.
>> 
>> Just venting.
>> 
>> Tired of arguing in front of management with Oracle certified DBAs that
>> RAID 5 is not good, OFA is unnecessary, and uniform extents is the only
> way
>> to go.  Looking for a big stick to catch their attention with.
>> 

-- 
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: Logical standby mode - Dataguard - 9.2.0.4

[VIVEK_SHARMA]

 

Can anyone who has
successfully used Logical Standby Database share the ENTIRE Commands’ set?


 

I shall share our entire
current commands’ set which is being used to bring up the Logical standby
database ( without any errors ) with anyone who asks.

NOTE –
Though there are NO Errors (in alert_.log) & all Our Commands complete
successfully, DMLs on Primary tables 

are NOT getting
applied to Standby Database 

 

We have raised a
few Oracle TARs too.

 

Thanks

 

 

-Original Message-
From: VIVEK_SHARMA 
Sent: Monday, September 29, 2003
1:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Logical standby mode
- Dataguard - 9.2.0.4

 

OR is it so that logical Standby mode is just NOT possible for the
Entire Database 

if the Database has even 1 Table with a LONG field datatype ?

 

 

-Original Message-
From: VIVEK_SHARMA 
Sent: Monday, September 29, 2003
1:25 PM
To: Multiple recipients of list
ORACLE-L
Subject: Logical standby mode -
Dataguard - 9.2.0.4

 

A Basic Qs. On Logical standby mode - Dataguard - 9.2.0.4 . Is the
following statement correct ?

 

From the Primary Database the DMLs on tables NOT having LONG columns
are successfully applied across to the 

Logical Standby database while those tables containing LONG columns
fail . 

 

 

Query to find Objects which are NOT supported ;-

 

Select * from DBA_LOGSTDBY_UNSUPPORTED; 

 

 

RE: x$ constructs and memory

[Steve Adams]

Hi Tanel,

Answers inline ...

>> As you may know,
>> heaps are implemented as a heap descriptor and linked list of extents,
>> and within each extent there is a linked list of chunks.
>
>Is there a linked list for *all* chunks in a heap as well, regardless of
>their type, or is there only a list for each type of chunks, free and
>recreatable ones?
>Am I correct that permanent chunks don't have to be in any list because
>they're never deallocated and they should stay in same place anyway?

There is an invariant chunk header that identifies the chunk class and
implements the linked list of all chunks in an extent. Then there is a class
specific header that in the case of permanent, free and recreatable chunks
has a pointer for another linked list. I'm not sure why the permanent linked
list is needed (other than to make heapdumps efficient). The free and
recreatable chunks obviously need theirs for the freelists and LRU lists.

>> Some "X$ tables" have become "X$ interfaces" in recent versions, for
>> example X$KTCXB and X$KSQRS. [snip] All you will notice is that the
>> ADDR column of the X$ output now returns addresses which map into
>> your PGA rather than the SGA. In fact, that is in general a good way
>> to work out whether you are looking at an X$ table or an X$ interface.
>
>I've noticed that some tables such x$ktcxb and x$kturd return the same ADDR
>value for all it's rows. I've always thought, that it means a subroutine or
>function is returning the results instead of a direct read from array, as
>you described. But x$ksqrs does return different ADDRs for each row
(9.2.0.4
>on W2K). Am I on wrong tracks here?

The implementation of these row sources varies somewhat. Some of them, like
X$KSMSP, need to buffer their results in the CGA because the structure might
change before the next fetch; others like these ones you've mentioned do not
need to, but some of them do so anyway.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/ - For DBAs
@   http://www.christianity.net.au/  - For all 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve Adams
  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: Using dimensions

[Mark Richard]

I don't have experience with an Oracle Dimension as such, but plenty of
experience with homemade dimensions within an Oracle database - Perhaps
Oracle does some stuff for you.  To give an example of how we would use
them:

Assume a time dimension with columns as follows (sample data below):
YEARMONTH WEEKDAY DATE
20031   1   1   2003/01/01
20031   1   2   2003/01/02
20034   2   9   2003/04/09

Now if you have a fact table (say ORDERS) then you can join
ORDERS.ORDER_DATE to TIME.DATE and restrict on other columns in the TIME
table.  For example:

select year, month sum(order_total) from orders, time
where orders.order_date = time.date
and time.year = 2003
group by year, month

We also used Organisational dimensions.  For a company with several
thousand cost centres this provides the ability to summarise and aggregate
figures across the company at any level.  Another dimension that used to
cause grief was the Report dimension - the system I worked on had several
thousand report lines in their various financial reports (balance sheet,
cash flow, etc) and we then mapped around 80,000 financial accounts to
these report lines to create an entire report structure.  The funny thing -
we used a further eight dimensions just to map account codes to the report
lines - dimensions within dimensions.  Add enough dimensions to a fact
table in a star schema and the queries you can answer are enormous.

Hopefully this gives you a feel of how to use dimensions.  They have few
uses except for reporting and maintaining them can be a headache within
themself.  I used to work a lot with time-variant dimensions where not only
could you report on the organisational structure but also map data into the
structure at any point in time.  For example, we could take financial
figures from years past and apply the organisational changes to the figures
to report against today's structure.

Sorry if I've confused you.



   

  "Jamadagni,  

  Rajendra" To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
 Subject:  RE: Using dimensions  
   
  Sent by: 

  [EMAIL PROTECTED]
   
  com  

   

   

  30/09/2003 02:14 

  Please respond to

  ORACLE-L 

   

   





Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses
of dimensions ... where does one use them? in SQLs?

I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.

Thanks
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: Scott Canaan [mailto:[EMAIL PROTECTED]
  Sent: Monday, September 29, 2003 11:55 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Using dimensions

  Dimensions are data warehouse constructs.  They are implemented as
  tables in the database, but have the characteristic of a hierarchy
  that can be traversed.  For example:  a time dimension can have the
  hierarchy of date, day, week, month, quarter, year, decade, century.
  This is used for rollup reporting within the data mart.  I don't see
 

Re: shared_Pool

[Navneet Gupta]

YES

regards
navneet
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 30, 2003 2:29 AM


> List, will the following two queries give the same value for the
> shared_Pool-size ?
>
> select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared
pool';
>
> and
>
> show parameter shared_pool_size
>
> I always get a difference , the first one gives a value greater than the
> second by 12MB
> I tried with different values of shared_pool_size .
> What am I doing wrong here ?
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Navneet Gupta
  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: x$ constructs and memory

[Tanel Poder]

Hi Steve,

Thank you for your explanation, but I got few additional questions ig you
got a chance to answer:

> (There are similar X$ interfaces for other memory heaps). As you may know,
> heaps are implemented as a heap descriptor and linked list of extents, and
> within each extent there is a linked list of chunks. So what is done is
that

Is there a linked list for *all* chunks in a heap as well, regardless of
their type, or is there only a list for each type of chunks, free and
recreatable ones?
Am I correct that permanent chunks don't have to be in any list because
they're never deallocated and they should stay in same place anyway?

> Some "X$ tables" have become "X$ interfaces" in recent versions, for
example
> X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue
> resources arrays respectively. The reason is that they are no longer fixed
> arrays. Instead they are "segmented arrays" that can be dynamically
extended
> by adding discontiguous chunks of shared pool memory to the array. The
> freelists and latching for these arrays in unchanged however. All you will
> notice is that the ADDR column of the X$ output now returns addresses
which
> map into your PGA rather than the SGA. In fact, that is in general a good
> way to work out whether you are looking at an X$ table or an X$ interface.

I've noticed that some tables such x$ktcxb and x$kturd return the same ADDR
value for all it's rows. I've always thought, that it means a subroutine or
function is returning the results instead of a direct read from array, as
you described. But x$ksqrs does return different ADDRs for each row (9.2.0.4
on W2K). Am I on wrong tracks here?

Thank you!
Tanel.


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

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

RE: OFA myths was Re: BAARF

[Cary Millsap]

Oh man... now I see the problem.

Well, IMHO, Kevin's advice is the right advice for the wrong reasons.
It's not the OFA.

Thanks, Jacques, for pointing that out.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Jacques Kilchoer
Sent: Monday, September 29, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L

Not commenting on the accuracy of the information, but Kevin Loney, in
the Oracle8 DBA Handbook (1998), says the following (Chapter 3 Logical
Database Layouts), in a section entitled "The Optimal Flexible
Architecture (OFA)"
"Index segments should not be stored in the same tablespace as their
associated tables, since they have a great deal of concurreint I/O
during both manipulation and queries. Index segments are also subject to
fragmentation due to improper sizing or unpredicted table growth.
Isolating the application indexes to a separate tablespace greatly
reduces the administrative efforts involved in defragmenting either the
DATA or the INDEXES tablespace."

>From reading his book, I always thought that OFA implied the separation
of tables and indexes.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Steve Rospo
> Sent: jeudi, 25. septembre 2003 15:10
> 
> I'd like to get rid of the myth that OFA really states all 
> that much about
> what goes in what tablespace etc.  I've got a copy of the 
> Cary's OFA paper
> entitled "The OFA Standard - Oracle7 for Open Systems" dated Sept 24,
> 1995. (Happy belated birthday OFA!)  At the end of paper 
> there's a summary
> of the requirements and the recommendations that make up OFA. 
>  The CLOSEST
> the OFA comes to specifying table/index separation are
> 
> "#7 Separate groups of segments with different lifespans, I/O request
> demands, and backup frequencies among different tablespaces."
> 
> -or maybe-
> 
> "#11 *IF* [emphasis mine] you can afford enough hardware 
> that: 1) You can
> guarantee that each disk drive will contain database files 
> from exactly
> one application and 2) You can dedicate sufficiently many 
> drives to each
> database to ensure that there will be no I/O bottleneck."
> 
> The document itself says, "The OFA Standard is a set of configuration
> guidelines that will give you faster, more reliable Oracle 
> database that
> require less work to maintain."  So every time I read that someone is
> putting redo here, index tablespaces here, and temp 
> tablespaces there in
> order to be "OFA compliant" I kinda shrug.  Obviously it's 
> all a good idea
> to separate this stuff but it's not absolutely required for OFA-ness.
> Essentially, OFA is just a very good way of separating Oracle 
> code from
> Oracle data to make administration *much* easier.  I'm sure before OFA
> there were plenty of places that had everything under 
> $ORACLE_HOME/dbs and
> no naming standard for datafiles.  Ugh!
> 
> Now if we could only find this "Cary V. Millsap, Oracle Corporation"
> character so he could explain himself. ;-)  '95 was a 
> loong time ago.
-- 
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).


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

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

RE: BAARF

[Cary Millsap]

Niall,

I think you've specified the right test.

However, whether to separate indexes from data is an easier argument.
All it takes is one of potentially dozens of reasons, and isolating
becomes the right idea.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Niall Litchfield
Sent: Monday, September 29, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L

Cary writes

> It *is* a good idea to separate index data from heap data 
> into different tablespaces. But the reason isn't solely to 
> eliminate I/O competition. Even if I/O competition isn't an 
> issue for you (and the OFA Standard doesn't say that it will 
> be), then it's *still* a good idea to separate your index 
> data from your heap data, for reasons including:
> 
> * Index segments have different backup and recovery 
> requirements than their corresponding heap segments. For 
> example, as Peter mentioned, if you have an index block 
> corruption event, then it's convenient to just offline, kill, 
> and rebuild an index tablespace. If the indexes and data are 
> mixed up in a single tablespace, this is not an option. Another
> example: If you construct your backup schedule to make media 
> recovery time a constant, then you probably don't need to 
> back up your indexes on the same schedule as you back up your 
> heaps. But unless they're in different tablespaces, this 
> isn't an option either.

Hmmm maybe I'm going to start having to rethink some stuff, when you and
Howard agree and I disagree it seems likely I'm being dense. My concern
goes 

Indexes are largely built for one of two reasons

A) to make performance acceptable.
B) to enforce constraints. 

In a media recovery situation, recovering but with unacceptable
performance or locking issues probably doesn't really constitute
recovery. Now If it can be shown that trashing the index tablespace and
rebuilding is generally faster than restoring datafiles and applying
logs I might be more convinced but at the moment I'm not so sure. So is
this garbage Or not.?

Niall 

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

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


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

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

RE: x$ constructs and memory

[Steve Adams]

Hi Daniel and list,

There are two types of X$ row sources. "X$ tables" export in-memory data
structures that are inherently tabular, and "X$ interfaces" that call
functions to return data is non-tabular, or not memory resident.

For example, the array of structs in the SGA representing processes is
exported as the "X$ table" X$KSUPR. Not all of the struct members are
exported as columns, but all of the rows are exported. There is a freelist,
implemented as a header that points to the first free slot in the array, and
a member of each struct to point to the next free slot. The 'process
allocation' latch protects this freelist.

The most obvious example of an "X$ interface" to return non-tabular data is
X$KSMSP, which returns one row for each chunk of memory in the shared pool.
(There are similar X$ interfaces for other memory heaps). As you may know,
heaps are implemented as a heap descriptor and linked list of extents, and
within each extent there is a linked list of chunks. So what is done is that
when the X$ interface is queried these linked lists are navigated (under the
protection of the relevant latch if necessary) an a array is built in the
CGA (part of the PGA) from which rows are then returned by the row source.

An example of an "X$ interface" that returns data that is not memory
resident is X$KCCLE, which returns one row for each log file member entry in
the controlfile. In fact, all the X$KCC* interfaces read data directly from
the controlfile. Similarly, the X$KTFB* interfaces return LMT extent
information - from the bitmap blocks (for free extents) and from the segment
header and extent map blocks (for used extents).

Some "X$ tables" have become "X$ interfaces" in recent versions, for example
X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue
resources arrays respectively. The reason is that they are no longer fixed
arrays. Instead they are "segmented arrays" that can be dynamically extended
by adding discontiguous chunks of shared pool memory to the array. The
freelists and latching for these arrays in unchanged however. All you will
notice is that the ADDR column of the X$ output now returns addresses which
map into your PGA rather than the SGA. In fact, that is in general a good
way to work out whether you are looking at an X$ table or an X$ interface.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/ - For DBAs
@   http://www.christianity.net.au/  - For all 

-Original Message-
Daniel Fink
Sent: Tuesday, 30 September 2003 1:10 AM
To: Multiple recipients of list ORACLE-L


I was sitting on a mountain here in Colorado, pondering Oracle
optimization and an interesting scenario crossed my feeble mind.
As I began to ponder this (I asked the resident marmot, but he
must be a SQL*Server expert...), I came up with several
questions.

Where in memory (sga or other) do the x$ constructs reside?
Some of them are 'populated' by reading file-based structures
(control file, datafile headers, undo segments). Does this
information reside in memory or is it loaded each time the x$
construct is accessed?
What happens when these x$constructs begin to consume large
amounts of memory? Is there an upper bound?

Daniel Fink


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve Adams
  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: 8i OCP Net8 Exam

[AK]

I don't remember appearing this one in exam .

-Ak
OCP 8i

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 2:34 PM


> Can anyone recall whether the Oracle Intelligent Agent figured on the
> Oracle8i OCP Network Administration exam? Couchman's practice exams have
> quite a few questions on Intelligent Agent, but when I check the official
> Test Content Checklist on Oracle's Education website, it isn't directly
> mentioned. Being the lazy slob I am, wouldn't want to study extra.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  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: OFA myths was Re: BAARF

[Jacques Kilchoer]

Not commenting on the accuracy of the information, but Kevin Loney, in the Oracle8 DBA 
Handbook (1998), says the following (Chapter 3 Logical Database Layouts), in a section 
entitled "The Optimal Flexible Architecture (OFA)"
"Index segments should not be stored in the same tablespace as their associated 
tables, since they have a great deal of concurreint I/O during both manipulation and 
queries. Index segments are also subject to fragmentation due to improper sizing or 
unpredicted table growth. Isolating the application indexes to a separate tablespace 
greatly reduces the administrative efforts involved in defragmenting either the DATA 
or the INDEXES tablespace."

>From reading his book, I always thought that OFA implied the separation of tables and 
>indexes.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Steve Rospo
> Sent: jeudi, 25. septembre 2003 15:10
> 
> I'd like to get rid of the myth that OFA really states all 
> that much about
> what goes in what tablespace etc.  I've got a copy of the 
> Cary's OFA paper
> entitled "The OFA Standard - Oracle7 for Open Systems" dated Sept 24,
> 1995. (Happy belated birthday OFA!)  At the end of paper 
> there's a summary
> of the requirements and the recommendations that make up OFA. 
>  The CLOSEST
> the OFA comes to specifying table/index separation are
> 
> "#7 Separate groups of segments with different lifespans, I/O request
> demands, and backup frequencies among different tablespaces."
> 
> -or maybe-
> 
> "#11 *IF* [emphasis mine] you can afford enough hardware 
> that: 1) You can
> guarantee that each disk drive will contain database files 
> from exactly
> one application and 2) You can dedicate sufficiently many 
> drives to each
> database to ensure that there will be no I/O bottleneck."
> 
> The document itself says, "The OFA Standard is a set of configuration
> guidelines that will give you faster, more reliable Oracle 
> database that
> require less work to maintain."  So every time I read that someone is
> putting redo here, index tablespaces here, and temp 
> tablespaces there in
> order to be "OFA compliant" I kinda shrug.  Obviously it's 
> all a good idea
> to separate this stuff but it's not absolutely required for OFA-ness.
> Essentially, OFA is just a very good way of separating Oracle 
> code from
> Oracle data to make administration *much* easier.  I'm sure before OFA
> there were plenty of places that had everything under 
> $ORACLE_HOME/dbs and
> no naming standard for datafiles.  Ugh!
> 
> Now if we could only find this "Cary V. Millsap, Oracle Corporation"
> character so he could explain himself. ;-)  '95 was a 
> loong time ago.
-- 
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).

Re: 8i OCP Net8 Exam

[Stephane Faroult]

DENNIS WILLIAMS wrote:
> 
> Can anyone recall whether the Oracle Intelligent Agent figured on the
> Oracle8i OCP Network Administration exam? Couchman's practice exams have
> quite a few questions on Intelligent Agent, but when I check the official
> Test Content Checklist on Oracle's Education website, it isn't directly
> mentioned. Being the lazy slob I am, wouldn't want to study extra.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]

Methinks that they finally found 'intelligent' a bit overstretched. You
may be more lucky looking for 'agent'.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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: BAARF

[Binley Lim]

Havent' you heard about the theory of relativity?

1 - ideal - full recovery with indexes
2 - relatively less than ideal - having to rebuild indexes

It doesn't mean you should aim for 2, but you sure want to keep 2 as an
option. If you don't have separate index tablespaces, you are simply
limiting your options. In a recovery situation you want all the options you
can get!


> Indexes are largely built for one of two reasons
>
> A) to make performance acceptable.
> B) to enforce constraints.
>
> In a media recovery situation, recovering but with unacceptable
> performance or locking issues probably doesn't really constitute
> recovery. Now If it can be shown that trashing the index tablespace and
> rebuilding is generally faster than restoring datafiles and applying
> logs I might be more convinced but at the moment I'm not so sure. So is
> this garbage Or not.?
>
> Niall


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Binley Lim
  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: Reality check for filesystem/disk layout

[JayMiller]

This database is required to be 7x24 so we have to run in archivelog mode
(no cold backups).

My concern with SAME is that we may very well end up with a lot of io
contention when we're having large data loads and large sorts happening at
the same time.  And would you really put data files on RAID5 when our main
problem on the database is the amount of time it takes to do our monthly
loads?  Wouldn't that slow down all the inserts?

Unfortunately putting redo on dedicated disks will not be approved due to
the wasted space.  I'd love to do it but...

You're probably right about not bothering to put the archive logs on the
outer portion of the disk.  Thinking it over that doesn't seem necessary.
Comments from anyone else on what might profitably inhabit that valuable
disk real estate?  Rollback segments perhaps?  Temp?  Or just not bother to
specify anything?

Jay Miller
Sr. Oracle DBA



-Original Message-
Sent: Saturday, September 27, 2003 4:50 AM
To: Multiple recipients of list ORACLE-L


Hi, 
Since it seems that your data can be loaded again easily via night batch
load, why not consider noarchivelog mode?
SAME is better than your disk partition policy ,I think. You have
limited number of disk, seperate your limited number of disks for dedicated
redo/archive maybe is not a good idear.
And using outer part of the disk maybe become much more complicated when
raid is in use.Do you know the underlying raid policy? 
Another possible solution I will consider is put redo on mirrored disk(2
disks) and everything else on raid5. This max the daily read performance and
does not affect the nightly loading.Archive log is not relavant to
performance of read and loading,unless archive process is unable to catch
the speed of redo generation.I won't put valuable disk resource to
archivelog.

Zhu Chao.

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

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Richard Foote]

Title: Message



Hi Mladen,
 
Because when you insert a row, Oracle has 
absolutely no idea by how much it might grow (should the insertion of that 18th 
row use up the remaining space in the block or should we save some, who's to 
know ...). Therefore the setting of some magic PCTFREE is not supported. Forget 
about PCTUSED, FREELISTS and FREELIST GROUPS but ASSM doesn't support the 
forgetting of PCTFREE.
 
Cheers
 
Richard

  - Original Message - 
  From: 
  Mladen 
  Gogala 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, September 30, 2003 2:09 
  AM
  Subject: RE: SEGMENT SPACE MANAGEMENT 
  AUTO hangs on 9.2.0.4 on Linux
  
  And 
  why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic 
  segment space management.
  Initial/next are resolved by using LMT, because that's what takes care 
  of your extent sizes.
   
   
  --Mladen GogalaOracle DBA 
  

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Richard 
FooteSent: Monday, September 29, 2003 11:55 AMTo: 
Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE 
MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Hi Mladen,
 
I can't help you with your problem, I haven't 
had the pleasure on NT or Tru64 but I just wanted to point out that you 
can't forget about PCTFREE even with ASSM.
 
Cheers
 
Richard

  - Original Message - 
  From: 
  Mladen Gogala 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Tuesday, September 30, 2003 
  12:44 AM
  Subject: SEGMENT SPACE MANAGEMENT 
  AUTO hangs on 9.2.0.4 on Linux
  
  I have RDBMS 
  9.2.0.4 on RH 7.3 and I executed the following 
  command:
   
  create 
  tablespace wizard
  datafile 
  '/oradata/WIZ/wizard01.dbf' size 3072M reuse
  autoextend on 
  next 1024M maxsize 16385m
  extent 
  management local autoallocate
  segment space 
  management auto;
   
  The whole 
  system just hung, doing I/O like crazy.  I was unable to killl one of 
  the server processes
  which survived 
  even shutdown abort, so I had to bounce thw whole box. No errors, no 
  traces, no
  anything. Does 
  anybody else have experience with this? Is there a known bug (not 
  currently known
  to me)  
  with a patch that I can install? I'd really like to use "SEGMENT SPACE 
  MANAGEMENT AUTO"
  and forget 
  about pctfree/pctused stuff. 
   
  --Mladen GogalaOracle DBA 
   
   
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any 
  mistransmission.  If you receive this message in error, please 
  immediately delete it and all copies of it from your system, destroy any 
  hard copies of it and notify the sender.  You must not, directly or 
  indirectly, use, disclose, distribute, print, or copy any part of this 
  message if you are not the intended recipient. Wang Trading LLC and any of its 
  subsidiaries each reserve the right to monitor all e-mail communications 
  through its networks.  Any views expressed in this message are those 
  of the individual sender, except where the message states otherwise and 
  the sender is authorized to state them to be the views of any such 
  entity.
   
   
   
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any mistransmission.  
  If you receive this message in error, please immediately delete it and 
  all copies of it from your system, destroy any hard copies of it and notify 
  the sender.  You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. Wang Trading 
  LLC and any of its subsidiaries each reserve the right to 
  monitor all e-mail communications through its networks.  Any views 
  expressed in this message are those of the individual sender, except where the 
  message states otherwise and the sender is authorized to state them to be the 
  views of any such entity.
   
   

RE: Problems creading a Index

[Teresita Castro]

Yes was the unique, thanks to all!!
>>> [EMAIL PROTECTED] 09/29/03 
03:09PM >>>
 the first three items in 
the primary key index is the same as the  first items in your UNIQUE 
index you are trying to make...would be my guess
 
don't make a unique 
index
 
 

  -Original 
  Message-From: Teresita Castro 
  [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 
  2003 2:35 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Problems creading a Index
  HI!!
  I want to create the next index:
   
  CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON 
    "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, 
  ITEM)   TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5  
  STORAGE(INITIAL 40960 )
   
  But I can't because Oracle send me the next 
  error:
   
  The following error has occurred:
   
  ORA-01452: cannot CREATE UNIQUE INDEX; 
  duplicate keys found
   
  I checked on TOAD ( with F4 on the table name) and It give 
  me the next script.
  I don't have an index with the field ITEM on it, so I 
  don't  undestand what I am getting this error.
   
  DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; 
  
   
  CREATE TABLE OEINVCLINE (   
  COMPANY   NUMBER 
  (4)    NOT NULL,   
  INVC_PREFIX   CHAR 
  (2)  NOT NULL,   
  INVC_NUMBER   NUMBER (8)    
  NOT NULL,   
  LINE_NBR  NUMBER 
  (6)    NOT NULL,   
  LINE_TYPE CHAR 
  (1)  NOT NULL,   
  ITEM  
  CHAR (32) NOT NULL,   
  DESCRIPTION   CHAR 
  (30) NOT NULL,   
  ORDER_NBR NUMBER 
  (8)    NOT NULL,   
  SHIPMENT_NBR  NUMBER (10)   NOT NULL, 
    QUANTITY  
  NUMBER (13,4) NOT NULL,   
  INVC_CW_QTY   NUMBER (13,4) NOT NULL, 
    SPR_UOM   
  CHAR (4)  NOT NULL,   
  SELL_UOM  CHAR 
  (4)  NOT NULL,   
  SEC_UOM   CHAR 
  (4)  NOT NULL,   
  MULT_SPR_FL   CHAR 
  (1)  NOT NULL,   
  SPR_TO_STOCK  NUMBER (13,7) NOT NULL,   
  SELL_TO_STOCK NUMBER (13,7) NOT NULL,   
  SEC_UOM_MULT  NUMBER (13,7) NOT NULL,   
  LOCATION  CHAR 
  (5)  NOT NULL,   
  PRICE_STATUS  CHAR 
  (1)  NOT NULL,   
  ENTERED_PRICE NUMBER (13,5) NOT NULL,   
  UNIT_PRICE    NUMBER (13,5) NOT NULL, 
    SELL_PRC_CURR NUMBER (15,7) NOT NULL, 
    SELL_UNIT_PRC NUMBER (15,7) NOT NULL, 
    UNIT_COST NUMBER 
  (13,5) NOT NULL,   CURRENT_COST  NUMBER 
  (13,5) NOT NULL,   NO_CHARGE_FL  CHAR 
  (1)  NOT NULL,   
  ENTERED_DISC  NUMBER (15,2) NOT NULL,   
  ADD_ON_DISC   NUMBER (15,2) NOT NULL, 
    ALLOC_DISC    NUMBER (15,2) 
  NOT NULL,   TAX_EXEMPT_CD CHAR 
  (1)  NOT NULL,   
  TAX_CODE  CHAR 
  (10) NOT NULL,   
  ENT_TAXABLE   NUMBER (15,2) NOT NULL, 
    TAXABLE_BSE   NUMBER (15,2) NOT 
  NULL,   TAX_AMT_CURR  NUMBER (15,2) NOT 
  NULL,   TAX_AMT_BSE   NUMBER (15,2) 
  NOT NULL,   REASON_CODE   CHAR 
  (4)  NOT NULL,   
  DISC_CODE CHAR 
  (10) NOT NULL,   
  ORD_DISC_FL   CHAR 
  (1)  NOT NULL,   
  CONTRACT_NBR  CHAR (14) 
  NOT NULL,   PROMOTION 
  CHAR (10) NOT NULL,   
  ACTIVITY  CHAR 
  (15) NOT NULL,   
  ACCT_CATEGORY CHAR (5)  
  NOT NULL,   ATN_OBJ_ID    
  NUMBER (12)   NOT NULL,   
  ACTIVITY_C    CHAR 
  (15) NOT NULL,   
  ACCT_CATEG_C  CHAR 
  (5)  NOT NULL,   
  ATN_OBJ_ID_C  NUMBER (12)   NOT NULL, 
    FINAL_INVC_FL CHAR 
  (1)  NOT NULL,   
  SLS_ACCT_UNIT CHAR (15) NOT 
  NULL,   SLS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  SLS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   SALES_MAJCL   CHAR 
  (4)  NOT NULL,   
  SALES_MINCL   CHAR 
  (4)  NOT NULL,   
  DSC_AMT_01    NUMBER (15,2) NOT NULL, 
    DSC_AMT_02    NUMBER (15,2) 
  NOT NULL,   DSC_AMT_03    
  NUMBER (15,2) NOT NULL,   DSC_ACCT_UNIT_01  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_02  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_03  CHAR 
  (15) NOT NULL,   
  DSC_ACCOUNT_01    NUMBER (6)    NOT NULL, 
    DSC_ACCOUNT_02    NUMBER (6)    NOT 
  NULL,   DSC_ACCOUNT_03    NUMBER (6)    
  NOT NULL,   DSC_SUB_ACCT_01   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_02   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_03   NUMBER (4)    
  NOT NULL,   DSC_AMT_BASE  NUMBER (15,2) 
  NOT NULL,   OFF_ACCT_UNIT CHAR 
  (15) NOT NULL,   
  OFF_ACCOUNT   NUMBER (6)    
  NOT NULL,   OFF_SUB_ACCT  NUMBER 
  (4)    NOT NULL,   
  CGS_ACCT_UNIT CHAR (15) NOT 
  NULL,   CGS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  CGS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   LAST_MISC_SEQ NUMBER 
  (3)    NOT NULL,   
  LAST_COMM_SEQ NUMBER (3)    NOT NULL, 
    TERRITORY CHAR 
  (4)  NOT NULL,   
  SALESMAN  NUMBER 
  (4)    NOT NULL,   
  SALESMAN_2    NUMBER 
  (4)    NOT NULL,   
  COMM_RATE_1   NUMBER (7,7)  NOT NULL, 
    COMM_RATE_2   NUMBER (7,7)  
  NOT NULL,   COMM_SPLIT   

RE: Off Topic: PC Firewall Recommendation

[Bob Metelsky]

I agree

I have a SMC 8 port broadband router that has a web based firewall admin
module. It's worked excellent for over 2 years and is fully
configurable. I would look for any over the counter router that included
a web based firewall. Probably around $75

SMC lynksys...



-Original Message-
Sent: Monday, September 29, 2003 6:00 PM
To: Multiple recipients of list ORACLE-L

I second this recommendation. CNET testing showed that ZoneAlarm (even
the free version; there's also ZoneAlarm Pro) did a better job of
blocking break-in and hack attempts than most of the commercial
products.   
--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> Try Zonealarm.   It's free.
>  
> I have a wireless router, which has a built in firewall.
> 
> -Original Message-
> Sent: Monday, September 29, 2003 10:05 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I have a Dell 8200 with XP Prof. SP1.
>  
> I would like recommendations as to a good firewall for this machine. 
> XP has a firewall but it is not the greatest.
>  
> Thanks much,
> Ken Janusz, CPIM
> 
> 


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  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: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 8i OCP Net8 Exam

[Gary W. Parker]

I took that exam earlier this year and I don't recall anything related to the IA

-Original Message-
DENNIS WILLIAMS
Sent: Monday, September 29, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


Can anyone recall whether the Oracle Intelligent Agent figured on the
Oracle8i OCP Network Administration exam? Couchman's practice exams have
quite a few questions on Intelligent Agent, but when I check the official
Test Content Checklist on Oracle's Education website, it isn't directly
mentioned. Being the lazy slob I am, wouldn't want to study extra.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary W. Parker
  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: 8i OCP Net8 Exam

[Bob Metelsky]

Hello Dennis

To the best of my recollection it was not included. Pretty much basic
stuff on that test. For me that was the easiest, and made the most sense
of the tests I've taken

Bob


Can anyone recall whether the Oracle Intelligent Agent figured on the
Oracle8i OCP Network Administration exam? Couchman's practice exams have
quite a few questions on Intelligent Agent, but when I check the
official
Test Content Checklist on Oracle's Education website, it isn't directly
mentioned. Being the lazy slob I am, wouldn't want to study extra.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Off Topic: PC Firewall Recommendation

[Paul Baumgartel]

I second this recommendation. CNET testing showed that ZoneAlarm (even
the free version; there's also ZoneAlarm Pro) did a better job of
blocking break-in and hack attempts than most of the commercial
products.   
--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> Try Zonealarm.   It's free.
>  
> I have a wireless router, which has a built in firewall.
> 
> -Original Message-
> Sent: Monday, September 29, 2003 10:05 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I have a Dell 8200 with XP Prof. SP1.
>  
> I would like recommendations as to a good firewall for this machine. 
> XP has a firewall but it is not the greatest.
>  
> Thanks much,
> Ken Janusz, CPIM
> 
> 


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  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: BAARF

[Tim Gorman]

Oh, plenty of times.  Just never heard it referred to as "OFA".



on 9/29/03 7:04 AM, Thomas Day at [EMAIL PROTECTED] wrote:

> 
> My struggle is not with the directory layout OFA.
> 
> It is with the "mythical" OFA that every DBA that I have talked to knows
> all about.  Where ORACLE says that if you are a good and competent DBA you
> will separate your  table data and your index data into two separate
> tablespaces so that one disk head can be reading index entries while
> another disk head is reading the table data.  You've never run into that?
> 
> 
> 
>  
> Tim Gorman  @sagelogix.com>  To:  Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> ml-errorsSubject: Re: BAARF
>  
>  
> 09/28/2003 09:44
> PM
> Please respond
> to ORACLE-L
>  
>  
> 
> 
> 
> 
> Thomas,
> 
> Please pardon me, but you are off-target in your criticisms of OFA.
> 
> It has never advocated separating tables from indexes for performance
> purposes.  Ironically, your email starts to touch on the real reason for
> separating them (i.e. different types of I/O, different recovery
> requirements, etc).  Tables and indexes do belong in different tablespaces,
> but not for reasons of performance.
> 
> Cary first designed and implemented OFA in the early 90s and formalized it
> into a paper in 1995.  Quite frankly, it is a brilliant set of rules of how
> Oracle-based systems should be structured, and a breath of fresh air from
> the simplistic way that Oracle installers laid things out at the time.  It
> took several years for Oracle Development to see the light and become
> OFA-compliant, and not a moment too soon either.  Just imagine if
> everything
> were still installed into a single directory tree under ORACLE_HOME?   All
> of things you mention here have nothing to do with OFA.
> 
> Please read the paper.
> 
> Hope this helps...
> 
> -Tim
> 
> P.S.By the way, multiple block sizes are not intended for performance
>   optimization;  they merely enable transportable tablespaces between
>   databases with different block sizes.
> 
> 
> on 9/25/03 11:04 AM, Thomas Day at [EMAIL PROTECTED] wrote:
> 
>> 
>> I would love to have a definitive site that I could send all RAID-F
>> advocates to where it would be laid out clearly, unambiguously, and
>> definitively what storage types should be used for what purpose.
>> 
>> Redo logs on RAID 0 with Oracle duplexing (y/n)?
>> Rollback (or undo) ditto?
>> Write intensive tablespaces on RAID 1+0 (or should that be 0+1)?
>> Read intensive tablespaces on RAID ? (I guess 5 is OK since it's cheaper
>> than 1+0 and you won't have the write penalty)
>> 
>> While we're at it could we blow up the OFA myth?  Since you're
> tablespaces
>> are on datafiles that are on logical volumns that are on physical devices
>> which may contain one or many actual disks, does it really make sense to
>> worry (from a performance standpoint) about separating tables and indexes
>> into different tablespaces?
>> 
>> We have killed the "everything in one extent" myth haven't we?
> Everybody's
>> comfortable with tables that have 100's of extents?
>> 
>> And while we're at it, could we include the Oracle 9 multiple blocksizes
>> and how to use them.  The best that I've seen is indexes in big blocks,
>> tables in small blocks --- uh, oh, time to separate tables and indexes.
>> 
>> Maybe we will never get rid of the OFA myth.
>> 
>> Just venting.
>> 
>> Tired of arguing in front of management with Oracle certified DBAs that
>> RAID 5 is not good, OFA is unnecessary, and uniform extents is the only
> way
>> to go.  Looking for a big stick to catch their attention with.
>> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
> INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 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-

Re: Last Call for RMOUG Training Days 2004

[Daniel Fink]

Melanie, you are correct, the deadline has been extended to October 1st.
I did not realize they were going to extend it and I did not check before
I posted the message.

I also failed to include the url...
https://www.rmoug.org/td2004_abs_subm.htm.



Dan

Melanie Caffrey wrote:

> Uhhh  Dan?
>
> The Website states that the deadline has been extended to Oct. 1st.
>
> Which is more correct?  You or the Website?
>
> Just so I know to turn to a few people here and tell them to hurry up.
>
> Of course, I should probably just do that anyway.  :-)
>
> -Original Message-
> Daniel Fink
> Sent: Monday, September 29, 2003 3:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Today is the last day to submit an abstract for Rocky Mountain
> Oracle User Group Training Days 2004 in sunny and snowy Denver,
> Colorado.
>
> Last year, we had sessions from oracle-lers Cary, Anjo, Rachel,
> Tim as well as Stephan Haisley, Gary Goodman, Kent Graziano,
> Dave Ensor, Craig Shallahamer and Kevin Loney.
>
> Don't forget to bring your skis and sunscreen!
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Melanie Caffrey
>   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).
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

Re: workarea_size_policy=auto and performance efficiency [was: Re:

[Tim Gorman]

Richard,

I take it that your two points are...shall we say...enhancement requests,
not current functionality?  :-)

Following up on the discussion of "space-efficiency" and tabling (for the
moment) my questions about the "performance-efficiency" side of things.
Yes, there certainly is an element of "performance-efficiency" to
"space-efficiency" if it keeps you from swapping...

...anyway...

Using WORKAREA_SIZE_POLICY = MANUAL, only the sort workarea has ever even
pretended to give memory back for the duration of the session, depending on
the relationship between SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE.  The
hash and bitmap workareas have never had this functionality, as near as I
can tell.

So, I think that you're absolutely correct that sessions using
WORKAREA_SIZE_POLICY = MANUAL will allocate the memory and hold onto it for
a long time, essentially until they disconnect.  Is this correct?

Is WORKAREA_SIZE_POLICY = AUTO any different?  From what I've gathered, the
P_A_T algorithms only occur upon allocation of workarea memory.  Is there
any additional logic around de-allocation, possibly when the server process
has finished using the workarea?  Perhaps there is logic to de-allocate
before beginning another operation requiring?  Or do server processes hold
onto workarea memory forever here as well?

I'm prepared to accept P_A_T as the "best thing since LMT", but so far I
don't see it.  At least not for all circumstances (as with LMT).  I see it
as a good thing in memory-constrained environments, but in environments with
plenty of RAM I see it so far as a possible source of unnecessary
instability with no upside.

Thanks!

-Tim



on 9/29/03 5:10 AM, Richard Foote at [EMAIL PROTECTED] wrote:

> Hi Tim,
> 
> There are couple of parts of the conversation we've missed out ;)
> 
> Firstly, the server process when talking to the P_A_T instance should have
> said, "What the hell is going on here, what do you mean I can't have my full
> 100M, this keeps on happening and it's just good enough. Get a bloody DBA to
> increase the P_A_T now because it's bloody obvious that the damn thing is
> set too low ."   (especially if the load you describe is typical).
> 
> Secondly, the server process when talking to the non P_A_T should have said
> upon receiving the memory, "ha, thanks, and guess what, no one else can have
> this memory back until I decide to rack off, and no I don't care if you're
> running short of memory, bugger ya, page for all I care "
> 
> These are very important parts of the conversion !!
> 
> At the site I currently work at, we had 12G of memory which at peak load was
> just about running out. We have 1000-1200 sessions with (generally) only a
> small number active at a time but the sum of the PGAs was considerable and
> the major contributor. We had a number of disk sorts occurring although the
> SAS kept the number within acceptable limits. After setting the P_A_T, we
> now have a comfortable buffer of free memory (generally sitting around 1G),
> disk sorts have disappeared entirely (in four months, we've had 2 disk
> sorts) and hash joins have improved considerably.
> 
> Based on my experience, P_A_T is the best thing Oracle has introduced since
> LMT !!
> 
> Cheers
> 
> Richard Foote
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, September 29, 2003 6:59 AM
> 
> 
> Referencing the article mentioned in this thread, I'd also like to
> understand exactly what is meant by the phrase "[PGA_AGGREGATE_TARGET] leads
> to a more efficient use of RAM memory"?
> 
> From what I've been able to determine about this functionality, "efficient"
> merely means "space-efficient", not "performance-efficient" (i.e. Fewer
> cycles?  Smarter cycles?).  Is this correct?  Does anyone know of anything
> in WORKAREA_SIZE_POLICY=AUTO which improves performance over
> WORKAREA_SIZE_POLICY=MANUAL?
> 
> Please correct me if I'm wrong, but I think the algorithm for
> WORKAREA_SIZE_POLICY=AUTO can be characterized something like:
> 
>   [server process]:  I'd like to malloc some private heap/data memory
>   use in sorting, hashing, bitmap operations, or whatever?
>   [instance]:  OK, what do you need?
>   [server process]:  Um, I'd like 100Mb, please?
>   [instance]:  Well, PGA_AGGREGATE_TARGET is 2Gb and currently I see
>   that 150 other server processes are using 1.2Gb at the
>   moment...
>   [another server process]:  I'm done sorting!  I've released the
>   100Mb I was using!  Thanks...
>   [instance]:  OK, so now it is 149 other server processes using
>   1.19Gb at the moment.  So, you wanted 100Mb?  Well, since
>   the amount in use is over 50% of the target, I have to
>   scale your request back by 25%, so I'll let you take 75Mb
>   [server process]:  Well, OK.  My execution plan was originally
>   devised under the assumption that I'd have 100Mb of sort
>   space in mem

8i OCP Net8 Exam

[DENNIS WILLIAMS]

Can anyone recall whether the Oracle Intelligent Agent figured on the
Oracle8i OCP Network Administration exam? Couchman's practice exams have
quite a few questions on Intelligent Agent, but when I check the official
Test Content Checklist on Oracle's Education website, it isn't directly
mentioned. Being the lazy slob I am, wouldn't want to study extra.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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).

RE: BAARF

[Niall Litchfield]

Cary writes

> It *is* a good idea to separate index data from heap data 
> into different tablespaces. But the reason isn't solely to 
> eliminate I/O competition. Even if I/O competition isn't an 
> issue for you (and the OFA Standard doesn't say that it will 
> be), then it's *still* a good idea to separate your index 
> data from your heap data, for reasons including:
> 
> * Index segments have different backup and recovery 
> requirements than their corresponding heap segments. For 
> example, as Peter mentioned, if you have an index block 
> corruption event, then it's convenient to just offline, kill, 
> and rebuild an index tablespace. If the indexes and data are 
> mixed up in a single tablespace, this is not an option. Another
> example: If you construct your backup schedule to make media 
> recovery time a constant, then you probably don't need to 
> back up your indexes on the same schedule as you back up your 
> heaps. But unless they're in different tablespaces, this 
> isn't an option either.

Hmmm maybe I'm going to start having to rethink some stuff, when you and
Howard agree and I disagree it seems likely I'm being dense. My concern
goes 

Indexes are largely built for one of two reasons

A) to make performance acceptable.
B) to enforce constraints. 

In a media recovery situation, recovering but with unacceptable
performance or locking issues probably doesn't really constitute
recovery. Now If it can be shown that trashing the index tablespace and
rebuilding is generally faster than restoring datafiles and applying
logs I might be more convinced but at the moment I'm not so sure. So is
this garbage Or not.?

Niall 

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

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

RE: Problems creading a Index

[Govind.Arumugam]

 
Run the following sql statement to see whether there are duplicate 
entries.  Chances are that you will find duplicates hence you get the above 
error.  You may choose to remove the duplicates or create a non-unique 
index otherwise.
 
select COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM, 
count(*)
from LAWSON2.OEINVCLINE
group by COMPANY, INVC_PREFIX, INVC_NUMBER, 
ITEM
having count(*) > 1;
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Teresita 
  CastroSent: Monday, September 29, 2003 3:35 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Problems creading a 
  Index
  HI!!
  I want to create the next index:
   
  CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON 
    "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, 
  ITEM)   TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5  
  STORAGE(INITIAL 40960 )
   
  But I can't because Oracle send me the next 
  error:
   
  The following error has occurred:
   
  ORA-01452: cannot CREATE UNIQUE INDEX; 
  duplicate keys found
   
  I checked on TOAD ( with F4 on the table name) and It give 
  me the next script.
  I don't have an index with the field ITEM on it, so I 
  don't  undestand what I am getting this error.
   
  DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; 
  
   
  CREATE TABLE OEINVCLINE (   
  COMPANY   NUMBER 
  (4)    NOT NULL,   
  INVC_PREFIX   CHAR 
  (2)  NOT NULL,   
  INVC_NUMBER   NUMBER (8)    
  NOT NULL,   
  LINE_NBR  NUMBER 
  (6)    NOT NULL,   
  LINE_TYPE CHAR 
  (1)  NOT NULL,   
  ITEM  
  CHAR (32) NOT NULL,   
  DESCRIPTION   CHAR 
  (30) NOT NULL,   
  ORDER_NBR NUMBER 
  (8)    NOT NULL,   
  SHIPMENT_NBR  NUMBER (10)   NOT NULL, 
    QUANTITY  
  NUMBER (13,4) NOT NULL,   
  INVC_CW_QTY   NUMBER (13,4) NOT NULL, 
    SPR_UOM   
  CHAR (4)  NOT NULL,   
  SELL_UOM  CHAR 
  (4)  NOT NULL,   
  SEC_UOM   CHAR 
  (4)  NOT NULL,   
  MULT_SPR_FL   CHAR 
  (1)  NOT NULL,   
  SPR_TO_STOCK  NUMBER (13,7) NOT NULL,   
  SELL_TO_STOCK NUMBER (13,7) NOT NULL,   
  SEC_UOM_MULT  NUMBER (13,7) NOT NULL,   
  LOCATION  CHAR 
  (5)  NOT NULL,   
  PRICE_STATUS  CHAR 
  (1)  NOT NULL,   
  ENTERED_PRICE NUMBER (13,5) NOT NULL,   
  UNIT_PRICE    NUMBER (13,5) NOT NULL, 
    SELL_PRC_CURR NUMBER (15,7) NOT NULL, 
    SELL_UNIT_PRC NUMBER (15,7) NOT NULL, 
    UNIT_COST NUMBER 
  (13,5) NOT NULL,   CURRENT_COST  NUMBER 
  (13,5) NOT NULL,   NO_CHARGE_FL  CHAR 
  (1)  NOT NULL,   
  ENTERED_DISC  NUMBER (15,2) NOT NULL,   
  ADD_ON_DISC   NUMBER (15,2) NOT NULL, 
    ALLOC_DISC    NUMBER (15,2) 
  NOT NULL,   TAX_EXEMPT_CD CHAR 
  (1)  NOT NULL,   
  TAX_CODE  CHAR 
  (10) NOT NULL,   
  ENT_TAXABLE   NUMBER (15,2) NOT NULL, 
    TAXABLE_BSE   NUMBER (15,2) NOT 
  NULL,   TAX_AMT_CURR  NUMBER (15,2) NOT 
  NULL,   TAX_AMT_BSE   NUMBER (15,2) 
  NOT NULL,   REASON_CODE   CHAR 
  (4)  NOT NULL,   
  DISC_CODE CHAR 
  (10) NOT NULL,   
  ORD_DISC_FL   CHAR 
  (1)  NOT NULL,   
  CONTRACT_NBR  CHAR (14) 
  NOT NULL,   PROMOTION 
  CHAR (10) NOT NULL,   
  ACTIVITY  CHAR 
  (15) NOT NULL,   
  ACCT_CATEGORY CHAR (5)  
  NOT NULL,   ATN_OBJ_ID    
  NUMBER (12)   NOT NULL,   
  ACTIVITY_C    CHAR 
  (15) NOT NULL,   
  ACCT_CATEG_C  CHAR 
  (5)  NOT NULL,   
  ATN_OBJ_ID_C  NUMBER (12)   NOT NULL, 
    FINAL_INVC_FL CHAR 
  (1)  NOT NULL,   
  SLS_ACCT_UNIT CHAR (15) NOT 
  NULL,   SLS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  SLS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   SALES_MAJCL   CHAR 
  (4)  NOT NULL,   
  SALES_MINCL   CHAR 
  (4)  NOT NULL,   
  DSC_AMT_01    NUMBER (15,2) NOT NULL, 
    DSC_AMT_02    NUMBER (15,2) 
  NOT NULL,   DSC_AMT_03    
  NUMBER (15,2) NOT NULL,   DSC_ACCT_UNIT_01  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_02  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_03  CHAR 
  (15) NOT NULL,   
  DSC_ACCOUNT_01    NUMBER (6)    NOT NULL, 
    DSC_ACCOUNT_02    NUMBER (6)    NOT 
  NULL,   DSC_ACCOUNT_03    NUMBER (6)    
  NOT NULL,   DSC_SUB_ACCT_01   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_02   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_03   NUMBER (4)    
  NOT NULL,   DSC_AMT_BASE  NUMBER (15,2) 
  NOT NULL,   OFF_ACCT_UNIT CHAR 
  (15) NOT NULL,   
  OFF_ACCOUNT   NUMBER (6)    
  NOT NULL,   OFF_SUB_ACCT  NUMBER 
  (4)    NOT NULL,   
  CGS_ACCT_UNIT CHAR (15) NOT 
  NULL,   CGS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  CGS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   LAST_MISC_SEQ NUMBER 
  (3)    NOT NULL,   
  LAST_COMM_SEQ NUMBER (3)    NOT NULL, 
    TERRITORY CHAR 
  (4)  NOT NULL,   
  SALESMAN  NUMBER 
  (4)    NOT NULL,   

RE: workarea_size_policy=auto and performance efficiency [was: Re:

[Niall Litchfield]

Hi Tim and Richard

Is there another modification to the process as follows

 [server process foote]:  I'd like to malloc some private 
 heap/data memory
 use in sorting, hashing, bitmap operations, or whatever?
 [instance ellison]:  OK, what do you need?
 [server process foote]:  Um, I'd like 100Mb, please? Mr Bowie has
released a *lot* of records and I need them in date order, by record
label and sleeve colour, grouped by NME review rating
 [instance ellison]:  Well, PGA_AGGREGATE_TARGET is 2Gb and
currently I see
 that 150 other server processes are using 1.2Gb at the
 moment...
 [server process gorman]:  I'm done sorting!...
 [instance ellison]: shutup Tim you'll have to wait I'm talking to
Mr Foote about the man who fell to earth damnit. 

Or in other words is there not a latch on this tally of allocated
memory? This is a real question.

Niall

But I like the conversation idea anyway 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Richard Foote
> Sent: 29 September 2003 14:30
> To: Multiple recipients of list ORACLE-L
> Subject: Re: workarea_size_policy=auto and performance 
> efficiency [was: Re:
> 
> 
> Hi Tim,
> 
> There are couple of parts of the conversation we've missed out ;)
> 
> Firstly, the server process when talking to the P_A_T 
> instance should have said, "What the hell is going on here, 
> what do you mean I can't have my full 100M, this keeps on 
> happening and it's just good enough. Get a bloody DBA to 
> increase the P_A_T now because it's bloody obvious that the 
> damn thing is
> set too low ."   (especially if the load you describe is typical).
> 
> Secondly, the server process when talking to the non P_A_T 
> should have said upon receiving the memory, "ha, thanks, and 
> guess what, no one else can have this memory back until I 
> decide to rack off, and no I don't care if you're running 
> short of memory, bugger ya, page for all I care "
> 
> These are very important parts of the conversion !!
> 
> At the site I currently work at, we had 12G of memory which 
> at peak load was just about running out. We have 1000-1200 
> sessions with (generally) only a small number active at a 
> time but the sum of the PGAs was considerable and the major 
> contributor. We had a number of disk sorts occurring although 
> the SAS kept the number within acceptable limits. After 
> setting the P_A_T, we now have a comfortable buffer of free 
> memory (generally sitting around 1G), disk sorts have 
> disappeared entirely (in four months, we've had 2 disk
> sorts) and hash joins have improved considerably.
> 
> Based on my experience, P_A_T is the best thing Oracle has 
> introduced since LMT !!
> 
> Cheers
> 
> Richard Foote
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, September 29, 2003 6:59 AM
> 
> 
> Referencing the article mentioned in this thread, I'd also 
> like to understand exactly what is meant by the phrase 
> "[PGA_AGGREGATE_TARGET] leads to a more efficient use of RAM memory"?
> 
> From what I've been able to determine about this 
> functionality, "efficient" merely means "space-efficient", 
> not "performance-efficient" (i.e. Fewer cycles?  Smarter 
> cycles?).  Is this correct?  Does anyone know of anything in 
> WORKAREA_SIZE_POLICY=AUTO which improves performance over 
> WORKAREA_SIZE_POLICY=MANUAL?
> 
> Please correct me if I'm wrong, but I think the algorithm for 
> WORKAREA_SIZE_POLICY=AUTO can be characterized something like:
> 
> [server process]:  I'd like to malloc some private 
> heap/data memory
> use in sorting, hashing, bitmap operations, or whatever?
> [instance]:  OK, what do you need?
> [server process]:  Um, I'd like 100Mb, please?
> [instance]:  Well, PGA_AGGREGATE_TARGET is 2Gb and currently I see
> that 150 other server processes are using 1.2Gb at the
> moment...
> [another server process]:  I'm done sorting!  I've released the
> 100Mb I was using!  Thanks...
> [instance]:  OK, so now it is 149 other server processes using
> 1.19Gb at the moment.  So, you wanted 100Mb?  Well, since
> the amount in use is over 50% of the target, I have to
> scale your request back by 25%, so I'll let you take 75Mb
> [server process]:  Well, OK.  My execution plan was originally
> devised under the assumption that I'd have 100Mb of sort
> space in memory, but...
> [instance]:  Hey pal!  Take it or leave it!  Someone else just
> took 75Mb, so if you think about it much longer, the
> total amount in use might grow and then I might
> only be able to give you 50% of your request!
> [server process]:  OK! OK!  I'll take it.  (goes off and sadly
> mallocs only 75Mb of sort space in private memory)...
> 
>

RE: Problems creading a Index

[Mercadante, Thomas F]

Teresita,
 
You cannot create a unique 
index on the combination of columns that you listed because there are more than 
one of those type of records.
 
You can see the problem if you 
do the following:
 
select  
distinct COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM, count(*)
from 
OEINVCLINE
group by COMPANY, 
INVC_PREFIX, INVC_NUMBER, ITEM
having count(*) 
> 1
 
This will list 
the records showing you that you have more than one record with that combination 
of columns.  You could create a normal (non-unique) index on those columns 
if that would help you.
 
Good 
Luck
 
Tom 
Mercadante Oracle Certified 
Professional 

  -Original Message-From: Teresita Castro 
  [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 
  2003 3:35 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Problems creading a Index
  HI!!
  I want to create the next index:
   
  CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON 
    "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, 
  ITEM)   TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5  
  STORAGE(INITIAL 40960 )
   
  But I can't because Oracle send me the next 
  error:
   
  The following error has occurred:
   
  ORA-01452: cannot CREATE UNIQUE INDEX; 
  duplicate keys found
   
  I checked on TOAD ( with F4 on the table name) and It give 
  me the next script.
  I don't have an index with the field ITEM on it, so I 
  don't  undestand what I am getting this error.
   
  DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; 
  
   
  CREATE TABLE OEINVCLINE (   
  COMPANY   NUMBER 
  (4)    NOT NULL,   
  INVC_PREFIX   CHAR 
  (2)  NOT NULL,   
  INVC_NUMBER   NUMBER (8)    
  NOT NULL,   
  LINE_NBR  NUMBER 
  (6)    NOT NULL,   
  LINE_TYPE CHAR 
  (1)  NOT NULL,   
  ITEM  
  CHAR (32) NOT NULL,   
  DESCRIPTION   CHAR 
  (30) NOT NULL,   
  ORDER_NBR NUMBER 
  (8)    NOT NULL,   
  SHIPMENT_NBR  NUMBER (10)   NOT NULL, 
    QUANTITY  
  NUMBER (13,4) NOT NULL,   
  INVC_CW_QTY   NUMBER (13,4) NOT NULL, 
    SPR_UOM   
  CHAR (4)  NOT NULL,   
  SELL_UOM  CHAR 
  (4)  NOT NULL,   
  SEC_UOM   CHAR 
  (4)  NOT NULL,   
  MULT_SPR_FL   CHAR 
  (1)  NOT NULL,   
  SPR_TO_STOCK  NUMBER (13,7) NOT NULL,   
  SELL_TO_STOCK NUMBER (13,7) NOT NULL,   
  SEC_UOM_MULT  NUMBER (13,7) NOT NULL,   
  LOCATION  CHAR 
  (5)  NOT NULL,   
  PRICE_STATUS  CHAR 
  (1)  NOT NULL,   
  ENTERED_PRICE NUMBER (13,5) NOT NULL,   
  UNIT_PRICE    NUMBER (13,5) NOT NULL, 
    SELL_PRC_CURR NUMBER (15,7) NOT NULL, 
    SELL_UNIT_PRC NUMBER (15,7) NOT NULL, 
    UNIT_COST NUMBER 
  (13,5) NOT NULL,   CURRENT_COST  NUMBER 
  (13,5) NOT NULL,   NO_CHARGE_FL  CHAR 
  (1)  NOT NULL,   
  ENTERED_DISC  NUMBER (15,2) NOT NULL,   
  ADD_ON_DISC   NUMBER (15,2) NOT NULL, 
    ALLOC_DISC    NUMBER (15,2) 
  NOT NULL,   TAX_EXEMPT_CD CHAR 
  (1)  NOT NULL,   
  TAX_CODE  CHAR 
  (10) NOT NULL,   
  ENT_TAXABLE   NUMBER (15,2) NOT NULL, 
    TAXABLE_BSE   NUMBER (15,2) NOT 
  NULL,   TAX_AMT_CURR  NUMBER (15,2) NOT 
  NULL,   TAX_AMT_BSE   NUMBER (15,2) 
  NOT NULL,   REASON_CODE   CHAR 
  (4)  NOT NULL,   
  DISC_CODE CHAR 
  (10) NOT NULL,   
  ORD_DISC_FL   CHAR 
  (1)  NOT NULL,   
  CONTRACT_NBR  CHAR (14) 
  NOT NULL,   PROMOTION 
  CHAR (10) NOT NULL,   
  ACTIVITY  CHAR 
  (15) NOT NULL,   
  ACCT_CATEGORY CHAR (5)  
  NOT NULL,   ATN_OBJ_ID    
  NUMBER (12)   NOT NULL,   
  ACTIVITY_C    CHAR 
  (15) NOT NULL,   
  ACCT_CATEG_C  CHAR 
  (5)  NOT NULL,   
  ATN_OBJ_ID_C  NUMBER (12)   NOT NULL, 
    FINAL_INVC_FL CHAR 
  (1)  NOT NULL,   
  SLS_ACCT_UNIT CHAR (15) NOT 
  NULL,   SLS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  SLS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   SALES_MAJCL   CHAR 
  (4)  NOT NULL,   
  SALES_MINCL   CHAR 
  (4)  NOT NULL,   
  DSC_AMT_01    NUMBER (15,2) NOT NULL, 
    DSC_AMT_02    NUMBER (15,2) 
  NOT NULL,   DSC_AMT_03    
  NUMBER (15,2) NOT NULL,   DSC_ACCT_UNIT_01  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_02  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_03  CHAR 
  (15) NOT NULL,   
  DSC_ACCOUNT_01    NUMBER (6)    NOT NULL, 
    DSC_ACCOUNT_02    NUMBER (6)    NOT 
  NULL,   DSC_ACCOUNT_03    NUMBER (6)    
  NOT NULL,   DSC_SUB_ACCT_01   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_02   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_03   NUMBER (4)    
  NOT NULL,   DSC_AMT_BASE  NUMBER (15,2) 
  NOT NULL,   OFF_ACCT_UNIT CHAR 
  (15) NOT NULL,   
  OFF_ACCOUNT   NUMBER (6)    
  NOT NULL,   OFF_SUB_ACCT  NUMBER 
  (4)    NOT NULL,   
  CGS_ACCT_UNIT CHAR (15) NOT 
  NULL,   CGS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  CGS_SUB_ACCT  NUMBER (4)    NOT 
  NULL

Re: v$sort_usage

[Daniel Fink]

Looks like a documentation bug. The description exists in the 901 docs but not
in 920 docs. The view still exists in 920.


[EMAIL PROTECTED] wrote:

> List, I am unable to find v$sort_usage in the 9i docs, though this  synonym
> exists.  Any idea why ?
>
> --
> 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).
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

RE: Problems creading a Index

[Odland, Brad]

 the first three items in 
the primary key index is the same as the  first items in your UNIQUE 
index you are trying to make...would be my guess
 
don't make a unique 
index
 
 

  -Original 
  Message-From: Teresita Castro 
  [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 
  2003 2:35 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Problems creading a Index
  HI!!
  I want to create the next index:
   
  CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON 
    "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, 
  ITEM)   TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5  
  STORAGE(INITIAL 40960 )
   
  But I can't because Oracle send me the next 
  error:
   
  The following error has occurred:
   
  ORA-01452: cannot CREATE UNIQUE INDEX; 
  duplicate keys found
   
  I checked on TOAD ( with F4 on the table name) and It give 
  me the next script.
  I don't have an index with the field ITEM on it, so I 
  don't  undestand what I am getting this error.
   
  DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; 
  
   
  CREATE TABLE OEINVCLINE (   
  COMPANY   NUMBER 
  (4)    NOT NULL,   
  INVC_PREFIX   CHAR 
  (2)  NOT NULL,   
  INVC_NUMBER   NUMBER (8)    
  NOT NULL,   
  LINE_NBR  NUMBER 
  (6)    NOT NULL,   
  LINE_TYPE CHAR 
  (1)  NOT NULL,   
  ITEM  
  CHAR (32) NOT NULL,   
  DESCRIPTION   CHAR 
  (30) NOT NULL,   
  ORDER_NBR NUMBER 
  (8)    NOT NULL,   
  SHIPMENT_NBR  NUMBER (10)   NOT NULL, 
    QUANTITY  
  NUMBER (13,4) NOT NULL,   
  INVC_CW_QTY   NUMBER (13,4) NOT NULL, 
    SPR_UOM   
  CHAR (4)  NOT NULL,   
  SELL_UOM  CHAR 
  (4)  NOT NULL,   
  SEC_UOM   CHAR 
  (4)  NOT NULL,   
  MULT_SPR_FL   CHAR 
  (1)  NOT NULL,   
  SPR_TO_STOCK  NUMBER (13,7) NOT NULL,   
  SELL_TO_STOCK NUMBER (13,7) NOT NULL,   
  SEC_UOM_MULT  NUMBER (13,7) NOT NULL,   
  LOCATION  CHAR 
  (5)  NOT NULL,   
  PRICE_STATUS  CHAR 
  (1)  NOT NULL,   
  ENTERED_PRICE NUMBER (13,5) NOT NULL,   
  UNIT_PRICE    NUMBER (13,5) NOT NULL, 
    SELL_PRC_CURR NUMBER (15,7) NOT NULL, 
    SELL_UNIT_PRC NUMBER (15,7) NOT NULL, 
    UNIT_COST NUMBER 
  (13,5) NOT NULL,   CURRENT_COST  NUMBER 
  (13,5) NOT NULL,   NO_CHARGE_FL  CHAR 
  (1)  NOT NULL,   
  ENTERED_DISC  NUMBER (15,2) NOT NULL,   
  ADD_ON_DISC   NUMBER (15,2) NOT NULL, 
    ALLOC_DISC    NUMBER (15,2) 
  NOT NULL,   TAX_EXEMPT_CD CHAR 
  (1)  NOT NULL,   
  TAX_CODE  CHAR 
  (10) NOT NULL,   
  ENT_TAXABLE   NUMBER (15,2) NOT NULL, 
    TAXABLE_BSE   NUMBER (15,2) NOT 
  NULL,   TAX_AMT_CURR  NUMBER (15,2) NOT 
  NULL,   TAX_AMT_BSE   NUMBER (15,2) 
  NOT NULL,   REASON_CODE   CHAR 
  (4)  NOT NULL,   
  DISC_CODE CHAR 
  (10) NOT NULL,   
  ORD_DISC_FL   CHAR 
  (1)  NOT NULL,   
  CONTRACT_NBR  CHAR (14) 
  NOT NULL,   PROMOTION 
  CHAR (10) NOT NULL,   
  ACTIVITY  CHAR 
  (15) NOT NULL,   
  ACCT_CATEGORY CHAR (5)  
  NOT NULL,   ATN_OBJ_ID    
  NUMBER (12)   NOT NULL,   
  ACTIVITY_C    CHAR 
  (15) NOT NULL,   
  ACCT_CATEG_C  CHAR 
  (5)  NOT NULL,   
  ATN_OBJ_ID_C  NUMBER (12)   NOT NULL, 
    FINAL_INVC_FL CHAR 
  (1)  NOT NULL,   
  SLS_ACCT_UNIT CHAR (15) NOT 
  NULL,   SLS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  SLS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   SALES_MAJCL   CHAR 
  (4)  NOT NULL,   
  SALES_MINCL   CHAR 
  (4)  NOT NULL,   
  DSC_AMT_01    NUMBER (15,2) NOT NULL, 
    DSC_AMT_02    NUMBER (15,2) 
  NOT NULL,   DSC_AMT_03    
  NUMBER (15,2) NOT NULL,   DSC_ACCT_UNIT_01  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_02  CHAR 
  (15) NOT NULL,   DSC_ACCT_UNIT_03  CHAR 
  (15) NOT NULL,   
  DSC_ACCOUNT_01    NUMBER (6)    NOT NULL, 
    DSC_ACCOUNT_02    NUMBER (6)    NOT 
  NULL,   DSC_ACCOUNT_03    NUMBER (6)    
  NOT NULL,   DSC_SUB_ACCT_01   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_02   NUMBER (4)    
  NOT NULL,   DSC_SUB_ACCT_03   NUMBER (4)    
  NOT NULL,   DSC_AMT_BASE  NUMBER (15,2) 
  NOT NULL,   OFF_ACCT_UNIT CHAR 
  (15) NOT NULL,   
  OFF_ACCOUNT   NUMBER (6)    
  NOT NULL,   OFF_SUB_ACCT  NUMBER 
  (4)    NOT NULL,   
  CGS_ACCT_UNIT CHAR (15) NOT 
  NULL,   CGS_ACCOUNT   NUMBER 
  (6)    NOT NULL,   
  CGS_SUB_ACCT  NUMBER (4)    NOT 
  NULL,   LAST_MISC_SEQ NUMBER 
  (3)    NOT NULL,   
  LAST_COMM_SEQ NUMBER (3)    NOT NULL, 
    TERRITORY CHAR 
  (4)  NOT NULL,   
  SALESMAN  NUMBER 
  (4)    NOT NULL,   
  SALESMAN_2    NUMBER 
  (4)    NOT NULL,   
  COMM_RATE_1   NUMBER (7,7)  NOT NULL, 
    COMM_RATE_2   NUMBER (7,7)  
  NOT NULL,   COMM_SPLIT    
  NUMBER (5,5)  NOT NULL,   
  USER_FLD1 CHAR 
  (2)  NOT NULL

Re: Last Call for RMOUG Training Days 2004

[Stephane Faroult]

Daniel Fink wrote:
> 
> Today is the last day to submit an abstract for Rocky Mountain
> Oracle User Group Training Days 2004 in sunny and snowy Denver,
> Colorado.
> 
> Last year, we had sessions from oracle-lers Cary, Anjo, Rachel,
> Tim as well as Stephan Haisley, Gary Goodman, Kent Graziano,
> Dave Ensor, Craig Shallahamer and Kevin Loney.
> 
> Don't forget to bring your skis and sunscreen!


And pepper-spray.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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: v$sort_usage

[Mladen Gogala]

Yes. 

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 4:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: v$sort_usage
> 
> 
> List, I am unable to find v$sort_usage in the 9i docs, though 
> this  synonym exists.  Any idea why ?
> 
> -- 
> 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).
> 




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

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

shared_Pool

[bulbultyagi]

List, will the following two queries give the same value for the
shared_Pool-size ?

select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool';

and

show parameter shared_pool_size

I always get a difference , the first one gives a value greater than the
second by 12MB
I tried with different values of shared_pool_size .
What am I doing wrong here ?


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

v$sort_usage

[bulbultyagi]

List, I am unable to find v$sort_usage in the 9i docs, though this  synonym
exists.  Any idea why ?

-- 
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: Last Call for RMOUG Training Days 2004

[Melanie Caffrey]

Uhhh  Dan?

The Website states that the deadline has been extended to Oct. 1st.

Which is more correct?  You or the Website?

Just so I know to turn to a few people here and tell them to hurry up.

Of course, I should probably just do that anyway.  :-)

-Original Message-
Daniel Fink
Sent: Monday, September 29, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L

Today is the last day to submit an abstract for Rocky Mountain
Oracle User Group Training Days 2004 in sunny and snowy Denver,
Colorado.

Last year, we had sessions from oracle-lers Cary, Anjo, Rachel,
Tim as well as Stephan Haisley, Gary Goodman, Kent Graziano,
Dave Ensor, Craig Shallahamer and Kevin Loney.

Don't forget to bring your skis and sunscreen!


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Melanie Caffrey
  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 10g Pricing

[Jonathan Gennick]

Monday, September 29, 2003, 2:44:40 PM, you wrote:
TJ> t the same time, users are being prepared for a new
TJ> list of licensing options that, depending on their clarity, could
TJ> confuse the software market even more. 

Clarity? Fortunately, there won't be any clarity, so no one
need be confused on that point.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

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

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

RE: RE: Using dimensions

[DENNIS WILLIAMS]

Ryan, Stephane

   Here is the way I would put it, based on my admittedly small experience:
 - The in the star schema design, dimension hierarchy gives users a clearer
way to select data. Often in the GUI screen they have pull-down boxes for
the hierarchies.
 - The regularity of the star schema not only allows users to easier access,
but for software tools like Oracle to implement performance features aimed
at the star schema. For example, there is the STAR_TRANSFORMATION hint.
Other Oracle features that are really useful in DW are bitmap indexes,
materialized views, and partitioning. You may not use any of these on your
DW, but if you have a tough performance problem, these can be really useful.

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


-Original Message-
Sent: Monday, September 29, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L


so basically your saying you use dimensions hand in hand with materialized
views. 

do they have other uses? 
> 
> From: "Stephane Paquette" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon PM 02:39:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: Using dimensions
> 
> Using dimensionsI`ve not used dimensions in Oracle only read about them.
> But I have designed DW using dimensional modeling. So from what I've read
in
> the doc, Oracle will used the dimensions to be better at query rewriting
> because it knows the hierarchy of the data (example : neighbourhood, city,
> region, province, country)
> 
> Stephane Paquette
> Administrateur de bases de donnees
> 
> Database Administrator
> 
> Standard Life
> 
> www.standardlife.ca
> 
> Tel. (514) 499-7999 7470 and (514) 925-7187
> 
> [EMAIL PROTECTED]
> 
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
>   Sent: Monday, September 29, 2003 2:20 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Re: RE: Using dimensions
> 
> 
>   Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_
> uses of dimensions ... where does one use them? in SQLs?
> 
>   I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.
> 
>   Thanks
>   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: Scott Canaan [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Using dimensions
> 
> 
> Dimensions are data warehouse constructs.  They are implemented as
> tables in the database, but have the characteristic of a hierarchy that
can
> be traversed.  For example:  a time dimension can have the hierarchy of
> date, day, week, month, quarter, year, decade, century.  This is used for
> rollup reporting within the data mart.  I don't see any good use of it in
an
> OLTP environment, but I may be wrong.
> 
> 
> 
> Scott Canaan ([EMAIL PROTECTED])
> 
> (585) 475-7886
> 
> "Life is like a sewer, what you get out of it depends on what you put
> into it." - Tom Lehrer.
> 
> 
> 
> -Original Message-
> From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Using dimensions
> 
> 
> 
> I have tried, but haven't found a good example of how to _use_ a
> dimension in 9ir2. I defined one, but then sat clueless on what to do with
> it. Is it any good in an OLTP environment? (I smell the answer is a NO,
but
> still) ...
> 
> Any notes from your experience?
> 
> TIA
> 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 !
> 
> 
> 
-- 
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).

Re: Problems creading a Index

[Daniel Fink]

Teresita,
The problem  has nothing to do with existing indexes, but rather
that the combination of the columns is not unique. I don't know Lawson,
so I'm taking a guess, but I think the issue may be that the same
item could appear more than once on an invoice. If you add invoice line
do you have the same error.
Daniel Fink
Teresita Castro wrote:
 HI!!I want
to create the next index: CREATE
UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON
  "LAWSON2".OEINVCLINE(COMPANY,
INVC_PREFIX, INVC_NUMBER, ITEM)
  TABLESPACE LAWSON_PRUEBAS_INDICES
PCTFREE 5  STORAGE(INITIAL 40960 ) But
I can't because Oracle send me the next error: The
following error has occurred: ORA-01452:
cannot CREATE UNIQUE INDEX; duplicate keys found I
checked on TOAD ( with F4 on the table name) and It give me the next script.I
don't have an index with the field ITEM on it, so I don't  undestand
what I am getting this error. DROP TABLE
OEINVCLINE CASCADE CONSTRAINTS ; CREATE
TABLE OEINVCLINE (
  COMPANY  
NUMBER (4)    NOT NULL,
  INVC_PREFIX  
CHAR (2)  NOT NULL,
  INVC_NUMBER  
NUMBER (8)    NOT NULL,
  LINE_NBR 
NUMBER (6)    NOT NULL,
  LINE_TYPE
CHAR (1)  NOT NULL,
  ITEM 
CHAR (32) NOT NULL,
  DESCRIPTION  
CHAR (30) NOT NULL,
  ORDER_NBR
NUMBER (8)    NOT NULL,
  SHIPMENT_NBR 
NUMBER (10)   NOT NULL,
  QUANTITY 
NUMBER (13,4) NOT NULL,
  INVC_CW_QTY  
NUMBER (13,4) NOT NULL,
  SPR_UOM  
CHAR (4)  NOT NULL,
  SELL_UOM 
CHAR (4)  NOT NULL,
  SEC_UOM  
CHAR (4)  NOT NULL,
  MULT_SPR_FL  
CHAR (1)  NOT NULL,
  SPR_TO_STOCK 
NUMBER (13,7) NOT NULL,
  SELL_TO_STOCK
NUMBER (13,7) NOT NULL,
  SEC_UOM_MULT 
NUMBER (13,7) NOT NULL,
  LOCATION 
CHAR (5)  NOT NULL,
  PRICE_STATUS 
CHAR (1)  NOT NULL,
  ENTERED_PRICE
NUMBER (13,5) NOT NULL,
  UNIT_PRICE   
NUMBER (13,5) NOT NULL,
  SELL_PRC_CURR
NUMBER (15,7) NOT NULL,
  SELL_UNIT_PRC
NUMBER (15,7) NOT NULL,
  UNIT_COST
NUMBER (13,5) NOT NULL,
  CURRENT_COST 
NUMBER (13,5) NOT NULL,
  NO_CHARGE_FL 
CHAR (1)  NOT NULL,
  ENTERED_DISC 
NUMBER (15,2) NOT NULL,
  ADD_ON_DISC  
NUMBER (15,2) NOT NULL,
  ALLOC_DISC   
NUMBER (15,2) NOT NULL,
  TAX_EXEMPT_CD
CHAR (1)  NOT NULL,
  TAX_CODE 
CHAR (10) NOT NULL,
  ENT_TAXABLE  
NUMBER (15,2) NOT NULL,
  TAXABLE_BSE  
NUMBER (15,2) NOT NULL,
  TAX_AMT_CURR 
NUMBER (15,2) NOT NULL,
  TAX_AMT_BSE  
NUMBER (15,2) NOT NULL,
  REASON_CODE  
CHAR (4)  NOT NULL,
  DISC_CODE
CHAR (10) NOT NULL,
  ORD_DISC_FL  
CHAR (1)  NOT NULL,
  CONTRACT_NBR 
CHAR (14) NOT NULL,
  PROMOTION
CHAR (10) NOT NULL,
  ACTIVITY 
CHAR (15) NOT NULL,
  ACCT_CATEGORY
CHAR (5)  NOT NULL,
  ATN_OBJ_ID   
NUMBER (12)   NOT NULL,
  ACTIVITY_C   
CHAR (15) NOT NULL,
  ACCT_CATEG_C 
CHAR (5)  NOT NULL,
  ATN_OBJ_ID_C 
NUMBER (12)   NOT NULL,
  FINAL_INVC_FL
CHAR (1)  NOT NULL,
  SLS_ACCT_UNIT
CHAR (15) NOT NULL,
  SLS_ACCOUNT  
NUMBER (6)    NOT NULL,
  SLS_SUB_ACCT 
NUMBER (4)    NOT NULL,
  SALES_MAJCL  
CHAR (4)  NOT NULL,
  SALES_MINCL  
CHAR (4)  NOT NULL,
  DSC_AMT_01   
NUMBER (15,2) NOT NULL,
  DSC_AMT_02   
NUMBER (15,2) NOT NULL,
  DSC_AMT_03   
NUMBER (15,2) NOT NULL,
  DSC_ACCT_UNIT_01  CHAR (15)
NOT NULL,
  DSC_ACCT_UNIT_02  CHAR (15)
NOT NULL,
  DSC_ACCT_UNIT_03  CHAR (15)
NOT NULL,
  DSC_ACCOUNT_01    NUMBER
(6)    NOT NULL,
  DSC_ACCOUNT_02    NUMBER
(6)    NOT NULL,
  DSC_ACCOUNT_03    NUMBER
(6)    NOT NULL,
  DSC_SUB_ACCT_01   NUMBER (4)   
NOT NULL,
  DSC_SUB_ACCT_02   NUMBER (4)   
NOT NULL,
  DSC_SUB_ACCT_03   NUMBER (4)   
NOT NULL,
  DSC_AMT_BASE 
NUMBER (15,2) NOT NULL,
  OFF_ACCT_UNIT
CHAR (15) NOT NULL,
  OFF_ACCOUNT  
NUMBER (6)    NOT NULL,
  OFF_SUB_ACCT 
NUMBER (4)    NOT NULL,
  CGS_ACCT_UNIT
CHAR (15) NOT NULL,
  CGS_ACCOUNT  
NUMBER (6)    NOT NULL,
  CGS_SUB_ACCT 
NUMBER (4)    NOT NULL,
  LAST_MISC_SEQ
NUMBER (3)    NOT NULL,
  LAST_COMM_SEQ
NUMBER (3)    NOT NULL,
  TERRITORY
CHAR (4)  NOT NULL,
  SALESMAN 
NUMBER (4)    NOT NULL,
  SALESMAN_2   
NUMBER (4)    NOT NULL,
  COMM_RATE_1  
NUMBER (7,7)  NOT NULL,
  COMM_RATE_2  
NUMBER (7,7)  NOT NULL,
  COMM_SPLIT   
NUMBER (5,5)  NOT NULL,
  USER_FLD1
CHAR (2)  NOT NULL,
  USER_FLD2
CHAR (30) NOT NULL,
  USER_FLD3
CHAR (15) NOT NULL,
  LINE_GRS_CURR
NUMBER (15,2) NOT NULL,
  INVL_OBJ_ID  
NUMBER (12)   NOT NULL,
  PROD_TAX_CAT 
CHAR (15) NOT NULL,
  LINE_GRS_BASE
NUMBER (15,2) NOT NULL,
  OILSET2_SS_SW
CHAR (1)  NOT NULL,
  OILSET3_SS_SW
CHAR (1)  NOT NULL,
  OILSET4_SS_SW
CHAR (1)  NOT NULL,
  CONSTRAINT OILSET1
  PRIMARY KEY ( COMPANY, INVC_PREFIX, INVC_NUMBER,
LINE_

RE: Using dimensions

[DENNIS WILLIAMS]

Raj - There is some melding of DW and OLTP environments at some sites today.
Most DW's are separate environments with data extracted from the OLTP on a
regular batch schedule. But it is possible to have a combined environment
that satisfies both requirements, especially if you are starting from
scratch and not trying to add DW to an existing system. If your users
require "real-time" DW queries, this may be a better alternative.
 The biggest problem I've heard is the Oracle buffer cache. After it has
been running awhile the OLTP buffers will tend to hold the hot blocks. By
definition, a DW doesn't have hot blocks, so if both OLTP and DW share the
same instance, the DW will tend to mess up the buffer cache for OLTP, so
OLTP performance will suffer. Of course, a combination schema design may
satisfy nobody, but we DBAs are used to dealing with unhappy people.



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

-Original Message-
Sent: Monday, September 29, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L



Thanks Dennis ... 

We have "a" group who design their application as if this is a DW
environment, so I thought learning this stuff might be beneficial for "me".

I'll check it out. 
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: Monday, September 29, 2003 2:25 PM 
To: Multiple recipients of list ORACLE-L 


Raj - Actually a good place to start is the Oracle9i Data Warehousing Guide 
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical
 . 
htm#97703 
<
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical
  
.htm#97703> 
I think it is important for all Oracle DBAs to understand the fundamental 
concepts behind DW. You never know when you'll get yanked into a meeting 
where they are discussing it and you don't want to say something Neanderthal

like "of course we'll fully normalize the schema". Ralph Kimball has some 
good materials on his web site: http://www.ralphkimball.com
  
< http://www.ralphkimball.com  >  

Dennis Williams 

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

RE: x$ constructs and memory

[Mladen Gogala]

You are right. This is what has confused my script, as taken from SQL.BSQ:

create table kottbx$ of kottbx  /* additional type table
*/
  oid '00010042'
/

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of K Gopalakrishnan
> Sent: Monday, September 29, 2003 3:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: x$ constructs and memory
> 
> 
> Mladen:
> 
> I hope you are not kidding.. X$ table (!) definitions are 
> defined in the source code and you can not 
> create/update/delete them. However there are some 
> undocumented procudures , thru which you can reset certain tables.
> 
> Regards,
> Gopal
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, September 29, 2003 11:54 PM
> 
> 
> > With all due respect, I don't believe that it is a fixed 
> area. You can 
> > create X$ tables by running certain catalog scripts. I believe that 
> > the description of X$ tables is located logically close to the 
> > description of the data dictionary, which would mean shared 
> pool, not 
> > the fixed one. Now, can we get back to bears?
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> >
> >
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf 
> > > Of Tanel Poder
> > > Sent: Monday, September 29, 2003 1:45 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: x$ constructs and memory
> > >
> > >
> > > >What I have not checked so far is how an ALTER SYSTEM
> > > increasing a
> > > parameter affects the SGA. In practice it's a realloc() 
> > > (functionally speaking). It would seem reasonable to me to have a 
> > > shared memory segment to hold all parameters which can by 
> > > dynamically changed. I wouldn't touch it if parameters are 
> > > decreased, but I would have to realloc it in case of a massive 
> > > increase. Hmm, I guess that I would allow some spare memory 
> > > initially, performance penalty would otherwise be severe. 
> Which all 
> > > makes the 10g dynamic rearrangement quite sensible ...
> > >
> > > Hi!
> > >
> > > I think the behaviour depends on which parameter you are 
> changing. 
> > > If you're changing shared_pool_size to higher size, then just 
> > > additional extents of memory are allocated and heap header is 
> > > updated. If you set sort_area_size higher, nothing particular 
> > > happens, except some maximum is increased in UGA I believe and 
> > > during next sort you can go up to that limit. Some 
> parameters like 
> > > enqueue_resources can't be changed in the fly, because they are 
> > > fixed, they stay in fixed area of SGA, fixed area isn't 
> managed as 
> > > heap as I understand, it does not have any free or LRU lists, 
> > > because it's physical structure remains unchanged during the 
> > > lifetime of an instance.
> > >
> > > Tanel.
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Tanel Poder
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 
> http://www.fatcity.com
> > > San Diego, California-- Mailing list and web 
> hosting services
> > > 
> 
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > > and in the message BODY, include a line containing: UNSUB
> > > ORACLE-L (or the name of mailing list you want to be removed
> > > from).  You may also send the HELP command for other
> > > information (like subscribing).
> > >
> >
> >
> >
> >
> > Note:
> > This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  
> No confidentiality or privilege is waived or lost by any 
> mistransmission.  If you receive this message in error, 
> please immediately delete it and all copies of it from your 
> system, destroy any hard copies of it and notify the sender.  
> You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you 
> are not the intended recipient. Wang Trading LLC and any of 
> its subsidiaries each reserve the right to monitor all e-mail 
> communications through its networks.
> > Any views expressed in this message are those of the individual 
> > sender,
> except where the message states otherwise and the sender is 
> authorized to state them to be the views of any such entity.
> >
> > --
> > 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
> > 
> ---

RE: RE: Using dimensions

[rgaffuri]

so basically your saying you use dimensions hand in hand with materialized views. 

do they have other uses? 
> 
> From: "Stephane Paquette" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon PM 02:39:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: Using dimensions
> 
> Using dimensionsI`ve not used dimensions in Oracle only read about them.
> But I have designed DW using dimensional modeling. So from what I've read in
> the doc, Oracle will used the dimensions to be better at query rewriting
> because it knows the hierarchy of the data (example : neighbourhood, city,
> region, province, country)
> 
> Stephane Paquette
> Administrateur de bases de donnees
> 
> Database Administrator
> 
> Standard Life
> 
> www.standardlife.ca
> 
> Tel. (514) 499-7999 7470 and (514) 925-7187
> 
> [EMAIL PROTECTED]
> 
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
>   Sent: Monday, September 29, 2003 2:20 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Re: RE: Using dimensions
> 
> 
>   Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_
> uses of dimensions ... where does one use them? in SQLs?
> 
>   I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.
> 
>   Thanks
>   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: Scott Canaan [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Using dimensions
> 
> 
> Dimensions are data warehouse constructs.  They are implemented as
> tables in the database, but have the characteristic of a hierarchy that can
> be traversed.  For example:  a time dimension can have the hierarchy of
> date, day, week, month, quarter, year, decade, century.  This is used for
> rollup reporting within the data mart.  I don't see any good use of it in an
> OLTP environment, but I may be wrong.
> 
> 
> 
> Scott Canaan ([EMAIL PROTECTED])
> 
> (585) 475-7886
> 
> "Life is like a sewer, what you get out of it depends on what you put
> into it." - Tom Lehrer.
> 
> 
> 
> -Original Message-
> From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Using dimensions
> 
> 
> 
> I have tried, but haven't found a good example of how to _use_ a
> dimension in 9ir2. I defined one, but then sat clueless on what to do with
> it. Is it any good in an OLTP environment? (I smell the answer is a NO, but
> still) ...
> 
> Any notes from your experience?
> 
> TIA
> 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 !
> 
> 
> 
Title: Using dimensions



I`ve 
not used dimensions in Oracle only read about them. 
But I 
have designed DW using dimensional modeling. So from what I've read in the doc, 
Oracle will used the dimensions to be better at query rewriting because it 
knows the hierarchy of the data (example : neighbourhood, city, region, 
province, country)
 



Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Monday, September 29, 2003 2:20 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  RE: Using dimensions
  Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ 
  uses of dimensions ... where does one use them? in SQLs? 
   
  I have scanned TFM, but haven't STFW'd yet ... scared of too many 
  hits.
   
  Thanks
  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: Scott Canaan 
[mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Using dimensions

Dimensions are data 
warehouse constructs.  They are implemented as tables in the database, 
but have the characteristic of a hierarchy that can be traversed.  For 
example:  a time dimension can have the hierarchy of date, day, week, 
month, quarter, year, decade, century.  This is used for 

Re: RE: x$ constructs and memory

[rgaffuri]

i think there are memory structurse that oracle isnt telling us about. wouldnt 
surprise me if the x$ tables are stored in some place that is not documented. 
> 
> From: "Mladen Gogala" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon PM 02:24:46 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: x$ constructs and memory
> 
> With all due respect, I don't believe that it is a fixed area.
> You can create X$ tables by running certain catalog scripts. I believe
> that the description of X$ tables is located logically close to the
> description of the data dictionary, which would mean shared pool, not
> the fixed one. Now, can we get back to bears?
> 
> --
> Mladen Gogala
> Oracle DBA 
> 
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> > Behalf Of Tanel Poder
> > Sent: Monday, September 29, 2003 1:45 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: x$ constructs and memory
> > 
> > 
> > >What I have not checked so far is how an ALTER SYSTEM 
> > increasing a
> > parameter affects the SGA. In practice it's a realloc() 
> > (functionally speaking). It would seem reasonable to me to 
> > have a shared memory segment to hold all parameters which can 
> > by dynamically changed. I wouldn't touch it if parameters are 
> > decreased, but I would have to realloc it in case of a 
> > massive increase. Hmm, I guess that I would allow some spare 
> > memory initially, performance penalty would otherwise be 
> > severe. Which all makes the 10g dynamic rearrangement quite 
> > sensible ...
> > 
> > Hi!
> > 
> > I think the behaviour depends on which parameter you are 
> > changing. If you're changing shared_pool_size to higher size, 
> > then just additional extents of memory are allocated and heap 
> > header is updated. If you set sort_area_size higher, nothing 
> > particular happens, except some maximum is increased in UGA I 
> > believe and during next sort you can go up to that limit. 
> > Some parameters like enqueue_resources can't be changed in 
> > the fly, because they are fixed, they stay in fixed area of 
> > SGA, fixed area isn't managed as heap as I understand, it 
> > does not have any free or LRU lists, because it's physical 
> > structure remains unchanged during the lifetime of an instance.
> > 
> > Tanel.
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Tanel Poder
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> > and in the message BODY, include a line containing: UNSUB 
> > ORACLE-L (or the name of mailing list you want to be removed 
> > from).  You may also send the HELP command for other 
> > information (like subscribing).
> > 
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain confidential, 
> proprietary or legally privileged information.  No confidentiality or privilege is 
> waived or lost by any mistransmission.  If you receive this message in error, please 
> immediately delete it and all copies of it from your system, destroy any hard copies 
> of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you are not the intended 
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
> monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to state them to be the 
> views of any such entity.
> 
> -- 
> 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 ma

Last Call for RMOUG Training Days 2004

[Daniel Fink]

Today is the last day to submit an abstract for Rocky Mountain
Oracle User Group Training Days 2004 in sunny and snowy Denver,
Colorado.

Last year, we had sessions from oracle-lers Cary, Anjo, Rachel,
Tim as well as Stephan Haisley, Gary Goodman, Kent Graziano,
Dave Ensor, Craig Shallahamer and Kevin Loney.

Don't forget to bring your skis and sunscreen!

begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

RE: oracle newsgroup

[DENNIS WILLIAMS]

AK - A simple way to get started is to just surf over to
http://groups.google.com   You don't have to
hassle with installing anything or arguing with your network people. You
could try it and then if you find the groups are useful, then you might find
one of the other suggested solutions worth implementing.



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

-Original Message-
Sent: Monday, September 29, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


How to one subcribe to Comp.database.oracle newsgroup .  Can it be added
into outlook directly . 
 
thanks,
-ak
 

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

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

Problems creading a Index

[Teresita Castro]

HI!!
I want to create the next index:
 
CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON 
  "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, 
ITEM)   TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5  
STORAGE(INITIAL 40960 )
 
But I can't because Oracle send me the next 
error:
 
The following error has occurred:
 
ORA-01452: cannot CREATE UNIQUE INDEX; 
duplicate keys found
 
I checked on TOAD ( with F4 on the table name) and It give me 
the next script.
I don't have an index with the field ITEM on it, so I 
don't  undestand what I am getting this error.
 
DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; 

 
CREATE TABLE OEINVCLINE (   
COMPANY   NUMBER 
(4)    NOT NULL,   
INVC_PREFIX   CHAR 
(2)  NOT NULL,   
INVC_NUMBER   NUMBER (8)    NOT 
NULL,   LINE_NBR  
NUMBER (6)    NOT NULL,   
LINE_TYPE CHAR 
(1)  NOT NULL,   
ITEM  
CHAR (32) NOT NULL,   
DESCRIPTION   CHAR 
(30) NOT NULL,   
ORDER_NBR NUMBER 
(8)    NOT NULL,   
SHIPMENT_NBR  NUMBER (10)   NOT NULL, 
  QUANTITY  NUMBER 
(13,4) NOT NULL,   INVC_CW_QTY   
NUMBER (13,4) NOT NULL,   
SPR_UOM   CHAR 
(4)  NOT NULL,   
SELL_UOM  CHAR 
(4)  NOT NULL,   
SEC_UOM   CHAR 
(4)  NOT NULL,   
MULT_SPR_FL   CHAR 
(1)  NOT NULL,   
SPR_TO_STOCK  NUMBER (13,7) NOT NULL,   
SELL_TO_STOCK NUMBER (13,7) NOT NULL,   
SEC_UOM_MULT  NUMBER (13,7) NOT NULL,   
LOCATION  CHAR 
(5)  NOT NULL,   
PRICE_STATUS  CHAR 
(1)  NOT NULL,   
ENTERED_PRICE NUMBER (13,5) NOT NULL,   
UNIT_PRICE    NUMBER (13,5) NOT NULL, 
  SELL_PRC_CURR NUMBER (15,7) NOT NULL, 
  SELL_UNIT_PRC NUMBER (15,7) NOT NULL, 
  UNIT_COST NUMBER 
(13,5) NOT NULL,   CURRENT_COST  NUMBER 
(13,5) NOT NULL,   NO_CHARGE_FL  CHAR 
(1)  NOT NULL,   
ENTERED_DISC  NUMBER (15,2) NOT NULL,   
ADD_ON_DISC   NUMBER (15,2) NOT NULL, 
  ALLOC_DISC    NUMBER (15,2) 
NOT NULL,   TAX_EXEMPT_CD CHAR 
(1)  NOT NULL,   
TAX_CODE  CHAR 
(10) NOT NULL,   
ENT_TAXABLE   NUMBER (15,2) NOT NULL, 
  TAXABLE_BSE   NUMBER (15,2) NOT 
NULL,   TAX_AMT_CURR  NUMBER (15,2) NOT 
NULL,   TAX_AMT_BSE   NUMBER (15,2) 
NOT NULL,   REASON_CODE   CHAR 
(4)  NOT NULL,   
DISC_CODE CHAR 
(10) NOT NULL,   
ORD_DISC_FL   CHAR 
(1)  NOT NULL,   
CONTRACT_NBR  CHAR (14) NOT 
NULL,   PROMOTION CHAR 
(10) NOT NULL,   
ACTIVITY  CHAR 
(15) NOT NULL,   
ACCT_CATEGORY CHAR (5)  NOT 
NULL,   ATN_OBJ_ID    NUMBER 
(12)   NOT NULL,   
ACTIVITY_C    CHAR 
(15) NOT NULL,   
ACCT_CATEG_C  CHAR 
(5)  NOT NULL,   
ATN_OBJ_ID_C  NUMBER (12)   NOT NULL, 
  FINAL_INVC_FL CHAR 
(1)  NOT NULL,   
SLS_ACCT_UNIT CHAR (15) NOT 
NULL,   SLS_ACCOUNT   NUMBER 
(6)    NOT NULL,   
SLS_SUB_ACCT  NUMBER (4)    NOT 
NULL,   SALES_MAJCL   CHAR 
(4)  NOT NULL,   
SALES_MINCL   CHAR 
(4)  NOT NULL,   
DSC_AMT_01    NUMBER (15,2) NOT NULL, 
  DSC_AMT_02    NUMBER (15,2) 
NOT NULL,   DSC_AMT_03    NUMBER 
(15,2) NOT NULL,   DSC_ACCT_UNIT_01  CHAR 
(15) NOT NULL,   DSC_ACCT_UNIT_02  CHAR 
(15) NOT NULL,   DSC_ACCT_UNIT_03  CHAR 
(15) NOT NULL,   
DSC_ACCOUNT_01    NUMBER (6)    NOT NULL, 
  DSC_ACCOUNT_02    NUMBER (6)    NOT 
NULL,   DSC_ACCOUNT_03    NUMBER (6)    
NOT NULL,   DSC_SUB_ACCT_01   NUMBER (4)    
NOT NULL,   DSC_SUB_ACCT_02   NUMBER (4)    
NOT NULL,   DSC_SUB_ACCT_03   NUMBER (4)    
NOT NULL,   DSC_AMT_BASE  NUMBER (15,2) 
NOT NULL,   OFF_ACCT_UNIT CHAR 
(15) NOT NULL,   
OFF_ACCOUNT   NUMBER (6)    NOT 
NULL,   OFF_SUB_ACCT  NUMBER 
(4)    NOT NULL,   CGS_ACCT_UNIT 
CHAR (15) NOT NULL,   
CGS_ACCOUNT   NUMBER (6)    NOT 
NULL,   CGS_SUB_ACCT  NUMBER 
(4)    NOT NULL,   LAST_MISC_SEQ 
NUMBER (3)    NOT NULL,   
LAST_COMM_SEQ NUMBER (3)    NOT NULL, 
  TERRITORY CHAR 
(4)  NOT NULL,   
SALESMAN  NUMBER 
(4)    NOT NULL,   
SALESMAN_2    NUMBER 
(4)    NOT NULL,   
COMM_RATE_1   NUMBER (7,7)  NOT NULL, 
  COMM_RATE_2   NUMBER (7,7)  
NOT NULL,   COMM_SPLIT    NUMBER 
(5,5)  NOT NULL,   
USER_FLD1 CHAR 
(2)  NOT NULL,   
USER_FLD2 CHAR 
(30) NOT NULL,   
USER_FLD3 CHAR 
(15) NOT NULL,   
LINE_GRS_CURR NUMBER (15,2) NOT NULL,   
INVL_OBJ_ID   NUMBER (12)   NOT 
NULL,   PROD_TAX_CAT  CHAR 
(15) NOT NULL,   
LINE_GRS_BASE NUMBER (15,2) NOT NULL,   
OILSET2_SS_SW CHAR (1)  NOT 
NULL,   OILSET3_SS_SW CHAR 
(1)  NOT NULL,   
OILSET4_SS_SW CHAR (1)  NOT 
NULL,   CONSTRAINT OILSET1  PRIMARY KEY ( COMPANY, 
INVC_PREFIX, INVC_NUMBER, LINE_NBR )     USING INDEX 
 TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 
5 STORAGE ( INITIAL 40960 ))   
TABLESPACE LAWSON_PRUEBAS_DATOS   PCTFREE 5   
PCTUSED 94   INITRANS 1   MAXTRANS 25

Re: x$ constructs and memory

[K Gopalakrishnan]

Mladen:

I hope you are not kidding.. X$ table (!) definitions are defined in the
source
code and you can not create/update/delete them. However there are some
undocumented procudures , thru which you can reset certain tables.

Regards,
Gopal

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 11:54 PM


> With all due respect, I don't believe that it is a fixed area.
> You can create X$ tables by running certain catalog scripts. I believe
> that the description of X$ tables is located logically close to the
> description of the data dictionary, which would mean shared pool, not
> the fixed one. Now, can we get back to bears?
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > Behalf Of Tanel Poder
> > Sent: Monday, September 29, 2003 1:45 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: x$ constructs and memory
> >
> >
> > >What I have not checked so far is how an ALTER SYSTEM
> > increasing a
> > parameter affects the SGA. In practice it's a realloc()
> > (functionally speaking). It would seem reasonable to me to
> > have a shared memory segment to hold all parameters which can
> > by dynamically changed. I wouldn't touch it if parameters are
> > decreased, but I would have to realloc it in case of a
> > massive increase. Hmm, I guess that I would allow some spare
> > memory initially, performance penalty would otherwise be
> > severe. Which all makes the 10g dynamic rearrangement quite
> > sensible ...
> >
> > Hi!
> >
> > I think the behaviour depends on which parameter you are
> > changing. If you're changing shared_pool_size to higher size,
> > then just additional extents of memory are allocated and heap
> > header is updated. If you set sort_area_size higher, nothing
> > particular happens, except some maximum is increased in UGA I
> > believe and during next sort you can go up to that limit.
> > Some parameters like enqueue_resources can't be changed in
> > the fly, because they are fixed, they stay in fixed area of
> > SGA, fixed area isn't managed as heap as I understand, it
> > does not have any free or LRU lists, because it's physical
> > structure remains unchanged during the lifetime of an instance.
> >
> > Tanel.
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Tanel Poder
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the message BODY, include a line containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to be removed
> > from).  You may also send the HELP command for other
> > information (like subscribing).
> >
>
>
>
>
> Note:
> This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
>
> -- 
> 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: K Gopalakrishnan
  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 

RE: 10G

[Pete Sharman]

Yes, I know for sure.  :)

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Jerome Roa
Sent: Tuesday, September 30, 2003 5:05 AM
To: Multiple recipients of list ORACLE-L


Does anybody know FOR SURE whether 10G will be available on 32 and/or 64
bit? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jerome Roa
  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: Pete Sharman
  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 newsgroup

[Todd Boss]

Two options you can look into:

- read and post via groups.google.com.  I post this way using a "fake"
yahoo account that i never check.  Be warned; posting to a newsgroup 
causes open season on your email address for spam.  

- if your isp doesn't have a newsfeed, you can get a free account
around the net.  I happened across news.cis.dfn.de, which allows
people to get news fed from their server after registration.
I subscribe and read news from their feed through Netscape Messenger.

Hope this helps, Todd

> 
> This is a multi-part message in MIME format.
> 
> --_=_NextPart_001_01C386B1.9DAE7AEB
> Content-Type: text/plain;
>   charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> You can access it through the Outlook Newsreader via the Tools menu on
> IE but... you have to have DNS/ISP set up for it and most companies
> don't give carte blanche to news because of all the other junk out
> there. ;-)
> 
>   -Original Message-
>   From: AK [mailto:[EMAIL PROTECTED]
>   Sent: Monday, September 29, 2003 12:35 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: oracle newsgroup
> =09
> =09
>   How to one subcribe to Comp.database.oracle newsgroup .  Can it
> be added into outlook directly .=20
>   =20
>   thanks,
>   -ak
>   =20
> 
> 
> --_=_NextPart_001_01C386B1.9DAE7AEB
> Content-Type: text/html;
>   charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> 
> Message
>  charset=3Dus-ascii">
> 
> 
> 
> 
>  size=3D2>You=20
> can access it through the Outlook Newsreader via the Tools menu on IE =
> but... you=20
> have to have DNS/ISP set up for it and most companies don't give carte =
> blanche=20
> to news because of all the other junk out there. ;-)
> 
>   
>align=3Dleft>   face=3DTahoma size=3D2>-Original Message-From: AK=20
>   [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, =
> 2003=20
>   12:35 PMTo: Multiple recipients of list =
> ORACLE-LSubject:=20
>   oracle newsgroup
>   How to one subcribe to=20
>   Comp.database.oracle newsgroup .  Can it be added =
> into=20
>   outlook directly . 
>    
>   thanks,
>   -ak
>size=3D2> 
> =00
> --_=_NextPart_001_01C386B1.9DAE7AEB--
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   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: Todd Boss
  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).

Describe privilege on procedures & packages

[Gary Jackson]

Hello,
 I wanted to give another user access to view my procedures & packages 
(just DESC capability), but it seems that the only way for him to be able to 
DESC them is for me to grant execute.  Is this correct?? (I guess I have 
never had this situation before, it just seems surprising if there is no way 
to grant a read-only privilege).

Thanks!
-Fred S.
_
Share your photos without swamping your Inbox.  Get Hotmail Extra Storage 
today! http://join.msn.com/?PAGE=features/es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Jackson
 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 newsgroup

[Mladen Gogala]

Title: Message



Plus, 
Forte Agent  and Gravity are much better choices to read news then the 
obfuscator express (OE).
http://www.newsville.com/support/Free_Agent/
http://more-news-groups.com//gravity.htm
http://pan.rebelbase.com/ (the best 
one)
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, 
  SteveSent: Monday, September 29, 2003 2:50 PMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: oracle 
  newsgroup
  You 
  can access it through the Outlook Newsreader via the Tools menu on IE but... 
  you have to have DNS/ISP set up for it and most companies don't give carte 
  blanche to news because of all the other junk out there. 
  ;-)
  

-Original Message-From: AK 
[mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 
12:35 PMTo: Multiple recipients of list 
ORACLE-LSubject: oracle newsgroup
How to one subcribe to 
Comp.database.oracle newsgroup .  Can it be added into 
outlook directly . 
 
thanks,
-ak
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

10G

[Jerome Roa]

Does anybody know FOR SURE whether 10G will be available on 32 and/or 64 bit? 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jerome Roa
 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: Solaris /etc/system values for Oracle8i

[Steve McClure]

Just wanted to jump in a bit here.  I have 4 oracle instances running on a
solaris box with 2GB of RAM.  My available memory hovers at a little more
than 1 GB free.  Swap size isn't really a factor, unless you are actively
swapping, which we are not.  Now granted the largest of these instances has
a SGA footprint of about 200MB.  While we are not talking about large
databases, I think I could easily drop 4 more smallish DBs out there.  Now I
admit, that if I needed to do this this, I would also request additional
memory, but that is just my nature, not a real requirement.  oh and since
you did ask about swap size in Tanel's case, our swap slice is 2GB we rarely
use more than 500MB of swap.


Steve McClure

-Original Message-
[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 7:35 AM
To: Multiple recipients of list ORACLE-L



Tanel:

How large is the swap file?  For Oracle usage, maximum memory settings in
the /etc/system file are based on total memory available, or REAL memory.
This would be physical memory + swap file space (virtual memory). So, with
1GB of physical memory, and an equal amount or more of swap space, you
could run it the way you have configured it.





Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]





tanel.poder.00
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]   Subject: Re: Solaris
/etc/system values for Oracle8i
ity.com


09/28/2003
08:29 PM
Please respond
to ORACLE-L






Yep, I have development and even small production 8i instances which take
only about 100MB of memory (SGA, listener, dispatcher, shared servers).

Tanel.

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


> I've a customer running a development environment of two OraApps 11.5.8
> database instances and one more database instance (for web development
under
> WebLogic), all on a Sun V100.
>
> Yes, that is a rack-mountable Solaris machine of 1U rack height with a
> maximum configuration of one (1) UltraSPARC-III CPU, 1.0 Gb of RAM, and
> three 36-Gb HDD.  Main storage is a NAS (since the machine doesn't
> accommodate SCSI or FC adapters).
>
> Foolishly underconfigured, yes.  Impossible or difficult, no.
>
>
>
> on 9/27/03 7:54 AM, Tanel Poder at [EMAIL PROTECTED] wrote:
>
> > What the heck was that?
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Saturday, September 27, 2003 2:54 AM
> >
> >
> >>
> >> Mario:
> >>
> >> If you are using Solaris with 2GB of memory, it will be awfully
difficult,
> >> if not impossible, to run 6 instances of Oracle8i simultaneously.
> >> Basically, because of the use of semaphores and the way Solaris
manages
> >> memory, I would say you could run 3 or 4 instances , depending on
their
> >> size.  But to have all six up and running, especially if you have to
> > create
> >> them, will not work.  Oracle usually needs 1 GB per instance while you
are
> >> creating a database.  While running it, you would not necessarily need
> > that
> >> much.  I advice you to upgrade the memory on the server to 8 GB. I
suggest
> >> you budget 1 GB per Oracle instance.
> >>
> >> RWB
> >>
> >>
> >


> > 
> >>
> >> Reginald W. Bailey
> >> IBM Global Services - ETS SW GDSD - Database Management
> >> Your Friendly Neighborhood DBA
> >> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> >> [EMAIL PROTECTED]
> >> [EMAIL PROTECTED]
> >>
> >


> > 
> >>
> >>
> >>
> >> [EMAIL PROTECTED]
> >> .xerox.com To:
> > [EMAIL PROTECTED]
> >> Sent by:   cc:
> >> [EMAIL PROTECTED]   Subject: Solaris
> > /etc/system values for Oracle8i
> >> m
> >>
> >>
> >> 09/26/2003 06:19 PM
> >> Please respond to
> >> ORACLE-L
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>>   Hi managers.
> >>>
> >>>   I need modify /etc/systems parameters in my e450 box, it allow 6
> >> instances
> >>> for oracle 8i
> >>>
> >>>Box have 2 GB in RAM
> >>>
> >>>Next value

RE: Estimating space needed for UNDO tablespaces

[Thomas Jeff]

Kirti,

Thanks for this information.I've implemented AUM in a number of our
development
databases.One of the things I have to do is write up a monitoring policy
to hand
to our contracted production DBAs -- guidelines on how to address certain
scenarios
and so forth -- otherwise, they will simply resort to adding 'more' of
whatever they
presume is in short supply in event of a production crisis.

For example, I'm seeing some steal counts in v$undostat, implying that the
undo
tablespace needs more space.   However, from what you are saying, it seems
that if
undo_retention is consistently larger then maxquerylen during the period of
time when 
the steal counts occur, that maybe the smarter thing to do is simply reduce
the 
undo_retention parameter before considering adding more space?


Jeff



-Original Message-
Sent: Friday, September 26, 2003 11:50 PM
To: Multiple recipients of list ORACLE-L


You can run following query to get an idea of undo generation rate and max
query length: 

SELECT 
  to_char(min(begin_time),'MM/DD/ HH24:MI:SS') "Begin Time",
  to_char(max(end_time),'MM/DD/ HH24:MI:SS') "End Time",
  (max(end_time)-min(begin_time))*24*60*60 "Seconds",
  sum(undoblks) "UndoBlks",
  sum(undoblks)/((max(end_time)-min(begin_time))*24*60*60)
"UndoBlksPerSec",
  max(maxquerylen) "MaxQueryLenSecs"
 FROM 
v$undostat;

Unfortunately, the TXNCOUNT column in v$undostat view in Oracle 9.2.0.x is
screwed up. It does not
correctly report the transaction count for the sample interval. Instead it
keeps accumulating. One
needs to do the math to get the correct count for the desired sample
interval. It will show the
time of high transaction activity with related undo generation.

Oracle recommends setting undo_retention to the max(maxquerylen), but use
your judgement. If data
loads and queries accessing same tables, do not run at the same time (in DW,
for example), setting
undo_retention to a high number (maxquerylen) will simply waste disk space. 

If undo_retention is not set appropriately, you will get ORA-1555, and it
will be reported in
alert.log along with the affected SQL statement. The log entry will also
contain the query time,
in seconds, before it got aborted due to ORA-1555. 

Also, the above query works only when the database is using AUM. V$undostat
does not report
anything in 9.2.0.x when using MUM (manual undo mode). In 9.0.1, it returns
one useless row when
using MUM! 

BTW, you can also use the OEM to see the undo generation rate. It is one of
the few things in OEM
(standalone mode) I use. 


Hth. 

- Kirti 



--- Daniel Fink <[EMAIL PROTECTED]> wrote:
> That sounds very reasonable. You can check that number against the values
in
> v$undostat as it runs. Remember, UNDO_RETENTION is not guaranteed. If the
> space is needed by another segment, it may be taken even if the expire
time
> has not been reached.
> 
> Daniel
> 
> Thomas Jeff wrote:
> 
> > Thanks for the reply Dan.
> >
> > Would you suggest setting UNDO_RETENTION to roughly the length of time
of
> > the longest
> > running job in the database?   For example, in our DW, our BI analysts
tell
> > me that their
> > longest batch run is about 1 hr 45 minutes.   My uneducated guess is to
> > accordingly
> > set the parameter to approx 2 hours.
> >
> > -Original Message-
> > Sent: Friday, September 26, 2003 4:15 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > That is a good place to start. You might consider adding a little if you
> > have many concurrent transactions or want to increase the undo_retention
> > to a high number. Once you are using AUM, keep a close eye on
> > v$undostat, though there are some known issues with it not populating
> > properly, keep an eye on the begin_time and end_time. However, for
> > estimation purposes it should work.
> >
> > Daniel Fink
> >
> > Thomas Jeff wrote:
> >
> > > I'm beginning the process of converting over to automatic
> > > undo management.  I'm wondering as to exactly how large to
> > > initially build the UNDO tablespace.Make it roughly
> > > the same size as the sum of the current rollback
> > > tablespaces?Or has your experience been different,
> > > i.e., you've found you've generally needed more or less
> > > space with respect to the previous allocation for rollback
> > > segments (manual undo)?
> > >
> > > Thanks.
> > >
> > > 
> > > Jeffery D Thomas
> > > DBA
> > > Thomson Information Services
> > > Thomson, Inc.
> > >
>


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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

RE: oracle newsgroup

[Orr, Steve]

Title: Message



You 
can access it through the Outlook Newsreader via the Tools menu on IE but... you 
have to have DNS/ISP set up for it and most companies don't give carte blanche 
to news because of all the other junk out there. ;-)

  
  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 
  12:35 PMTo: Multiple recipients of list ORACLE-LSubject: 
  oracle newsgroup
  How to one subcribe to 
  Comp.database.oracle newsgroup .  Can it be added into 
  outlook directly . 
   
  thanks,
  -ak
   

Oracle 10g Pricing

[Tony Johnson]

... or lack thereof. I saw this AM that now pricing will now not be out on 10g til 
late October.

Gee, Larry .. I thought we were supposed to get this 2 weeks ago.



ORACLE SILENT ON 10G COSTS | VNunet
It looks as if Oracle Corp. will not announce its pricing strategy
for its 10g database and application server products until they ship
in late October. At the same time, users are being prepared for a new
list of licensing options that, depending on their clarity, could
confuse the software market even more. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tony Johnson
  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: Using dimensions

[Jamadagni, Rajendra]

Title: RE: Using dimensions





Thanks Dennis ...


We have "a" group who design their application as if this is a DW environment, so I thought learning this stuff might be beneficial for "me".

I'll check it out.
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: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 29, 2003 2:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Using dimensions



Raj - Actually a good place to start is the Oracle9i Data Warehousing Guide
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical.
htm#97703
 
I think it is important for all Oracle DBAs to understand the fundamental
concepts behind DW. You never know when you'll get yanked into a meeting
where they are discussing it and you don't want to say something Neanderthal
like "of course we'll fully normalize the schema". Ralph Kimball has some
good materials on his web site: http://www.ralphkimball.com
  


Dennis Williams 



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

RE: oracle newsgroup

[Mladen Gogala]

Title: Message



comp.databases.oracle is not a newsgroup, it's a family of 
newsgroups.  Yes, it can be added to outlook directly.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  AKSent: Monday, September 29, 2003 2:35 PMTo: 
  Multiple recipients of list ORACLE-LSubject: oracle 
  newsgroup
  How to one subcribe to 
  Comp.database.oracle newsgroup .  Can it be added into 
  outlook directly . 
   
  thanks,
  -ak
   
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

RE: RE: Using dimensions

[Stephane Paquette]

Title: Using dimensions



I`ve 
not used dimensions in Oracle only read about them. 
But I 
have designed DW using dimensional modeling. So from what I've read in the doc, 
Oracle will used the dimensions to be better at query rewriting because it 
knows the hierarchy of the data (example : neighbourhood, city, region, 
province, country)
 



Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Monday, September 29, 2003 2:20 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  RE: Using dimensions
  Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ 
  uses of dimensions ... where does one use them? in SQLs? 
   
  I have scanned TFM, but haven't STFW'd yet ... scared of too many 
  hits.
   
  Thanks
  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: Scott Canaan 
[mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Using dimensions

Dimensions are data 
warehouse constructs.  They are implemented as tables in the database, 
but have the characteristic of a hierarchy that can be traversed.  For 
example:  a time dimension can have the hierarchy of date, day, week, 
month, quarter, year, decade, century.  This is used for rollup 
reporting within the data mart.  I don't see any good use of it in an 
OLTP environment, but I may be wrong.
 

Scott Canaan 
([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out 
of it depends on what you put into it." - Tom 
Lehrer.
 
-Original 
Message-From: 
Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 
AMTo: Multiple recipients 
of list ORACLE-LSubject: 
Using dimensions
 
I have tried, but 
haven't found a good example of how to _use_ a dimension in 9ir2. I defined 
one, but then sat clueless on what to do with it. Is it any good in an OLTP 
environment? (I smell the answer is a NO, but still) ..
Any notes from your 
experience? 
TIA 
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 ! 

oracle newsgroup

[AK]

How to one subcribe to 
Comp.database.oracle newsgroup .  Can it be added into outlook 
directly . 
 
thanks,
-ak
 

RE: x$ constructs and memory

[Mladen Gogala]

With all due respect, I don't believe that it is a fixed area.
You can create X$ tables by running certain catalog scripts. I believe
that the description of X$ tables is located logically close to the
description of the data dictionary, which would mean shared pool, not
the fixed one. Now, can we get back to bears?

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Tanel Poder
> Sent: Monday, September 29, 2003 1:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: x$ constructs and memory
> 
> 
> >What I have not checked so far is how an ALTER SYSTEM 
> increasing a
> parameter affects the SGA. In practice it's a realloc() 
> (functionally speaking). It would seem reasonable to me to 
> have a shared memory segment to hold all parameters which can 
> by dynamically changed. I wouldn't touch it if parameters are 
> decreased, but I would have to realloc it in case of a 
> massive increase. Hmm, I guess that I would allow some spare 
> memory initially, performance penalty would otherwise be 
> severe. Which all makes the 10g dynamic rearrangement quite 
> sensible ...
> 
> Hi!
> 
> I think the behaviour depends on which parameter you are 
> changing. If you're changing shared_pool_size to higher size, 
> then just additional extents of memory are allocated and heap 
> header is updated. If you set sort_area_size higher, nothing 
> particular happens, except some maximum is increased in UGA I 
> believe and during next sort you can go up to that limit. 
> Some parameters like enqueue_resources can't be changed in 
> the fly, because they are fixed, they stay in fixed area of 
> SGA, fixed area isn't managed as heap as I understand, it 
> does not have any free or LRU lists, because it's physical 
> structure remains unchanged during the lifetime of an instance.
> 
> Tanel.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 




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

-- 
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: Using dimensions

[DENNIS WILLIAMS]

Raj - Actually a good place to start is the Oracle9i Data Warehousing Guide
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical.
htm#97703
 
I think it is important for all Oracle DBAs to understand the fundamental
concepts behind DW. You never know when you'll get yanked into a meeting
where they are discussing it and you don't want to say something Neanderthal
like "of course we'll fully normalize the schema". Ralph Kimball has some
good materials on his web site: http://www.ralphkimball.com
  



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

-Original Message-
Sent: Monday, September 29, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L


Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses
of dimensions ... where does one use them? in SQLs? 
 
I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.
 
Thanks
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: Monday, September 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L



Dimensions are data warehouse constructs.  They are implemented as tables in
the database, but have the characteristic of a hierarchy that can be
traversed.  For example:  a time dimension can have the hierarchy of date,
day, week, month, quarter, year, decade, century.  This is used for rollup
reporting within the data mart.  I don't see any good use of it in an OLTP
environment, but I may be wrong.

 

Scott Canaan ([EMAIL PROTECTED])

(585) 475-7886

"Life is like a sewer, what you get out of it depends on what you put into
it." - Tom Lehrer.

 

-Original Message-
Sent: Monday, September 29, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L

 

I have tried, but haven't found a good example of how to _use_ a dimension
in 9ir2. I defined one, but then sat clueless on what to do with it. Is it
any good in an OLTP environment? (I smell the answer is a NO, but still) ...

Any notes from your experience? 

TIA 
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 ! 

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

Re: RE: Using dimensions

[rgaffuri]

i think there are examplse in the datawarehouse doc on otn.

there is an oracle datawarehouse book that has come recommended(havent read it). tim 
gorman wrote that one right? Id bet its in there too. 

you use dimensions with star schema's right? 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon PM 12:14:39 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Using dimensions
> 
> Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses
> of dimensions ... where does one use them? in SQLs? 
>  
> I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.
>  
> Thanks
> 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: Monday, September 29, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Dimensions are data warehouse constructs.  They are implemented as tables in
> the database, but have the characteristic of a hierarchy that can be
> traversed.  For example:  a time dimension can have the hierarchy of date,
> day, week, month, quarter, year, decade, century.  This is used for rollup
> reporting within the data mart.  I don't see any good use of it in an OLTP
> environment, but I may be wrong.
> 
>  
> 
> Scott Canaan ([EMAIL PROTECTED])
> 
> (585) 475-7886
> 
> "Life is like a sewer, what you get out of it depends on what you put into
> it." - Tom Lehrer.
> 
>  
> 
> -Original Message-
> Sent: Monday, September 29, 2003 10:55 AM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> I have tried, but haven't found a good example of how to _use_ a dimension
> in 9ir2. I defined one, but then sat clueless on what to do with it. Is it
> any good in an OLTP environment? (I smell the answer is a NO, but still) ...
> 
> Any notes from your experience? 
> 
> TIA 
> 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 ! 
> 
> 
> 
Title: Using dimensions



Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ 
uses of dimensions ... where does one use them? in SQLs? 
 
I have scanned TFM, but haven't STFW'd yet ... scared of too many 
hits.
 
Thanks
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: Scott Canaan 
  [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Using dimensions
  
  Dimensions are data 
  warehouse constructs.  They are implemented as tables in the database, 
  but have the characteristic of a hierarchy that can be traversed.  For 
  example:  a time dimension can have the hierarchy of date, day, week, 
  month, quarter, year, decade, century.  This is used for rollup reporting 
  within the data mart.  I don't see any good use of it in an OLTP 
  environment, but I may be wrong.
   
  
  Scott Canaan 
  ([EMAIL PROTECTED])
  (585) 475-7886
  "Life is like a sewer, what you get out 
  of it depends on what you put into it." - Tom Lehrer.
   
  -Original 
  Message-From: Jamadagni, 
  Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 
  AMTo: Multiple recipients of 
  list ORACLE-LSubject: Using 
  dimensions
   
  I have tried, but haven't 
  found a good example of how to _use_ a dimension in 9ir2. I defined one, but 
  then sat clueless on what to do with it. Is it any good in an OLTP 
  environment? (I smell the answer is a NO, but still) ...
  Any notes from your 
  experience? 
  TIA 
  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 ! 

Re: (long and boring) "SQL AREA" and "LIBARARY CACHE" size?

[Paul Baumgartel]

"No expert"?  Hardly!  Tanel, just how the heck do you KNOW all this
stuff?


--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> As I understand, when shared pool heap is allocated, half of it's
> memory is
> actually "hidden" at first. Oracle just allocates one big permanent
> type
> chunk for that.
> The rest of memory is put on shared pool freelist. Initially this is
> just
> one big free chunk as well, but starts shrinking as space requests
> are done
> from it. One space request might result in multiple allocated chunks,
> if
> there's not enough free space in one memory extent for example.
> 
> When a new chunk is allocated, the allocator will specify size and
> type of
> chunk it wants:
> - permanent type is permanent, unpinnable and unfreeable chunk.
> Permanent
> chunks exist until the whole heap is deallocated.
> - freeable type chunks can explicitly be freed by allocator (there's
> also
> special type of freeable chunks, called freeable with a mark, which
> can be
> freed implicitly, depending on memory usage in heap)
> - recreatable type chunks are pinned ("in use") right after
> allocation and
> they can't be freed until they are explicitly unpinned.
> 
> So, when allocating a recreatable type chunk, first freelists are
> searched
> for suitably sized free chunks. A heap freelist actually consists of
> 255
> different lists, one for each size range of free chunks (smallest
> size range
> starts from 16 bytes, largest is about 64k+). This allows the
> freelist to be
> scanned faster. When no exactly matching free chunk is found, the
> next
> largest will be taken and is split. The leftover free chunk is placed
> to
> appropriate range in freelist. Memory allocations & deallocations in
> shared
> pool are protected by shared pool latch (by shared pool child latch
> starting
> from 9i - you can separate shared pool to several heaps for better
> concurrency in 9i).  AFAIK, Oracle is also able to coalesce adjacent
> free
> chunks when they're freed.
> 
> When a recreatable chunk is allocated, it is marked as "pinned" -
> meaning
> currently in use. Thus noone can free it until it is explicitly
> unpinned by
> it's allocator (for example, several chunks might be pinned in shared
> pool
> during SQL parse and execution, but get unpinned right after the
> statement
> has finished). Here comes the LRU list into play. When a recreatable
> chunk
> is unpinned first time, it is put into MRU end of *transient* LRU
> list,
> since Oracle doesn't know whether it's needed ever again. When it is
> pinned
> next time, then of course it's taken off from LRU list at first, but
> the
> chunk itself is marked recurrent and is put in *recurrent* LRU list
> when
> unpinned again.
> (Note that I'm not sure how this LRU list internal structure looks
> like,
> whether there are really two LRU lists for each heap or is there a
> single
> one with two ends).
> 
> Now, when a new space request is done, first freelists are scanned,
> but if
> there is no sufficient space there, transient LRU list is scanned and
> if big
> enough unpinned recreatable chunk is found, it is freed and returned
> to free
> list.
> Ok, but what happens if no suitable chunk is found from neither
> freelists
> nor LRU list? Oracle will then release "hidden" free space, which is
> allocated as permanent chunk during startup and is not in any
> freelists. The
> reason behind that might be that it is good to have less available
> memory
> during database startup, dictionary cache population and various
> applications initialization operations - that way more transient
> recreatable
> chunks can be reused and LRU lists don't get that long and there's
> less
> fragmentation in shared pool before "real work" starts. Long LRU and
> freelists are one reason for shared pool latch contention, that's why
> one
> should consider reducing of shared pool in case of this latch problem
> instead of usual "more memory is better" approach (as mentioned
> above, in 9i
> it's possible to split shared pool into several heaps to improve
> concurrency).
> 
> And if even hidden memory is used up, then we get ORA-4031.
> 
> Ok, this was a tiny part of heap management in Oracle, there is
> actually
> much more, such reserved list for shared pool reserved area and what
> happens
> free chunk split leftovers which are smaller than 16 bytes etc. Since
> I'm
> not expert on SGA, please correct if I'm wrong.
> 
> Tanel.
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, September 26, 2003 3:17 PM
> 
> 
> > ...long long way to go . b4  i reach x$ tables.
> >
> > Tanel, can  u brief me about transient chunks & recurrent chunks
> > that u were discussing with Steve ?
> >
> > Jp.
> >
> >
> > 26-09-2003 19:54:48, "Tanel Poder" <[EMAIL PROTECTED]> wrote:
> >
> > >I'd suggest, when possible, not to use any x$ views, but stich
> with plain
> > >old documented ways. That way you'll probably avoid a lot of
> confusion

RE: Off Topic: PC Firewall Recommendation

[Robson, Peter]

On the same area - I'm using Black Ice, but its never been clear to me
whether these products trap outgoing stuff.

The BIG problem as I see it as when one inadvertently loads a 1 pixel gif,
populated from a rogue site, which then gives implicit confirmation that
there is a PC at the end of the line...

Anyone been down this particular topic?

peter
edinburgh


> -Original Message-
> From: Brian Dunbar [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 6:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Off Topic: PC Firewall Recommendation
> 
> 
> KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 
> 29, 2003 9:05
> AM said;
> 
> 
> > I have a Dell 8200 with XP Prof. SP1.
> 
> > I would like recommendations as to a good firewall for this 
> machine.  XP
> has a firewall but it is not the greatest.
> 
> ZoneAlarm on the desktop - free version or pay to upgrade to the pro
> version.
> Assuming you have a home network, you also want to buy a 
> DSL/Cable router -
> which has it's own firewall built in.
> 
> If you're feeling frisky, consider replacing the 
> router/firewall with a PC
> (with 2 nics) running BSD or Linux.  You can also find 
> distros tweaked to
> act as a firewall/router - that's what I've done.
> 
> FWIW, a friend of mine had his XP system plugged directly into his RR
> connection.  Friend said he didn't need a firewall or router 
> (I'm not into
> that security crap, I just want to play games).  Friend has now had to
> reformat his box (and lost work) because his box was rooted, 
> blasted and
> fubared within days of hooking it to the cable connection 
> w/out a firewall.
> YMMV.
> 
> ~brian
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Brian Dunbar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


*
This  e-mail  message,  and  any  files  transmitted  with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  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).

OT: Going to OT with Griz

[Orr, Steve]

It's not just any pepper spray but is specially formulated for Griz. 
Here's what you NEED in Montana: http://www.udap.com/

Last year a hunter was killed by Griz while dressing his elk. Griz has
actually learned to head towards gun fire knowing he may find a gut pile
left by some hapless hunter. When I go hunting I carry my .44Mag AND
pepper spray for close encounters while field dressing my kill. If
confronted by Griz I figure my chances are better with the spray. (The
.44 is merely for backup on windy days.) My cousin-in-law actually used
the spray on griz from 10 feet away and says it was VERY effective. Griz
was bouncing off trees as he ran away.

Mladen, you ought to take this topic and join us in the Oracle-L OT
list. You have a natural talent for it. ;-)
http://groups.yahoo.com/group/oracle-l-ot/


Steve Orr
Bozeman, Montana


-Original Message-
Sent: Monday, September 29, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L


Pepper spray? I would feel much safer with a good Springfield rifle by
my side. I'm not sure that a can of pepper spray can stop a 700 lbs
animal, charging at 30 MPH, armed with 2" teeth and 5" claws. On short
distances, a bear can outrun 
a deer.

--
Mladen Gogala
Oracle DBA 


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Orr, Steve
> Sent: Monday, September 29, 2003 12:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: x$ constructs and memory
> 
> 
> > What happens when these x$constructs begin to consume large amounts 
> > of memory? Is there an upper bound?
> Dan, can you think of a scenario where X$ constructs could
> consume enough memory that DBA marmots like us should 
> meditate on them?
> 
> OT: Are there many grizzlies in CO? There are plenty here in
> MT and I always take my pepper spray with me whenever if go 
> to the mountain top to comtemplate things Oracle and 
> otherwise. Got within 100 yards of one and I saw him but he 
> didn't see me.
> 
> 
> Steve Orr
> Bozeman, Montana
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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: x$ constructs and memory

[Tanel Poder]

>What I have not checked so far is how an ALTER SYSTEM increasing a
parameter affects the SGA. In practice it's a realloc() (functionally
speaking). It would seem reasonable to me to have a shared memory segment to
hold all parameters which can by dynamically changed. I wouldn't touch it if
parameters are decreased, but I would have to realloc it in case of a
massive increase. Hmm, I guess that I would allow some spare memory
initially, performance penalty would otherwise be severe. Which all makes
the 10g dynamic rearrangement quite sensible ...

Hi!

I think the behaviour depends on which parameter you are changing.
If you're changing shared_pool_size to higher size, then just additional
extents of memory are allocated and heap header is updated. If you set
sort_area_size higher, nothing particular happens, except some maximum is
increased in UGA I believe and during next sort you can go up to that limit.
Some parameters like enqueue_resources can't be changed in the fly, because
they are fixed, they stay in fixed area of SGA, fixed area isn't managed as
heap as I understand, it does not have any free or LRU lists, because it's
physical structure remains unchanged during the lifetime of an instance.

Tanel.


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

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

Re: Off Topic: PC Firewall Recommendation

[KENNETH JANUSZ]

My PC is stand alone with dial-up phone line.

Ken


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 12:04 PM


> KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 29, 2003 9:05
> AM said;
>
>
> > I have a Dell 8200 with XP Prof. SP1.
>
> > I would like recommendations as to a good firewall for this machine.  XP
> has a firewall but it is not the greatest.
>
> ZoneAlarm on the desktop - free version or pay to upgrade to the pro
> version.
> Assuming you have a home network, you also want to buy a DSL/Cable
router -
> which has it's own firewall built in.
>
> If you're feeling frisky, consider replacing the router/firewall with a PC
> (with 2 nics) running BSD or Linux.  You can also find distros tweaked to
> act as a firewall/router - that's what I've done.
>
> FWIW, a friend of mine had his XP system plugged directly into his RR
> connection.  Friend said he didn't need a firewall or router (I'm not into
> that security crap, I just want to play games).  Friend has now had to
> reformat his box (and lost work) because his box was rooted, blasted and
> fubared within days of hooking it to the cable connection w/out a
firewall.
> YMMV.
>
> ~brian
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Brian Dunbar
>   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: KENNETH JANUSZ
  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: guidance

[April Wells]

Title: RE: guidance





WOW... and with sticks and stones... I'll bet abends were extremely painful and resulted in broken bones!


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Bellow, Bambi [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 29, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: guidance



YOU HAD BOOKS?  In my day, we drew on cave walls with sticks.  Sticks
represented 1s.  Stones represented 0s.  Our compilers were VERY slow... and
we learned everything we knew about correlated subqueries by watching the
antelopes and marmots eating grizzly bears on the Serengeti (well, actually,
that was UNION and MINUS statements... the correlation can't be conveyed in
audiences which may contain young children).


HTH,
Bambi.


-Original Message-
Sent: Saturday, September 27, 2003 6:00 PM
To: Multiple recipients of list ORACLE-L



My dad never drove me to school. We didn't have cars in Denmark back in 
those days. I learned to survive. By the age of 12 I had studied and 
understood the excellent book Godfather by Mario Puzo, and implemented 
the organisational structure described in that manual in my class (5th 
grade). I was the lawyer. I think that might explain the difference 
between me and Cary today.


And yes, my father was in the Military. No need to drive your sons to 
school.


Mogens


Caffrey, Melanie wrote:


>:-)  :-)  :-)  :-)  :-)  :-) :-)  :-)  :-) :-)  :-)  :-) :-)  :-)  :-) :-)
:-)  :-)
> 
>To BOTH answers below!
>
>   -Original Message- 
>   From: Connor McDonald [mailto:[EMAIL PROTECTED]] 
>   Sent: Sat 9/27/2003 7:34 AM 
>   To: Multiple recipients of list ORACLE-L 
>   Cc: 
>   Subject: RE: guidance
>   
>   
>
>   Conversely, on *my* 30min drives to school with my
>   Dad, his advice was:
>   
>   "Why don't you take the bloody bus!"
>   
>   :-)
>   
>    --- Cary Millsap <[EMAIL PROTECTED]> wrote: >
>   How can I say this...
>   >
>   > "Don't confuse learning how to pass the performance
>   > tuning exam with
>   > learning how to make systems faster."
>   >
>   > I'll offer you my Dad's advice on this, which he
>   > reiterated frequently
>   > on our 30-minute drives to and from school:
>   >
>   > "There are two answers to every question your
>   > teachers will ask you
>   > while you're in school. There's the correct answer,
>   > and there's the
>   > answer that the teacher wants. I expect you to know
>   > them both."
>   >
>   >
>   > Cary Millsap
>   > Hotsos Enterprises, Ltd.
>   > http://www.hotsos.com
>   >
>   > Upcoming events:
>   > - Performance Diagnosis 101: 10/28 Phoenix, 11/19
>   > Sydney
>   > - Hotsos Symposium 2004: March 7-10 Dallas
>   > - Visit www.hotsos.com for schedule details...
>   >
>   >
>   > -Original Message-
>   > [EMAIL PROTECTED]
>   > Sent: Thursday, September 25, 2003 3:05 PM
>   > To: Multiple recipients of list ORACLE-L
>   >
>   > Thanks O'mladen one.
>   > No really, thanks , good advice.  I am really going
>   > hyper about
>   > performance
>   > tuning exam.  The course is so vast, and the exam so
>   > expensive.
>   > Honestly how can you test a newbie  in performance
>   > tuning ? shouldn't it
>   > be
>   > a part of ocm ?
>   > Instead of putting that riduculous condition of
>   > attending Oracle classes
>   > to
>   > give ocp they should see how much experience you
>   > have before allowing
>   > you to
>   > appear for performance tuning exam.  I would be much
>   > more prepared for
>   > the
>   > exam if I had apprenticed under you for a while.
>   > Look at me I haven't even read Cary's book ( wait a
>   > minute , neither
>   > have
>   > many people on this list , thanks to amazon)
>   >
>   > - Original Message -
>   > To: "Multiple recipients of list ORACLE-L"
>   > <[EMAIL PROTECTED]>
>   > Sent: Thursday, September 25, 2003 03:09
>   >
>   >
>   > > Realx and feel the force. Only if you open your
>   > mind, you can master
>   > the
>   > > force.
>   > >
>   > > --
>   > > Mladen Gogala
>   > > Oracle DBA
>   > >
>   > >
>   > >
>   > > > -Original Message-
>   > > > From: [EMAIL PROTECTED]
>   > [mailto:[EMAIL PROTECTED]] On
>   > > > Behalf Of [EMAIL PROTECTED]
>   > > > Sent: Wednesday, September 24, 2003 5:05 PM
>   > > > To: Multiple recipients of list ORACLE-L
>   > > > Subject: guidance
>   > > >
>   > > >
>   > > > List , I am plann

RE: guidance

[Bellow, Bambi]

YOU HAD BOOKS?  In my day, we drew on cave walls with sticks.  Sticks
represented 1s.  Stones represented 0s.  Our compilers were VERY slow... and
we learned everything we knew about correlated subqueries by watching the
antelopes and marmots eating grizzly bears on the Serengeti (well, actually,
that was UNION and MINUS statements... the correlation can't be conveyed in
audiences which may contain young children).

HTH,
Bambi.

-Original Message-
Sent: Saturday, September 27, 2003 6:00 PM
To: Multiple recipients of list ORACLE-L


My dad never drove me to school. We didn't have cars in Denmark back in 
those days. I learned to survive. By the age of 12 I had studied and 
understood the excellent book Godfather by Mario Puzo, and implemented 
the organisational structure described in that manual in my class (5th 
grade). I was the lawyer. I think that might explain the difference 
between me and Cary today.

And yes, my father was in the Military. No need to drive your sons to 
school.

Mogens

Caffrey, Melanie wrote:

>:-)  :-)  :-)  :-)  :-)  :-) :-)  :-)  :-) :-)  :-)  :-) :-)  :-)  :-) :-)
:-)  :-)
> 
>To BOTH answers below!
>
>   -Original Message- 
>   From: Connor McDonald [mailto:[EMAIL PROTECTED] 
>   Sent: Sat 9/27/2003 7:34 AM 
>   To: Multiple recipients of list ORACLE-L 
>   Cc: 
>   Subject: RE: guidance
>   
>   
>
>   Conversely, on *my* 30min drives to school with my
>   Dad, his advice was:
>   
>   "Why don't you take the bloody bus!"
>   
>   :-)
>   
>--- Cary Millsap <[EMAIL PROTECTED]> wrote: >
>   How can I say this...
>   >
>   > "Don't confuse learning how to pass the performance
>   > tuning exam with
>   > learning how to make systems faster."
>   >
>   > I'll offer you my Dad's advice on this, which he
>   > reiterated frequently
>   > on our 30-minute drives to and from school:
>   >
>   > "There are two answers to every question your
>   > teachers will ask you
>   > while you're in school. There's the correct answer,
>   > and there's the
>   > answer that the teacher wants. I expect you to know
>   > them both."
>   >
>   >
>   > Cary Millsap
>   > Hotsos Enterprises, Ltd.
>   > http://www.hotsos.com
>   >
>   > Upcoming events:
>   > - Performance Diagnosis 101: 10/28 Phoenix, 11/19
>   > Sydney
>   > - Hotsos Symposium 2004: March 7-10 Dallas
>   > - Visit www.hotsos.com for schedule details...
>   >
>   >
>   > -Original Message-
>   > [EMAIL PROTECTED]
>   > Sent: Thursday, September 25, 2003 3:05 PM
>   > To: Multiple recipients of list ORACLE-L
>   >
>   > Thanks O'mladen one.
>   > No really, thanks , good advice.  I am really going
>   > hyper about
>   > performance
>   > tuning exam.  The course is so vast, and the exam so
>   > expensive.
>   > Honestly how can you test a newbie  in performance
>   > tuning ? shouldn't it
>   > be
>   > a part of ocm ?
>   > Instead of putting that riduculous condition of
>   > attending Oracle classes
>   > to
>   > give ocp they should see how much experience you
>   > have before allowing
>   > you to
>   > appear for performance tuning exam.  I would be much
>   > more prepared for
>   > the
>   > exam if I had apprenticed under you for a while.
>   > Look at me I haven't even read Cary's book ( wait a
>   > minute , neither
>   > have
>   > many people on this list , thanks to amazon)
>   >
>   > - Original Message -
>   > To: "Multiple recipients of list ORACLE-L"
>   > <[EMAIL PROTECTED]>
>   > Sent: Thursday, September 25, 2003 03:09
>   >
>   >
>   > > Realx and feel the force. Only if you open your
>   > mind, you can master
>   > the
>   > > force.
>   > >
>   > > --
>   > > Mladen Gogala
>   > > Oracle DBA
>   > >
>   > >
>   > >
>   > > > -Original Message-
>   > > > From: [EMAIL PROTECTED]
>   > [mailto:[EMAIL PROTECTED] On
>   > > > Behalf Of [EMAIL PROTECTED]
>   > > > Sent: Wednesday, September 24, 2003 5:05 PM
>   > > > To: Multiple recipients of list ORACLE-L
>   > > > Subject: guidance
>   > > >
>   > > >
>   > > > List , I am planning to give my 9i performance
>   > tuning exam on
>   > > > the first . Any advice you all want to give me ?
>   > Pretty
>   > > > nervous about it.  Sure would appreciate your
>   > guidance. 
>   > > >
>   > > > --
>   > > > 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
> 

Re: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[rgaffuri]

i thought i read that auto-segment management only handles pctused. you have to handle 
pctfree yourself? 
> 
> From: "Mladen Gogala" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon PM 12:09:46 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
> 
> And why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic
> segment space management.
> Initial/next are resolved by using LMT, because that's what takes care of
> your extent sizes.
>  
>  
> --
> Mladen Gogala
> Oracle DBA 
> 
> 
> -Original Message-
> Richard Foote
> Sent: Monday, September 29, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Mladen,
>  
> I can't help you with your problem, I haven't had the pleasure on NT or
> Tru64 but I just wanted to point out that you can't forget about PCTFREE
> even with ASSM.
>  
> Cheers
>  
> Richard
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L   
> Sent: Tuesday, September 30, 2003 12:44 AM
> 
> I have RDBMS 9.2.0.4 on RH 7.3 and I executed the following command:
>  
> create tablespace wizard
> datafile '/oradata/WIZ/wizard01.dbf' size 3072M reuse
> autoextend on next 1024M maxsize 16385m
> extent management local autoallocate
> segment space management auto;
>  
> The whole system just hung, doing I/O like crazy.  I was unable to killl one
> of the server processes
> which survived even shutdown abort, so I had to bounce thw whole box. No
> errors, no traces, no
> anything. Does anybody else have experience with this? Is there a known bug
> (not currently known
> to me)  with a patch that I can install? I'd really like to use "SEGMENT
> SPACE MANAGEMENT AUTO"
> and forget about pctfree/pctused stuff. 
>  
> --
> Mladen Gogala
> Oracle DBA 
> 
>  
>  
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.  If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify the
> sender.  You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.  Any views
> expressed in this message are those of the individual sender, except where
> the message states otherwise and the sender is authorized to state them to
> be the views of any such entity.
>  
>  
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain confidential, 
> proprietary or legally privileged information.  No confidentiality or privilege is 
> waived or lost by any mistransmission.  If you receive this message in error, please 
> immediately delete it and all copies of it from your system, destroy any hard copies 
> of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
> distribute, print, or copy any part of this message if you are not the intended 
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
> monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where 
> the message states otherwise and the sender is authorized to state them to be the 
> views of any such entity.
> 
> 
> 
Title: Message



And 
why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic segment 
space management.
Initial/next are resolved by using LMT, because that's what takes care of 
your extent sizes.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Richard FooteSent: Monday, September 29, 2003 11:55 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
  Hi Mladen,
   
  I can't help you with your problem, I haven't had 
  the pleasure on NT or Tru64 but I just wanted to point out that you can't 
  forget about PCTFREE even with ASSM.
   
  Cheers
   
  Richard
  
- Original Message - 
From: 
Mladen 
Gogala 
To: Multiple recipients of list ORACLE-L 

Sent: Tuesday, September 30, 2003 12:44 
AM
Subject: SEGMENT SPACE MANAGEMENT AUTO 
hangs on 9.2.0.4 on Linux

I have RDBMS 
9.2.0.4 on RH 7.3 and I executed the following 
command:
 
create 
tablespace wizard
datafile 
'/oradata/WIZ/wizard01.dbf' size 3072M reuse
autoextend on 
next 1024M maxsize 16385m
extent 
management local autoallocate
segment space 
management auto;
 
The whole system 
just hung, doing I/O like crazy.  I was unable 

RE: RE: interesting sql question

[rgaffuri]

no there are examples in the book using where 'not exists'. the query was horrible. 
Ill post it later if you want to see how bad it is. 

no its not homework. Id get the answer wrong if i did it this way, since Id have to 
follow the model in the book. Which is terrible. 
> 
> From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon PM 12:29:40 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: interesting sql question
> 
> yeah!  I think it *is* homework  :)
>  
> Tom 
>  
>  
>  -Original Message-
> Sent: Monday, September 29, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hey ... the question wasn't complete ... 
> 
> give us the full statement of the question ... 
>  
> 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: Monday, September 29, 2003 11:55 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> a user may request the same boat more than once. not sure that work. 
> > 
> > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> 
> > Date: 2003/09/29 Mon AM 10:34:53 EDT 
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
> > Subject: RE: RE: interesting sql question 
> > 
> > Here is an attempt ... 
> > 
> > select p.* 
> > from persons p 
> > where sid in 
> >  (select sid, count(bid) 
> > from bids 
> >group by sid 
> >   having count(sid) = (select count(boad_id) from boats)) 
> > / 
> > 
> > You wanted to find all persons who have booked all boats ... add criteria 
> > for booked in the first sub-query. 
> > 
> > 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 ! 
> > 
> > 
> 
> 
> 
Title: RE: RE: interesting sql question



yeah!  I think it *is* homework  :)
 
Tom  
 
 -Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 
12:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
RE: RE: interesting sql question

  Hey ... the question wasn't complete ... 
  give us the full statement of the question ... 
   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: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 29, 2003 11:55 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: RE: 
  interesting sql question 
  a user may request the same boat more than once. not sure that 
  work. > > From: 
  "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon AM 10:34:53 EDT > 
  To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
  > Subject: RE: RE: interesting sql question 
  > > Here is an attempt 
  ... > > select 
  p.* > from persons p > 
  where sid in >  
  (select sid, count(bid) > from bids 
  >    group by 
  sid >   having 
  count(sid) = (select count(boad_id) from boats)) > 
  / > > You wanted to find 
  all persons who have booked all boats ... add criteria > for booked in the first sub-query. > 
  > 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 ! > 
  > 

RE: Top (<=10) Issues faced by Oracle DBAs Deploying in a

[Bellow, Bambi]

Hemant --

I just came off a gig where I was the storage/Unix/DBA geek, and, in my
opinion, while the level of expertise *does* need to be higher, *and
different*, for in that environment, it's all front-end.  Once you have the
database configured and the backup and recovery scripts written and tested,
you can go back to having just straight DBAs.  At least that's what they did
at my last site, and I haven't heard any complaints from them.

Bambi.

-Original Message-
Sent: Saturday, September 27, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L



As an Oracle DBA , I have no problems putting my Databases on SANs [yes,
we have seperate SANs, from different vendors].

However, I find that Storage and Unix Admin skill requirements for a SAN
seem to be higher.  When Clustered servers access the SAN, it seems to
be even more difficult to get an additional mount point made available to
the DBA.

Hemant
At 10:59 AM 25-09-03 -0800, you wrote:
>Fellow Listers,
>
>If you don't deal with Oracle databases on SAN/NAS
>environments, this posting may not interest you. If
>so, my apologies, please delete this. Otherwise,
>please read on.
>
>In an effort to better understand what issues you face
>when deploying an Oracle database in a SAN/NAS
>environment, I am writing to you to get some "real
>life" feedback. Although I have a fair idea, where
>some of the pain lies, it would be much more valuable
>if you could tell me. Kind of like "From the horse's
>mouth..."...;-) And I truly meant that as a
>compliment...:-)
>
>My goal is to fully understand where the "real pain"
>lies, so that appropriate solutions can be built to
>alleviate or even eliminate the pain. You can be as
>broad or narrow in your responses using the following
>topics as guidelines:
>
>* Initial SAN/NAS Configuration for Database Creation
>   and Application Deployment
>* Ongoing Storage Volume Management in a SAN/NAS
>* Ongoing Storage Administration (Growth, Resizing)
>* Performance Optimization & Troubleshooting
>* Things that require automation
>* Anything else you think is important that I have
>   missed
>
>I do really appreciate you taking the time to put your
>feedback in "black and white". Those of you who take
>the time and effort to provide feedback, will be
>entered in a raffle to for some T-shirts and other
>freebies. Oh, BTW, when you do send your response,
>please provide your full contact information, so that
>I know where to mail the goodies.
>
>In the interest of not "flooding the list", please
>send me your feedback directly to [EMAIL PROTECTED] As
>a courtesy to my fellow listers, I will collate all
>responses and post a summary in the near future. You
>can count on me to do that.
>
>
>Best regards,
>
>
>Gaja
>
>=
>Gaja Krishna Vaidyanatha|  E-Mail: [EMAIL PROTECTED]
>Principal Technical Product Manager  |  Phone: (650)-527-3180
>Application Performance Management   |  Web: http://www.veritas.com
>Veritas Corporation |
>
>__
>Do you Yahoo!?
>The New Yahoo! Shopping - with improved product search
>http://shopping.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Gaja Krishna Vaidyanatha
>   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
My personal web site is :  http://hkchital.tripod.com


-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  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 mess

Re: x$ constructs and memory

[Tanel Poder]

> A lot of memory structures x$ tables reflect are located in SGA fixed
area,
> for example x$ktuxe which a transaction entry table is located there and
> controlled by init parameter "transactions"

Sorry, I was talking about x$ktcxb here, this is the transaction object
table in SGA fixed area.
x$ktuxe is a window to physical transaction tables in rollback segment
headers.

Tanel.


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

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

RE: Off Topic: PC Firewall Recommendation

[Brian Dunbar]

KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 29, 2003 9:05
AM said;


> I have a Dell 8200 with XP Prof. SP1.

> I would like recommendations as to a good firewall for this machine.  XP
has a firewall but it is not the greatest.

ZoneAlarm on the desktop - free version or pay to upgrade to the pro
version.
Assuming you have a home network, you also want to buy a DSL/Cable router -
which has it's own firewall built in.

If you're feeling frisky, consider replacing the router/firewall with a PC
(with 2 nics) running BSD or Linux.  You can also find distros tweaked to
act as a firewall/router - that's what I've done.

FWIW, a friend of mine had his XP system plugged directly into his RR
connection.  Friend said he didn't need a firewall or router (I'm not into
that security crap, I just want to play games).  Friend has now had to
reformat his box (and lost work) because his box was rooted, blasted and
fubared within days of hooking it to the cable connection w/out a firewall.
YMMV.

~brian
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Brian Dunbar
  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: x$ constructs and memory

[Mladen Gogala]

Pepper spray? I would feel much safer with a good Springfield rifle by my
side.
I'm not sure that a can of pepper spray can stop a 700 lbs animal, charging
at
30 MPH, armed with 2" teeth and 5" claws. On short distances, a bear can
outrun 
a deer.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Orr, Steve
> Sent: Monday, September 29, 2003 12:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: x$ constructs and memory
> 
> 
> > What happens when these x$constructs begin to consume large
> > amounts of memory? Is there an upper bound?
> Dan, can you think of a scenario where X$ constructs could 
> consume enough memory that DBA marmots like us should 
> meditate on them?
> 
> OT: Are there many grizzlies in CO? There are plenty here in 
> MT and I always take my pepper spray with me whenever if go 
> to the mountain top to comtemplate things Oracle and 
> otherwise. Got within 100 yards of one and I saw him but he 
> didn't see me.
> 
> 
> Steve Orr
> Bozeman, Montana
> 
> 
> -Original Message-
> Sent: Monday, September 29, 2003 9:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> You should  have asked a grizzly bear. They're much wiser 
> then marmots and they don't run away that easily. Also, when 
> you see a grizzly bear 100ft away from you and realize that 
> you only have a camera with you, then you begin to understand 
> that there are bigger worries in this world then the location 
> of database structures. What a grizzly would tell you is 
> that, according to my sources,  those tables are stored in 
> the "misc" area of shared pool, which can easily be seen  
> when selected * from V$SGASTAT. Here is what a grizzly would 
> have in mind:
> POOLNAMEBYTES
> --- -- --
> shared pool 1M buffer 2098176
> shared pool KGLS heap 4102928
> shared pool PX subheap  76920
> shared pool parameters  32796
> shared pool free memory 101833708
> shared pool PL/SQL DIANA  1028660
> shared pool FileOpenBlock 3476816
> shared pool PL/SQL MPCODE  547852
> shared pool library cache30858108
> shared pool miscellaneous11656764
> shared pool pl/sql source2708
> 
> 
> --
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> On Behalf 
> > Of Daniel Fink
> > Sent: Monday, September 29, 2003 11:10 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: x$ constructs and memory
> >
> >
> > I was sitting on a mountain here in Colorado, pondering Oracle 
> > optimization and an interesting scenario crossed my feeble 
> mind. As I 
> > began to ponder this (I asked the resident marmot, but he must be a 
> > SQL*Server expert...), I came up with several questions.
> >
> > Where in memory (sga or other) do the x$ constructs reside? Some of 
> > them are 'populated' by reading file-based structures 
> (control file, 
> > datafile headers, undo segments). Does this information reside in 
> > memory or is it loaded each time the x$ construct is accessed? What 
> > happens when these x$constructs
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   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).
> 




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

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

RE: x$ constructs and memory

[Orr, Steve]

> What happens when these x$constructs begin to consume large 
> amounts of memory? Is there an upper bound?
Dan, can you think of a scenario where X$ constructs could consume
enough memory that DBA marmots like us should meditate on them?

OT: Are there many grizzlies in CO? There are plenty here in MT and I
always take my pepper spray with me whenever if go to the mountain top
to comtemplate things Oracle and otherwise. Got within 100 yards of one
and I saw him but he didn't see me.


Steve Orr
Bozeman, Montana


-Original Message-
Sent: Monday, September 29, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L


You should  have asked a grizzly bear. They're much wiser then marmots
and they don't
run away that easily. Also, when you see a grizzly bear 100ft away from
you and realize
that you only have a camera with you, then you begin to understand that
there are bigger
worries in this world then the location of database structures.
What a grizzly would tell you is that, according to my sources,  those
tables are stored
in the "misc" area of shared pool, which can easily be seen  when
selected * from V$SGASTAT.
Here is what a grizzly would have in mind:
POOLNAMEBYTES
--- -- --
shared pool 1M buffer 2098176
shared pool KGLS heap 4102928
shared pool PX subheap  76920
shared pool parameters  32796
shared pool free memory 101833708
shared pool PL/SQL DIANA  1028660
shared pool FileOpenBlock 3476816
shared pool PL/SQL MPCODE  547852
shared pool library cache30858108
shared pool miscellaneous11656764
shared pool pl/sql source2708


--
Mladen Gogala
Oracle DBA



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Daniel Fink
> Sent: Monday, September 29, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: x$ constructs and memory
>
>
> I was sitting on a mountain here in Colorado, pondering
> Oracle optimization and an interesting scenario crossed my
> feeble mind. As I began to ponder this (I asked the resident
> marmot, but he must be a SQL*Server expert...), I came up
> with several questions.
>
> Where in memory (sga or other) do the x$ constructs reside?
> Some of them are 'populated' by reading file-based structures
> (control file, datafile headers, undo segments). Does this
> information reside in memory or is it loaded each time the x$
> construct is accessed? What happens when these x$constructs
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Matthew Zito]

Title: Message



 
Tanel 
is right.  An unkillable process represents one that is in an interruptible 
wait context on system response (i.e. a system call).  If you waited long 
enough, it would probably return (or the box would crashed).  What's an 
indication of a real hung process/serious kernel bug is where the process is 
waiting on something, but the kernel isn't servicing it 
anymore.
 
Thanks,
Matt
 
--Matthew ZitoGridApp SystemsEmail: 
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel 
  PoderSent: Monday, September 29, 2003 11:55 AMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE 
  MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
  Hi!
   
  If your server process couldn't be even killed, 
  then probably it was waiting on kernel IO or smth like that. This is a case 
  when a process can't be killed just like that, even with -9.
   
  I assume you already tried to isolate the 
  problem, by creating smaller file or removing auto segment space management 
  clause?
   
  Tanel.
   
  
- Original Message - 
From: 
Mladen 
Gogala 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, September 29, 2003 5:44 
PM
Subject: SEGMENT SPACE MANAGEMENT AUTO 
hangs on 9.2.0.4 on Linux

I have RDBMS 
9.2.0.4 on RH 7.3 and I executed the following 
command:
 
create 
tablespace wizard
datafile 
'/oradata/WIZ/wizard01.dbf' size 3072M reuse
autoextend on 
next 1024M maxsize 16385m
extent 
management local autoallocate
segment space 
management auto;
 
The whole system 
just hung, doing I/O like crazy.  I was unable to killl one of the 
server processes
which survived 
even shutdown abort, so I had to bounce thw whole box. No errors, no traces, 
no
anything. Does 
anybody else have experience with this? Is there a known bug (not currently 
known
to me)  
with a patch that I can install? I'd really like to use "SEGMENT SPACE 
MANAGEMENT AUTO"
and forget about 
pctfree/pctused stuff. 
 
--Mladen GogalaOracle DBA 
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  
If you receive this message in error, please immediately delete it and 
all copies of it from your system, destroy any hard copies of it and notify 
the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the 
intended recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right 
to monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to 
be the views of any such entity.
 
 

RE: RE: interesting sql question

[Mercadante, Thomas F]

Title: RE: RE: interesting sql question



yeah!  I think it *is* homework  :)
 
Tom  
 
 -Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 
12:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
RE: RE: interesting sql question

  Hey ... the question wasn't complete ... 
  give us the full statement of the question ... 
   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: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 29, 2003 11:55 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: RE: 
  interesting sql question 
  a user may request the same boat more than once. not sure that 
  work. > > From: 
  "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > Date: 2003/09/29 Mon AM 10:34:53 EDT > 
  To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
  > Subject: RE: RE: interesting sql question 
  > > Here is an attempt 
  ... > > select 
  p.* > from persons p > 
  where sid in >  
  (select sid, count(bid) > from bids 
  >    group by 
  sid >   having 
  count(sid) = (select count(boad_id) from boats)) > 
  / > > You wanted to find 
  all persons who have booked all boats ... add criteria > for booked in the first sub-query. > 
  > 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 ! > 
  > 

Re: x$ constructs and memory

[Tanel Poder]

Hi!

X$ fixed tables are just interfaces to Oracle database and instance memory
structures. In my understanding, there are no separate memory structures
built only for serving x$ tables, x$ tables just help humans to read
existing instance memory and physical structures more easily. Selecting from
x$ table doesn't mean only reading and formatting some memory locations,
they can have rules associated with them, for example x$ktfbue and x$ktfbfe
(LMT used extents and free extents) require selecting from ts$ for example
and of course reading relevant bitmap blocks into buffer cache as well.

A lot of memory structures x$ tables reflect are located in SGA fixed area,
for example x$ktuxe which a transaction entry table is located there and
controlled by init parameter "transactions" or x$ksqeq which should be
depenent on enqueue_resources parameter. There's a table called x$ksmmem
which is a map for whole SGA, each line mapping a word from SGA memoy. X$
tables aren't restricted to SGA or physical structures only, they can
reflect PGA structs for example as well.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 6:10 PM


> I was sitting on a mountain here in Colorado, pondering Oracle
> optimization and an interesting scenario crossed my feeble mind.
> As I began to ponder this (I asked the resident marmot, but he
> must be a SQL*Server expert...), I came up with several
> questions.
>
> Where in memory (sga or other) do the x$ constructs reside?
> Some of them are 'populated' by reading file-based structures
> (control file, datafile headers, undo segments). Does this
> information reside in memory or is it loaded each time the x$
> construct is accessed?
> What happens when these x$constructs begin to consume large
> amounts of memory? Is there an upper bound?
>
> Daniel Fink
>


-- 
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: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Mladen Gogala]

Title: Message



And 
why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic segment 
space management.
Initial/next are resolved by using LMT, because that's what takes care of 
your extent sizes.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Richard FooteSent: Monday, September 29, 2003 11:55 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
  Hi Mladen,
   
  I can't help you with your problem, I haven't had 
  the pleasure on NT or Tru64 but I just wanted to point out that you can't 
  forget about PCTFREE even with ASSM.
   
  Cheers
   
  Richard
  
- Original Message - 
From: 
Mladen 
Gogala 
To: Multiple recipients of list ORACLE-L 

Sent: Tuesday, September 30, 2003 12:44 
AM
Subject: SEGMENT SPACE MANAGEMENT AUTO 
hangs on 9.2.0.4 on Linux

I have RDBMS 
9.2.0.4 on RH 7.3 and I executed the following 
command:
 
create 
tablespace wizard
datafile 
'/oradata/WIZ/wizard01.dbf' size 3072M reuse
autoextend on 
next 1024M maxsize 16385m
extent 
management local autoallocate
segment space 
management auto;
 
The whole system 
just hung, doing I/O like crazy.  I was unable to killl one of the 
server processes
which survived 
even shutdown abort, so I had to bounce thw whole box. No errors, no traces, 
no
anything. Does 
anybody else have experience with this? Is there a known bug (not currently 
known
to me)  
with a patch that I can install? I'd really like to use "SEGMENT SPACE 
MANAGEMENT AUTO"
and forget about 
pctfree/pctused stuff. 
 
--Mladen GogalaOracle DBA 
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  
If you receive this message in error, please immediately delete it and 
all copies of it from your system, destroy any hard copies of it and notify 
the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the 
intended recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right 
to monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to 
be the views of any such entity.
 
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

Re: RE: interesting sql question

[rgaffuri]

you could do this, but i would have concerns over the indexing strategy. 


select name
from person, 
(select distinct sid, count(*) bid_count
  from bids
  group by sid
  HAVING count(*) = (SELECT COUNT(BOAT_ID FROM BOATS)) bids
where person.sid = bids.sid;



Now yours bids table is an intersect table and would have the most records of all 
three tables. I would create an extra field that never gets update and just put a 
default value in it. Then I would put a bitmap index on it. since they aer VERY faster 
on counts. 

my problem is with the group by. SID could be huge. That could lead to a massive slow 
down and alot of LIOs dont think there is a faster a solution though. No 
correlated sub-queries which are LIO intensive. 
> 
> From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon AM 09:34:38 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: interesting sql question
> 
> Ralph,
> 
> Assuming that there is no history in the BIDS table (meaning that there are
> no "old" records indicating a bid recorded last year), I think the following
> would work just fine.
> 
> 
> select name
> from person, 
> (select distinct sid, count(*) bid_count
>   from bids
>   group by sid) bids
> where person.sid = bids.sid
> and bid_count = 3
> 
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Monday, September 29, 2003 9:20 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Im taking a database theory class(no I dont need help with my homework).
> There is an interesting query in the book that I have never seen posed
> before. The solution would be hideously slow if there was even a moderate
> amount of data in the tables. How would you write it? 
> 
> Given 3 tables: and columns in the tables:
> 
> TABLE: Person
> Primary Key: SID
> COLUMN: NAME
> 
> TABLE: BIDS
> Primary Key: BID
> Foreign Key: SID
> FOREIGN KEYT: BOAT_ID
> Column: Date
> 
> Boat:
> Primary Key: BOAT_ID
> Column: Color
> 
> Find any person who has reserved all the boats. The 
> 
> I dont have the solution with me, but there is a 'NOT EXISTS', then in the
> subquery there is a minus and a correlated 'where' clause.'. That query
> wouldnt move.
> 
> How would you solve this? 
> 
> Also, according to the 'SQL Standard', SQL is supposed to support op codes
> such as 'ALL' or 'ANY' So you can say:
> 
> Find all people who are older than any person with blue eyes. Or find all
> the people who are older than 'ALL' the people with blue eyes.
> 
> Just to reiterate. Not looking for help with my homework. My professor isnt
> an Oracle guy so he doesnt know.  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mercadante, Thomas F
>   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: Using dimensions

[Jamadagni, Rajendra]

Title: Using dimensions



Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ 
uses of dimensions ... where does one use them? in SQLs? 
 
I have scanned TFM, but haven't STFW'd yet ... scared of too many 
hits.
 
Thanks
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: Scott Canaan 
  [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Using dimensions
  
  Dimensions are data 
  warehouse constructs.  They are implemented as tables in the database, 
  but have the characteristic of a hierarchy that can be traversed.  For 
  example:  a time dimension can have the hierarchy of date, day, week, 
  month, quarter, year, decade, century.  This is used for rollup reporting 
  within the data mart.  I don't see any good use of it in an OLTP 
  environment, but I may be wrong.
   
  
  Scott Canaan 
  ([EMAIL PROTECTED])
  (585) 475-7886
  "Life is like a sewer, what you get out 
  of it depends on what you put into it." - Tom Lehrer.
   
  -Original 
  Message-From: Jamadagni, 
  Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 
  AMTo: Multiple recipients of 
  list ORACLE-LSubject: Using 
  dimensions
   
  I have tried, but haven't 
  found a good example of how to _use_ a dimension in 9ir2. I defined one, but 
  then sat clueless on what to do with it. Is it any good in an OLTP 
  environment? (I smell the answer is a NO, but still) ...
  Any notes from your 
  experience? 
  TIA 
  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 ! 

RE: RE: interesting sql question

[Jamadagni, Rajendra]

Title: RE: RE: interesting sql question





Hey ... the question wasn't complete ... 


give us the full statement of the question ...

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: interesting sql question



a user may request the same boat more than once. not sure that work. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon AM 10:34:53 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: interesting sql question
> 
> Here is an attempt ...
> 
> select p.*
> from persons p
> where sid in 
>  (select sid, count(bid)
> from bids
>    group by sid
>   having count(sid) = (select count(boad_id) from boats))
> /
> 
> You wanted to find all persons who have booked all boats ... add criteria
> for booked in the first sub-query.
> 
> 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 !
> 
> 



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

RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Mladen Gogala]

Title: Message



Smaller file didn't help. Removing the SPACE MANAGEMENT clause did the 
trick.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel 
  PoderSent: Monday, September 29, 2003 11:55 AMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE 
  MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
  Hi!
   
  If your server process couldn't be even killed, 
  then probably it was waiting on kernel IO or smth like that. This is a case 
  when a process can't be killed just like that, even with -9.
   
  I assume you already tried to isolate the 
  problem, by creating smaller file or removing auto segment space management 
  clause?
   
  Tanel.
   
  
- Original Message - 
From: 
Mladen 
Gogala 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, September 29, 2003 5:44 
PM
Subject: SEGMENT SPACE MANAGEMENT AUTO 
hangs on 9.2.0.4 on Linux

I have RDBMS 
9.2.0.4 on RH 7.3 and I executed the following 
command:
 
create 
tablespace wizard
datafile 
'/oradata/WIZ/wizard01.dbf' size 3072M reuse
autoextend on 
next 1024M maxsize 16385m
extent 
management local autoallocate
segment space 
management auto;
 
The whole system 
just hung, doing I/O like crazy.  I was unable to killl one of the 
server processes
which survived 
even shutdown abort, so I had to bounce thw whole box. No errors, no traces, 
no
anything. Does 
anybody else have experience with this? Is there a known bug (not currently 
known
to me)  
with a patch that I can install? I'd really like to use "SEGMENT SPACE 
MANAGEMENT AUTO"
and forget about 
pctfree/pctused stuff. 
 
--Mladen GogalaOracle DBA 
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  
If you receive this message in error, please immediately delete it and 
all copies of it from your system, destroy any hard copies of it and notify 
the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the 
intended recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right 
to monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to 
be the views of any such entity.
 
 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

Re: BAARF

[Tanel Poder]

Hi!

> * Index segments have different backup and recovery requirements than
> their corresponding heap segments. For example, as Peter mentioned, if
> you have an index block corruption event, then it's convenient to just
> offline, kill, and rebuild an index tablespace. If the indexes and data

Even though I agree with your point, I couldn't resist commenting that it is
not too convenient to rebuild a billion row index...

See you at Hotsos Symposium next year ;)

Tanel.


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

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

RE: x$ constructs and memory

[Stephane Faroult]

>I was sitting on a mountain here in Colorado,
>pondering Oracle
>optimization and an interesting scenario crossed my
>feeble mind.
>As I began to ponder this (I asked the resident
>marmot, but he
>must be a SQL*Server expert...), I came up with
>several
>questions.
>
>Where in memory (sga or other) do the x$ constructs
>reside?
>Some of them are 'populated' by reading file-based
>structures
>(control file, datafile headers, undo segments).
>Does this
>information reside in memory or is it loaded each
>time the x$
>construct is accessed?
>What happens when these x$constructs begin to
>consume large
>amounts of memory? Is there an upper bound?
>
>Daniel Fink

Dan,

  Concerning question 1, I think that most X$ information resides in the SGA, however 
some X$ tables obviously map the PGA (those on which GV$SQL_BIND_DATA is based are an 
obvious example - you can only see what refers to your own session, for what I have 
seen; other examples with cursor-related fixed views).
  I don't believe that any of them is ever reloaded - they contain data which is 
really useful to Oracle.
  For the last point, if you run a count(*) on them you will notice a stunning 
resemblance to some of your init.ora parameters ... It's less obvious with the V$ 
views because the V$ views chop any null (not in the SQL acceptance) row off, but the 
X$ are unrepentant memory arrays, with 0s or similar at unused positions.
   What I have not checked so far is how an ALTER SYSTEM increasing a parameter 
affects the SGA. In practice it's a realloc() (functionally speaking). It would seem 
reasonable to me to have a shared memory segment to hold all parameters which can by 
dynamically changed. I wouldn't touch it if parameters are decreased, but I would have 
to realloc it in case of a massive increase. Hmm, I guess that I would allow some 
spare memory initially, performance penalty would otherwise be severe. Which all makes 
the 10g dynamic rearrangement quite sensible ...
 
Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Richard Foote]

Title: Message



Hi Mladen,
 
I can't help you with your problem, I haven't had 
the pleasure on NT or Tru64 but I just wanted to point out that you can't forget 
about PCTFREE even with ASSM.
 
Cheers
 
Richard

  - Original Message - 
  From: 
  Mladen 
  Gogala 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, September 30, 2003 12:44 
  AM
  Subject: SEGMENT SPACE MANAGEMENT AUTO 
  hangs on 9.2.0.4 on Linux
  
  I have RDBMS 
  9.2.0.4 on RH 7.3 and I executed the following 
  command:
   
  create tablespace 
  wizard
  datafile 
  '/oradata/WIZ/wizard01.dbf' size 3072M reuse
  autoextend on next 
  1024M maxsize 16385m
  extent management 
  local autoallocate
  segment space 
  management auto;
   
  The whole system 
  just hung, doing I/O like crazy.  I was unable to killl one of the server 
  processes
  which survived 
  even shutdown abort, so I had to bounce thw whole box. No errors, no traces, 
  no
  anything. Does 
  anybody else have experience with this? Is there a known bug (not currently 
  known
  to me)  with 
  a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT 
  AUTO"
  and forget about 
  pctfree/pctused stuff. 
   
  --Mladen GogalaOracle DBA 
   
   
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any mistransmission.  
  If you receive this message in error, please immediately delete it and 
  all copies of it from your system, destroy any hard copies of it and notify 
  the sender.  You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. Wang Trading 
  LLC and any of its subsidiaries each reserve the right to 
  monitor all e-mail communications through its networks.  Any views 
  expressed in this message are those of the individual sender, except where the 
  message states otherwise and the sender is authorized to state them to be the 
  views of any such entity.
   
   

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Tanel Poder]

Title: Message



Hi!
 
If your server process couldn't be even killed, 
then probably it was waiting on kernel IO or smth like that. This is a case when 
a process can't be killed just like that, even with -9.
 
I assume you already tried to isolate the problem, 
by creating smaller file or removing auto segment space management 
clause?
 
Tanel.
 

  - Original Message - 
  From: 
  Mladen 
  Gogala 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, September 29, 2003 5:44 
  PM
  Subject: SEGMENT SPACE MANAGEMENT AUTO 
  hangs on 9.2.0.4 on Linux
  
  I have RDBMS 
  9.2.0.4 on RH 7.3 and I executed the following 
  command:
   
  create tablespace 
  wizard
  datafile 
  '/oradata/WIZ/wizard01.dbf' size 3072M reuse
  autoextend on next 
  1024M maxsize 16385m
  extent management 
  local autoallocate
  segment space 
  management auto;
   
  The whole system 
  just hung, doing I/O like crazy.  I was unable to killl one of the server 
  processes
  which survived 
  even shutdown abort, so I had to bounce thw whole box. No errors, no traces, 
  no
  anything. Does 
  anybody else have experience with this? Is there a known bug (not currently 
  known
  to me)  with 
  a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT 
  AUTO"
  and forget about 
  pctfree/pctused stuff. 
   
  --Mladen GogalaOracle DBA 
   
   
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any mistransmission.  
  If you receive this message in error, please immediately delete it and 
  all copies of it from your system, destroy any hard copies of it and notify 
  the sender.  You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. Wang Trading 
  LLC and any of its subsidiaries each reserve the right to 
  monitor all e-mail communications through its networks.  Any views 
  expressed in this message are those of the individual sender, except where the 
  message states otherwise and the sender is authorized to state them to be the 
  views of any such entity.
   
   

RE: Using dimensions

[Scott Canaan]

Title: Using dimensions









Dimensions are data warehouse constructs. 
They are implemented as tables in the database, but have the characteristic of
a hierarchy that can be traversed.  For example:  a time dimension can have the
hierarchy of date, day, week, month, quarter, year, decade, century.  This is
used for rollup reporting within the data mart.  I don’t see any good use
of it in an OLTP environment, but I may be wrong.

 



Scott Canaan ([EMAIL PROTECTED])

(585) 475-7886

"Life is like a sewer, what you get
out of it depends on what you put into it." - Tom Lehrer.



 

-Original Message-
From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED] 
Sent: Monday, September 29, 2003
10:55 AM
To: Multiple recipients of list
ORACLE-L
Subject: Using dimensions

 

I have tried, but haven't
found a good example of how to _use_ a dimension in 9ir2. I defined one, but
then sat clueless on what to do with it. Is it any good in an OLTP environment?
(I smell the answer is a NO, but still) ...

Any notes from your
experience? 

TIA 
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 ! 

RE: RE: interesting sql question

[rgaffuri]

a user may request the same boat more than once. not sure that work. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/09/29 Mon AM 10:34:53 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: interesting sql question
> 
> Here is an attempt ...
> 
> select p.*
> from persons p
> where sid in 
>  (select sid, count(bid)
> from bids
>group by sid
>   having count(sid) = (select count(boad_id) from boats))
> /
> 
> You wanted to find all persons who have booked all boats ... add criteria
> for booked in the first sub-query.
> 
> 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 !
> 
> 
Title: RE: RE: interesting sql question





Here is an attempt ...


select p.*
from persons p
where sid in 
 (select sid, count(bid)
    from bids
   group by sid
  having count(sid) = (select count(boad_id) from boats))
/


You wanted to find all persons who have booked all boats ... add criteria for booked in the first sub-query.


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 !

RE: Solaris /etc/system values for Oracle8i

[Cunningham, Gerald]

Check out doc ID 15566.1 at Metashlink.

-Original Message-
[mailto:[EMAIL PROTECTED] 
Sent: Friday, September 26, 2003 7:55 PM
To: Multiple recipients of list ORACLE-L



Mario:

If you are using Solaris with 2GB of memory, it will be awfully
difficult, if not impossible, to run 6 instances of Oracle8i
simultaneously. Basically, because of the use of semaphores and the way
Solaris manages memory, I would say you could run 3 or 4 instances ,
depending on their size.  But to have all six up and running, especially
if you have to create them, will not work.  Oracle usually needs 1 GB
per instance while you are creating a database.  While running it, you
would not necessarily need that much.  I advice you to upgrade the
memory on the server to 8 GB. I suggest you budget 1 GB per Oracle
instance.

RWB




Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED] [EMAIL PROTECTED]




 

[EMAIL PROTECTED]

.xerox.com To:
[EMAIL PROTECTED]

Sent by:   cc:

[EMAIL PROTECTED]   Subject: Solaris
/etc/system values for Oracle8i   
m

 

 

09/26/2003 06:19 PM

Please respond to

ORACLE-L

 

 







>   Hi managers.
>
>   I need modify /etc/systems parameters in my e450 box, it allow 6
instances
> for oracle 8i
>
>Box have 2 GB in RAM
>
>Next values are valid???
> SHMMAX 0.5*(physical memory present in machine)
> SHMMIN 1
> SHMMNI 100
> SHMSEG 10
> SEMMNI 100
> SEMMSL Set to 10 plus the largestinitsid.ora PROCESSES parameter of an

> Oracle database on the system. SEMMNS Set to the sum of the 
> PROCESSESparameter for each Oracle database except the largest one, 
> plus 2 timesthe largest PROCESSES value, plus 10 times the number of 
> Oracle databases. SEMOPM 100
> SEMVMX 32767
>
> Mario Henley Becerril Geldis
>*  (52) +55 5326 3200 ext. 1588
>* [EMAIL PROTECTED]
>   System Administrator 
> ___
> sunmanagers mailing list
> [EMAIL PROTECTED] 
> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Becerril, Mario Henley
  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: 
  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: Cunningham, Gerald
  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: x$ constructs and memory

[Orr, Steve]

> I was sitting on a mountain here in Colorado, pondering Oracle...
You are one twisted individual! :-)  Here's some SQL for ya:

ALTER brain RECOVER STANDBY consciousness CONTINUE UNTIL CANCEL;



-Original Message-
Sent: Monday, September 29, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L


I was sitting on a mountain here in Colorado, pondering Oracle
optimization and an interesting scenario crossed my feeble mind. As I
began to ponder this (I asked the resident marmot, but he must be a
SQL*Server expert...), I came up with several questions.

Where in memory (sga or other) do the x$ constructs reside? Some of them
are 'populated' by reading file-based structures (control file, datafile
headers, undo segments). Does this information reside in memory or is it
loaded each time the x$ construct is accessed? What happens when these
x$constructs begin to consume large amounts of memory? Is there an upper
bound?

Daniel Fink
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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: x$ constructs and memory

[Mladen Gogala]

Title: Message



You should  have asked a grizzly bear. They're much wiser 
then marmots and they don'trun away that easily. Also, when you see a 
grizzly bear 100ft away from you and realizethat you only have a camera with 
you, then you begin to understand that there are biggerworries in this world 
then the location of database structures.What a grizzly would tell you is 
that, according to my sources,  those tables are storedin the "misc" 
area of shared pool, which can easily be seen  when selected * from 
V$SGASTAT.Here is what a grizzly would have in 
mind:POOL    
NAME    
BYTES--- -- --shared pool 1M 
buffer 
2098176shared pool KGLS 
heap 
4102928shared pool PX 
subheap  
76920shared pool 
parameters  
32796shared pool free 
memory 
101833708shared pool PL/SQL 
DIANA  
1028660shared pool 
FileOpenBlock 
3476816shared pool PL/SQL 
MPCODE  
547852shared pool library 
cache    
30858108shared pool 
miscellaneous    
11656764shared pool pl/sql 
source    
2708--Mladen GogalaOracle DBA> 
-Original Message-> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On> 
Behalf Of Daniel Fink> Sent: Monday, September 29, 2003 11:10 AM> 
To: Multiple recipients of list ORACLE-L> Subject: x$ constructs and 
memory>>> I was sitting on a mountain here in Colorado, 
pondering> Oracle optimization and an interesting scenario crossed 
my> feeble mind. As I began to ponder this (I asked the resident> 
marmot, but he must be a SQL*Server expert...), I came up> with several 
questions.>> Where in memory (sga or other) do the x$ constructs 
reside?> Some of them are 'populated' by reading file-based 
structures> (control file, datafile headers, undo segments). Does 
this> information reside in memory or is it loaded each time the 
x$> construct is accessed? What happens when these x$constructs> 
begin to consume large amounts of memory? Is there an upper 
bound?>> Daniel Fink> 
 
Note:
This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.  If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. Wang Trading 
LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.  Any views 
expressed in this message are those of the individual sender, except where the 
message states otherwise and the sender is authorized to state them to be the 
views of any such entity.
 
 

RE: x$ constructs and memory

[Hately, Mike (LogicaCMG)]

As I understand it, the X$ information is largely a window onto the control
structures in shared memory rather than a summary, aggregation or
abstraction. I may be wrong here but that's the way I've always understood
it to work. So the structures 'occupy' the same space as the data they're
supposed to reflect.

If I'm wrong I'd be interested to know the true story.

Cheers,
Mike HAtely

-Original Message-
Sent: 29 September 2003 15:10
To: Multiple recipients of list ORACLE-L


I was sitting on a mountain here in Colorado, pondering Oracle
optimization and an interesting scenario crossed my feeble mind.
As I began to ponder this (I asked the resident marmot, but he
must be a SQL*Server expert...), I came up with several
questions.

Where in memory (sga or other) do the x$ constructs reside?
Some of them are 'populated' by reading file-based structures
(control file, datafile headers, undo segments). Does this
information reside in memory or is it loaded each time the x$
construct is accessed?
What happens when these x$constructs begin to consume large
amounts of memory? Is there an upper bound?

Daniel Fink



E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  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: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

[Hemant K Chitale]

I've had no problems with the syntax on 9.2.0.2 on Solaris, HPUX and
Tru64.
Haven't tried 9.2.0.4
Is the "segment space management auto" really the problem ? Or
is it
the file size.
Just run the create tablespace with a 100M or 50M initial file
size.
Hemant
At 06:44 AM 29-09-03 -0800, you wrote:
I have
RDBMS 9.2.0.4 on RH 7.3 and I executed the following 
command:
 
create tablespace wizard
datafile '/oradata/WIZ/wizard01.dbf' size 3072M
reuse
autoextend on next 1024M maxsize
16385m
extent management local
autoallocate
segment space management auto;
 
The whole system just hung, doing I/O like
crazy.  I was unable to killl one of the server
processes
which survived even shutdown abort, so I had to
bounce thw whole box. No errors, no traces, no
anything. Does anybody else have experience
with this? Is there a known bug (not currently known
to me)  with a patch that I can install?
I'd really like to use "SEGMENT SPACE MANAGEMENT
AUTO"
and forget about pctfree/pctused stuff.

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

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : 
http://hkchital.tripod.com

-- 
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: x$ constructs and memory

[Robson, Peter]

Dan -

I think you are in grave danger of forgetting the point of sitting on the
top of mountains

Either that or your Colorado mountains have nothing on our variety from the
NW Highlands of Scotland... (grin!)

peter
edinburgh


> -Original Message-
> From: Daniel Fink [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 29, 2003 4:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: x$ constructs and memory
> 
> 
> I was sitting on a mountain here in Colorado, pondering Oracle
> optimization and an interesting scenario crossed my feeble mind.
> As I began to ponder this (I asked the resident marmot, but he
> must be a SQL*Server expert...), I came up with several
> questions.
> 
> Where in memory (sga or other) do the x$ constructs reside?
> Some of them are 'populated' by reading file-based structures
> (control file, datafile headers, undo segments). Does this
> information reside in memory or is it loaded each time the x$
> construct is accessed?
> What happens when these x$constructs begin to consume large
> amounts of memory? Is there an upper bound?
> 
> Daniel Fink
> 


*
This  e-mail  message,  and  any  files  transmitted  with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  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: Solaris /etc/system values for Oracle8i

[Reginald . W . Bailey]

Tanel:

How large is the swap file?  For Oracle usage, maximum memory settings in
the /etc/system file are based on total memory available, or REAL memory.
This would be physical memory + swap file space (virtual memory). So, with
1GB of physical memory, and an equal amount or more of swap space, you
could run it the way you have configured it.




Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]



   
  
tanel.poder.00 
  
[EMAIL PROTECTED]To: [EMAIL PROTECTED] 
   
Sent by: cc:   
  
[EMAIL PROTECTED]   Subject: Re: Solaris  /etc/system 
values for Oracle8i   
ity.com
  
   
  
   
  
09/28/2003 
  
08:29 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Yep, I have development and even small production 8i instances which take
only about 100MB of memory (SGA, listener, dispatcher, shared servers).

Tanel.

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


> I've a customer running a development environment of two OraApps 11.5.8
> database instances and one more database instance (for web development
under
> WebLogic), all on a Sun V100.
>
> Yes, that is a rack-mountable Solaris machine of 1U rack height with a
> maximum configuration of one (1) UltraSPARC-III CPU, 1.0 Gb of RAM, and
> three 36-Gb HDD.  Main storage is a NAS (since the machine doesn't
> accommodate SCSI or FC adapters).
>
> Foolishly underconfigured, yes.  Impossible or difficult, no.
>
>
>
> on 9/27/03 7:54 AM, Tanel Poder at [EMAIL PROTECTED] wrote:
>
> > What the heck was that?
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Saturday, September 27, 2003 2:54 AM
> >
> >
> >>
> >> Mario:
> >>
> >> If you are using Solaris with 2GB of memory, it will be awfully
difficult,
> >> if not impossible, to run 6 instances of Oracle8i simultaneously.
> >> Basically, because of the use of semaphores and the way Solaris
manages
> >> memory, I would say you could run 3 or 4 instances , depending on
their
> >> size.  But to have all six up and running, especially if you have to
> > create
> >> them, will not work.  Oracle usually needs 1 GB per instance while you
are
> >> creating a database.  While running it, you would not necessarily need
> > that
> >> much.  I advice you to upgrade the memory on the server to 8 GB. I
suggest
> >> you budget 1 GB per Oracle instance.
> >>
> >> RWB
> >>
> >>
> >


> > 
> >>
> >> Reginald W. Bailey
> >> IBM Global Services - ETS SW GDSD - Database Management
> >> Your Friendly Neighborhood DBA
> >> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> >> [EMAIL PROTECTED]
> >> [EMAIL PROTECTED]
> >>
> >


> > 
> >>
> >>
> >>
> >> [EMAIL PROTECTED]
> >> .xerox.com To:
> > [EMAIL PROTECTED]
> >> Sent by: