Re: Suggestion reg. encryption ??

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 precio

Re: shared_Pool

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, Septe

Statspack Report!

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  

Re: BAARF

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 a

RE: Logical standby mode - Dataguard - 9.2.0.4

  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 (

RE: x$ constructs and memory

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 f

RE: Using dimensions

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): YEAR

Re: shared_Pool

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 w

Re: x$ constructs and memory

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 lin

RE: OFA myths was Re: BAARF

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

RE: BAARF

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: - Perfo

RE: x$ constructs and memory

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 i

Re: 8i OCP Net8 Exam

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 Administr

RE: OFA myths was Re: BAARF

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 ass

Re: 8i OCP Net8 Exam

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 web

Re: BAARF

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

RE: Reality check for filesystem/disk layout

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

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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 supp

RE: Problems creading a Index

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-F

RE: Off Topic: PC Firewall Recommendation

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

RE: 8i OCP Net8 Exam

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

RE: 8i OCP Net8 Exam

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?

RE: Off Topic: PC Firewall Recommendation

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

Re: BAARF

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

Re: Last Call for RMOUG Training Days 2004

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?

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

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 o

8i OCP Net8 Exam

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.

RE: BAARF

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

RE: Problems creading a Index

  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(*)

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

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 fo

RE: Problems creading a Index

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

Re: v$sort_usage

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

RE: Problems creading a Index

 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,

Re: Last Call for RMOUG Training Days 2004

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, >

RE: v$sort_usage

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

shared_Pool

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 wi

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 Dieg

RE: Last Call for RMOUG Training Days 2004

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 Se

Re: Oracle 10g Pricing

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

RE: RE: Using dimensions

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

Re: Problems creading a Index

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

RE: Using dimensions

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 scr

RE: x$ constructs and memory

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:[EMA

RE: RE: Using dimensions

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

Re: RE: x$ constructs and memory

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 PRO

Last Call for RMOUG Training Days 2004

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 Ke

RE: oracle newsgroup

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 sugg

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 erro

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

RE: 10G

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 recip

Re: oracle newsgroup

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

Describe privilege on procedures & packages

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 i

RE: oracle newsgroup

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 -Origina

10G

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 l

RE: Solaris /etc/system values for Oracle8i

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

RE: Estimating space needed for UNDO tablespaces

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 s

RE: oracle newsgroup

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 PR

Oracle 10g Pricing

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

RE: Using dimensions

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

RE: oracle newsgroup

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

RE: RE: Using dimensions

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 : neighb

oracle newsgroup

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

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

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

Re: RE: Using dimensions

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

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

"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

RE: Off Topic: PC Firewall Recommendation

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 lin

OT: Going to OT with Griz

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

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 par

Re: Off Topic: PC Firewall Recommendation

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

RE: guidance

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

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, t

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

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 AUT

RE: RE: interesting sql question

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, T

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

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 tes

Re: x$ constructs and memory

> 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$

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 up

RE: x$ constructs and memory

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 Me

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

RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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 kerne

RE: RE: interesting sql question

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

Re: x$ constructs and memory

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

RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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 PRO

Re: RE: interesting sql question

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

RE: Using dimensions

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

RE: RE: interesting sql question

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 emai

RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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 re

Re: BAARF

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 E

RE: 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

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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 recipient

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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 removi

RE: Using dimensions

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, cent

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

RE: Solaris /etc/system values for Oracle8i

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 instance

RE: x$ constructs and memory

> 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 O

RE: x$ constructs and memory

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 wo

RE: x$ constructs and memory

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

Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux

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:

RE: x$ constructs and memory

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 P

Re: Solaris /etc/system values for Oracle8i

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,

  1   2   >