Hi
Those are the times to get the reply from the remote machines back.
10 msec is the fastest (at the moment) but may depend on network as well.
Jack
Seema Singh [EMAIL PROTECTED]@fatcity.com on 15-01-2002 21:40:26
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To:
May I please have a copy of this paper?
Thanks
-Original Message-
Sent: Wednesday, January 16, 2002 00:38
To: Multiple recipients of list ORACLE-L
Hi,
WAFL is Write Anywhere File Layout...
Its the file lay out used by snapshot supported storege Devices(NetApp
Storege Etc), This
Hello All
We are now in the process of adding LDAP to oracle 8.1.6.
I had a talk just yesterday with a guy that works on LDAP.
he said: NT LDAP has problems. Better go with OID or Novell LDAP.
1) For your knowledge.
2) Can anybody share their own experience on the subject.
Thanks
Yechiel
I think that you just run into :
RAIC: Redundant Array of Independent Consultants.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Wed, January 16, 2002 2:01 AM
To: Multiple recipients of list ORACLE-L
This seems strange.
Can you catch all the session duet(imp prompts and you answers) and post
them in the list?
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 15, 2002 10:05 PM
To:
The ora-600 12333 occurs in the two task layer, if it receives a function
code or argument, that is unexpected or invalid. Normally,the arguments
after [12333] identify some details about this, and there are a few metalink
notes relevant. The 12333 will always be followed by an ora-3106.
In
I thought about it, but there are many update programs
and my first inclination is to leave the design as is.
We are talking about PORTING application and I do not want
to add design changes as well.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From:
$)CYes.
Look at the list of required init.ora settings to be applied after
migrating/upgrading
an Apps 10.7/11 database to 8.1.7 when upgrading to Apps 11i !
[pasting from the Apps 11i Upgrade manual]
Set init.ora file parameters
In your init.ora file, set the following parameters to the
If you are using 8i , you can setup Resource Manager. For more info about
this subject see Oracle Administrator´s Guide.
HIH,
Antonio Belloni
Carle,
Hi All,
I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database
I have created the catalogs and registered the database with the catalog.
I than mad a full backup of the database TEST2 (is in Archivelog mode)
with
Since EMC took over MAMBA seems to have disappeared ... any ideal where to
get hold of the copy for eval (if it is still available?)
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
'instead of' trigger on he view may help with inserts/updates.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 4:05 AM
I thought about it, but there are many update programs
and
Andrea,
Designer 6i is the newest one - release 3. You can actually download it
from OTN. Designer2000 was renamed to 6i after the Y2K hysteria calmed down
(and Uncle Larry got on his i bandwagon).
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Hi Andrea,
Designer 6i is the latest release of the Designer products. I would
recommend you learn this release. Designer 2000 is probably still
in use in a FEW places, but little new work should be done in this
release.
John
[EMAIL PROTECTED] wrote:
Hi,
Is Designer 2000 and Designer 6i
Jack,
What is the status of your target database?
Try having it in startup mount status rather than startup open.
The other thing you should do is to backup your control file (using Rman)
with every database backup. I do this as my last step with every backup so
that the latest changes
Hi List,
I'd like to take the opportunity to ask if any of you would be interested in
testing a copy of a new tool that is available through Cool-Tools (from a
company called Net2000 Ltd. run by another of our list members Dale Edgar)
*free of charge*. We are looking for people to test it out,
I believe that the only way to see that information is to do an alter
database backup controlfile to trace
as it is stored only in the controlfiles. This was true in 7.3 and 8.x
--- Sinard Xing [EMAIL PROTECTED] wrote:
Hi all,
Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ?
Yes,
There is an article on moving to CBO for 11i by
Ahmed Alomari where there is a discussion on the mentioned
parameters.
Also 3-4 of these undocumented parameters are infact documented in the
oracle documentation (which metalink has promptly dissociated itself with)
!!
I believe OID is licensed seperately - it is for Oracle 9i Enterprise Edition.
On Tuesday 15 January 2002 04:01 pm, you wrote:
Hi
Does Oracle8i come with any built in LDAP functions or
do you have to write your own functions to search and
update an LDAP directory?
Does the Oracle Internet
Alas, the last time I looked, the OTN download for Designer was missing.
The latest is Des6i release 4, which it said was 'coming soon'
Simon Anderson
Andrea,
Designer 6i is the newest one - release 3. You can actually download it
from OTN. Designer2000 was renamed to 6i after the Y2K
What version of the database are you using? My info here is based on 8.1.7.
I connect to my databases as internal to do the backups. I fire up RMAN with either
one of these commands:
rman target / catalog rman/rman@test1 (SID must be set correctly)
rman target internal/pwd@test2 catalog
I keep getting the following error while trying to install Oracle 8.1.7 on
my NT server.
There is over 1G of freespace on the drive. If I say ignore, the installer
continues to run.
Any ideas?
Error in writing to file c:\winnt\system32\ctl3d32.dll
Ron
--
Please see the official ORACLE-L FAQ:
From Metalink NOTE: 155416.1
QUICK INSTALL OF OID 3.0.1
-
Oid 3.0.1 is bundled with Oracle9i Enterprise Edition on the
latest cd pack.
NOTE:
OID 3.0.1 part of 9.0.1 CD PACK is under special licensing
for a 2 USER license for strict use with 9i single signon
Designer 4 is here since some monthes, you have to download patch 4a from
metalink.
Tamas Szecsy
-Original Message-
Sent: Wednesday, January 16, 2002 14:45
To: Multiple recipients of list ORACLE-L
Alas, the last time I looked, the OTN download for Designer was missing.
The latest is
Much of this is controlled through Oracles
SQL*Net product. It needs to be
configured. It also depends on
what version of the database you are using. Oracle8.0/8i and beyond have mechanisms called profiles
(oracle7 had them as well but didnt work well) that can assist in dead connection
Ron,
Does the dll already exist from a prior install failure? If it is NOT
an NT dll then move it to another location and try the install again.
Check the permissions and ownership on the file and make sure that you
can overwrite it.
Ron,
ROR mª¿ªm
[EMAIL PROTECTED] 01/16/02 09:10AM
I keep
They are just different tools of the same product and not
one I would choose to learn if all I wanted to learn was
data modeling.
It is a tool that is best used for the complete life cycle,
from process modeling, all the way to generating your code.
Unless you are committed to doing that (with
I get a lot of those when installing on NT. I usually go into explorer,
rename the existing file to .old and hit Retry and the install continues on.
Sometimes that won't work if the file is truly locked by another process.
In that case you have to find who has locked the file. I use the
Is there a way to specify a custom font size for Forms 6i hint text
associated with a field?
I notice that it is possible for ToolTips, but not for Hint Text.
I just posted to the ODTUG listserv but usually they reject my e-mails
because I am not a member.
Regards,
Patrice Boivin
Systems
Hi,
Okay, this is the second time this has happened and while I have a guess I'd
appreciate any feedback on the issue. Last night during a direct load to
one of our datawarehouse tables 4 of the index partition rebuilds failed
with the following errors (the remaining partitions were fine, as
Hi!
Oracle 8.1.7 on AIX, on EMC discs boxes which are synchronized with SRDF.
At the target site, we have BCV volumes. We want to open reporting database
on a daily basis. Now we can open target database with the same AIX volume
group as the primary database.
My question is do you have
I have always used US7ASCII character set. I am creating a new server and
database for an existing production application and I was wondering if I
should be using one of the newer character sets. Is there a newer character
set that would still work with the old application data?
Ron Smith
--
Title: RE: Oracle Performance monitoring tools.
What's the current price tag of Quest's Spotlight?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Thus spake the master programmer:
Let the programmers by many and the managers few,
Then all will be productive - The Tao of Programming
Remove the word execute. Within PL/SQL you do not need EXECUTE. That is a SQL*Plus command.
Thank You
Stephen P. Karniotis
Technical
Alliance Manager
Compuware
Corporation
Direct: (248)
865-4350
Mobile: (248)
408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
Sonja,
that is a very interesting question.
I have tested the source/target scenario under Digital Unix.
We did come across a command that allowed you to mount the devices with the
same name on the same server
with a mount /ignore(?).
There may well be a ruse to rename the whole battle ship.
It
One thing to consider is adding a field to the table for the three positions
and have a trigger fire to insert the substr from the other field. It will
slow things down, but would give you the field needed to do the partioning.
Terry
-Original Message-
From: [EMAIL PROTECTED]
I need to execute a procedure with in
a loop of another. I need to pass a variable to the second
procedure. I am using Execute, looks like this:Execute
Primus_Dump_TEST_2(Solution);
Getting this error:PLS-00103:
Encountered the symbol "PRIMUS_DUMP_TEST_2" when expecting one of the
Hello gurus,
I have a query which seems to have a mystery cartesian join in it and I
can't seem to locate it. I would definitely appreciate some help if
possible. My view doesn't have a join associated with it and it appears
that I have the correct number of joins for the number of tables I am
I believe you don't need the execute within pl/sql
--- Lance Prais [EMAIL PROTECTED] wrote:
I need to execute a procedure with in a loop of another. I need to
pass a
variable to the second procedure. I am using Execute, looks like
this:
Execute Primus_Dump_TEST_2(Solution);
Getting
Lance,
just remove the word 'execute'
-Original Message-From: Lance Prais
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002
10:57 AMTo: Multiple recipients of list ORACLE-LSubject:
Calling a procedure from a procedure
I need to execute a procedure with
in a
Dont use the execute.
Primus_Dump_TEST_2(Solution);
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Lance
Prais
Sent: Wednesday, January 16, 2002
9:57 AM
I am working up a script to run the dbms_stats.gather_database_stats()
procedure and have run into something for which I haven't yet found an
explanation.
Maybe someone here can tell me why I can run dbms_stats.gather_database_stats
from Python like this (Perl would be similar, I believe,
Title: Message
I am looking for
some guidance from people who use this product. Is it a value add to the
organization or not. If possible also let me know how in the hell does it do a
online object extraction from the backup.
Would appreciate all
your comments and recommendations
Thx
Unless you have the need to support other languages other than English or need to
support characters
like the Euro, don't bother. You would not believe the pains we are having here
trying to get UTF8
working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other
listers
It was a good product when owned by Data Tools.
It is now owned by BMC, and the support is poor.
My experience with this tool is as of December 2000.
As far as object extraction, it did not work as of
December of 2000. They had been claiming that it
would for some time, but the DBA in
It's impossible to precisely determine where the cartesian
product is coming from with out knowing the primary keys
of the si_monitor and sm_log_type slt tables.
If your join does not include all columns
of the parent table(s), there is the possibility
of a cartesian product. ( it's data
And interestingly enough, a DBA could be much more productive
with CASE 5.1 and Forms 3 than would ever be possible on the
GUI versions.
Jared
Kimberly
Glenn,
I believe that CALL needs to be terminated with a semicolon.
Jared
Glenn Stauffer
Reed,
Please reply to the list as well.
I don't seen any key information here.
And taking a closer I caught the part about this join
being done on views.
Joining views can be problemetic. You need to ensure
that the joins in a view ( if any ) are correct, and that all
columns of the
We use WE8ISO8859P1 as a corporate standard for all databases globally with no
problem. Haven't tried UTF8 yet though.
Jim
Ron Thomas [EMAIL PROTECTED] wrote:
Unless you have the need to support other languages other than English or need to
support characters
like the Euro, don't bother.
Thanks Kirti and Paul for the reply.
The instance is up for only 3 days. We know there are
very heavy inserts in the database.
Yes, There are high waits for 'buffer busy waits'
event in V$SYSTEM_EVENT view. But I didn't see 'buffer
busy waits' in V$SESSION_EVENT. I may try to increase
the
Title: RE: mystery cartesian join
are the joins themselves correct?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: mystery cartesian join
It's impossible to
This may be a STAR schema execution plan where Oracle joins dimensions and
use Nested loop + index to join it to the fact.
Some times it's very efficient but if you do not like it I think there is a
parameter in init.ora that disables it.
Regards,
Waleed
-Original Message-
Sent:
Ron,
Can you elaborate on the pains you are having getting UTF8 working
correctly?
We are preparing to convert some databases to UTF8. I'd appreciate any
specific details that you can provide.
We are using 8.1.7.2 and 9.0.1 on Sun Solaris 2.6.
Cherie Machler
Oracle DBA
Gelco Information
*warning*
if using the following material on human subjects, do
not get in ears of damagers, they are usually already
obstructed beyond repair, but in case some use of the
ears can be redeemed, the use of said product would
simply make the effort to get damagement to listen
all that much harder.
We have been using it for about 5 years on both Unix and NT. We have it
connected to Netbackup to handle the tapes. We love it. I agree that the
support is not what it used to be but we hardly ever need support.
Although, the last time we called we got a support person that knew more
about
Reed,
What is the structure of the SI_LOG table (the one being accessed by the
view).
Furthermore, what is a MERGE JOIN CARTESIAN - anybody? I am thinking that
this is normal, in that the query was broken up into two distinct parts, and
the results of those parts should be MERGE JOIN CARTESIAN
Title: RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?
Since I didn't see this yet, I thought I might add it in.
Try increasing the PCTFREE, perhaps there are two many transactions happening in the same block, and oracle is locking the entire block until the other transaction if
Here is the structure of the underlying base table si_log table. I also do
not know what a MERGE CARTESIAN JOIN is. The data returned is correct and
the tkprof output looks OK except for the elapsed time the query took and
the cartesian join portion.
desc si_log
Name
Hi all
I am looking for some real life opinions about Oracle raw I/O - are
people using it, is there really a performance gain? Any other pros,
cons?
I have seen some info on Metalink but real life often is quite
different...
Thanks
Witold
==
Witold Iwaniec
Chris,
You should see the waits in V$SESSION_EVENT as well, as these are rolled in
to the V$SYSTEM_EVENT. You have to query V$SESSION_EVENT when these thread
are active. And you will have to query it repeatedly as it reports waits as
and when session encounters some.
I would also consider the
Given-
- Oracle Applications 11.5.4
- HPUX 11.0
- Support for English, Brazilian Portuguese, and Simplied Chinese required UTF8
- DB, forms, reports, and Apache servers all run with NLS_LANG=American_America.UTF8
Problems-
- Any Oracle reports generated require printing via a utility called
Real life opinion from me:
Yes, Oxford is using it. Yes, it is faster. Yes it makes it practically
impossible
to backup without a 3rd party backup tool. Yes, it is boring to chew raw
vs. cooked
debate over and over again. Why doesn't someone come up with something new
and not yet discussed topic
Title: RE: mystery cartesian join
Maybe the optimizer thinks there's a many-to-many relationship between si_log
and sm_monitor? Try putting in an ORDERED hint and see if that helps.
Jeff T.
-Original Message-
From: Kempf, Reed [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January
A MERGE CARTESIAN JOIN is one of the new paths the optimizer can take in
Oracle 8(i?)
If you really, truely are not missing a join clause, the following may be
what is happening
Basically, what Oracle does is perform a cartesian product (CT) on 2 tables
via a merge-join operation.
I would like get your opinion on what would be the best way provide access
to data across multiple databases on just on Node (database).
One way that I have tried is create a view on one database that reads tables
across remaining four databases using Dblinks. Let us say there is a table
called
There is also a problem with 8.0.5 Client software not being
happy with the ISO8859 part 15 characterset. The symptoms are
that of either not displaying certain characters or displaying spurious
chars
(whatever is in the given code page for the given value from the
database...)
The only thing
Hey now, be nice :-). The best thing is to point people towards
the archives.
Martin
http://oracle-rescue.com
-Original Message-
Mladen
Sent: 16 January 2002 19:57
To: Multiple recipients of list ORACLE-L
Real life opinion from me:
Yes, Oxford is using it. Yes, it is faster. Yes it
Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ...
I have been asked a simple question, and I am stumped ...
Given a set of users, how to calculate the load they are putting on the
system when using our application (CPU, MEMORY etc).
We have 8161 running on DGUX (yeah, I know ...)
That was me who made that statement about prepared statements being faster than stored
procedures. It was not a general statement.. As my e-mail states, we have done some
testing. Our test included inserts into more than 10 different tables on different
system configurations (Sparc
Hey guys you have not heard about STAR SCHEMA execution plan?
-Original Message-
Sent: Wednesday, January 16, 2002 1:48 PM
To: Multiple recipients of list ORACLE-L
This may be a STAR schema execution plan where Oracle joins dimensions and
use Nested loop + index to join it to the fact.
Its a great product for the price. I have used it in and out for 5 years
internationally and truly it is the best backup/recovery product we have.
There are some pros and cons to using the tool:
Pros:
1. Great product, works brilliant works all the time.
2. Upgrades are simple.
Cons:
1.
Ron,
Thanks for taking time to provide this detailed reply. It is quite
helpful.
Cherie Machler
Gelco Information Network
Ron Thomas
Thanks for the insight. I will rewrite my query to not use the view and see
if the optimizer is more friendly with the execution plan.
Thanks also to SteveO for the rewrite idea.
ReedK
DBA from Montana
-Original Message-
Sent: Wednesday, January 16, 2002 1:04 PM
To: Multiple
Raj - I found your question a bit unclear. Did you mean:
- For 10 users, our application requires 50% of a 300-mhz CPU
- There are two groups of users on the system. How do I figure out how many
resources group A would use.
I just thought you might get better assistance by clarifying your
List,
If we use partitioning for a big tables after finish development, do we have
to change the code for accessing diffrent partition or this will handle by
oracle itself.
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any
Hi,
Oracle 7.3.4 on Unix.
The database has dozens of little lookup tables. I'd like to cache those
used the most. Is there a way to see how often a table is queried?
Thanks,
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
--
Please see the official
Dennis,
Actually we have N users on the system where N is a variable. Of that I have
a certain group of users, I need to monitor and see how much load they put
on the system.
The idea is out on N total users on the system, X number of users use only
one part of application 95% of the time
The latter.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Sent: Wednesday, January 16, 2002 3:07 PM
To: Multiple recipients
Hi
At time of export i am getting following error
EXP-8: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 6 with name R03 too
small
Please suggest
Thanks
-Seema
_
Chat with friends online,
Why in toad when I try to create a stored proc where I drop and create
a table I get the following error:
PLS-00103: Encountered the symbol "DROP" when expecting one of the
following:
begin function package pragma procedure subtype type
use an identifier a
All,
In trying to solve some Library Cache latch contention issues, I've been
stumped on the following issues:
1) Do freeable chunks get coalesced during an ALTER SYSTEM FLUSH
SHARED_POOL.
2) If freeable chunks are freed when a session disconnects, is there a way
to determine chunks per
You
need to use 'Dynamic SQL' in order to drop and create
tables.
-Original Message-From: Lance Prais
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002
4:36 PMTo: Multiple recipients of list ORACLE-LSubject:
procedure error
Why in toad when I try
Take a look at V$SYSSTAT. I'm not sure if it's the answer because your question
specifies a set of users. V$SYSSTAT includes all users not just a particular set.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 16, 2002
Raj - I don't know DGUX, but if the users each have their own system login,
the system administrator may be able to help. With forms, that may not help.
From my experience, there isn't any ready way within Oracle.
Another idea might be to sample the system load and number of users
for
It depends on what the meaning of the word unbreakable is ... Check
http://www.securityfocus.com/news/309
HTH
Raj
__
Rajendra JamadagniMIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
what do you mean the latter Jack
-Original Message-
Sent: Wednesday, January 16, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L
The latter.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin,
try changing CREATE OR REPLACE PROCEDURE Primus_Report
AS
Drop Table PRIMUS_TEMP_DUMP;
CREATE TABLE PRIMUS_TEMP_DUMP
to CREATE OR REPLACE PROCEDURE Primus_Report
AS
BEGIN
Drop Table PRIMUS_TEMP_DUMP;
CREATE TABLE PRIMUS_TEMP_DUMP
--
=
Peter
Jerry - If they are stored in separate tablespaces, it would be easy.
However, we DBAs tend to not keep small code tables in separate tablespaces.
You can dump v$sqltext to an O.S. file and search for these table names to
get an idea of how often they are used. On Unix, for example, grep can tell
DROP
and CREATE are DDL functions ... you have to use DBMS_SQL package or Native
Dynamic SQL (execute immediate) statement to achieve this.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 23:55
Hi
At time of export i am getting following error
EXP-8: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 6 with name R03
I have about 50 lookup tables in my database(we are in the middle of design)
just want to check with you guys if define all these lookup as IOT is there
any advantage also do I have to put all the Primary Key for these lookup
tables in separate Tablespace or NOT? asking for performance issue
Thanks Dennis, Ian,
Yes, that is another approach ... right now I am looking at what I can do
within Oracle. As for DB links, very little stuff goes across for this
application, so would not be a bottleneck right now.
Raj
__
Rajendra Jamadagni
Ok, you guys are really missing the support issue. :)
The support is very bad. Yes, you don't need it often.
But when you do need it, they don't have it.
SQL*Backtrack is normally run as a menu to the
back end tools. As I recall, even most of the commands
used in cron for scheduled backups
Peter,
That won't work either.
DROP and CREATE commands can only be executed in a
procedure via dynamic SQL.
Such as the older DBMS_SQL package, or the newer and
much easier to use EXECUTE IMMEDIATE.
Jared
Try putting in an ORDERED hint and see if that helps.
Good call!
The following link is a discussion of a similar nature, and the cartesian
product
was eliminated through the use of the 'ordered' hint.
Use database auditing.
Lookup 'audit' in the SQL manual.
Jared
Whittle Jerome
Title: RE: How to calculate user load on the system
Database Load ... is the main target at this time
...
Thanks
Tony,
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
Title: RE: How to calculate user load on the system
Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)?
Tony
Seema,
The ORA-1555 snapshot too old occurs when export tries to construct a read
consistent view of your data from rollback segments, which has been
overwritten or reused for new transactions.
Other sessions are updating data while the export is running in consistent
mode (using consistent =
1 - 100 of 117 matches
Mail list logo