ttp://www.orafaq.com
-
To unsubscribe send email to: [EMAIL PROTECTED]
put 'unsubscribe' in the subject line.
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECT
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: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcit
null loop
dbms_output.put_line ('i=' || i);
str:= my_package.function(i);
i := refTbl.next(i);
end loop;
end;
/
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services
te 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.oraf
op
x := x || substr(buf, pos, 70) || chr(10);
pos := pos+70;
end loop;
end;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
;
>
> Jared
>
> On Sat, 2004-01-10 at 19:39, Rachel Carmichael wrote:
> > Jared has a utility to dump tables to flat files
> >
> > http://www.cybcon.com/~jkstill/util/
> >
> > on the lefthand menu, under Utilities click on Dump Tables to Flat
> >
ny) it would be by doing Option 2 or 3 above. Does anyone
know if I would see siginificant performance boost by using C? Any other
suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services
; also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-50
> end loop;
> return null;
> exception
> when others then return null;
> end;
>
> It will only be one coursor
>
> Guang Mei wrote:
>
> >I have a function like below (psudo code). If cursor cur1 have multiple
> >rows, would the code leave the cursor open
tab1 where ID = gid;
begin
for x in cur1 loop
return x.c1;
end loop;
return null;
exception
when others then return null;
end;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
'SYSTEM' tablespace. What else should I look for? We
have plenty of space in TEMP if I can get this process to use it.
TIA ... Robyn
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Service
ormance of the above lines by using "bulk
bind"?
I am brain-dead now and can not seem to find if it can be done and/or how it
can be done.
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Ser
IA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
find if it can be done and/or how it can be
done.
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and w
Title: Could not run export utility from cron job
You
need to load user's .profile in your cronjob (to set ENVs), becuase the unix
user who executes cronjob does not have it's profile loaded.
HTH.
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Beh
sfer unit (session data unit).
When
> you enable jumbo frames and set MTU/SDU to 8192 for example, you'll fit
much
> more in single packet, thus increasing performance for larger
transactions.
__
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
2.3695,8750.1141
0
TRIGGER 0 0 0
0
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
can be used to insert separated words
into the database, instead
of printing them. The bottom line is that perl is an excellent tool for
parsing strings and all sorts of string
manipulation.
On 2003.11.20 22:39, Guang Mei wrote:
> Hi:
>
> In my pl/sql program, I want to process each &qu
ng, 1, pos - 1) then assign ltrim(substr(string, pos
+ 1), '#') to string (very similar to what you were planning to do with owa).
This will be probably much faster than a character-by-character loop and calls to an
owa package.
HTH,
Stephane Faroult
>- --- Original Messag
much slower than direct
string manupilation. But I would like to try it in this case if I could
easily get the "wrods" from the string. Any suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat Cit
-
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
Title: RE: sqlplus prompt question in 9i
Thanks David!
That's exactly what I am looking
for.
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of david hillSent:
Thursday, October 30, 2003 11:30 AMTo: Multiple recipients of list
ORACLE-LS
-
Joan Hsieh
Sent: Wednesday, October 29, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
I had same problem with 9i, what I did is at the begining of the
dbstarup or stop script, I mv the glogin.sql to _old, at end of scripts
I mv back to the original name.
Joan
Guang Mei wrote:
>
&
hat sqlplus prompt displays
"username" and "hostname" when launched? I know there is a new
_CONNECT_IDENTIFIER in 9i, but that's not good enough.
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat C
know why the orginal query
failed in 9i?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
0 SORT (ORDER BY) (Cost=184 Card=2 Bytes=84)
> >21 CONCATENATION
> >32 TABLE ACCESS (BY INDEX ROWID) OF 'BLASTRESULTS' (Cost=
> > 11 Card=1 Bytes=42)
> >
> >43 INDEX (RANGE SCAN) OF 'BLASTRESULTS_SUBJID_INDEX
EX' (
NON-UNIQUE) (Cost=3 Card=1)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
anyone applied that patchset on Sun OS and what is your experience of
9204?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
asically the
timestamp of table import).
If I use STATISTICS=ALWAYS in Step 3, I got the same result. So my question
is: what should I do so that I can import 8i statistics into an 9i db?
Thanks.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL P
Title: RE: SAME and separating disk and index tablespaces
Hi:
I had
this situation last month and I finally bounced the db.
"drop tablespace temp INCLUDING
CONTENTS" might work if you want to wait long
enough. I tried this and the db just hang for 30 min before I killed it. My temp
ts
;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
--
Autho
ge 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: Guang Mei
INET: [EMAIL PROTECTED]
directory, such as
>
> cloneDBCreation.log lockAccount.log postDBCreation.log
> postScripts.log ultraSearchCfg.log
>
>
> So does anyone know where I can find the script? Thanks.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
>
$ORACLE_ADMIN//create directory, such as
cloneDBCreation.log lockAccount.log postDBCreation.log
postScripts.log ultraSearchCfg.log
So does anyone know where I can find the script? Thanks.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET
Size in Bytes
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting ser
---
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
s trouble ( our
> Administrator is not here until Monday).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
ling 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
Title: Message
Thanks for the suggestions. I already have planned to move all our
instances to one server and move all schemas (in all instances) to sys schema.
This way I can have better use of system tablespace and drop all other
tablespaces. Also I will put in a cron job to "rm" all databa
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: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.f
Here
we have 3 environments for most applications (dev, QA and prod) and
all Oracle version are the same (8173 now). It works fine. And to save Oracle
license costs, we also consolidated some db servers by putting multiple
instances on one server machine. No problem so
far.
Guang
-
e Doc does not seem to give out clear instruction of how to do
this.
Guang
-Original Message-
Guang Mei
Sent: Wednesday, September 17, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
Hi:
I did RTFM, but I could not find any answer.
I created two TEMPORARY Tablespaces (see bel
name, ts# from ts$ where NAME='TEMP';
>
> NAME TS#
> -- --
> TEMP2
>
>
> But I am not ready to try it on our production system. Has anyone tries
this
> or has an
ALTER TABLESPACE TEMP
ADD TEMPFILE '/oracle/u4/oradata/YPD/temp04.dbf' SIZE 2000M;
ALTER TABLESPACE TEMP
ADD TEMPFILE '/oracle/u4/oradata/YPD/temp05.dbf' SIZE 2000M;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fa
s in TEMP
ts be cleaned up by SMON if I wait for a couple of days?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fa
There
must be a "G" missing there. It should be "(20G or more Oracle
tables)".
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent:
Thursday, September 11, 2003 11:49 AMTo: Multiple recipients of
list ORACLE-LSubject: What
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: Guang Mei
INET: [EMAI
-------
> 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
tart the instance by running
script "dbstart"? TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 ht
entifier
> and externaldbid = 9
> and l.objectid !=k.objectid)<5
>
> to make the whole thing faster?
>
> TIA.
>
> Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Ser
Well,
you can tell them "NOT" to do that. They can write scripts to monitor OS
performance, but DBA is the one to monitor DB performance. You can aslo tell
them you will be writing scripts to monitor Unix performance and probably make
some changes in files in /etc directory. If they insist o
tid !=k.objectid)<5
to make the whole thing faster?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web h
1044, 3001064, 3001073)
> and CurationDetails.Text = to_char(termlist.TermID)
> and Observationlist.NextObs is null
> and Observationlist.CurationStatus = 'E'
> and Observationlist.CurationType in (3000722)
> and Observationlist.Target = 'GeneID'
> and Identifier.Specie
--
db_file_multiblock_read_count
8
-Original Message-
Daniel Fink
Sent: Monday, August 25, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Guang,
What is the value of dba_tables.blocks for each of the tables?
What is the value of db_file_multiblock_read_count for e
you are using
that is slow. Oracle is more likely to use an index if that value is close
to the number of blocks. Less likely if its close to the number of rows.
it basically says how well ordered the data is. Then make sure you analyze
your indexes.
>
> From: "Guang Mei" <[EMAIL PROTE
exists (
select 1 from termobs
where termobs.obsid=observationlist.id and
TermObs.TermID = 3000313)
and exists (
select 1 from termobs
where termobs.obsid=observationlist.id and
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: ht
I am
not sure in 9i. But in 8i I think you can use "case" in sql but not in pl/sql.
You have to use if elsif in pl/sql.
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of A JoshiSent:
Thursday, August 07, 2003 4:24 PMTo: Multiple recipient
Title: RE: last column in a table is added with a DEFAULT
See the test
below:
[EMAIL PROTECTED]> create table t1 (c1
number); Table created. [EMAIL PROTECTED]> insert into t1 (c1)
values (1); 1 row created. [EMAIL PROTECTED]> insert into t1 (c1)
values (2); 1 row created.
[EMAIL PROTECTE
he 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: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Below
is an example (with Oracle 8173), "case" works in sql, not in
pl/sql.
Guang
[EMAIL PROTECTED]> create table
t1 (name varchar2(30), salary number ); Table
created. [EMAIL PROTECTED]> insert into t1
(name,salary) values ('Bill', 1000); 1 row
created. [EMAIL PROTECTED]> insert
Please suggest if this approach is feasible or is it at all possible. Tested this
> with upto 5 instances, and
> it seems to work. The customer is willing to upgrade to any hardware needed for
> this setup.
>
> Thanks in advance for your time.
>
> Dilip.
>
--
Please s
t;
> > 7. Remove old RBS tablespace's datafiles from OS
> >
> > 8. Create new RBS tablespace as LMT
> >
> > 9. Create new rollback segments (RBS01, ... RBS06) in RBS, set them
> online;
> >
> > 10. alter rollback segments (RBSlmt01, RBSlmt02, ... RB
fine until you close the
cursor.
> At least that's been my experience.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fat
ng
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
k segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) offline,
then drop them;
11. alter tablespace rbslmt offline
12. drop tablespace rbslmt
13. Remove tablespace rbslmt's datafiles from OS.
Anything I am missing?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: G
converting an RBS tablespace?
If just an exercise, it's understandable.
If for a production database, just create a new tablespace, new rollback
segments, and then drop the old ones.
Jared
"Guang Mei" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/23/2003 10:24 AM
Ple
IA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
my question is what I can/should do so that I
can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the
same time?
Thanks.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 85
indexes at the same time?
Thanks.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web h
t; INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > T
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing li
-
> 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
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
qlldrst $ORACLE_HOME/bin/
Now use expst and impst instead of imp or exp when doing export & import of
data.
Let me know if you have any problems, or improve the above procedure
somehow.
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EM
to save repeated sql calls, do only one call and get all the
rows back.
Is it possible in any version DBI/DBD? I looked at
http://perldoc.com/perl5.6.1/lib/DBI.html
and I does not seem to be able to figure it out. If it is possible, any
simple example code somewhere?
Thanks.
Guang
--
Please see
it possible in any version DBI/DBD? I looked at
http://perldoc.com/perl5.6.1/lib/DBI.html
and I does not seem to be able to figure it out. If it is possible, any
simple example code somewhere?
Thanks.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INE
k with
the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of.
Why do you ask? Jared has spoken eloquently about how frequent index
rebuilds can reduce your performance.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTE
--------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of ma
t;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>Privileged/Confidential information may be contained in this message.
> If you are not the addressee indicated in this message
>(or r
them are
much more filled (like 90% full).
Any idea what might be the problem? TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif
lps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
Hi:
I have a basic sql question about sql. I have the follwing four sqls and I
am wondering why #3 "costs" less than #4 in explain plan. #1 and #2 cost
the same. How is "distinct"and "group by" treated internally by Oracle? Is
#3 a better "optimized"
Use of function "replace" solved my problem. But thanks for you help.
Guang
Original Message Follows
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Date: Mon, 3 Feb 2003 13:14:38 -0800
Use the octal code for the character, and using the quoting
mechanism of your choice:
$ = octal
|''','''||
segment_name||''',cascade => TRUE);'
from ( select owner,segment_name, sum(bytes) from dba_segments s
where segment_type like 'TABLE%' and
owner = 'ISI' and
s.partition_name is null
group b
/"\$"/g
123578$
essex$ echo "123$45$678" | sed s/"$"/"\\$"/g
123578$
Maybe there is another syntax that I should use? TIA.
Guang Mei
_
MSN 8 with e-mail virus protection service: 2 mo
KAGE BODY
SYSDBMS_SUMREF_UTIL PACKAGE BODY
7 rows selected.
I have never seen this before. Although I recompiled them without any
problem, I am wondering how this could happen. Anyone has also expeienced
this?
TI
-- ---
5677056 116935242880 516096
TIA.
Guang
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see th
I know if my "Variable Size" is too large or not? Which tables or
views that I can query to find if my shared_pool_area is set properly? BTW,
the db performance has been fine so far for about a year.
TIA.
Guang Mei
rotect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
S
C - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
we got 20% performance boost when sort_area_size was
increased from 21M to 151M.
Is what I see here typical? It seems that with the increase of
sort_area_size, the index rebuild will be faster, but not as fast as I
hoped. Any comments?
ers40960
log_buffer1024000
...
_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
ree memory 20906472
_
Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
I
be improved based on the above info?
TIA
Guang Mei
_
Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gu
N 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity
maxextents 800) tablespace rbs;
I set maxextents to avoid "run away transaction". But now with rbs in LMT,
there is no way to set maxextents, how can we avoid "run away transaction"
in this situation?
Thanks.
Guang Mei
temp tablespace,
I found they were created extremely fast, so I suspected that not real disk
space were allocated. But the "ls -l" command still showed 10GB were
allocated.
TIA.
Guang Mei
[EMAIL PROTECTED]
http://www.geocities.co
n terms of performance did you see after you convert dmt to
lmt?
TIA
Guang Mei
[EMAIL PROTECTED]
http://www.geocities.com/guangmei/
_
MSN 8: advanced junk mail protection and 3 months FREE*.
http://join.msn.com/?pag
Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
1 - 100 of 111 matches
Mail list logo