Exactly. Get a design with three or four levels
of PK/FK relationships and watch the cascading everytime
a mistyped natural PK needs to be edited to the correct
value. It's just not practical.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
eg. if you update the natural
Dangerous. The UPDATE is not the same as
a SELECT with lock. It has a read component
that won't lock and a write component that
WILL lock at write time. That is not what
you want.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
What about doing it in one step?
Declare
Hi All,
I need a means to search for a pattern (With basic wildcard characters like %, _, ^,
[]). How do I do this in oracle. I also need to get back the string that matches the
pattern. Is there any predefined function or procedure that does this. Would like to
avoid implementing this on my
Not until 10g
Regards
Naveen
-Original Message-
From: Shiva Maran [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: pattern search
Hi All,
I need a means to search for a pattern (With basic wildcard
Undo normally occupies a sizeable portion of your
buffer cache - a good thing too, because they're
hammered for consistent read and the like.
Of course, if your undo segments are massive, then the
percentage of any given undo segment being the cache
drops...Massive undo segments *might* be
Hi Shiva,
10g comes with full regular _expression_ support. So if upgrading to 10 is
an option in the near future, don't put too much effort in building your
own solution.
Carel-Jan
At 23:19 6-11-03 -0800, you wrote:
Hi All,
I need a means to search for a pattern (With basic wildcard
One of the guys here did some research and found that files over 32GB can cause data
dictionary corruption. anyone have problems with this? we are using an automated
transportable tablespace process with alot of logic and between many instances and
servers.
we would prefer not to complicate
I think there was something in Metaclick about files
in 32-bit OS's not being able to extend much over
32Gb, even with extensions. That's Unix flavours and
32-bit Windoze. Much larger than that and you are
definitely in exclusive 64-bit territory.
Cheers
Nuno Souto
[EMAIL PROTECTED]
-
Naveen and Shiva,
Please see my article at
http://www.stormloader.com/yonghuang/computer/OracleRegExp.html
for a summary of the usage of owa_pattern, a very little known package since
probably Oracle 7.3. It also has a link to Tom Kyte, Mark Piermarini and Daniel
Savarese's external Java
Check LIKE
LIKE Conditions
The LIKE conditions specify a test involving pattern matching. Whereas the
equality operator (=) exactly matches one character value to another, the
LIKE conditions match a portion of one character value to another by
searching the first value for the pattern specified
I like this solution. It works way better than the
dbms_lock.sleep() suggestion ;)
Thank you.
Saira
-Original Message-
Sent: November 6, 2003 3:54 PM
To: [EMAIL PROTECTED]
Cc: Saira Somani-Mendelin
Catch the error in an exception clause and ignore it.
SQL set
RE: Wall Street Journal,
11/7/2003,Review/Books page W8
I opened my WSJ this
morning and found a review of these two books on Larry.
Everyone Else Must Fail by
Karen Southwick
Sofwar by Mathew
Symonds
The reviews were very
interesting.
This is the print version
of the WSJ. The reviews
Don't tell me you tried it g
MG, another feather for your Cap ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
The sleeping beauty suggestion works extremely well, if you are patient.
Patience, you know, is a virtue and my goal is to promote fair and balanced
view to the database.
On 11/07/2003 09:17:12 AM, Saira Somani-Mendelin wrote:
I like this solution. It works way better than the
Speaking of WSJ, they got more then a honorary mention in the
great book by Al Franken. Being an admirer of Mr. Al Franken,
you'll understand my hesitation to give money to WSJ in any way or
form.
On 11/07/2003 09:18:03 AM, KENNETH JANUSZ wrote:
RE: Wall Street Journal, 11/7/2003, Review/Books
Let's not forget PostgreSQL, arguably more enterprise-ready than MySQL,
and now with clustering on Linux:
http://www.open-mag.com/0182533982.shtml
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
Ryan,
Oracle can certainly transport more than one datafile at a
time. I'm not sure what you mean by the datafiles need to
be 'atomic' to be transported, but it is certainly a
limitation of the application logic, not Oracle. You could
transport every single PERMANENT tablespace in a database
The thing about it is that I distinctly remember complaining in a comment in
one of my Perl/DBI progs about having to use positional binds. And now I
can't find it. Oh well. Live and learn and hope no one else comes across
that bit of code to see what an idiot I am.
Rich Jesse
Depending on the Oracle version you're using, try looking up Context,
InterMedia, or Text indexes. Same thing, just different names for different
versions of Oracle. The wildcard syntax is different from regex, but works
like a charm if you understand what the index does.
If you have an Oracle
AH, My choice in an Open Source DB.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, November 07, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L
Let's not forget PostgreSQL, arguably more enterprise-ready than MySQL,
and now with clustering
Mladen Gogala scribbled on the wall in glitter crayon:
The sleeping beauty suggestion works extremely well, if you are
patient. Patience, you know, is a virtue and my goal is to promote
fair and balanced view to the database.
me, i want my patience RIGHT NOW!;-)
BTW, is there any chance of
[Sorry, also posted with the wrong subject title - RE: (un)intelligent agent]
Hi all,
Does anyone have an idea why the query is picking a random local bitmap index whose
single column is not used in the query to do a conversion on?
Regards,
Adrian
---
SELECT 1
FROM
Hi all,
Does anyone have an idea why the query is picking a random local bitmap index whose
single column is not used in the query to do a conversion on?
Regards,
Adrian
---
SELECT 1
FROM small_t bo_
WHERE exists (
select 1
from big_t
where
Hi
Can somebody tell me the steps for changingmy serverconfiguration from dedicated server to shared server?
Thanks
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
Sorry, its late on Friday and need beer...
The bitmap index is partitioned in INV5.
-Original Message-
Sent: 07 November 2003 15:30
To: Multiple recipients of list ORACLE-L
on.
[Sorry, also posted with the wrong subject title - RE: (un)intelligent agent]
Hi all,
Does anyone have an
Title: Message
If you purchase"Oracle Networking ...
(something or other) :-) " by Jonathan Gennick and Hugo Toledo, this
shouldgive you an excellent start.
I
can't recall, off the top of my head if the new MTS 9i init.ora parameters are
included in this text.
I
believe that the latest
Oracle
version??
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Mauricio "Vélez
[mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003
10:34 AMTo: Multiple recipients of list ORACLE-LSubject:
Change dedicated server to shared server
Hi
I believe the connections to the server are controlled by the init.ora
options and the tnsnames.ora.
The proper method of establishing and switching the connection type
are described in the net8 guides.Basicly you set the MTS parameers and
bounce the datanase.
Ron
[EMAIL PROTECTED] 11/07/2003
Title: Message
The
actual titile is "Oracle Net8: Configuration and Troubleshooting", but I
remember a good start to 9i's Oracle Net features being included as
well.
Melanie
-Original Message-From: Melanie Caffrey
[mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003
Melanie --
What's happening is that, in a write-intensive environment, the developers
want to freeze a moment in time which can be used across developers and
applications for testing to ensure consistent results. The functionality
may be expanded, in time, depending on how it works. But from
Well, I just paged through the front part and it says nothing about 9i
coverage. I don't use MTS, so I'm not a good judge on what it covers
that may apply to 9i or not. The rest of the book I can judge and find
it (IMHO) to be a very good book on Oracle Network communication, both
with good
At my last project, we were putting in OraFin and we had a team of Oracle
consultants doing up the front-end setup stuff (populating screens, etc).
Well, one day, I get this panicked call that the system was down. Well,
of course, that was silly. The system was up just fine,
thank-you-very-much,
Hi Stephen,
Check out the Shared Server/MTS chapter. The last few
pages of this chapter should introduce the new 9i
init.ora parameters.
And, I agree. I like this book very much.
Melanie
--- Stephen Andert [EMAIL PROTECTED]
wrote:
Well, I just paged through the front part and it
says
Thanks for sharing that Bambi. Really brightened up my Friday.
-Original Message-
Sent: Friday, November 07, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
At my last project, we were putting in OraFin and we had a team of Oracle
consultants doing up the front-end setup stuff
Book review from Amazon ... might be a good plane trip read
Everyone Else Must Fail: The Unvarnished Truth About Oracle and Larry Ellison
From Publishers Weekly
Southwick, a veteran Silicon Valley observer and author of several books (including
Silicon Gold Rush), offers a detailed look at
That's alright Rich - you aren't the only idiot here ;)
-Original Message-
Sent: Friday, November 07, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
The thing about it is that I distinctly remember complaining in a comment in
one of my Perl/DBI progs about having to use
I smell a Sharktank T-shirt coming up!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:20 AM
To:
Hi,
I have been running oracle8163 since long time on sun platform ,no error
seen earlier but since we are planning to migrate to use webserver as linux
box instead of sun.We have been noticing error
ORA-07445: exception encountered: core dump [ttci2u()+2356] [SIGSEGV]
[Address not mapped to
For reasons why, think about it from the backup/restore
perspective. Which database can be backed up or restored
faster: one with 100 2Gb datafiles or one with 2 100Gb
datafiles? Datafile management is just like extent
management. As Roger Waters said, All in all, they're all
just bricks
The answer is that
free list handling is overhead, which means that the database is working on
its own structures and not working on the user data. It's easy to conceive a
busy transaction table to which records are frequently added and from which
they're frequently removed. Having only one
upgrade.
8163 not supported anymore on sun, i'm sure of it.
joe
Seema Singh wrote:
Hi,
I have been running oracle8163 since long time on sun platform ,no
error seen earlier but since we are planning to migrate to use
webserver as linux box instead of sun.We have been noticing error
No wonder MetaLink is slow - it's too busy serving up graphics to customer
installations.
[EMAIL PROTECTED] 11/07/03 11:44AM
At my last project, we were putting in OraFin and we had a team of Oracle
consultants doing up the front-end setup stuff (populating screens, etc).
Well, one day, I get
Sorry if I bore you all with my dumb questions, its just that
the simplest and silliest things appear complex, if we dont know them...
Often when I learn something, I go : was that all? and they go,
yes, yes, that was all... Well, let me show you what I mean..
What does it mean when a .sql
yes, but as you all know by now ( or should know ), having the best
technology does not make you a market leader.
MySQL will walk all over PostgreSQL, regardless of the superiority of the latter.
Otherwise, we would all be using RDB, wouldn't we?
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent
Maryann,
It could mean very bad things.
For example. If you have the following:
Insert into table as select * from another_table
/
/
The insert will run twice. Try it. You may not like it.
A slash means to execute what's in the sqlplus sql buffer. So whatever is
in there will be executed.
I have 2 of those babies. :)
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/07/2003 09:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Great story! Metalink down caused inhouse crash
I
Oh, RDBheavy sigh Oracle Corp was smart enough to strip out all the
goodies from it except for the SQLMOD feature. Head and tails above the
Pro*Crap. Complete language independence, all your callable SQL in one (or
more) modules, etc.
Who knows? We won't put *any* Oracle DBs on Winders
Here are a number of examples using the OWA_PATTERN package:
declare
tstr varchar2(100) := 'this contains tabsmultiple spaces and single spaces';
begin
dbms_output.put_line( tstr);
owa_pattern.change( tstr, '\s', '', 'g');
dbms_output.put_line( tstr);
end;
/
declare
Can I say I told you so! now? ;)
Yeah, I've already sold most of my Oracle stock. :-)
The lastest versions of MySQL have been performing quite nicely and
their plans to improve transactions are progressing apace. The fact that
they are studying Cary's book says something too.
DBA's wake up!
On the other hand, you might have overallocated the space, which would
leave plenty of blocks on the free list, thus minimizing the impact.
These things are best seen on almost full tables with things like
row chaining, row migration, waits on ITL entries and other lovely
things. Looks like
Your script contains URL? May be, if you show us the code snippet,
we could tell you something that actually makes sense? Not that is normally
to be expected from the DBA crowd, but you are welcome to try.
Do you feel lucky?
On 11/07/2003 01:39:26 PM, Maryann Atkinson wrote:
Sorry if I bore you
Nope, we would be using IMS and/or CICS DL/I. On the beginning
of my career, when I was a junior programmer using completely outdated,
badly overused language (COBOL, for short) an ancient IBM 3084 with only 32M RAM
was able to service 800+ users, as long as there weren't too many TSO users.
I'd
Count me in, too.
On 11/07/2003 12:34:26 PM, STEVE OLLIG wrote:
That's alright Rich - you aren't the only idiot here ;)
-Original Message-
Sent: Friday, November 07, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
The thing about it is that I distinctly remember
Hi!
These aren't sticky bits, they are setuid and setgid bits. (Sticky bit is
the t bit in file listing).
Oracle Agent runs without these bits according to my knowledge too, you just
can't execute host jobs under different users than dbsnmp is running or smth
like that.
Tanel.
- Original
Mladen Gogala scribbled on the wall in glitter crayon:
try. Do you feel lucky?
No.
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]
In the
OH, ANCIENT History!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, November 07, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
Nope, we would be using IMS and/or CICS DL/I. On the beginning
of my career, when I was a junior programmer
that's ok.I want to fix this without changing hardware/software.
thx-Dinesh
From: Joe Testa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: CORE DUMP
Date: Fri, 07 Nov 2003 10:34:26 -0800
upgrade.
8163 not supported anymore on
That must be so true!
Great story! Thank you for sharing.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Jay Hostetter
Sent: Friday, November 07, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
No wonder MetaLink is slow - it's too busy serving up graphics to
Doh! Right you are! I have the mask right, but with the wrong name. I get
those confused sometimes...
Thx!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Tanel Poder
32MB? We'd have given our left insert body part here for 32MB. We had an
8MB 4341 that ran the whole school (remember those days, Al?). Try
compiling a CICS program on that puppy during Registration! And then I
suppose you never forgot to put in your un-callable STOP RUN, did you?
Now, as for
Each '/' on a line by itself, at the beginning of the line, will re-execute the
SQL statement in the sqlplus buffer.
try this:
select * from dual
/
/
/
/
Jared
Maryann Atkinson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/07/2003 10:39 AM
Please respond to ORACLE-L
To:
I believe that an 'alter database backup controlfile to trace' loses the
RMAN data stored in the control files if you're not using a repository (if I
remember right from RF's book).
Since we're not using a repository, we've got controlfile autobackup on (in
9i use 'configure controlfile
Goulet, Dick scribbled on the wall in glitter crayon:
OH, ANCIENT History!!
u... do i admit to getting a job hit last week because i know CICS?;-)
it's still out there and still being used.
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell song
Others have mentioned it, but I just wanted to chime in to warn you to warn
your developers, that they will only have five days to use their frozen
moment in time. This is the limitation imposed by the scn table mentioned
in Dan's post. The reason I decided to chime in is that AFAIK, no official
CREATE TABLESPACE DATA01
DATAFILE '\data01.dbf' size 8M reuse
AUTOEXTEND ON NEXT 4096M MAXSIZE 32M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
Our prod sys is using 8i on solaris, but I quickly tried that on 9i
on my own pc running on XP, before I go try it anywhere else,
That darn NULL process was always *hogging* the CPU.
[EMAIL PROTECTED] 11/07/03 02:09PM
Nope, we would be using IMS and/or CICS DL/I. On the beginning
of my career, when I was a junior programmer using completely outdated,
badly overused language (COBOL, for short) an ancient IBM 3084 with
While I agree that the older machines and 3GL technologies *ran* faster, it
took 8 times longer to develop a simple report. a thousand lines of cobol
code to produce a simple list. and wait for a change request. another week
to figure out what the other programmer did, make a minor change, test
it's a quiet little secret in consultant-land right now that the older
technologies are in play. as the older-folks retire, there is a need for
cobol-based support. especially in NY state agencies.
-Original Message-
Sent: Friday, November 07, 2003 3:04 PM
To: Multiple recipients of
List,
When I create a table as select * from another
table across a dblink, how do I find out how many rows were created in the
table? Is there a statistic somewhere, documented or otherwise, that tells me
how many rows were fetched?
Currently I am using a rather convoluted approach -
Arup
select count(*) from table?
What is your goal? Corruption detection?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November 07, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L
List,
When I create a table as select * from
And
seeing eachother at DECUS.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003
12:45 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Uncle Larry, wake up!!!yes, but as you all know by now ( or should know ), having
Arup
Frankly speaking I have no idea but give a try to v$sql / v$sqlarea and see
rows_processed...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 07 Nov 2003 12:34:25 -0800
List,
When I create a table as select * from another
Use
pl/sql block with execute immediate 'create table as
...'
Number
of rows should be in sql%rowcount (immediately after execute
immediate).
Waleed
-Original Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003 3:34
PMTo: Multiple recipients
Jonathan
Yet another way [I do understand the drawbacks :)]:
* Table with the sequences my_sequences -- for preliminary definition
sys.seq$ can be considered, if possible each row is placed into dedicated
block (number of sequence does matter in this case so, it's a search for
trade off) --
I have a hunch that it will fail on Oracle 8i and with the message like
SQL command not properly terminated, with the asterisk below the word SEGMENT.
It's just my intuition.
On 11/07/2003 03:04:31 PM, Maryann Atkinson wrote:
CREATE TABLESPACE DATA01
DATAFILE '\data01.dbf' size 8M reuse
Arup,
Using before and after values for 'table scan rows gotten' from v$mystat
did the trick for me.
Jared
Arup Nanda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/07/2003 12:34 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hee hee... I am indeed a novice, but I make fairly sound judgments based
on the name of a function :)
-Original Message-
Jamadagni, Rajendra
Sent: November 7, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
Don't tell me you tried it g
MG, another feather for your Cap ...
Waleed,
Thanks a bunch; it worked like a
charm.
The list rules!
Arup
- Original Message -
From:
Khedr,
Waleed
To: Multiple recipients of list ORACLE-L
Sent: Friday, November 07, 2003 3:49
PM
Subject: RE: Getting Number of Rows in
CTAS across DBLink
I'm sure there are many ways to perform complex validations a shell
script. And I needed a simple solution so I opted for the easy way.
Unfortunately, I'm not an expert shell programmer yet. Fortunately, I
did receive many good suggestions from the list to help me progress in
my quest to learn
1 begin
2 execute immediate 'drop table emp1';
3 execute immediate 'create table emp1 as select * from emp';
4 dbms_output.put_line('Number of rows:'||SQL%ROWCOUNT);
5* end;
SQL /
Number of rows:14
PL/SQL procedure successfully completed.
SQL
On 11/07/2003 03:34:25 PM, Arup Nanda
Dennis,
Thanks. Sorry for not being explicit about it. Since the table created is
huge, I want to avoid the count(*) if I can get the number in some other
way.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 3:44 PM
Arup,
Any chance there will be an index on the table?
Daniel
"Arup Nanda" [EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/07/2003 12:34 PM
Please
respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]>
cc:
Subject: Getting Number of Rows
in CTAS across DBLink
Hey, don't forget about me! This was a very timely thread. Named bind
variables in perl solves a problem I'm working on today. :)
Time to go home and have a beer.
Thanks all!
On Fri, 2003-11-07 at 14:09, Mladen Gogala wrote:
Count me in, too.
On 11/07/2003 12:34:26 PM, STEVE OLLIG wrote:
Mercadante, Thomas F scribbled on the wall in glitter crayon:
it's a quiet little secret in consultant-land right now that the older
technologies are in play. as the older-folks retire, there is a need
for cobol-based support. especially in NY state agencies.
i know, Keane tried to sucker
Ah, just noticed the 'dblink' part of your message.
V$mystat probably won't help there.
Jared
Arup Nanda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/07/2003 12:34 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Rich - Could you point to the place where Robert states that bit about
controlfiles to trace? Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November 07, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L
I believe that an 'alter
Rollback?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Cary Millsap
Sent: 05 November 2003 20:39
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: How do you generate primary keys?
I've heard of people using instance startup
Arup,
I am currently devising something I have already more or less done in
the past (version 6, pre-analyse) to get a low-cost and fast estimate of
the size of huge tables, which I have recently redone at a site where
some of their applications are stubbornly stats-free.
Restrictions :
Ahh ... looks like you missed Henry Poras's reply,
Niall.
He replied with the same answer for this one. ;)
--- Niall Litchfield [EMAIL PROTECTED]
wrote:
Rollback?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Cary Millsap
Sent: 05
Hi (again) Mladen,
I'm sure I mentioned this previously but ASSM only deals with FREELISTS,
FREELIST GROUPS and PCTUSED (with possibly significant overheads).
You still need to set *PCTFREE*, which means you can still have over
allocation of space if you set it too high, you can still have row
dead connection detection is supposed to work on 9.2.0.4, but I can't seem to find any docs on this. has anyone exmained this?
thanks,
Pd"Khedr, Waleed" [EMAIL PROTECTED] wrote:
Did you try orakill?
-Original Message-From: Mauricio "Vilez [mailto:[EMAIL PROTECTED]Sent: Thursday,
This is true, Tom.
Some technologies never die ...
Personally, COBOL and CICS are not my favorite
skillsets, *but* knock wood if it ever comes down to
going back to coding in COBOL or being unemployed then
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
it's a quiet little secret in
Richard, here is what the concepts manual says (quoted):
Segment Space Management in Locally Managed Tablespaces
When you create a locally managed tablespace using the CREATE TABLESPACE
statement, the SEGMENT SPACE MANAGEMENT clause lets you specify how free and
used space within a segment is
And we do need education, because we do want to be bricks in the wall.
You seem to know everything, so please, don't leave us alone.
On 2003.11.07 12:49, Tanel Poder wrote:
For reasons why, think about it from the backup/restore
perspective. Which database can be backed up or restored
faster:
Since I upgraded to 9.2.0.3 my xml is no longer indented. Any ideas?
9.2.0.1
GROUP NAME=CS_SECURITY_VIEW
USERJDEFAZIO/USER
USERJWMILLE2/USER
USERSNGHATTA/USER
USERJALARA/USER
USERGHAM/USER
/GROUP
9.2.0.3
GROUP
Arup,
connot
you use COPY command?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Daniel FinkSent:
Friday, November 07, 2003 4:20 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Getting Number of Rows in CTAS across
DBLinkArup,
Sami,
This is inside a PL/SQL procedure; hence SQL*Plus
commands like COPY are not available.
The trick is to use SQL%ROWCOUNT as mentioned
byWaleed and Mladen.Thanks for the help though.
Regards,
Arup
- Original Message -
From:
Sami
To: Multiple recipients of list
Dan,
Are you referring to an index on the source table
(which is remote)? Since I'm creating the table on the destination side, there
is no index. However, I am creating several indexes after the table created.
The answer is to use SQL%ROWCOUNT. I'm curious -
how will an index help?
98 matches
Mail list logo