: Snapshot too old during stress test... how to avoid
Try removing optimal setting, and shrinking RBS to the min extents (or
even below) before running
your tests.
- Kirti
--- Garry Gillies [EMAIL PROTECTED] wrote:
From memory (of a course attended looong ago),
Oracle recommends one rollback
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Snapshot too old during stress test... how to avoid
Try removing optimal setting, and shrinking RBS to the min extents (or
even below) before running
your tests.
- Kirti
--- Garry
Title: RE: OCP Test Order
to tell the truth the networking exam is basically some rote memorization and the questions are straightforward - I prepared while waiting 1/2 hour to take exam at most.
The performance tuning exam is what I have been told to immediately forget by some certifiable
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
in order to gather statistics and timing under worst case scenarios.
Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this
test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot
too old? I would think that 11GBs of rollback would be big enough
Hello:
I resently finished my 8i Backup and Recovery test and was thinking about
taking the 8i Networking testing before performance tuning. I was wondering
if those of you that have taken both test feel that would be an ok choice of
action or would taking performance tuning first be better
.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, June 02, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Hello:
I resently finished my 8i Backup and Recovery test and was thinking about
taking the 8i Networking testing before performance tuning. I was wondering
if those
You passed!! Ruth
- Original Message !-
From:
Scott Stefick
To: Multiple recipients of list ORACLE-L
Sent: Friday, March 21, 2003 4:28
PM
Subject: Test
This is a test, I have not received any messages in the last
couple of
days.-Scott
This is a test, I have not received any messages in the last couple of days.
-Scott
**
Scott Stefick
Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http
delete from oracle-l where subscriber = 'Gene Sais';
commit;
select count(*) from oracle-l
where subscriber = 'Gene Sais';
COUNT(*)
--
0
--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
Sunday, April 27 8:30am - 4:30pm - Problem
Multiple recipients of list ORACLE-LSubject: Re:
Test - Delete medelete from oracle-l where subscriber
= 'Gene Sais';commit;select count(*) from oracle-lwhere
subscriber = 'Gene Sais';
COUNT(*)--
0--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 O
Yahoo! Mobile
- Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
Yahoo! Mobile
- Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi,
This is test msg. pl. ignore.
srinivas
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: kommareddy sreenivasa
INET
Regards, Daljit
You can contact me at Office : [EMAIL PROTECTED] Res :
[EMAIL PROTECTED]
I have a user that is using the SCOTT test tables on one of our dev
databases. He is apparently missing the DEPT table.
Where are the scripts that create the SCOTT tables? I tried looking
through the on-line documentation and Metalink to no avail. Can anyone
point me in the right direction
Cherie:
Check $ORACLE_HOME/sqlplus/demo/demobld.sql
--Kevin
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, January 21, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L
I have a user that is using the SCOTT test tables on one of our dev
databases. He is apparently missing
are the scripts
located to create the SCOTT
[EMAIL PROTECTED] test objects
have a user that is using the SCOTT test tables on one of our dev
databases. He is apparently missing the DEPT table.
Where are the scripts that create the SCOTT tables? I tried looking
through the on-line documentation and Metalink to no avail. Can anyone
point me in the right direction
ORACLE-L
Subject: Where are the scripts located to create the SCOTT test
objects?
I have a user that is using the SCOTT test tables on one of our dev
databases. He is apparently missing the DEPT table.
Where are the scripts that create the SCOTT tables? I tried looking
through
are the scripts located to create the SCOTT test object
Hi Cherie,
May be this is what you mean.
Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC
VARCHAR2(13))
Rgrds,
Sony
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent
))
Rgrds,
Sony
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 11:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Where are the scripts located to create the SCOTT test
objects?
I have a user that is using the SCOTT
From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 4:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
test this email ad
Tim,
I think you are wasting your time. A
threat from Dick is meaningless...cause they appear not to know
Dick!
I checked their websit
, January 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Um... This looks like a sales critter post... So, let's test it... Tell me
Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste
of marketing material won't do... What exactly does it do for you that is so
recipients of list ORACLE-L
Um... This looks like a sales critter post... So, let's test it... Tell
me
Paul... Exactly why is this tool so wonderful??? And, a simple cut and
paste
of marketing material won't do... What exactly does it do for you that is
so
wonderful??? How does it free up your
. Instead of 'Contact Us' it says 'Contacts Us'
on
each page...And I'm going to trust them to monitor my database?
-Original Message-
Sent: Wednesday, January 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Um... This looks like a sales critter post... So, let's test
' it says 'Contacts Us'
on
each page...And I'm going to trust them to monitor my database?
-Original Message-
Sent: Wednesday, January 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Um... This looks like a sales critter post... So, let's test it... Tell
me
Paul
?
-Original Message-
Sent: Wednesday, January 08, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Um... This looks like a sales critter post... So, let's test it... Tell
me
Paul... Exactly why is this tool so wonderful??? And, a simple cut and
paste
of marketing material won't do
BTW, for those of you stuck with MS Lookout as your e-mail reader, you can
prevent the senseless download of images when viewing/previewing these HTML
messages, whose links often contain encoded IDs so the authors get better
ways to track you down and sell your e-mail addresses.
1. In IE, under
Guys and Gays
I just started working for
this company and they have a really cool DBA appliance. Itfor up my time
to do other DBA stuff.
Paul
OCP
Monitors
database health, performance, host, space, audit, response, stand-by and
security events
Um... This looks like a sales critter post... So, let's test
it... Tell me Paul... Exactly why is this tool so wonderful???
And, a simple cut and paste of marketing material won't do... What exactly
does it do for you that is so wonderful???How does it free up your
time???FYI, if you
: Johnston, Tim
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003
2:59 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: test this email ad
Um... This looks like a sales critter post... So, let's
test it... Tell me Paul... Exactly why is this tool so
wonderful
, Dan
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
test this email ad
Tim,
I think you are wasting your time. A
threat from Dick is meaningless...cause they appear not to know
Dick!
I checked their website. Instead
Guys and Gays
Undskyld, please?
-
Kirti
-Original Message-From: Dessources Paul
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003
2:07 PMTo: Multiple recipients of list ORACLE-LSubject:
FW: test this email ad
Guys and Gays
I just started working
office
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
test please ignore
__
Do you Yahoo!?
Yahoo! Mail Plus Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: john
INET: [EMAIL PROTECTED]
Fat City Network
test please ignore
__
Do you Yahoo!?
Yahoo! Mail Plus Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: john
INET: [EMAIL PROTECTED]
Fat City Network
ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 23, 2002 9:13 AM
test please ignore
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http
Hi, I am looking for a best database response measurment for load runner
test, any comments are welcome.
I am looking at response time per execution in OEM Capacity Planner,
however how do I understand the report with massive executions come with
very low response time per execution, while
How doesOracle handle the licensing of the
Dev andTest servers. Does an OTN license need to be purchased
forthis or does the purchase of the
production server license allow for theTest
and Dev servers.
thanks,
caj
From:
Paulo Gomes
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dcutrone
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
just to see if i can sendemail to the list - have got
problems in teh last few emails
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
NO
Yechiel AdarMehish
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 09, 2002 5:18
PM
Subject: RE: test - please ignore
Can
you hear me now
Good
;o)
-Original
Somebody say something???
peter
-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: 12 September 2002
14:54To: Multiple recipients of list ORACLE-LSubject:
Re: test - please ignore
NO
Yechiel AdarMehish
- Original Message -
From
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Basavaraja, Ravindra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Title: OEM: Is there a test to find broken dblinks?
Hi All,
I'm looking for an event test in OEM to find broken dblinks.
Anyone know such?
Thanks.
Title: OEM: Is there a test to find broken dblinks?
That
would be useful, as import drops package bodies when there are invalid db links
in packages.
Short
of testing them manually one by one, I don't know of one. Import must be
doing it though, when it tries to compile packages.
Regards
Just testing, I'm not getting any messages
lately.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
Can
you hear me now
Good
;o)
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 09, 2002
9:38 AMTo: Multiple recipients of list ORACLE-LSubject:
test - please ignore
Just testing, I'm not getting any messages
lately
___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis!
Descárgalo ya desde http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
TEST
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denis Vasconcelos
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
list, i will be testing various recovery scenarios on a test instance..
my db is in archive log.. i hv a cold backup, i created a table, inserted
some records and
switched the logfile.. (i dnt hv a hot backup) , then i deleted both the
online redo logs.
now i;m trying to re-create
List I'
Subject: test scenario # 1, dropped online redo logs
list, i will be testing various recovery scenarios on a test instance..
my db is in archive log.. i hv a cold backup, i created a table, inserted
some records and
switched the logfile.. (i dnt hv a hot backup) , then i deleted
online redo log !!!
now what ???
--
From: Rahul
Sent: Friday, August 16, 2002 1:57 PM
To: 'Oracle List I'
Subject:test scenario # 1, dropped online redo logs
list, i will be testing various recovery scenarios on a test
instance..
my db
Hi. This is a test mail to
see if my subscription was successful. Sorry to bother.
Cesar Aracena
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621
:
Sent by: Subject: Re: Exporting stats for a
production server to a dev/test
[EMAIL PROTECTED]server
om
Cherie,
Great name.
Our initial stats were generated with the ANALYZE
command. We did export all the stats with the
dbms_stats - one parameter of the GATHER_TABLE_STATS
procedure is CASCADE, which picks up the index and
column stats too. Please test first on your own system
to make sure
Hi
Can anyone give feedback good or bad on the dbms_stats feature of
exporting statistics. Is there any gotcha's or does it work well
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW:
We just used it with great success to test our new
analyze strategy. You can label each set of stats, and
quickly switch between different analyze levels. Store
your old stats first and you can always fall back if
necessary.
Jack
--- [EMAIL PROTECTED] wrote:
Hi
Can anyone give feedback
I've used 1 month ago on Oracle817 without any
problem.
--- [EMAIL PROTECTED] a écrit : Hi
Can anyone give feedback good or bad on the
dbms_stats feature of
exporting statistics. Is there any gotcha's or does
it work well
Cheers
--
Title: Message
Test complete - you have been assimilated.
-The borg
-Original Message-
Sent: 21 June 2002 16:53
To: Multiple recipients of list ORACLE-L
test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services
recipients of list ORACLE-L
Test complete - you have been assimilated.
-The borg
-Original Message-
Sent: 21 June 2002 16:53
To: Multiple recipients of list ORACLE-L
test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat
indexes on a 300m row fact table
today. I am researching bitmap versus btree (again) to
see where the latest info points.
Anyone care to comment on the way to determine whether
an index should be a btree or a bitmap? Anyone even
know a good way to test this?
thx,
/jack
On 2002.05.25 17:38 Rachel Carmichael wrote:
low cardinality -- good candidate for bitmap. little or no updates to
the column being indexed -- good candidate for bitmap
low cardinality is relative -- 10,000 distinct values in a 300m row
table is low, 100 distinct values in a 10K row table
Title: TEST
Ahhh.
I'm guessing that your employer is filtering out
any email from these lists? How about if you set up your own free hotmail
or yahoo account to use to participate in these lists, instead?
I apologize for the curt email earlier, but I (and
others) had assumed (always
Listers,
We are creating indexes on a 300m row fact table
today. I am researching bitmap versus btree (again) to
see where the latest info points.
Anyone care to comment on the way to determine whether
an index should be a btree or a bitmap? Anyone even
know a good way to test this?
thx
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at
x4338 for any query. Thanks.
Anand Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at
x4338 for any query. Thanks.
Anand Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
: Bitmap vs btree - how to
tell?
how to test?
05/24/2002
to tell?
how to test?
05/24/2002
02:00 PM
Please
respond to
ORACLE-L
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj
I am on leave from May 27 to July 15. Please contact Jaspreet Jajj at
x4338 for any query. Thanks.
Anand Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
To: Multiple recipients of
list ORACLE-L @firsthealth.[EMAIL PROTECTED]
com cc:
Sent by: rootSubject: Re: Bitmap vs btree -
how to tell? how to test?
05/24/2002
02:00 PM
Title: TEST
TEST
:TEST
TEST
--
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
Title: test
Testing .
Can I have a copy of three or so test result sets that you have compiled? ;P
Thanks!
Mark
-Original Message-
Sent: 22 May 2002 12:43
To: Multiple recipients of list ORACLE-L
Testing .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
very...
-Original Message-
Sent: 22 May 2002 12:43
To: Multiple recipients of list ORACLE-L
Testing .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas, Kevin
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
you've been ignored, forever
RAJESH DAYAL wrote:
TESTING ..
PLS IGNORE .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
Title: TEST
What
are you testing?
-Original Message-From: RAJESH DAYAL
[mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 11:18
AMTo: Multiple recipients of list ORACLE-LSubject:
TEST
TESTING ...
Your shift key is not working correctly
-Original Message-
Sent: Monday, May 20, 2002 1:18 AM
To: Multiple recipients of list ORACLE-L
TESTING ...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schilling, Ben
INET: [EMAIL PROTECTED]
Fat
Title: TEST
TESTING ...
Test Mail
---
Madhavan Amruthur
Outgrown your current e-mail service?
Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus
--
Please see the official ORACLE
.
Stefan, have you tried running your own test? There's a sure fire
way
to
convince yourself. Even a small test (no fancy code) would suffice.
Wish I
had more time to play...
Lisa Koivu
Oracle Database Monkey Mama
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft
Miller's show?
TEST TEXT FILE ATTACHMENT FOR ORACLE-L ANTI-VIRUS SPAMMERS
101 - 200 of 357 matches
Mail list logo