This only works if you don't want to rename the database.
Jared
On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote:
i saw this document on Metalink, it is possible to copy everything even
without creating the controlfiles!!
* goal: How to copy an Oracle database to another machine
Hi Begun ,
I am very eager to know the reason why 27th Nov is taken as the base for each
year. Can you please explain me the reasons. This query is really helpful for me .
Thanks Regards,
Shankar
-Original Message-
Sent: Saturday, March 29, 2003 11:39 AM
To: Multiple
100% correct
Re: copying datafile nt4-w2k
---BeginMessage---
This only works if you don't want to rename the database.
Jared
On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote:
i saw this document on Metalink, it is possible to copy everything even
without creating the controlfiles!!
hello all,
how does increasing the value of SORT_AREA_SIZE affect the unix system
perfomance.
Thanks
Arvind
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arvind Kumar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
I have found out the reasons. Thanks for your information.
-Original Message-
Sent: Monday, March 31, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Begun ,
I am very eager to know the reason why 27th Nov is taken as the base for each
year. Can you please explain me
2.
Fix: Increase Rll Back segments
1.
Why: Oracle RDBMS tries to provide "Read consistent " viiew of the data (
changed or clean ) at the "statement level" read consitency and "transaction
level" read consistency
This
isone of the whys- an Oracle DBA's makeshis living in their
Arvind,
When u set the sort_area_size for a database, it will allocate that much
memory PER USER
for any sort operation being performed on the database. In practice, it
means that if u allocate
too high a value for the sort_area_size and multiple users are performing
multiple sorts, the Unix
Your PGA directly Affects the Amt memory the OS has to shell out for
Oracle Server Process so Increasing the Sort_Area_Size does not have
immd effect but if your users are going to do a sort then your PGA can
grow to a Maximum of Sort_Area_Size before being pulled down to the Temp
Segments.
Just
Guys,
I came across this error in ALRT log file.
ORA-00600 Internal error [12501]
It happened during this SELECT statement and it returned no rows,
after i dropped an index on FROMPROFNO column.
SELECT NAME,AGE,SEX FROM MSGHISTORY WHERE
( MEMNO = 123 AND PROFNO = 456 AND
Hello to everyone
I see two options for 9i download at
"technet" site - "AIX" and "AIX based 5L systems".
What does that difference
mean?
How do I find out whether server is one
or the other?
Thanks,
Vladimir
Barac
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database
--- SARKAR, Samir
[EMAIL PROTECTED] wrote:
Arvind,
When u set the sort_area_size for a database, it
will allocate that much
Reddy
There are a variety of techniques to accomplish this, and it is difficult
to determine which will work best in your situation. Here is a link to a
classic article on this topic by the great Jonathan Gennick who participates
in this list from time to time.
Hello Guys,
We have a requirement to add a VARCHAR2 column to an existing table which is
a part of an application and also has a LONG column with data in it. Without
using PL/SQL, how can we create the new VARCHAR2 column and default it to
the LONG column data?
The idea is all future inserts and
Anybody doing Rman Disk and MML tape backups ?
Do you know how to force Rman just look at tape backups?
(please no change the directory on disk answers.. just
lookin to see if I can automate it at the command level.)
Brian
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
So whats the reality, Connor ?? I thought it was the reverse which was the
myth i.e. it
is often misunderstood as the total memory available to the database user as
a whole for sort
operations.I believe the reality is that the sort area size is the size
allocated by Oracle
per user process
Hello Arvind,
This is sort of an open ended question. In general this parameter
controls how much memory is allocated on a per session basis for in
memory sorts. Sorts that require more memory than this will sort on the
disk with a performance penalty. If you have the memory you should stay
Hello all,
i am facing swapping problem ..below is the details
System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE
DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE
93%
Now the problem is of swapping there are about 70 oracle users using this
for one of the db over here alert log
is biggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log file
to another directory , will oracle create a new alert log file ?
Do I need to bounce db ?
btw its 8.1.6 ( hp-ux )
-ak
It works under Oracle 8.0.6 as well, that's our platform version and I
successfully run your queries.
Thanks!
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Jeremiah
Wilton
Enviado el: viernes, 28 de marzo de 2003 16:19
Para: Multiple
Dennis, you seem to be have a master in Oracle! please can you help, I can see
the SPID column under table v$process, but how do I link it to table v$session so that
I actually know which UNIX process it corresponds to. I think there must be another
table that links both of them; you
If it is a myth where do we find the truth?
Allan
-Original Message-
Sent: Monday, March 31, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being
just backup it ( cp alertDBSID.log backupalert.old) and empty it (echo
/dev/null alertDBSID.log) no need to bounce DB
rui
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: alert
log file
for one
You can not do this with SQL. You must use a
procedural language such as PL/SQL.
If your long columns are 32k, PL/SQL will not
work either. You will have to use C or Java
(not sure about Java and Longs) , or some
other supported procedural language.
Jared
On Monday 31 March 2003 07:08,
Title: Message
No problems, just move it. No need to shutdown, Oracle will just
create a new file next time it needs to write to it.
Moving the alert log should be something you do on a regular
basis.
Pete
"Controlling
developers is like herding cats."
Kevin
Loney, Oracle DBA Handbook
Hey all,
I'm downloading Designer 9.0.2.4.0 to try it out. I don't want to #$%^@ up
my current ORACLE_HOME, like I've done while testing every other Oracle
product for Winders 2000. Any tips?
Without reading the docs yet (still downloading), I plan to install it into
another ORACLE_HOME.
Hi!
You didn't send your SHARED_POOL_SIZE parameter
value...
but...
usually, when the machine swaps is due to not enough
memory allocated!
I would check your shared_pool_size, sort_area_size,
and db_block_buffer for verifying that there's enough
memory asigned.
Of course, you should diagnose
Shutdown will automatically rebuild the kernel.
Please correct me if I'm wrong.
-Original Message-
Sent: Friday, March 28, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L
On HP you must rebuild the kernel for the change to take effect.
Allan
-Original Message-
Sent:
I have found out the reasons. Thanks for your information.
That's good.
P.S.: 27 of Nov is my birthday. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ:
Hi...
If you do not want to use pl-sql for populating your
varchar2 field, then another choice is:
use the COPY command from sqlplus... for doing the
pass of data.
you must have into account that varchar2 just can hold
up to 4000 characters!
so, your long data column, should not have more than
You
can rename the alert log or move it. Oracle will create a new one the next
time it has to write to it. You don't need to bounce the
DB.
Dave
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54
AMTo: Multiple recipients of list
rename it, Oracle will create a new alert log file when it needs to
write to the alert log again
--- AK [EMAIL PROTECTED] wrote:
for one of the db over here alert log is biggg .Looks like its
never been truncated or backup .
Is it a problem if i just move this alert log file to another
If you move the alert log to another directory, Oracle will create a new
one in its place. There is no need to bounce the DB.
-Scott
At 07:54 AM 3/31/03 -0800, you wrote:
for one of the
db over here alert log is biggg .Looks like its never been
truncated or backup .
Is it a problem if i
I just found that v$session.paddr = v$process.addr is the join that has to be
done. Right?
-Mensaje original-
De: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 31 de marzo de 2003 18:01
Para: '[EMAIL PROTECTED]'
Asunto: RE: Which process is taking up so
Brian - I couldn't figure out what you are asking. First of all, are you
intending to use RMAN with a catalog? Are you wanting to distinguish the
backups for a report or on recovery. I think that RMAN will record all the
backups you have performed and will want to use the most recent backup for
Hi all!
I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS.
How do I modify this? ALTER LOBSEGMENT doesn't work. I'm still
R'ing the FMs, but I thought I'd ask the list too.
Thanks,
Mike
---
===
Michael P.
Copy the alert log to the desired location and then
CAT /dev/null into the alert log.
CAT /dev/null alert.log
This will zero out the alert log and allow you to keep the old data.
Ron
[EMAIL PROTECTED] 03/31/03 10:53AM
for one of the db over here alert log is biggg .Looks like its
never
Jose - Not enough allocated or too much allocated (from the Oracle
perspective)?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 31, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Hi!
You didn't send your
I am using RMan with and without the Catalog...
if the Catalog goes down..my backups and restores just
switch to Nocatalog mode and keep on ticking..
My goal is to restore/recovery just a backup that resides on
tape rather than accessing the Disk copies...
I guess that Rman at least with
When I see a humungous file like that, I build a little
ksh
script that hasn't failed me yet.
suffix=`date +%y%m%d`
cp -p alertSID.log alertSID_${suffix}.log
alertSID.log
The only thing that might happen is if Oracle is updating
the
log file at EXACTLY the moment you execute this script
Title: RE: alert log file
We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From:
Arvind ,
Do you have any other instance or application running on same box ?
-ak
- Original Message -
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:54 AM
Hello all,
i am facing swapping problem ..below is the
I have a table X with unix index on column A
,B and non unique index on A,C,D . The query give below doesn't use any
index .
I thought its due to function nvl being
used here , so made a change in query to replace
B= NVL(:b2,B) with
(B=:b2 or :b2 is null ) , but this one also not using
thanks,
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 8:53 AM
rename it, Oracle will create a new alert log file when it needs to
write to the alert log again
--- AK [EMAIL PROTECTED] wrote:
for one of the db over
Jared - You are right, I do type too many words. Just look how people are
misled. I can hear the faint sound of laughter in the air.
Fermin - If you've noticed my signature, I'm nowhere near the expert level.
For joining v$process and v$session, I join v$process.addr =
v$session.paddr. I can't
Thanks a lot!!!
-Original Message-
Sent: Saturday, March 29, 2003 1:09 AM
To: Multiple recipients of list ORACLE-L
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using
Shutdown will NOT rebuild the kernel, you must do that manually. On HP use SAM as it
does all of the work for you. Also, take a look at the owner and group associated
with that file. I've seen that cause the same problems, especially the 'file already
in use' one. If that doesn't fix the
From MetaLink Note # 102339.1
For each session there will be a moment in time when the first sort
has to be performed. At that moment, memory is allocated for performing
that sort (sort area). The size of the sort area grows incrementally
until sufficient memory has been allocated to perform
From the Manual:
SORT_AREA_SIZE specifies in bytes the maximum amount of memory Oracle will use
for a sort. Afterthe sort is complete, but before the rows are returned,
Oracle releases memory down to the size specified by the
SORT_AREA_RETAINED_SIZE parameter. After the
Is this just a data dictionary upgrade?
The real question is, does the down time for this upgrade depend on the
number of objects in the data dictionary or on the overall used tablespace
in the database?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
Title: RE: Solaris/8.1.7/LOBSEGMENT
Thanks! I found a note on MetaLink, and got your message
at
about the same time. I figured it out, and applied the
change.
Cheers,
Mike
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003
10:25
Actually, it won't. If you have built a kernel (SAM is usually the
easiest way) then the kernel build process will boot the machine and
push the new kernel into place. A simple shutdown will not do it.
Allan
-Original Message-
Sent: Monday, March 31, 2003 10:39 AM
To: Multiple
Title: RE: ORA-600 [12501] Error ??
Couldn't find it on Metalink. Perhaps you should open a TAR for it?
Oracle version? Server version? Is there a trace file? Can you show us the DDL for the table including its indexes?
-Original Message-
From: Prem Khanna J [mailto:[EMAIL
Title: Re: index ??
What is the selectivity of column A? How many distinct values? Is A
nullable? How many rows and blocks in the table and what are the nr of leaf
blocks and the clustering factors of the indexes?
At 09:08 AM 3/31/2003 -0800, you wrote:
I have a table X with unix index
alter table table_name
modify lob (lob_column)
(storage (maxextents unlimited));
Look in dba_lobs if you are unsure of the table_name
the lobsegment belongs to.
Rob Pegram
Oracle Certified DBA
--- Vergara, Michael (TEM) [EMAIL PROTECTED]
wrote:
Hi all!
I'm getting a report that
Dennis...
not enough from (for) the Oracle
and too much (used) from the OS perspective.
That's why you can get swapped data to disk!
JL
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Jose - Not enough allocated or too much allocated
(from the Oracle
perspective)?
Dennis Williams
DBA,
Thomas,
I think you will find this in either in the upgrade manual or MetaLink.
IIRC it depends on the number of DD objects, but I can't recall where
it was that I read that.
Jared
Thomas Day [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/31/2003 10:34 AM
Please respond to ORACLE-L
Title: RE: Populating VARCHAR2 with LONG data...
(answer below)
-Original Message-
From: Gujral, Harpal S. [mailto:[EMAIL PROTECTED]]
We have a requirement to add a VARCHAR2 column to an existing
table which is
a part of an application and also has a LONG column with data
Jared - I agree with you. My understanding is that an Oracle upgrade just
changes the data dictionary. An Oracle migration (like Oracle 7 to Oracle 8)
involves changes to the tablespaces.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Brian - I'm still not clear on what you're trying to accomplish here.
Usually I feel that RMAN has better information than I do. With automated
systems like RMAN, trying to override them is usually not a good idea. I
don't think there is a direct command to do what you ask.
Some other ideas:
IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases. The MALLOC call never really returned the memory to the OS. Of
course, I don't have any earlier releases to prove it now! :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no,
Fermin,
The following query might help you
set linesize 120
select substr(vs.username,1,10)username,
vs.osuser,
vs.sid,
vs.serial#,
vs.LOGON_TIME,
to_char(vs.logon_time, 'DD-MON-YY HH24:MI:SS') LOGON_TIME,
substr(vs.machine,1,15)machine,
vs.process,
Oracle 7 to Oracle 8 involves changes to the rowid itself. Hence the
tablespaces are part of migration. For higher releases , the changes
take place to the system , rbs tablespaces (if i recall correctly) and
the user tablespaces are not touched by migration.
HTH
GovindanK
=
DENNIS
Pate,
Controlling duhvelopers is not like herding cats, it's more like giving them a
bath!! Heavy body armor required!
Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
IIRC, even this release down to S_A_R_S stuff
Thanks Dennis for taking the time to grapple with this..
The scripts that do the RMAN backups and recoveries...
can backup and restore without the Catalog being up.. (just run in nocatalog
mode)
and it automatically resyncs the catalog when it appears.
I want to be able to recover/validate ONLY
Hi All,
Oracle 8.1.7.4 Win 2000
Does anyone know how to delete a name server. I created thru net8
assistant however it will the service will not start.
I want to remove it. When I highlight it the 'X' is not deleted nor thru
menu options. How can I safely remove name service.
Thanks
Rick
--
Did you ever see the EDS commercial on herding cats? Damn, it was funny! I
still have it on my laptop, but I won't send it to the list (over 1 Mb is a
bit much to send).
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than
Title: RE: How to delete name service
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Oracle 8.1.7.4 Win 2000
Does anyone know how to delete a name server. I created thru net8
assistant however it will the service will not start.
I want to remove it. When
Title: Re: index ??
well , at A is not null and pt present there is
only one distinct value in A.
ak
- Original Message -
From:
Wolfgang
Breitling
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 31, 2003 10:34
AM
Subject: Re: index ??
What
should have bought the blue!!!
At 12:04 PM 3/28/03 -0800, you wrote:
Privileges should be granted to the user, who created the job.
Was it system?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March
S_A_R_S stuff? Please, be careful with those abbreviations.
-Original Message-
Sent: Monday, March 31, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
IIRC, even this release down to S_A_R_S stuff was a myth in earlier
releases. The MALLOC call never really returned the
Check the readme file or installation notes. It will tell you where to
install Designer to make it work.
I installed a couple of years old version, and I was asked to install
in another Oracle_home.
Hope this helps
--- Jesse, Rich [EMAIL PROTECTED] wrote:
Hey all,
I'm downloading Designer
Pete,
Then send it privately: [EMAIL PROTECTED] No I have not seen it, but I still
believe it's more like giving a cat a bath.
Dick Goulet
-Original Message-
Sent: Monday, March 31, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Did you ever see the EDS commercial on
I installed Jdeveloper 9.x on oracle 9.0.1.3 and did not have a problem
with OEM or SQL worksheet. I believe, you need to install it in a
separate directory. Also it does not give you any startup Icon or put
the Jdeveloper in Start and program menu, so you need to start from the
directory.
---
Title: RMAN question
List,
When I got into work this morning I noticed u01 was nearly full on out production OLTP machine. I found the files and the looked to be RMAN files.
They were all in '$ORACLE_HOME/dbs/.' My first thought was that they were the snapshot controlfiles. but
Hi.
I'm trying to see whether a logical partition of a IBM
server will have enough resources to support our
databse based on the size of the DB. In the past the
way I did it was to take an rperf, multipy by 100-125M
and see whether it will exceed my estimate for a DB
size (as suggested in IBM REd
Title: Re: index ??
Sorry, forgot to ask the first time. What is the selectivity of B?
At 12:53 PM 3/31/2003 -0800, you wrote:
well , at A is not null and pt present there is only one distinct value in A.
ak
- Original Message -
From: mailto:[EMAIL PROTECTED]Wolfgang Breitling
To:
Yes, Perl can do it also. And without 32k limits.
Jared
Jacques Kilchoer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/31/2003 11:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Using the EMP table as an example I want to create a query that will show a
list of employees and the mgrs above them. Like this:
ENAME MGRS
--- --
SMITH SMITH
SMITH FORD
SMITH JONES
SMITH KING
ALLEN
Hi,
Anyone having any formula to calculate table size?Basically to estimate the growth of
table over a peroid of time.
I have the row_size,db_block_size.How do i get the table size.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
INET:
I released DBD::Oracle 1.14 a few days ago.
In the release notes I said:
NOTE: OCI 7 and Oraperl will not be supported in future releases.
I'm keen to rip out the old OCI7 API code to make it easier to add
support for more OCI8 features.
I've had no reaction to that yet so I can't gauge how
Title: Re: index ??
is has got lots of distinct values .
- Original Message -
From:
Wolfgang
Breitling
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 31, 2003 2:38
PM
Subject: Re: index ??
Sorry, forgot to ask the first time. What is the
Hello
9i (ORA-01489! be aware):
SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2, 19)) ename
, ename mgrs
FROM emp
CONNECT BY PRIOR mgr = empno
/
Eberhard, Jeff wrote:
Using the EMP table as an example I want to create a query that will show a
list of employees and
Chris - Do you have any more details on the files you deleted that you felt
were snapshot control files? How large?
I may be incredibly stupid, but for the life of me I can't figure out why
you would ask RMAN to restore your controlfile from backup. Was it corrupt?
I would assume bad things
Vladimir Begun wrote:
SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2,
typo: ^RTRIM
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ:
Title: Message
AIX 5L
is version 5.1 or 5.2, as opposed to not 5L which would be
4.3.x
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vladimir BaracSent:
Monday, March 31, 2003 7:58 AMTo: Multiple recipients of list
ORACLE-LSubject: AIX
Title: Message
5L is
the designation for "Linux affinity". The output of 'oslevel -r' will tell
you your release and maintenance level. For example, 5100-02 means you're
running AIX 5L 5.1 maint level 02.
The
reason there are two different downloads is that 64-bit code is OS dependant;
No,
its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
where can one find the other myths about oracle?
Venkat
--
On Mon, 31 Mar 2003 06:18:35
Connor McDonald wrote:
Oracle Myth #1745
When u set the sort_area_size for a database, it will
allocate that much memory PER USER for any sort
operation being performed on the database
--- SARKAR,
89 matches
Mail list logo