I resemble that remark! Aussies are ALWAYS great communicators, just a
bit direct for some people sometime. :)
Aussies aint direct, oh no. Just talk with Danish!
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
--
Please see the official ORACLE-L
To what Mladen said about the optimizer_blah parameters, there is another thing which
can be added. Most third-party software is over-indexed (as you have noticed) because
they optimistically want to cover *all* possible cases and quite often a column which
is highly discreminant at one site
- Original Message -
(And unlike my presentations, I promise that there is
no profanity in the book...)
You mean you gloss over BCHR?
Shame on you!
;)
Cheers
Nuno Souto
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Souto
Hallo,
I have this sql query. I would like to change it so I could pick out the three forst
three charachters in the between statements. How can I do that in the most simply way?
and vgr in (between 101 and 101)
and vgr in (between 104 and 104) order by Avdnr ,Datum1
Venu,
I've taken both PD101 and OP101 and I can thoroughly recommend both of
them. The sequence of those two is irrelevant in my opinion.
If you're looking to improve your tuning skills and your understanding
of Oracle performance issues I would suggest the OP101. It has a very
good balance of
This works well in ver 8 or higher how do we do in Oracle 7 version.
Anand Kumar
ITW Signode India Ltd
- Original Message -
To: LazyDBA.com Discussion
Sent: Wednesday, January 07, 2004 1:50 PM
alter table emp move tablespace tbs2;
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)
Check the costs of the two queries (autotrace will be
sufficient).
In this example, rule based uses the index because
it exists and will return the right answer.
Cost based works out that the scan and sort is
cheaper.
The cost of an index full scan is approximately
blevel + leaf_blocks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi List, this is the question .
You are calculating the proper size for a temporary tablespace .
Which of the following are two most important factors to consider ?
A. users
B. sort_area_size
C. type of tablespace management
D.
Hi,
Can anyone point pros/cons of shrinking a rollback segment ? (other
than performance overheads associated with extent allocation and
reallocation)
Optimal is not set for my rollback segments. Recently I shrunk a
rollback segments which had more than 100 extents allocated to it.
Hi list , sorry to pester you with questions regarding
boson OCP questions . i have scheduled for #1Z0-031 exam
and so desperately need help from this list .
please bear with me for while . look at the 2 questions below .
-
I'm saving that for the Hotsos symposium
--- Daniel W. Fink [EMAIL PROTECTED] wrote:
Who cares about the profanity
Do you a) pound nails in a squirrel and b) force
David Kurtz to consume massive amounts of gin whilst
lobbing Fosters at the
audience?
Connor McDonald wrote:
I
Title: Last date for Oracle 8i OCP?
Does any one have an idea when is the last date to complete ORACLE 8i OCP exams?
Is there any last date announced or yet to announce for Oracle 8i OCP?
Thanks
Sanyu
You have to apply mig to it. The sooner you do it, the better.
Read database migration guide.
On 2004.01.07 05:19, N.Anand Kumar wrote:
This works well in ver 8 or higher how do we do in Oracle 7 version.
Anand Kumar
ITW Signode India Ltd
- Original Message -
To:
Apologies to the list.
The previous reply may have been informative,
but it was irrelevant. I failed to notice that the
indexed access path was followed up by a
table access by rowid. (This does explain why
the index_FFS path wasn't used, of course).
In this case, the cost of the indexed
Title: RE: oaktable people
You would fit right in fine in the North East US...
I am also too direct for people sometimes!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple pleasure of flying a kite
Hi
Steve-
Quite
interested in having a go at it.
Please
send to me a copy asap.
Cheers
and regards,
CSW
Simon.
-Original Message-From: Steve Perry
[mailto:[EMAIL PROTECTED]Sent: Monday, January 05, 2004 6:29
AMTo: Multiple recipients of list ORACLE-LSubject:
freebie.
Hi Prem,
Firstly, thank you for bringing back fond memories of when I used to teach
this stuff for Oracle. If we ever meet one day, I'll show you my highlighter
penned copy of the notes showing the various errors and inaccuracies (except
the Performance Tuning course where I highlighted the
switched emails. just testing.
If you leave in and around the Charlotte area or in a reachable distance and have not heard throughthe user group'sregular e-mail invitations here is the opportunity.
Cary presents for the Charlotte Oracle Users Group on Thursday January 8th - for more details visit www.cltoug.org
Murali
Hello Prem,
The syntax the question gives for DROP TABLESPACE doesn't
look right to me. Without looking at the current docsgrin,
I believe INCLUDING CONTENTS is a valid option, and that the
others are invalid. Thus, answer B, the statement will fail,
looks correct. Whoever wrote that test
Connor McDonald scribbled on the wall in glitter crayon:
I have to admit I like this stuff about Connor's
book especially since I'm only a co-author for the
thing :-)
(And unlike my presentations, I promise that there is
no profanity in the book...)
oh damn.;-)
--
Bill Shrek Thater
Hi again Prem,
OK, I've changed my opinion of dear Boson. At first I simply thought they
had no idea, now I suspect it's all a big joke designed to make DBAs have a
bit of a giggle on warm summer nights ...
Sizing the temp tablespace by the formula you've given is really quite
witty. Perhaps a
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:44 AM
I resemble that remark! Aussies are ALWAYS great communicators, just a
bit direct for some people sometime. :)
Hi Pete,
Me direct ???
Never !!
Richard ;)
--
Please see the official
And if enough attend, Cary has promised to related
the little tale of a certain rat called Rupert.
Cary, dare ya !!
Richard ;)
- Original Message -
From:
Murali Vallath
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 07, 2004 10:59
PM
Subject:
Jonathan,
I successfully use drop tablespace including contents and datafiles
all the time. And a quick check of the docs shows that cascade
constraints is valid but, as Richard said, belongs at the end of the
statement.
As for the second question. DBA_SEGMENTS gives you the total allocated
The date has not been announced. I contacted The OCP folks late last month
and they said that there has been no date set for ending the 8i OCP tests,
nor was he aware of anything being said about it.
We do an install on the workstation but the installation has been packaged
and is pushed I believe with SMS or at least it used to be done that way.
From: Jeffrey Beckstrom [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re:
Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael ([EMAIL PROTECTED]) wrote:
RC I successfully use drop tablespace including contents and datafiles
RC all the time. And a quick check of the docs shows that cascade
RC constraints is valid but, as Richard said, belongs at the end of the
RC
Actually from what is given I'd expect the optimizer to select a full table scan in
anycase, there's no where clause.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 07, 2004 1:09 AM
To: Multiple recipients of list ORACLE-L
You can
I didn't mean to scold... you post way more information than I usually
do!
And I answer whilst eating breakfast at times too :)
Richard *is* right, the problem is, the sql statement is misformed but
the answer key says it will work. Which is yet another reason I dislike
the OCP exams.
---
--_=_NextPart_001_01C3D52C.273B9780
Content-Type: text/plain
We've seen this error on one of our databases (9.2.0.3 on Win2003 Server).
Haven't seen it on our other instances (9.2.0.3 on HP-UX).
Robyn
-Original Message-
Sent: Tuesday, January 06, 2004 11:50 AM
To: Multiple
Hi Richard ,
Many a thanx for both of your replies .
All my worry is : do such questions appear in the real exams also ?
And your reply has increased my self-confidence.
particularly the line :
RFTrust what you *see*, not what you *read*. /RF
RFYou actually proven this yourself and yet you
Well, you've certainly gotten a few decent replies. I've never used Boson so
I can't comment on their exams, I prefer going to Oracle Press. Anyway, sizing temp
is a combination of things many of which are black magic at best. Number of users is
an interesting variable to add, but
8i is slated for desupport at the end of December, in any case.
Patrice
-Original Message-
Sent: January 7, 2004 9:44 AM
To: Multiple recipients of list ORACLE-L
The date has not been announced. I contacted The OCP folks late last month
and they said that there has been no date set
We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium
speaker agreement. I will admit that profanity from Connor does not
carry the same impact as profanity from Mogens!
Gary
-Original Message-
Connor McDonald
Sent: Wednesday, January 07, 2004 5:29 AM
To: Multiple
A small but growing number of employers want certification. Considering the
job market, I recommend anyone who is not at Rachel's, etc.. level to get
certified as both a developer and a DBA. I'm doing Java also, just to have
it. The java test is a total joke. You only need to get 52% right and its
1. Easier, but requires a bounce : Add the
following event into init.ora
event=1652 trace name processstate level 10
You should be able to set this dynamically as well (tested on 8.1.7).
SQL alter system set events '1652 trace name processstate level 10';
System altered.
Thanx for your reply Gennick.
..and for your word of caution about partitioned tables.
Cary , sometime back said that :
Cary
There are always two answers to a question that your
teacher would ask at school .
First one is the right answer.
Second one is the answer that your teacher
Title: RE: Re[2]: another OCP question -- help me guys
Uh No one can be at Rachel's level. She's the DBA Goddess
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:
Ryan People don't seem to be all that interested in
Ryan whether you can actually do the job.
Ryan , i would change your first line as Some people don't seem to ...
Because some people really DO care about what one can do.
Ryan They just assume your better than someone
Ryan else if you have
Michael Abbey once said (I'm paraphrasing here) the resume and OCP get
you in the door. It's your experience that gets you the job and keeps
you there
We've had numerous discussions on this list about interview questions.
I've been on interviews where I spent an entire day (9-4) and talked to
11
Wednesday, January 7, 2004, 9:39:25 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote:
PKJ Many a thanx for both of your replies .
PKJ All my worry is : do such questions appear in the real exams also ?
I think you've hit on something key here, and that is that
practice exams may not be reflective
Rachel Carmichael scribbled on the wall in glitter crayon:
Oh yeah -- how does having a college degree in art history make a
person a better DBA? how does my degree, which is in computer science
but which is 28 years old, have anything to do with current
programming and database work?
it
So I got two e-mails today from Oracle Support warning about Verisign Certs
expiring today and to check MetaLink (thanks for the advanced warning guys).
I've been trying for over an hour now and am getting no joy. Anyone know
what the Verisign Certs are used for in Oracle products? I don't think
Title: RE: Verisign and MetaLink
Financials... if you use https and primarily if you are using 11i externally
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age
You may be surprised to find that the email came from a domain hosted/owned by tucows
...
Domain Name: ORACLE-MAIL.COM
Registrar: TUCOWS, INC.
Whois Server: whois.opensrs.net
Referral URL: http://www.opensrs.org
Name Server: NS1.ORACLE.COM
Name Server: NS4.ORACLE.COM
Status: ACTIVE
Updated
Jesse,
Aren't these pieces of mail great? Talk about Spam.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, January 07, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L
So I got two e-mails today from Oracle Support warning about Verisign Certs
the ntoe I read talked about Oracle Wallets and SSL within Java
_
Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider
Tel: +44.1684.312364
http://www.speechmachines.com
-Original
Interesting. Of course, Gummi's right: I blew both my course URLs in my
note. The correct URL for the PD101 coruse is
http://www.hotsos.com/courses/PD101.php, too. Slow connection; didn't
have time to check thoroughly; sorry for the inconvenience.
Thanks, Gummi.
Cary Millsap
Hotsos Enterprises,
degrees and ocps often do alot more than get you past the HR department.
most jobs these days are short term temp jobs. temp companies offer you
salary based mainly on your resume.
most technical interviews are a joke. I can make more money if I double my
experience level and have a computer
On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote:
Oh yeah -- how does having a college degree in art history make a
person a better DBA? how does my degree, which is in computer science
but which is 28 years old, have anything to do with current programming
and database work?
Believe it
Per the doc on MetaLink, Oracle Wallet Manager and Sun Java JDK are
affected by the Verisign certs.
Here is some of the info:
VeriSign Class 2 and Class 3 PCA root certificates are included in the
Oracle Wallet Manager as well as Sun's Java JDK. These certificates will
expire on January 7,
Robyn - Thanks for replying. So what was the consequence of the error? What
did you have to do to fix the problem?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 07, 2004 8:40 AM
To: Multiple recipients of list ORACLE-L
This message
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it necessary to work harder to acquire some
veneer of false knowledge specifically in order to pass the exam?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Raj,
It seems as though all of Oracle's names are registered through tucows -
Tucows is simply the registrar, not the owner of the name. This is not at
all uncommon, and in fact makes sense, given the large number of domain
names under management for Oracle.
Thanks,
Matt
--
Matthew Zito
So a co-worker sends me an e-mail about Apple's just-announced Xserve RAID
with 3+TB for US $11K. After looking at Apple's page, I poo-poo it because
it's 7.2K spin ATA/100 drives, which I figure would lead to all sorts of
problems. I see today in Computerworld that it's being touted as blazing
I do understand, and that's why I said that I tried to bring people in
first, before HR (as you know)
--- Thater, William [EMAIL PROTECTED] wrote:
Rachel Carmichael scribbled on the wall in glitter crayon:
Oh yeah -- how does having a college degree in art history make a
person a better
But that will
ruin Carys clean cut image forever more!
(Trust me folks, Ive heard Richard tell this one before, and I never
want to hear it again!) J
Pete
Controlling
developers is like herding cats.
Kevin Loney,
Oracle DBA Handbook
Oh no,
it's not. It's much harder than
Jesse,
If they'll loan you one for a test period that test works out, Maybe. Now
if your SAN vendor is worth his/her weight in salt then they'll have a way to connect
that Xserve RAID system into their SAN. That way you get the best of both worlds.
Dick Goulet
Senior Oracle DBA
Found this note on Citrix web site:
DataDirect does support the use of Connect for ODBC on Citrix Metaframe and Windows Terminal Server
environments. Note that due to known problems with the Microsoft MSI
Engine, the installation of Connect for ODBC is currently not
supported through the
Rachel Carmichael scribbled on the wall in glitter crayon:
I do understand, and that's why I said that I tried to bring people in
first, before HR (as you know)
yup, but most places don't have a Goddess on staff.;-) and i'm seeing the
requirement for OCP being listed in consulting postings
for performance tuning exam you have to know some garbage.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:59 AM
My question, Richard, is can a person pass the exam just by studying
what is correct? Or is it
Shrinking of rollback segments may result in ORA-1555s. If you need to shrink
them, do so during a slow time.
Not shrinking rollback segments may result in ORA-1562 unable to extend rbs.
Satav, Pawan wrote:
Hi,
Can anyone point pros/cons of shrinking a rollback segment ? (other
than
Jared,
SAP does use default tablespace names as you have stated, but will
allow you to move them to alternate locations and recommends it under
certain conditions. We separated 10 or 12 of the tables that we
thought would grow the fastest into dedicated tablespaces when we
originally installed
Misconceptions, superstitions and myths are always useful to know
and believe in. They make people better socialized and the risk
of being burnt at stake as a heretic(metaphorically, of course)
is much lower.
On 01/07/2004 10:59:26 AM, Cary Millsap wrote:
Or is it necessary to work harder to
I got them as well and managed to get into metalink -- seems to be
connected to Advanced networking option
Rachel
--- Jesse, Rich [EMAIL PROTECTED] wrote:
So I got two e-mails today from Oracle Support warning about Verisign
Certs
expiring today and to check MetaLink (thanks for the advanced
But then again, the DBA can get a free iPod, which is a good thing indeed.
On 01/07/2004 10:59:50 AM, Jesse, Rich wrote:
So a co-worker sends me an e-mail about Apple's just-announced Xserve RAID
with 3+TB for US $11K. After looking at Apple's page, I poo-poo it because
it's 7.2K spin ATA/100
Cary,
So, I don't need to be completely proficient in SQL Optimization prior to enrolling in
Performance Diagnosis 101? When if it all do you plan to offer these classes in New
York, NJ area?
Venu Potluri
-Original Message-
Cary Millsap
Sent: Wednesday, January 07, 2004 1:04 AM
To:
From past history:
I passed the 8 and 8i exams without having done any work in either
version, nor did I study for them. I used Jonathan's method of using
later questions to infer the answer to earlier ones, in part. Marlene
Theriault, an excellent DBA, took several tries to pass because she
knew
Now I understand their use, I shall immediately go out and hire an art
history major as the deparmental sacrifical lamb (and dartboard while
we are at it)
I'm still a hands-on DBA, although I have some paperwork
responsibilities as well. Not management, other than my own work :)
Rachel
---
Wasn't it you, Cary, who got tought by his parents that every question has
two answers: The right one and the one the teacher wants to hear? And you
had to learn them both?
That's merely what OCP is about, I think. Get a certificate to get hired,
and get the proper knowledge to remain hired
Hi all,
I have been working with Oracle 92. I have no
experience with Oracle Warehouse. In my current
company, I was told the database is a warehouse. I
can connect to it using sql plus or pl/sql developer.
The warehouse looks the same as the database I
worked with before. How do I tell if a
Title: RE: Re[2]: another OCP question -- help me guys
brutal, absolutely brutal...
Rachel, can ya out-source your sacrificial lamb for our use as well:-)
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 11:54 AM
To: Multiple
Rachel,
A few years ago I was offered a job by a defense contractor in the area who
was looking for a DBA, but more importantly a DBA with a still active clearance. Well
all was well in 90% of that company, except HR. Simple answer, no degree no job. I
don't have the degree so they
What I have heard is that all the OCP questions are taken from the Oracle
University Student Guide. After all, you wouldn't you expect the class to
prepare you? Someone suggested that you think like a computer. Well, for
the philosophy behind the exam, think like an organization, namely
Oracle
Yes, I was the one. I was just wondering whether the OCP performance
exam was really as bad as it used to be. I haven't seen it since
whatever the things were called back in the early 90s. From some of what
I've seen here, the answer is that yes it is the same. Not just
philosophically the same,
or from the other side: the right one, and the one pig-headed students are
convinced is right (even if you can incontrovertably demonstrate they are
wrong). Does that make three answers? or two answers with three labels?
Henry
-Original Message-
Carel-Jan Engel
Sent: Wednesday, January
what you lose in worth you gain in self-worth.
Henry
-Original Message-
Ryan
Sent: Wednesday, January 07, 2004 10:55 AM
To: Multiple recipients of list ORACLE-L
degrees and ocps often do alot more than get you past the HR department.
most jobs these days are short term temp jobs. temp
Venu,
You are correct. The outcome of many problems you'll diagnose using the
PD101 method is that you'll need to fix some SQL, but the point of PD101
is teaching you (1) how to make sure you're working on the right
problem, and (2) how to forecast what kind of performance improvement
you'll get
I know it makes no sense... but it has something to do with a (very)
antiquated class system and the difference between white-collar
workers and blue-collar workers and salary vs hourly wages
for the non-US, the term white collar worker refers to office staff,
who would wear a white shirt and tie
prank
If you enter the following query select 'Data Warehouse' from dual;
and if the database responds with 'Data Warehouse', then your database
is a DW database.
/prank
Data warehouses can be distinguished from their less noble cousins,
the OLTP databases, by the way they're accessed and by
Janet,
A data warehouse is a database. Now if the data warehouse has all of the
data structures of the OLTP database and people are using those tables like one would
expect, then your just using the same instance for both purposes, which is a recipe
for disaster in my opinion. A data
how much of the material from these classes are in your book?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:24 PM
Venu,
You are correct. The outcome of many problems you'll diagnose using the
PD101 method is
Ryan,
Parts of the book are based upon the PD101 course. The book goes further
in some areas than the PD101 course (queueing theory, V$ views), but
then the course goes further in some areas than the book. The course
discusses developments that have occurred since the publication of the
book, and
Hi list , sorry to pester you with questions regarding
boson OCP questions . i have scheduled for #1Z0-031 exam
and so desperately need help from this list .
please bear with me for while . look at the 2 questions below .
Don't apologize Prem, who else are you gonna call, ghostbusters? :)
Prem ,
OCP has nothing to do with knowledge and nothing to do with the real world.
So if you want to give OCP, forget what you know and humbly, play by its
rules.
Right now if your are serious about giving OCP exams then please
enable suspension of disbelief , don't ask why and just mug up the
The Ralph Kimball answer:
A DW is a collection of data marts. A Data mart
is typically a fact table surrounded by a collection
of dimension tables.
The Bill Inmon answer:
A DW is a system designed to collect data from an
enterprise for the purpose of creating data marts.
It is not normally
It depends a lot on the workload - for DSS-esque systems with lots of
sequential reads/writes, etc., the performance of the individual ATA
spindles will probably be more than adequate. As another side note, at that
price point, maybe you could afford to buy double the number of spindles you
need
Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4
I am looking for any good product/option for centralized source code
control.
Any pointer or experiences shall be appreciated.
Regards
Rafiq
_
Have fun
Source Safe
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 07, 2004 1:34 PM
To: Multiple recipients of list ORACLE-L
Env: Windows 2000/NT/HP-UX/Solaris/Linux
Oracle Databases: 7.3 to 9.2.0.4
I am looking for any good product/option
the pl/sql exam is really bad too. It got worse from 8i to 9i. 10% of the
exam was on DBMS_LOB and no other packages were touched? I had about 6-7
questions on parameter ordering.
Its accurate, just useless.
I thought the architecture test wasn't bad at all. The 8i backup and
recovery one was
PVCS
http://www.softlanding.com/merant/vm.htm
I used this back when it was Intersolv that owned it. One useful thing
about it was that the command line interface was well implemented so scripts
to automate check in, check out, software builds, etc. could be written (and
were written).
We use PVCS ... oracle has SCM product ... if you intend to use source control for
Forms/Reports etc, then I'd recommend Oracle SCM.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Would it be lame if I suggested rcs or cvs? Those tools are standard.
On 01/07/2004 01:49:26 PM, Goulet, Dick wrote:
Source Safe
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 07, 2004 1:34 PM
To: Multiple recipients of list
Fewcomments inline:
1. Easier, but requires a bounce : Add the
following event into init.ora event="1652 trace name
processstate level 10"
You can use alter system and dbms_system.set_ev in
combination to force an event for all new and existing sessions, without a
bounce (alter system
Hi All,
Thanks for all your replies.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 07 Jan 2004 11:04:40 -0800
PVCS
http://www.softlanding.com/merant/vm.htm
I used this back when it was Intersolv that owned it. One useful
WinCVS has worked well for us and several of our friends. www.wincvs.org
If I recall correctly, it's free.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March
PVCS is a nice tool, especially when combined with PVCSTracker for
change management. VSS (Visual SourceSafe) and PVCS offer similar
capabilities when compared side-by-side. PVCS has an (optional)
promotion model that VSS doesn't have (although VSS Labels can
'fake' it). Both tools have a command
How about v$session_longops
Cheers
From: Daniel Hanks [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Progress of an index rebuild
Date: Tue, 06 Jan 2004 09:49:25 -0800
Is there any way to check on the progress of an index
1 - 100 of 193 matches
Mail list logo