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 .
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:
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=20
Logical Standby database while those tables
containing LONG columns fail
Query to find
hi all
we had a strange sort order on a attribute in a table with dashes (-) in the
data.
example
query with default NLS_SORT (NLS_LANGUAGE=american)
R/10-02
R/1-01
R/101-00
R/101-03
query with NLS_SORT=BINARY
R/1-01
R/10-02
R/101-00
R/101-03
Anyone with an
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
Howdy.
I accepted a job at a SQL Server shop, in the initial stages
of implementing an Oracle solution. My previous jobs Id been an Oracle
DBA, as well as back-filling on SQL Server for a couple years. I participated
in evaluating Oracle High Availability for our solution. Were an
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 29 Sep 2003 03:04:40
hi all
we had a strange sort order on a attribute in a
table with dashes (-) in the
data.
example
query with default NLS_SORT (NLS_LANGUAGE=american)
R/10-02
R/1-01
I have five tables, three are 3 million rows, one is a little more than 1
million, one a little less than one million.
All tables are structured the same, with the same indexing, just different
types of data. There is a date column
with a normal index.
A query with a 'between' on the date
--
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
- Original Message -
Why would taking an index off make this query faster? What doesn't the CBO
know that not using an index
is the best path?
The physical sequence of the rows in the smaller table
vis-a-vis the range you're querying on.
Cheers
Nuno Souto
[EMAIL PROTECTED]
--
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
Sorry missed off the www the link should be
http://www.pgibbs.demon.co.uk.
Kind regards
Pete
icle [EMAIL PROTECTED], Pete Finnigan
[EMAIL PROTECTED] writes
Hi Bambi
If it is ftp that is your issue and not the filesystem you can try
another approach, go to a friend of mines site
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
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
Hi,
For your reference, have a look at
http://www.cybcon.com/~jkstill/util/encryption/encryption.html
there is some good information from Jared, and a PL/SQL implementation of
the Blowfish algorithm that I donated.
In answer to your first question:
1) Security being the priority , which would be
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
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 29 Sep 2003 05:19:39
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
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
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
select pn.name
from (select /*+ no_merge */ count(*) boat_cnt from boat) bt, bid bd,
person pn
where bd.sid = pn.sid
group by pn.name, boat_cnt
having count(bd.boat_id) = boat_cnt
Waleed
-Original Message-
Sent: Monday, September 29, 2003 9:20 AM
To: Multiple recipients of
I use Mcafee online Virus scanner and firewall. Been happy for 3+
years.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have
From: Stephane Faroult [EMAIL PROTECTED]
Date: 2003/09/29 Mon AM 09:59:39 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: interesting sql question
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
For the past 1.5 years, starting at Oracle 8.1.7.3.2 and now 8.1.7.4.10 on
windows; we have encountered a problem wherein we encounter a runaway thread
during patching of Oracle Applications 11i. This thread is not know to
v$session and orakill will not terminate it. The only solution has
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
I use
Sygate Personal Firewall (free), and I've never had any problems. Very good
little firewall.
Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni,
RajendraSent: 29 September 2003 15:20To: Multiple
recipients of list
If you have access to a spare pc you're better off
running OpenBSD as your firewall/router and leaving your Windoze pc behind the
firewall.
HTH,
Mark Moynahan
-Original Message-
I have a Dell 8200 with XP Prof.
SP1.
I would like recommendations as to a
good
Try
Zonealarm. It's free.
I have
a wireless router, which has a built in firewall.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of KENNETH
JANUSZSent: Monday, September 29, 2003 10:05 AMTo:
Multiple recipients of list ORACLE-LSubject: Off
Title: Message
I have RDBMS 9.2.0.4
on RH 7.3 and Iexecuted 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
Title: 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
This would eliminate duplicate bids on the same boat by the same person
SELECT p.*
FROMPERSON p,
(
SELECT COUNT(*) boat_count
FROMBOAT
) c,
(
SELECT sid, COUNT(DISTINCT boat_id) bid_count
FROMBIDS
GROUP BY sid
Hi!
What are you trying to tell me?
I am already running my 100MB instances, this is completely irrelevant to my
swap space size.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 5:34 PM
Tanel:
How large is
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
Thomas,
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
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,
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
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
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
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
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
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
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.*
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,
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
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
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
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
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
Title: RE: RE: interesting sql question
Hey ... the question wasn't complete ...
give us the full statement of the question ...
g
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this
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 scannedTFM, but haven't STFW'd yet ... scared of too many
hits.
Thanks
Raj
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
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
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
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
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
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
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
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.
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,
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
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
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,
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
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
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
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.
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
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
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]
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
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
How to one subcribe to
Comp.database.oracle newsgroup . Can it be added into outlook
directly .
thanks,
-ak
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 atquery rewriting because it
knows the hierarchy of the data (example :
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
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
... 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
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
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
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
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
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
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
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
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
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
HI!!
I want to createthe 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
AK - A simple way to get started is to just surf over to
http://groups.google.com 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
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
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]
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
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
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]
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 Ithink the issue may be that the same
item could appear more than once on an invoice. If you add invoice line
do you have
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
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
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
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
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
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
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
1 - 100 of 133 matches
Mail list logo