Well, I think I forget the alter system switch logfile before shutdown
and after restart. I'll try that n let you all know the result.
Regards,
Wendry.
-Original Message-
Sent: Tuesday, January 13, 2004 6:07 PM
To: Wendry
Nothing major amiss there, that is exactly what I do.
Thank you for your reply,
Yes, you're quite right, I think the archive next to the cold backup is
corrupted. The hot backup is always succeeded. But I wonder why is my
cold backup is largely end up with internal error or corrupted archive
log files.
All I do for closed backup is shutdown
Are you certain that SHUTDOWN IMMEDIATE succeeded? There are lots of bugs
in MetaLink where it hangs or fails with ORA-00600...
on 1/12/04 7:04 AM, Wendry at [EMAIL PROTECTED] wrote:
Thank you for your reply,
Yes, you're quite right, I think the archive next to the cold backup is
Jared,
Are
you talking about yapppack? I've been using that for a while (nice display.
Though like statspack it is system wide so I usually just look for high level
stuff and changes). Not aware of a patch though.
With
most peoplesoft applications I have seen, the bottlenecks aren't
recipients of list ORACLE-L
Henry,
Sar is a better tool than vmstat/iostat as it collects a broad range of
information. Specifically, sar -q should show up CPU queueing and swapping,
and sar -v will show up file/process table overflow issues that may occur
during stress testing. IMHO, sar is quite
AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:stress testing
We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris
system starting next week
]
cc:
Subject:stress testing
We are planning on running some stress tests on a
PeopleSoft/Oracle/Solaris
system starting next week (using LoadRunner). I have never gone through a
formalized stress test before (most of my stress is brought about
informally
Hi Tim
Tony Jambu here. Saw your posting to Oracle-l with regards
to your sp_vmstat.sh script. I am not sure if know but
I write a regular hints tips column for Select Journal.
I read your article and would like to mention your script and
point people to the script. Do you mind if I mention it
Henry,
I use the attached shell script to gather and store VMSTAT information in a
custom table within the PERFSTAT schema (i.e. schema belonging to
STATSPACK). Allows for some nice reporting over time, rather than
anecdotal here-and-there observations. Should work OK on Solaris, HP, and
Linux.
We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris
system starting next week (using LoadRunner). I have never gone through a
formalized stress test before (most of my stress is brought about informally).
So far I am planning to gather statspack information, and
]
Sent by: [EMAIL PROTECTED]
01/02/2004 10:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:stress testing
We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris
system starting next week (using
Henry,
Sar is a better tool than vmstat/iostat as it collects a broad range of
information. Specifically, sar -q should show up CPU queueing and swapping,
and sar -v will show up file/process table overflow issues that may occur
during stress testing. IMHO, sar is quite underutilized ( had
recipients of list ORACLE-L
Subject:RE: stress testing
Henry,
Sar is a better tool than vmstat/iostat as it collects a broad range of
information. Specifically, sar -q should show up CPU queueing and swapping,
and sar -v will show up file/process table overflow issues that may occur
during
And when you're doing stress testing, make sure you load your system for
quite long time.
Stress testing shouldn't only verify system performance, but it should also
test system's reliability.
One of my clients had a problem with Oracle Apps, where they did a stress
test for just one hour
how come I never got email I sent to fatcity oracle
list? I sent to [EMAIL PROTECTED]
benny
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ:
]
cc:
Subject:testing
how come I never got email I sent to fatcity oracle
list? I sent to [EMAIL PROTECTED]
benny
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official
I think that www.2train4.com have a testing
tool.
also www.mercury.com have such a tool.
Yechiel AdarMehish
- Original Message -
From:
Baswannappa,
Shiva
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 06, 2003 5:30 PM
Subject: Testing tools for custom
Hi All
Gurus
My division is
pondering over acquiring automated testing tools for applications and
customizations made to the existing applications. Development is done using
almost 100% oracle tools barring O/S scripts in Unix/W2K, external C/C++
routines and some automation
¡Internet GRATIS es Yahoo! Conexión!
Usuario yahoo, contraseña yahoo.
Desde Buenos Aires, 4004-1010.
Otras ciudades: http://conexion.yahoo.com.ar/avanzados.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Diego=20Cutrone?=
INET:
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions. The
inst_id field looks like it would be useful only in Parallel Server
environments. Any other ideas?
I can't believe Oracle doesn't keep track of open
Sorry, no more ideas.
Allan
-Original Message-
Sent: Wednesday, February 26, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions.
The inst_id field
I think I spoke too soon.
The v$dblink view shows the db_links opened by the current session only.
I want to be able to find out the db_links opened by all current sessions
and the sids for the sessions. This way I can monitor all the application
instances that opened the db_link and those that
There is an underlying x$table named x$uganco that contains a column
named inst_id which is being filtered in the view_definition for
V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the
x$uganco should do the trick. Mind you there are no rows in there when
the links are not active
Dear Listers,
Oracle 8i HP-UX11.
We have a database link with a remote database which is accessed from the
application code. In the application code, a call is made to the
'dbms_session.close_database_link' procedure (that is what they claim!!).
We want to track the call to the database link
Charu,
The view V$DBLINK can show you if the link is in use.
select open_cursors, in_transaction
from v$dblonk
where db_link = 'mylink'
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 21, 2003 8:03 AM
Dear
V$dblink
-Original Message-
Sent: Friday, February 21, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Dear Listers,
Oracle 8i HP-UX11.
We have a database link with a remote database which is accessed from
the application code. In the application code, a call is made to the
Darn!!
I had taken a hasty look at 'Oracle 8i reference', before posting the query.
Not my day today.
Thanks Allan.
Regards,
Charu
-Original Message-
Allan
Sent: Friday, February 21, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
V$dblink
-Original Message-
Sent:
Hello
all,
Sorry
for this off-topic..i want to know what are the testing tools (like win-runner)
available and any good sites are there on the net from where i can learn
them...
Thanks and Regards,
Santosh
Varma
At a high level, I think the various pools operate in pretty
much the same way - but there are some differences,
some of which may be affected by various hidden
parameters.
For example, Steve Adams has this note (dated Oct 2000)
on his website as one of several observations on the 'new'
LRU
The reason that I consider it a problem is that I have increased the physical IO on
my database. I see Full Table Scans on these two tables, which are large tables
relative to the others. I moved them to they RECYCLE pool so that they would have
less of an impact on the DEFAULT pool. By
scans, then
checking the buffers to see what gets aged out. During my testing, it
seems like the first blocks to get into the RECYCLE buffer pool will
stay there. The following two tables are assigned to the RECYCLE
pool. No other segments are assigned to it:
WORK_ORDER_STEP - 428 blocks of data
. During my testing, it
seems like the first blocks to get into the RECYCLE buffer pool will
stay there. The following two tables are assigned to the RECYCLE
pool. No other segments are assigned to it:
WORK_ORDER_STEP - 428 blocks of data
ALRA_TRANSACTION_HISTORY - 14152 blocks of data
The RECYCLE
The 'problem' is, as you say, related to the tablescan.
Craig is correct that NORMALLY a full tablescan will
only permit a limited number of blocks to get into
the cache at the LRU end of the chain - the number
is typically the size of db_file_multblock_read_count.
There are a couple of special
, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Buffer Pool Testing
The 'problem' is, as you say, related to the tablescan.
Craig is correct that NORMALLY a full tablescan will
only permit a limited number of blocks to get into
the cache at the LRU end of the chain
I'm spending some time today experimenting with buffer pools in 8.1.7. I have two
tables that I have assigned to the RECYCLE pool. I have been running various queries
that perform full table scans, then checking the buffers to see what gets aged out.
During my testing, it seems like the first
Title: RE: Testing
We regret to inform you that your test has failed, please try again.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
hi, list friends:
I am interested in that
topic:http://www.ioug.org/ioug_s/repository_pkg.doc?v_tech_content_dtl_phy_id=7666
I am also considering whether too large rbs segment size does have adverse
impact on database performance. In my production (OLTP) i configured rbs to be
Zhu Chao,
Please be aware that rollback segments serve two major purposes:
* recover individual transactions (i.e. rollback)
* provide before-image information for read-consistency
The information you are getting from V$ROLLSTAT and STATSPACK is accurate at
measuring the first purpose
Anybody have experience with stress testing software for Peoplesoft? Links,
thoughts, comments etc...
Thanks,
Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
Gene Sais [EMAIL PROTECTED] wrote:
another suggestion:disable default roles.grant create session to all users.use application to enable roles with password.hth,gene [EMAIL PROTECTED] 08/09/02 01:58PM Why to find who and when. the best thing is to restrict the access.-Original
Just catching up after the long weekend here,
I have been under the understanding that if you are a development partner
then you are covered for all products for as many installations for
testing and development and learning purposes.
Is this wrong or changed ??
If not then it may be in your
We're planning to set-up some test servers here and I'm wondering what the
practice is out there regarding licences for same. This is only for short
term testing and to try out various DR scenarios etc. I'd guess there's
an Oracle view which would be if you install on server you pay a licence
is out there regarding licences for same. This is only for short
term testing and to try out various DR scenarios etc. I'd guess there's
an Oracle view which would be if you install on server you pay a licence,
(correct?). Is there some workaround for this?. All creative ideas welcome
Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of O'Neill, Sean
[EMAIL PROTECTED]
Sent: Friday, May 03, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Licences for testing
We're planning to set-up some test servers here and I'm wondering what the
practice
: Licences for testing|
|
We're planning to set-up some test servers here and I'm wondering what the
practice is out there regarding licences for same. This is only for short
term testing and to try out various DR scenarios etc
Last time I checked Oracle on Linux is free if it's used for testing only.
If you don't mind using Linux (we use it extensively) it could be a viable
option.
--Walt Weaver
Bozeman, Montana
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 7:43 AM
To: Multiple
there regarding licences for same. This is only for short
term testing and to try out various DR scenarios etc. I'd guess there's
an Oracle view which would be if you install on server you pay a licence,
(correct?). Is there some workaround for this?. All creative ideas welcome
term testing and to try out various DR scenarios etc. I'd guess there's
an Oracle view which would be if you install on server you pay a licence,
(correct?). Is there some workaround for this?. All creative ideas welcome
:)
-
Seán O' Neill
Organon (Ireland) Ltd
Message-
Sent: Friday, May 03, 2002 7:09 AM
To: Multiple recipients of list ORACLE-L
We're planning to set-up some test servers here and I'm wondering what the
practice is out there regarding licences for same. This is only for short
term testing and to try out various DR scenarios etc. I'd
Hi,
We have an ETL script that logs onto the db. The scripts usually runs without
error. During pre-production testing, we rec'd a logon denied error message. We
re-ran the scripts and all was fine.
I did not see anything in the alert log, only message for today was a redo
Hi Charlie
Via SQL*Plus I get connected without any problem via SQL*Net.
When using the JdbcCheckup.java program,it sends back messages on whatever
has gone through and one of them is the notification that it has connected
successfully.
If you look at the program which as I mentioned earlier on
Hi all
I hope you can help me out with this.
I am running JdbcCheckup connection that comes as part of jdbc samples on
oracle 9.0.1
I am running win2k and I get the following error.Unfortunately I dont have
access to metalink.
Can anyone help me out .
Oracle 9i is the downloadable one on technet.
Can anyone recommend and low cost tool(s) for load testing a database
server? I looked at Quest's Benchmark Factory, but it doesn't provide
the flexibility I need in this situation I'm facing The $15K I was
quoted for the Quest tool is a bit pricey, so I don't believe more
expensive tools
The low cost testing tool that will do the job is called sqlplus.
Just develop your scripts and fire away
-Original Message-
From: Ed [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L
Subject: Load Testing Help Needed
Check out Craig Shalamahar site
www.orapub.com under tools. He got a free loadtesting
tool.
Cheers,
RS
Can anyone recommend and low cost tool(s) for load
testing a database
server? I looked at Quest's Benchmark Factory,
but it
doesn't provide
the flexibility I need
Ed wrote:
Can anyone recommend and low cost tool(s) for load testing a database
server? I looked at Quest's Benchmark Factory, but it doesn't provide
the flexibility I need in this situation I'm facing The $15K I was
quoted for the Quest tool is a bit pricey, so I don't believe more
what I should be seeing when that happens.
So I guess I should try to make this into a question hmmn...
Am I barking up the wrong tree?
-rje
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, February 05, 2002, 10:36:27 AM
Subject: testing
this into a question hmmn...
Am I barking up the wrong tree?
The right tree, but the tree doesn't understand barking ;-)
Anjo.
-rje
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, February 05, 2002, 10:36:27 AM
Subject: testing
Kind Regards,
Hatzistavrou Yannis
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hatzistavrou Giannis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
If you have opened this you obviously can't read. I'm just testing my new
address. You should have read that in the subject and deleted this. DO NOT
REPLY to this. If this message starts a thread then there are a number of
you who need to go back to elementary school and learn to read
I be not read, what be virus? tanks.
Rodd Holman wrote:
If you have opened this you obviously can't read. I'm just testing my new
address. You should have read that in the subject and deleted this. DO NOT
REPLY to this. If this message starts a thread then there are a number of
you
Robert,
Simulating the problem and proving the correction is an excellent idea.
One thing to consider when putting together your testing scenario is
that writes to the database block by a transaction are done in memory,
that is they are made to the cached database blocks.
An internal locking
I've got a database that I'm experiencing blocking locks on insert
statements into the largest, most active transaction table. The
freelists currently=1 and it's on a 4 CPU Sparc under 8.0.5 in a 24/7
environment.
I think this points to freelists needing to be increased. The powers
that be want
Subject: Testing
Sent by:
[EMAIL PROTECTED
It's vewy vewy quiyet.
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Testing to see if the server is working properly.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
It is
[EMAIL PROTECTED]@fatcity.com den 2001-11-30 10:40 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Testing to see if the server is working properly.
Jared
--
Please see the official ORACLE-L
Hi,
Could somebody tell me what all to be considered for testing the
efficiency of an Oracle database application ?
Thanks and Regards
Pradeep
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mario Brenes
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
!! Please do not post Off Topic to this List !!
ignore this message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Hi,
look for WinRunner. I think it does that stuff and is scriptable (of
course ;).
[EMAIL PROTECTED] schrieb:
Hello,
Apologies for an off-topic posting.
Does anybody have any positive or negative experience with any system
stress testing tools?
I do not mean DB stress testing (we
Hello,
Apologies for an off-topic posting.
Does anybody have any positive or negative experience with any system
stress testing tools?
I do not mean DB stress testing (we have software fot that) but a test
package for system with a fat GUI client?
Need something that would simulate user
or negative experience with any system stress
testing tools?
I do not mean DB stress testing (we have software fot that) but a test
package for system with a fat GUI client?
Need something that would simulate user input (keystrokes/mouse clicks),
allow scripting, simulate multiple users and record
Anita,
As you might have guessed from my poast earlier on the ORACLE-L, I
applied the 8.1.7.2.1 patch set to the 81715 EE server last night (this
morning).
It had no effect - still receieved the same ORA-00600.
I even set compatible=8.1.7.2.0 and bounced - no effect.
I was working from home
Hi DBA's,
I joined previously, but for some reason my membership was not activated.
I've joined again and I'm checking if my membership is registered now.
Regards,
Denmark W.
_
Get your FREE download of MSN Explorer at
ORACLE-L
regression testing?, heck we are the alpha/beta/regression testers :)
joe
[EMAIL PROTECTED] 07/26/01 10:35AM
This makes me wonder: what kind of regression testing is implemented by
oracle?
Trial and error? It makes me wonder, oh it makes me wander (Stairway to
Heaven
recipients of list ORACLE-L
regression testing?, heck we are the alpha/beta/regression testers :)
joe
[EMAIL PROTECTED] 07/26/01 10:35AM
This makes me wonder: what kind of regression testing is implemented by
oracle?
Trial and error? It makes me wonder, oh it makes me wander (Stairway
Testing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-Original Message-
Sent: Friday, 29 June 2001 10:11 AM
To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list'
Testing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services
Testing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hi,
We r building a application and need to specify the requirements of a
hardware for testing of its performance.
our performace metric includes mostly insert statements
10 million insert to 7 tables...then we have to execute some
procedures...then report.
our main concern
see? just a test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
I have used SelfTest Software in the past to prepare for
the OCP tests. Is there another similar company that is
as good or better?
Thanks,
Ken Janusz, CPIM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hello if there any testing tools for QA staff / developer to test on bulk
data which can measure it performance,efficient.of the
program/PLSQL/sqlscript ???
The function of the tools is , prepare bulk data , testing , generate
report .
If no such tools , what might be an advice
This is a test.
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Just testing, not understanding why I was bounced ;)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Dear Listers ,
I want to try using RMAN in just 1 machine with 2 databases ( client and target ) .
I have followed every single step in manual , but there's always error ...
Do we must run RMAN in 2 machines ?
Thank a lot in advance : )
=bambang=
Bambang Setiawan
--
Please see the
No, I backup databases on 3 machines using rman. Our recovery catalog
database is on our production machine and I backup my production databases
on that machine.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 3:20 AM
91 matches
Mail list logo
