Hi Tim
We just signed a contract for external storage system from EMC and the
configuration is going to be:
Regular servers - connect as Nas
Database servers - connect as San.
If I remember correctly Nas use SCSI connections while San use fiber.
Yechiel Adar
Mehish
- Original Message -
Sounds fair enough to me.. ;)
-Original Message-
[EMAIL PROTECTED]
Sent: 06 November 2002 18:55
To: Multiple recipients of list ORACLE-L
That reminds me:
Mark, your annual stipend is due.
Make it a case of Glenmorangie this time, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent
take a look at your kernel params - may be there is not sufficient segment space
kr mr
[EMAIL PROTECTED] 11/01/02 21:20 PM
Forget this. Found the error.
WARNING: EINVAL creating segment of size 0x0a086000
fix shm parameters in /etc/system or equivalent
-Original Message-
This is how I do it:
1)Set-up an ODBC data source using either the Oracle or MS ODBC driver.
2)In Excel, use the Date-Get External Data menu option
3)Specify the ODBC driver
4)In the Wizard, select the table columns, where and sort or Untick the box and use MS Query where you can
Note 1009345.6 on MetaLink provides a solution
similar to the one proposed with an index.
Jared
On Tuesday 05 November 2002 09:24, Orr, Steve wrote:
Challenge: present SQL results hierarchically and sort the nodes. Use sort
column without changing data. Here's the DDL/DML to start:
create
just don't slip in that 32 year old Macallans! that one is MINE :)
--- Mark Leith [EMAIL PROTECTED] wrote:
Sounds fair enough to me.. ;)
-Original Message-
[EMAIL PROTECTED]
Sent: 06 November 2002 18:55
To: Multiple recipients of list ORACLE-L
That reminds me:
Mark, your
Title: SPIN_COUNT - 8i obsolete? What now?
Hello Guru's
I have run a script which indicates that of the three redo log latches two had occurences of sleeps. To overcome this usually you increase SPIN_COUNT by 50% or so.
When trying to ALTER SYSTEM SET SPIN_COUNT = 3000;
Present system is
Denham Eva wrote:
Hello Guru's
I have run a script which indicates that of the three redo log latches
two had occurences of sleeps. To overcome this usually you increase
SPIN_COUNT by 50% or so.
When trying to ALTER SYSTEM SET SPIN_COUNT = 3000;
Present system is set as 2000. I get
Oh no, I wouldn't dream of it! That is being saved for your up and coming UK
tour :) It's matured even more now as well.. ;)
-Original Message-
Carmichael
Sent: 07 November 2002 10:59
To: Multiple recipients of list ORACLE-L
just don't slip in that 32 year old Macallans! that one is
Eva,
the spin_count parameter became _spin_count in 8i. I believe that because
it's a hidden parameter it's now not possible to change it using ALTER
SYSTEM.
Regards,
Mike Hately
-Original Message-
Sent: Thursday, November 07, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Title: Oracle to Excel
Laura,
Sorry
about that - instead of using chr(10), use chr(09).
(10)
is line feed. (09) is tab.
also -
don't forget to : set trimspool on - it gets rid of trailing
spaces!
good
luck!
Tom
Mercadante Oracle Certified
Professional
-Original
Jos,
select value from v$parameter where name='shared_pool_size' will tell
you the size of the shared pool;
select * from v$sgastat where name like '%free%' and pool like
'%shared%'
will tell you how is free.
Then you can calculate the percentage free.
Hope this helps.
Govind
-Original
based on the date it was written, that was before hints were available
for use. so it makes sense to include the dummy comparison to the
indexed column in the where clause as described in the note.
You mean Oracle sometimes thinks of these things BEFORE we do? nah!
--- Jared Still [EMAIL
there is a point at which you begin to tune for the sake of tuning and
not because you are relieving a problem.
if you are not getting reports of performance problems, why are you
trying to fix it? the old adage if it ain't broke, don't fix it
applies here.
--- Denham Eva [EMAIL PROTECTED]
Title: RE: SPIN_COUNT - 8i obsolete? What now?
Already running on 100% caffeine_level saturation :)
Maybe your right, the contention could be elsewhere, the other issue I have been investigating is LGWR process? With increasing the LOG_BUFFER from 512 to a Meg in size, as I have at times very
This is the error message come whenever a process run in which number of
rows inserted into a big table (~1400 rows/min), and when this process
(called from forms) inserted around 4,50,000 entries in the table it
fails and flushes the following message:
ORA-04030 Out of Process memory when trying
Title: full exp/imp of user to new tablespace; same user
I have a full export of user to where I need to import all his objects/grants
but into a NEW tablespace. What's the easiest way I can assure that
~everything~ is imported. Will I need to use a combination of INDEXFILE
and other
Title: RE: Out of procee memory problem ..
what is 4,50,000 ?
-Original Message-
From: Satyendra K Khare [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 8:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Out of procee memory problem ..
This is the error
Markham, Richard wrote:
I have a full export of user to where I need to import all his
objects/grants
but into a NEW tablespace. What's the easiest way I can assure that
~everything~ is imported. Will I need to use a combination of
INDEXFILE
and other procedures or will a full export;
Title: RE: SPIN_COUNT - 8i obsolete? What now?
Ouch! :)
Rachel,
It's not a case of me looking for problems. I was surprised to find this occuring so maybe doing something about it would improve the system alittle. I am looking into the redo log performance because I am unsure that the
Hi,
This is a bug in Oracle. Apply a latest patch on it.
Regards
Darshan Singh
-Original Message-
Khare
Sent: Thursday, November 07, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
This is the error message come whenever a process run in which number of
rows inserted into a big
version of oracle?
On Thu, Nov 07, 2002 at 05:33:59AM -0800, Satyendra K Khare wrote:
This is the error message come whenever a process run in which number of
rows inserted into a big table (~1400 rows/min), and when this process
(called from forms) inserted around 4,50,000 entries in
Eva,
just to correct myself from my earlier post it's entirely possible to set
_spin_count using ALTER SYSTEM.
It may be a sensible measure to try if you're having serious contention
issues.
Steve Adams has some 'spin_count' scripts that you might find useful at
Title: full exp/imp of user to new tablespace; same user
Richard:
if all
of the objects are going into a single tablespace, make sure that new user has
default tablespace set properly to the new TS and that s/he has a proper quota
on that TS (I start with UNLIMITED). Also, make sure that
Title: Oracle to Excel
Thank you so much!! This works like a charm.
Laura
-Original Message-
From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 6:39 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle to Excel
Laura,
450,000 rows (four hundred and fifty thousands)
In Indian subcontinent it is written as 4 lacs 50 thousands where 1 lac(lakh
most commonly used) is equal to one hundred thousands...
Hope this will calrify. The person who put his problem was from India.
Regards
Rafiq
Reply-To: [EMAIL
Title: RE: SPIN_COUNT - 8i obsolete? What now?
log_buffer has nothing to do with log switches. Just
with checkpointing and some other things I can't think of right
now.
Size
of online redo logfiles does.
Jack
-Original Message-From: Denham Eva
[mailto:[EMAIL PROTECTED]]Sent:
-Original Message-
I have a full export of user to where I need to import all his
objects/grants
but into a NEW tablespace. What's the easiest way I can assure that
~everything~ is imported. Will I need to use a combination of INDEXFILE
and other procedures or will a full export;
Title: RE: SPIN_COUNT - 8i obsolete? What now?
additional factors:
log_checkpoint_timeoutlog_checkpoint_intervalfast_start_io_target90% size of smallest redo
log
alter system
checkpoint
-Original Message-From: Jack van Zanen
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November
Denham,
Sorry, I didn't mean to make you wince! It's just a case of seeing way
too many DBAs spending way too much time tuning things that really
aren't a problem.
Cary Millsap talks about this often. Find the business problem and tune
that. It's possible that something that shows up as very
Thanks Kevin, good to hear from you. As usual you're Johnie on spot with
TFM. It's interesting that this can be overcome with the inline view
technique posted earlier by Raj.
Steve
-Original Message-
Sent: Wednesday, November 06, 2002 5:23 AM
To: Multiple recipients of list ORACLE-L
Title: full exp/imp of user to new tablespace; same user
Extra
security could be to give zero quota on other tablespaces.
-Original Message-From: Markham, Richard
[mailto:[EMAIL PROTECTED]]Sent: donderdag 7 november 2002
14:59To: Multiple recipients of list ORACLE-LSubject:
I have a 9.2
database running on Solaris 8. I'm creating some test tables with indexes. The
USER_INDX tablespace's datafile is set to autoextend (as are TEMP and
USER_DATA). When the system attempts to create indexes, instead of auotextending
the datafile (there is plenty of space on the
And if all else fails (not that the advice already given will!), we have a
tool that can manipulate the DDL for the users objects VERY quickly and
easily, through a rule based change (e.g. Modify ALL tables storage
clauses within USERS schema to TABLESPACE):
Hey Jared, just got this because I was on a 4X10 day off yesterday. Anyway,
thanks for the info. There was lots of great discussion on this and I
appreciate the collective brain power of the list. Proposed solutions: 1)
upgrade to Oracle 9i and use an inline view; 2) use a hint; 3) use indexes
on
The following query is causing the following error
ERROR at line 1:
ORA-03232: unable to allocate an extent of 22 blocks from tablespace 3
select count(l.processid) from tmslog l, tmslogtimeout t where l.processid =
t.processid and l.statifiedflag='Y' and t.processcompleteflag='Y'
Tablespace
Dan,
is your datafile approaching (or past) the maxsize setting? AUTOEXTEND
functionality won't grow a file beyond this but I believe it's possible to
manuallly resize the file beyond the MAXSIZE figure.
That would explain the apparent anomaly.
regards,
Mike Hately
-Original Message-
One of my developers is testing a process that reads a CLOB, modifies it,
and inserts it to another table. The reading and modifying goes very
quickly, but the inserts take a long time. Looking at the main Wait Events
I'm seeing a lot of direct path read (lob) and direct path write (lob) which
never
heard on this problem but are u sure table the temp tablespace of the user
executing the commeand is temp and not user_indx???
regards
Paulo
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: quinta-feira, 7 de Novembro de 2002
15:39To: Multiple
I've heard about the same problem yesterday (while attending
Ann Arbor OUG conference), unfortunately - no solution, I think, they opened
TAR.
BTW, it was very good conference, great presentations by
Jonathan Lewis.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
Title: RE: full exp/imp of user to new tablespace; same user
well now I can say I'm spoiled. I was given more than enough information to
to accomplish the task (done) and a new tool to boot! =)
Thanks alot everyone.
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
To add another point, somebody else (the thread is too long for this lazy
git to go back and search who! ;P) mentioned that the access plans *could*
change if #3 were the solution you go for - however this can be overcome
with the use of stored outlines..
my 2 pence :)
Mark
-Original
Hi Paulo
When creating an index, or CTAS, oracle use temp segments
while building and rename them after the build finish. So if you do not have
enough space you will get: unable to allocate TEMP segment.
Yechiel AdarMehish
- Original Message -
From:
Paulo Gomes
To:
Thanks Rachel.
For Denham: Changing SPIN_COUNT from its default value is usually a Very
Bad Thing. Your sleeps are caused by lots of competition for one or more
latches. The best way to stop those sleeps from impacting response time
is to cut out the unnecessary competition. Because of how we're
I've been running with autoextend on (though limited to 2Gig) and never had
a problem.
-Original Message-
Sent: Thursday, October 24, 2002 5:26 PM
To: Multiple recipients of list ORACLE-L
I run my SYSTEM tablesaces in autoextend, and have for some time. I run them
that way from the
Hi Steve/Jared,
It was coincidence that just when Steve posted this we were trying to
flatten the hierarchy and PL/SQL was the only option and I was doing some
reserach and stumbled upon this parameter and then I used to it to
generate output using the sys_connect_by_path and then all I had to do
Hi all,
We are having a shareplex issue and I am hoping someone here with shareplex
knowledge
can help me out. I don't know much about shareplex. Basically we are
replicating to a
target table which is partitioned by date. And partitions that are 3 days
old will be set
to read-only because
And surprise, surprise... per Metalink, OWS is unwilling to support the
undocumented parameter approach.
-Original Message-
Sent: Thursday, November 07, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
To add another point, somebody else (the thread is too long for this lazy
git
Grace - Well if they want to build all you mentioned in-house,
order taking , purchase order and accounting module,hr
then I wouldn't worry too much about server sizing because it'll take them
forever to get all that done. Well, I just couldn't avoid tossing that
remark in, please excuse it.
Title: RE: SharePlex core dumps - help
Call Quest Software technical support. They will be more than happy to help you.
I think there is already a patch out to fix this.
Just call 1-800-306-9329 and once you speak with an operator, ask to place a support call for SharePlex.
Nick
Igor
and Yechiel,
Thanks for the responses. I'm glad to hear that I am not
the only one experiencing the problem.
I should have also mentioned that the tablespace is LMT
with autoallocate and is nowhere near the max size.
Dan
Fink
-Original Message-From: Yechiel Adar
10M temp TS? You must have quite a nicely controlled working environment,
Jared! ;)
But your example does bring up a question: For TEMP and RBS LMTs, does the
Goldilocks Rule (128K/4M/128M uniform extents, post version 7.x) follow? I
had created my TEMP and RBS with 1MB uniform before knowing
FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM
tablespace.
(In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe on
dev and sandbox databases).
If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM
rollback) or temporary segments and the
Dan,
That's exactly, what someone described yesterday, it was LMT
with autoallocate, and they made sure, that there was plenty of space on the
hard drive for TEMP file to grow.
The only difference: it was not Solaris - it was
AIX.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original
I'm asking this for my counterpart he posted it on the message board, I'm
seeing if we can get abetter responce from the mailing list
We currently have oracle applications 11.5.7 installed on a single node. A
secondary server has been setup to run the forms. Metrics server and client
have been
I use AUTOEXTEND and it has been extremely helpful to me in managing growth.
However, my policy is not to use autoextend for SYSTEM, rollback tablespace,
or temp tablespace.
SYSTEM (for me) is relatively stable. The only time I have significant growth
in SYSTEM is during an upgrade. For
Jesse,
I did the same thing last week on our sandbox system using the method others
have prescribed. There is a note 140913.1 covering a LMT bug in 8.1.6.
under OpenVMS. You might want to double check to make sure no equivalent
problem exists on your platform.
Ron,
As Jared pointed out, it's
Has anyone heard when Oracle will be releasing version 10i?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pall, Tom [Contractor]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
Sounds like a bug.
If SharePlex gets an error applying SQL to the target, the table should
get marked out-of-sync and Shareplex should go on it's merry way.
Call Shareplex Support - they are usually very responsive.
- Jerry
-Original Message-
Sent: Thursday, November 07, 2002 11:35 AM
I heard that the white paper has not yet been published internally...
-Original Message-
Sent: Thursday, November 07, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Has anyone heard when Oracle will be releasing version 10i?
--
Please see the official ORACLE-L FAQ:
Title: RE: System Tablespace and Autoextend
I have read complaints about SYS.IDL% objects having PCTINCREASE 50 and
space problems when they extend, in the forums. I went to check and
mine are already set to 0 along with 2147483645 MAXEXTENTS. I created
a TAR and verified with Oracle that
FWIW, what we just implemented (because senior management refuses to approve
additional storage on the grounds that making the database larger will
affect performance - aaargh!) is
1) Confirmed with business how long data needs to be online for various
tables (they're all partitioned so that
Actually what I have heard is that nothing has been published externally.
Oracle recommends to contact sales rep on info concerning
future releases
Rick
Wong, Bing
Are you done with 9i? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 07, 2002 1:09 PM
Has anyone heard when Oracle will be releasing version 10i?
--
Please see the official
The day we all finish upgrading our databases to 9i.
Sunil Nookala
DBA
Dell Corp.
-Original Message-
Sent: Thursday, November 07, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Has anyone heard when Oracle will be releasing version 10i?
--
Please see the official ORACLE-L
Jay,
just make sure you are not around when, after several Oracle upgrades, and
they want to import one of these files back that they discover that the
current release of import can no longer read the older version of the .dmp
file.
now what are these senior damagers going to do? blame the DBA,
10M? Hardly. That was just a test script to make sure
the syntax was correct. 10m just happens to be created
very quickly.
The sort_area_size equal or be a multiple of your TEMP
extent size.
Jared
On Thursday 07 November 2002 09:18, Jesse, Rich wrote:
10M temp TS? You must have quite a
Heck, Would you people kindly give some of us time to get fully up on 8i first!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 11/7/2002 11:08 AM
The day we all finish upgrading our databases to 9i.
Sunil Nookala
DBA
Dell Corp.
Greetings all -
I've had 3 of the several databases I run crash in the past 2 months
without producing any logs or dumps. I have BACKGROUND_DUMP_DEST, etc.
set. What else can I set so that Oracle is more verbose when it
encounters a problem?
For instance, today, some users filled up the
Mike,
Perhaps the reason that I was confused is that I did not phrase the
question correctly. If you create a tablespace to be used as the
temporary tablespace for users and create it as type temporary (
segments used by implicit sorts to handle order by clause) you can not
use the LMT clauses.
Title: RE: RE: When will Oracle 10i be out?
8i? You luck dog. I'm still trying to get about
15 systems up to 7.3 (from 7.2)
Matt Adams - GE Appliances - [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002
I just
manually expanded the file and the index build finished with no problem. I also
set the USER_DATA ts as autoextend and it extended several times without error.
The only difference is in the fact that the INDEX segment is initially created
as a TEMP segment. Interesting
Title: RE: RE: When will Oracle 10i be out?
Guys,
To
save time we thought we could simply copy Oracle from one host with version
Solaris 2.8 to another host with version 2.6. The error we are getting
is:
ld.so.1: svrmgrl: fatal: libgen.so.1: open failed: No such file
or directory
Killed
I create a table to store user account information and set userid column
to be primary key. I now want to set username to be primary key instead
of userid, how do I change it? There are couple hundreds of records in
table. Please advise.
Thanks,
David
--
Please see the official ORACLE-L FAQ:
Paula - When you say you copied Oracle from one host to another, what do you
mean? Did you copy the Oracle data files or the Oracle binaries? I am not
familiar with those two Solaris versions, and you didn't say which Oracle
version this is, but you might check the certification matrix to make
Title: RE: RE: When will Oracle 10i be out?
I
tried a relink and I think that fixed it.
-Original Message-From: Stankus, Paula G
Sent: Thursday, November 07, 2002 3:18 PMTo:
'[EMAIL PROTECTED]'Subject: RE: Issue on disaster
recovery
Guys,
To
save time we thought
Title: RE: Issue on disaster recovery
It was Solaris 2.8 to Solaris 2.6 and I copied the Oracle binaries and datafiles for one database a small one. It does save time and relinking did seem to resolve the issue as relinking with the new version of Solaris caused Oracle to point to the correct
David - First, export the table the way it is now. Next, what are the
end-user implications of this change? Are users querying this?
Adding/changing records? Do you have applications that depend on this that
must be changed at the same time? The simple answer is to alter table drop
primary key,
Update... I tried the same test with 8.1.7 on Solaris 8. Same
result...
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 1:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Space management failures on autoextend
Nguyen, David M wrote:
I create a table to store user account information and set userid column
to be primary key. I now want to set username to be primary key instead
of userid, how do I change it? There are couple hundreds of records in
table. Please advise.
Thanks,
David
David,
Hi
How to check which are those functions/procedures/packages etc applications
are using more frequntly?
THx
-Seema
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
You'll have to open the report using Oracle Developer (Reports). If it is
on Unix I usually ftp it to my local workstation and open it there.
Jay Miller
x48355
-Original Message-
Sent: Tuesday, November 05, 2002 1:13 AM
To: Multiple recipients of list ORACLE-L
definition file)
Can
Title: RE: Changing column format
David,
I suggest that you don't. There are many Jim Jones in the world. How are you going to handle that? Is this field really your primary key and related to other tables or do you just need to make sure there are no duplicate names? If so, create a
Hi List,
We are facing with some CPU problem (cpu 100% usage!), Just want to get some
idea from you guys, any clue what can cause this problem:
Here is a copy of some part of ora.ini
This happen during usage of some long query with subquery, this can be the
cause of problem or just some wrong
Thomas, Jay
Here is my thought for your consideration, evisceration. A fundamental
principle of backup and recovery is that you can only consider a backup to
be good if you've tested a recovery. Why not apply this principle to data
archiving? In other words, when you upgrade to a new Oracle
maybe temp segments don't cause an autoextend?
at least it's consistent
--- Fink, Dan [EMAIL PROTECTED] wrote:
Update... I tried the same test with 8.1.7 on Solaris 8. Same
result...
-Original Message-
Sent: Thursday, November 07, 2002 1:09 PM
To: Multiple recipients of list
David,
First, check the username column to insure that there are no
duplicate entries. If there are, you cannot make it a primary key.
Second, remove the current primary key constraint as there can only
be one primary key constraint per table.
Third, create the new primary
You don't need to rebuild when a datafile is added. Once the recovery fails
you just issue the create datafile command on the standby.
Jay Miller
-Original Message-
Sent: Tuesday, November 05, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
2k
First off, your process is doing a
Title: RE: Changing column format
1. Backup Table
2. ALTER TABLE user DROP PRIMARY KEY CASCADE;
This will drop the constraint and delete all foreign key relationships
to userid.
3. ALTER TABLE user ADD CONSTRAINT username_pk PRIMARY KEY (username)
USING INDEX TABLESPACE USER_INDEX;
This
David,
You can alter table drop constraint to get rid of the current pk and
then create a new one using the column you desire.
Ron
[EMAIL PROTECTED] 11/07/02 03:33PM
I create a table to store user account information and set userid
column
to be primary key. I now want to set username to be
David
Try this...
alter table tablename drop primary key;
alter table tablename add constraint tbl_pkey primary key (username );
Viral
From: "Nguyen, David M" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Changing column
Hello fokls. First, I do not and have never worked for Oracle. I thought I'd show you
some funny and interesting comments from the Oracle source tree that I've been made
privy to. Here is today's installment.
/* retch, gag, choke. If this bit is off, oracle doesn't break/reset
Well, if worst comes to worst we can always install an earlier version on a
box and import it there.
But the reason we can't get more storage approved still has me shaking my
head...
-Original Message-
Sent: Thursday, November 07, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Hamid - Does the system performance become sluggish for other users during
this time? My offhand guess is that the subquery is repeatedly scanning data
blocks it has loaded in memory. Have you used EXPLAIN PLAN? Can you run
STATSPACK during this situation? Or if you find it easier, examine
Does the SORT_AREA_SIZE not being a multiple of TEMP extent size have that
much impact if disk sorts are only 0.03% (3/100ths of 1 percent) of total
sorts? My numbers are according to V$SYSSTAT.
What resource is affected? Disk? Memory? CPU? Beer?
Rich
Rich Jesse
Right. Stand-by is exactly what you are trying to simulate. The archive logs
will reproduce 99% of what happens in the production environment. In
addition, it will provide for a quicker recovery.
AT
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients
Title: RE: Changing column format
I
believe "username" herewould be a unique identifier. In most
systems, username must be unique (at least within a particular domain). If
yours is a single domain system, David, then having two Jim Joneses would not be
the problem.
There is another,
more
Hamid Alavi wrote:
Hi List,
We are facing with some CPU problem (cpu 100% usage!), Just want to get some
idea from you guys, any clue what can cause this problem:
Here is a copy of some part of ora.ini
This happen during usage of some long query with subquery, this can be the
cause of
Hi Seema,
V$db_object_cache has a column called executions.
John
Seema Singh wrote:
Hi
How to check which are those functions/procedures/packages etc
applications are using more frequntly?
THx
-Seema
_
Protect your PC - get
http://computerworld.com/hardwaretopics/hardware/story/0,10801,75700,00.html
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services--
1 - 100 of 116 matches
Mail list logo