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.
H
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
> cor
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 immedi
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 R." <[EMAIL PROTECTED]>
> 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:
> Sub
> If you use it, ask me for the patch.
>
> Jared
>
>
>
>
>
> "Poras, Henry R." <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>
>
> 01/02/2004 10:54 AM
> Please respond to ORACLE-L
>
>
>
>
: Multiple 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, sa
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 dat
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
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 ju
Multiple 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 oc
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 a
t; <[EMAIL PROTECTED]>
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
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 periodically
of list ORACLE-L <[EMAIL PROTECTED]>
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 sit
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: http://www.orafaq.n
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 for
¡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, 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
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 databas
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 so
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 d
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: Frida
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
'dbms
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 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
'dbms_session.close_database_link' procedure (that is what they claim!!).
We want to track the call to the database link and
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
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 doi
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 mecha
t; From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 02, 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 NOR
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 c
ies that perform full table 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:
>
>WO
that perform full table 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:
>
>W
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
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 re
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 on
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 1m
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 Messa
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
ginal 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
es 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
:)
-
ng 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,
(correct?).
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
: (bcc: Rachel Carmichael) |
| Subject: 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. T
nal 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-
#x27;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,
(correct?).
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&
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
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 co
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.
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 p
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 prov
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:
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 m
ld try to make 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 P
ECTED] <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Tuesday, February 05, 2002, 10:36:27 AM
> Subject: testing freelists
>
> ===8<==Original message text===
> Robert,
>
> Simulating the problem and proving
> 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 acc
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 th
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 lea
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" wan
erman,
Edward" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Testing
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:
ber 30, 2001 12:40 PM
>
> 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
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
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
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 Internet
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?
>
&
y 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 input (keystrokes/mouse clicks),
allow scripting, simulate multiple
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
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 yest
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 http://exp
sday, July 26, 2001 9:29 AM
To: Multiple 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
AM
To: Multiple 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 wo
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 C
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
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
-
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 is
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: Sherman
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
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
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
92 matches
Mail list logo
