You can find out by employing the event 10053, lev 8. Looking from afar, however, it
seems more
likely that you haven't configured your CBO properly. Here is something you can try:
Execute the following commands:
alter session set optimizer_index_caching=40;
alter session set optimizer_index
Venu,
I can't give a nonpartisan answer, but I can provide some information. I
hope this helps:
Performance Diagnosis 101 (formerly the "Hotsos Clinic") - This is a
3-day course dedicated to teaching a method for diagnosing performance
problems on production (and integration-testing) systems. It'
Hi,
I'm in Raleigh, so DataDirect is right nearby. Also, I
know their current managers, etc. I worked with them
on my last contract, and know something about their
stuff.
We needed an ODBC driver from our ETL DataStage UNIX
server to an Sybase Adaptive Server Anywhere (old
version) client running
Hello Listers,
A normal sql query from a data warehouse tool called Sagent.
SELECT COL1, COL2, COL3
FROM TABLE
ORDER BY 3;
The table has approximately 2 mil records.
table has 22 indexes.
The database is set up optimizer CHOOSE.
I run DBMS_Stats.Gather_Schema_Stats('SchemaName') regularly.
OS i
So long and thanks for all the fish.
On 2004.01.06 23:44, Sultan Syed wrote:
> Thanks for all guys
>
> Syed
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 06, 2004 7:09 PM
>
>
> Hi!
>
> I wrote about recreatable c
Thanks for all guys
Syed
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 7:09 PM
Hi!
I wrote about recreatable chunk handling from memory and mixed up chunk
freeing routines and chunk's data recreation routines:
A call
they eventually said its data dictionary blocks in the old RBS, that were
having delayed block cleanout. they couldnt be cleaned out because the
tablespace was offline.
its a bug.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06,
John has already shown you how to generate a trace when
an error is encountered via the 'events' mechanism.
If you would like to see what events are available,
peruse the file $ORACLE_HOME/rdbms/mesg/oraus.msg if
you are on *nix. If you are on win32, the file is
unfortunately not available.
Star
Ah, Merant is just down the street, sort of.
Maybe they'll loan me one. :)
Thanks for the explanation. The concept isn't
new, but the terminology is.
Jared
On Tue, 2004-01-06 at 14:09, Grant Allen wrote:
> > -Original Message-
> > From: Jared Still [mailto:[EMAIL PROTECTED]
> > Sent:
In order to switch between undo management modes, you must shutdown and restart, so
all sessions are disconnected. Therefore, session cleanout is not the culprit.
OTS's answer does not make sense since the error is that the file can't be read, not
an ORA-1555 as I would expect if the rbs can't b
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 have to admit I like this stuff about "Connor's
> book" especially since I'm only a co-author for
SAP expects tables to be in certain tablespaces: PSAPBTABD for instance.
Same with indexes: PSAPBTABI
The SAPDBA interactive tool is being phased out in favor of the
command line tool brconnect. I don't know if brconnect allows
some flexibility in tablespace names, but I doubt it. Just haven'
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...)
Cheers
Connor
--- Niall Litchfield
<[EMAIL PROTECTED]> wrote: > I haven't
read it yet, but I'd be am
Hi,
I just use vi :%s/oldtablespacename/newtablespacename/g to edit the dump file and
import it back.In my case, it did work. And it is oracle supported method of renaming
tablespace in versions before 10g.
Manual parallel means:
I have to move 10 table, for example, so in one script,
What does a DBA do?
What should a DBA do?
Interesting short list, or maybe not so short.
http://dbasupport.com/oracle/ora9i/resolutions.shtml
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 8
I remember my previous aussie manager used to be verbose after few Beers (or Beah's)
otherwise was usually less talkative, but was a real nice guy. Aussies are good
natured people, not too uptight.
Raj
-Original Message-
Sent: Tuesday, January 06, 2004 6:45 PM
To: Multiple recipients of
Of course I resemble that remark! You really don't want to know what verbiage I have
though! :)
And of course, those that know both of us would realize that Niall and myself are two
of the few Oakies capable of having facial hair, so we clearly resemble each other. :)
Pete
"Controlling d
On 2004.01.06 18:44, Pete Sharman wrote:
> I resemble that remark! Aussies are ALWAYS great communicators, just a bit direct
> for some people sometime. :)
>
>
> Pete
You RESEMBLE that remark?
reÂsemÂble
(click to hear the word) (r-zmbl)
tr.v. reÂsemÂbled, reÂsemÂb
You could also use a trigger to get the info to a temp table as follows. This will probably fire after any error and could be performance hit. (happy new year to all). :
create or replace trigger system.server_1652_error_trig
after servererror
on database
declare
v_audsid number;
v_usernam
I resemble that remark! Aussies are ALWAYS great communicators, just a bit direct for
some people sometime. :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Or
Chris,
There are two options:
1. Easier, but requires a bounce : Add the following event into init.ora
event="1652 trace name processstate level 10"
This will dump the processstate for processing that encounter an ORA-01652.
And you can even add the following to capture 1555 and 4031 errors
e
And did you really expect that people might NOT be interested in drinks and dinner???
:)
I'll be there too, but thankfully relaxing and listening rather than presenting as I
usually am. It'll make an interesting change! :)
Pete
"Controlling developers is like herding cats."
Kevin Loney,
ALL_ROWS would indeed prefer hash join and S/M over NL.
On 2004.01.06 17:14, Jay Wade wrote:
> Thanks again for all your help.
> Does the ALL_ROWS hint force a preference in Join Types as well?
> If so would it try to force a HASH JOIN?
>
>
> >From: Mladen Gogala <[EMAIL PROTECTED]>
> >Reply-To
Thanks again for all your help.
Does the ALL_ROWS hint force a preference in Join Types as well?
If so would it try to force a HASH JOIN?
From: Mladen Gogala <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Re[2]: OCP Questio
A bigger error in option (d) is that it leaves
open the ambiguity of whether the rows
should, or should not, be part of the answer
to the join.
Oracle's choice of join could be affected
by adding 100 rows to the table that
should be included in the join, but remain
unchanged if you add 1
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 7 January 2004 07:45
> To: Multiple recipients of list ORACLE-L
> Subject: Re: oracle client on PC's
>
>
> What is a 'wire-protocol' ODBC driver?
>
> Jared
It's an ODBC driver that either speaks the na
--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> Like I implied, we had issues running Oracle7 on
> Windohs NT4.0. Those
> "issues" were frequent ORA-600s and corruption, if I
> remember correctly. We
> moved those DBs to Unix and the problem was solved.
Jesse:
new hardware.
new OS.
new oracle i
Is there an event to set where I can identify any sql that receives a 1652
error message?
There is some process running each night in a reporting database that has
been generating this error for the past week. I figured someone would
complain. That didn't happen so I went and asked the reporting
I see you're running on Oracle 9 there, and that
can make a big difference. After posting my
hypothesis, I created a test case, which behaved
as I had predicted - but the behaviour changed
in Oracle 9, and I had to do some tweaking.
Turns out my test case highlighted what looks
like a but in the
Hi
Obviously I'm not Tanel, but we have a similar situation where we don't
actually need to keep segments in specifically named tablespaces - but we do
need when upgrading all of the specifically named tablespaces to exist, and
have sufficient free speace for the upgrade. The app is cross-dbplatfo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: IT - Database (Do Not Use)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
Jonathan noted that
> > Nope. The answer is b). In the FIRST_ROWS mode, optimizer
> prefers NL
> > to
> all other
> > methos despite the price.
> >
>
> Unless the alternative is a full tablescan on the inner
> table - in which case merge or hash joins can be
> considered.
For some reason hash j
I believe the technical term is f'n magic.
It is pretty much the analog of the JDBC thin client drivers - i.e. one that
doesn't require the Oracle client software and communicates directly over
TCP (not sure if any support anything else) with the db server.
They cost.
Niall
> -Original
Like I implied, we had issues running Oracle7 on Windohs NT4.0. Those
"issues" were frequent ORA-600s and corruption, if I remember correctly. We
moved those DBs to Unix and the problem was solved. Granted, this was
Oracle7, but like I said, I see no need to spend money to re-investigate the
cos
Is anybody Running Rac on Unix that is also implemented RMAN on it as
well?
What type of setup or special considerations did you run into if any?
I am considering my options with RAC and whether to expect any bumps
with RMAN and/or extra considerations.
Feedback is greatly appreciated.
Title: Message
OK I'll bite. Why would you not
1. install the Oracle client on every PC?
OR
2. make the app web enabled and just point
everyone at a URL.
I get really confused when folk (and this
isn't aimed at you honest) are quite happy to have
sqlserver,msaccess,excel,text and foxp
Thanks for the help.
Do you have any ideas to the FIRST_ROWS behavior in regards to NL?
I've been looking and found
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#39473
it goes into detail about using hints for joins but now how the FIRST_ROWS
forces a join sele
Oracle doesn't but Jonathan Lewis does, in his "Tutorials". I found out about that
from Scott Gosset in 8i internals class in NYC. Seems still to be true.
Gospel of Jonathan should suffice, however. I just discovered that my
10053 trace name errorstack forever, level 12 causes ORA-600 in 9.2. Let
Title: Message
I
think we had something like this once before and it was a jdk version
issue. I think that we prepended the path with the java1.3 bin
directory. It was a while back,. my memory is hazy and we are 11.5.7
on HP-UX.
Allan
-Original Message-From:
[EMAIL PROTE
What I meant is that the question cannot be answered without making human
assumptions about the question itself. It is a little difficult (Note
"little" not "lot") to believe that such a poorly written question would
appear on a test that costs money to take.
-Original Message-
Someone
Jonathan, you're right. Interesting thing is that bitmap indexes, which were made for
DW processing and not for OLTP will also be considered for NL context in First_Rows
mode.
Here is the proof, which also proves that I'm a lousy typist:
SQL> set autorace on explain
SP2-0158: unknown SET option
Title: Message
Turns out we had the wrong version of JAVA...
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 11
-O
Well I don't know about SAP either, thank GOD. PeopleSoft does maintain the
tablespace where tables and index are suppose to reside so that come upgrade time you
can see what's moved, but at least they provide a rather painless way to change that
if needed.
Dick Goulet
Senior Oracle DBA
Oracle
we have a standard desktop or laptop image
which we install the client and create a package containing the
change, we then push to the pc's that require the oracle client.
We use onames with a primary and secondary
name server.
-Original
Message-From: [EMAIL PROTECTED]
[ma
Jared - I don't know SAP, but other canned applications have a "wonderful"
process they put you through every few years called an upgrade. Often you
end up creating another database and moving the data. This is a great
opportunity for the DBA to fix some issues like this. However, since SAP is
used
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
Piece of cake using vi, perl, or even pl/sql.
vi: 1000iWolfgang
perl: print qq{Wolfgang\n} x 1000;
pl/sql: typically more verbose, left as an exercise for the reader.
Oh, you didn't mean paper did you? Not sure I still
know how to do that.
;)
Jared
On Tue, 2004-01-06 at 12:19, Wolfgang Bre
What is a 'wire-protocol' ODBC driver?
Jared
On Tue, 2004-01-06 at 11:54, Justin Cave wrote:
> At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:
> >Rather than installing the Oracle client on every client PC, we have been:
> >- installing client on 1 PC
> >- copying directory to a network server
> >
Title: Message
in
$ORACLE_HOME/bin relink
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of April
WellsSent: Tuesday, January 06, 2004 11:20 AMTo:
Multiple recipients of list ORACLE-LSubject: RE: 11.5.8 AIX
database tier clone issue
Don
most of the remote sites do
not have a file server at all. They access file servers at the "main
office" for everything.>>> [EMAIL PROTECTED] 1/6/04 2:54:26
PM >>>
--- Jeffrey Beckstrom <[EMAIL PROTECTED]> wrote:>
Rather than installing the Oracle client on every> client PC, we have
been:>
Usually it is installed and configured as a
part of a standard corporate disk image.
Many shops will trim the fat off the client
to keep the size down.
Or you walk around with a
CD.
-Original
Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: Tuesday, Ja
Since we're both going to be in Dallas in March I'll have to have you write
my name 1000 times ;-)
At 01:04 PM 1/6/2004, you wrote:
Yeah I know, did it again.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-
--- Justin Cave <[EMAIL PROTECTED]> wrote:
> At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:
> >Rather than installing the Oracle client on every
> client PC, we have been:
> >- installing client on 1 PC
> >- copying directory to a network server
> >- extract the registry for "oracle" key
> >- fix
Maybe it indicates the different places we are in but I much prefer
"While I'm still confused and uncertain, it's on a much higher plane, d'you
see, and at least I know I'm bewildered about the really fundamental and
important facts of the universe." Treatle nodded. "I hadn't looked at it
like tha
FIRST_ROWS would alter the behavior regardless of the number of rows.
-Original Message-
Jay Wade
Sent: Tuesday, January 06, 2004 1:44 PM
To: Multiple recipients of list ORACLE-L
Hello:
I was looking through some OCP questions posted on the web and came across
the one below.
I believ
The application is a third-party application using Merant's ODBC
driver.
How do people normally install the client. Do you do an install to
every workstation???
>>> [EMAIL PROTECTED] 1/6/04 2:54:34 PM
>>>
At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:>Rather than
installing the Oracle cli
I haven't read it yet, but I'd be amazed if Connor's book wasn't excellent.
He is a great communicator, despite being an aussie and all.
Mogens and Tony from apress are probably pretty busy with the Miracle db
forum right now (work gloves and stuff were mentioned euurgh), but there are
plans that
Yeah I know, did it again.
On Tue, 2004-01-06 at 10:19, Mladen Gogala wrote:
> The name is Breitling. Wolfgang Breitling. Not to be confused with Bond. James Bond.
> On 2004.01.06 12:34, Jared Still wrote:
> > * to satisfy curiosity
> > * to have a better understanding of how Oracle works
> >
> >
Jesse wrote
> As far as "business requirements" go, we have a requirement
> for a certain amount of uptime and reliability. Oracle7 on
> Windohs could satisfy neither, and have no need to spend
> money to re-investigate this for newer versions of Oracle/Windohs.
What would that 'certain amount
At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:
Rather than installing the Oracle client on every client PC, we have been:
- installing client on 1 PC
- copying directory to a network server
- extract the registry for "oracle" key
- fix registry that was extracted to reference the network drive
- lo
--- Jeffrey Beckstrom <[EMAIL PROTECTED]> wrote:
> Rather than installing the Oracle client on every
> client PC, we have been:
> - installing client on 1 PC
> - copying directory to a network server
> - extract the registry for "oracle" key
> - fix registry that was extracted to reference the
> n
Note in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see http
Think like a computer.
"Which execution plan will be the result?"
result of what?
an insert statement?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
thought so, I'm not 100% certain the OCP will say that though. alot of
inaccuracies in that test.
btw, Ive been playing with first_rows lately. I've noticed that it has a
preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in
some test cases where you have two tables approxima
Btw, reading through a 10046/12 trace from instance startup & database
opening can reveal really lots of interesting information :)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 8:24 PM
> Thanks, Raj, but
Tuesday, January 6, 2004, 1:59:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG> Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other
MG> methos despite the price.
Does Oracle themselves *document* that what you say is the
case? I believe you, but I'm not sure that O
Is there a proper sequence of classes to take, among those offered by Hotsos? While I
do use Wait events to monitor & "tune" my Oracle Financials databases, I need more
training in Performance
tuning. I am just dipping my toes into the world of Oracle Performance Tuning. I am
reading Cary's boo
Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other
methos despite the price.
On 2004.01.06 13:44, Jay Wade wrote:
> Hello:
>
> I was looking through some OCP questions posted on the web and came across
> the one below.
> I believe the answer is (D), because the joi
On 2004.01.06 13:59, Mailing List Administrator wrote:
*** IT IS IMPORTANT THAT YOU READ THIS MESSAGE ***
Your message is being returned to you because of an error in your usage. The
mailing list address you sent your message to was:
Address: [EMAIL PROTECTED]
Description
I had the same discussion with Jeff Holt (one of Cary's partners in crime) and
he described #0 attributions as actions not associated with a cursor (i.e.
statement). For example, I worked on a web server which would maintain a
persistent connection. Every 90 minutes, it would execute a series of st
--- Jeffrey Beckstrom <[EMAIL PROTECTED]> wrote:
> Rather than installing the Oracle client on every
> client PC, we have been:
> - installing client on 1 PC
> - copying directory to a network server
> - extract the registry for "oracle" key
> - fix registry that was extracted to reference the
> n
Title: 11.5.8 AIX database tier clone issue
wence java shows wrong version (1.1.8)
oracle said that isn't an issue (previous core dump issue that is known
bug) since ./java shows 1.3.1 but they have had this sev2 itar for 4
hours now and it is still in WIP status... they are researching it..
Thanks, Raj, but I don't think so. The whole reason
behind enabling a db-wide trace was to capture
everything sql trace is instrumented to capture. As
you know sql_trace is a static parameter, so I got
everything "from the begining", including:
PARSING IN CURSOR #1
ALTER DATABASE MOUNT
..
PARSI
D is probably the answer, but most of the time oracle will choose nested
loop.
Beware the OCP tuning test. It is completely and totally inaccurate. I
emailed the author of the Sybex tuning book and he agreed with me. He said
he wrote the book to the test and knows its garbage.
- Original Mes
Hello:
I was looking through some OCP questions posted on the web and came across
the one below.
I believe the answer is (D), because the join type would be dependent on the
number of rows within the table. Is this correct or does the OPTIMIZER_MODE
set to FIRST_ROWS alter this behavior?
The
Welcome back. I was wondering where you've been the last couple of weeks.
At 11:19 AM 1/6/2004, you wrote:
As well as Arthur's books and Douglas's books. Some of the Robert's, too.
Personally,
I'd recommend "Stranger In The Strange Land".
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Con
You missed out Terry:
Oh, it's largely intuitive, Archchancellor. Obviously you
have to spend a lot of time learning it first, though."
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who ca
Rather than installing the Oracle client on every client PC, we have
been:- installing client on 1 PC
- copying directory to a network server
- extract the registry for "oracle" key
- fix registry that was extracted to reference the network drive
- load registry on client PCs
- add the network
--- Daniel Hanks <[EMAIL PROTECTED]> wrote:
> Is there any way to check on the progress of an
> index rebuild? (Oracle 8i). I.e., it would be nice
> to get some indicator as to how far an index rebuild
> has gone, something like "75% done...".
>
Daniel,
v$session_longops, perhaps?
(at least for
Hi All,
I need to load Multi-language data from MS-Excel sheet into Oracle 8i database
(UTF-8). I saved Excel file as .CSV file then using SQL*Loader did load the data into
Oracle database. But the data got garbled(all ). How should I resolve this issue?
Is there a way to store Excel file i
Daniel,
Check out V$SESSION_LONGOPS.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 06, 2004 12:49 PM
To: Multiple recipients of list ORACLE-L
Is there any way to check on the progress of an index rebuild? (Oracle 8i). I.e., it
I had the same thing happen in a DB I inherited. Turns out the PCTINCREASE
was set to 50%! I set optimal and tried to shrink, but extents were located
throughout. The only thing I could do was drop the tablespace and recreate
it and all the rollback (undo) segments.
HTH
Mike
-Original Messag
Hi!
Check v$session_longops view, it is meant for monitoring this kind of
long-running jobs - but it can be quite inaccurate.
Another way would be to check v$sort_usage during sorting phase of index
recreation and then check the newly created index segments size (it'll be
created as a temporary se
As well as Arthur's books and Douglas's books. Some of the Robert's, too. Personally,
I'd recommend "Stranger In The Strange Land".
On 2004.01.06 12:04, Pete Finnigan wrote:
> <[EMAIL PROTECTED]> writes
> >I won't argue that, Allan. The guy writes two sentences, and it
> >takes a week f
The name is Breitling. Wolfgang Breitling. Not to be confused with Bond. James Bond.
On 2004.01.06 12:34, Jared Still wrote:
> * to satisfy curiosity
> * to have a better understanding of how Oracle works
>
> Most DBA's probably don't need to know this stuff. Most
> performance problems will not
Hi,
Here is an easy one hopefully, but I've been unable to figure it out
via Google or Metalink. When selecting data from an AL32UTF8 database,
sqlplus has problems formatting output on the screen. When I select both
English (1-byte, A-Z) date and Unicode (2,3, or 4-byte) data, the colum
Title: 11.5.8 AIX database tier clone issue
Do you have correct JDK installed
(J2SE1.3.1+)?
IIRC, autoconfig uses java as well...
Tanel.
- Original Message -
From:
April Wells
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 06, 2004 7:19
PM
Have you checked v$session_longops ... ??? regular index builds show up there, so I
guess rebuilds will show up as well ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are stric
Is there any way to check on the progress of an index rebuild? (Oracle 8i). I.e., it
would be nice to get some indicator as to how far an index rebuild has gone, something
like "75% done...".
As a rough indicator, I've noticed when rebuilding/moving an index to a different
tablespace, Oracle wi
Actually, no. If we had any Oracle servers on Windohs, I would only feel
comfortable with TightVNC server on it, and even then I would insist on no
more than 800x600 and 256 colors (hopefully the Installer works with that!),
due to the transmission overhead involved.
And if you can set up an Orac
Thanks, Tanel.
I did checked v$session_connect info, but it doesn't
tell me much, except authentication_type='PROXY' which
is less than useful as it doesn't tell to whom.
v$session.client_identifier is empty.
Thanks,
Boris Dali.
> Check V$SESSION_CONNECT_INFO view.
> CLIENT_IDENTIFIER in V$SESS
* to satisfy curiosity
* to have a better understanding of how Oracle works
Most DBA's probably don't need to know this stuff. Most
performance problems will not likely require you to know
any of this.
If you spend a lot of time solving other people's 'unsolvable'
Oracle performance problems, as
We had some issues with using a TightVNC client
against vnc server v3.3.7, whereby the server process
would crash and not restart, requiring a server
reboot. So TightVNC got tossed as a client in our
environment.
Its nice to have Terminal Services enabled so that one
can attempt to restart a crash
Ugh ... you mentioned disable all that crap ... but that included windows .. no? That
would solve a lot of problems ... right?
sorry, I am in an exceptionally good mood today just because computer room woke me up
at 3:30am to fix something!! Aah... the joys of being on-call.
Raj
-
Rich,
> Citrix Metaframe, rdesktop, and TightVNC help a
> bunch, too. :)
This is the biggest reason why people badmouth Windows
for use with Oracle. You install Citrix MetaFrame on
the same server as you run Oracle Database Server? Get
real.
You probably have IIS, RRAS, IPSec, numerous file
se
> 2) since waits #0 appear only before the calls to a
> stored code - I don't know if they deliberatly "switch
> sessions" in the code that runs on the app server and
> run the stored code as the schema owner (similar to
> switching current schema as an alternative to using
> synonyms) or it is a f
Title: 11.5.8 AIX database tier clone issue
context editor
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 11
-Ori
Title: 11.5.8 AIX database tier clone issue
Don't HAVE adadmin on my database tier
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/
>\<
\
>\< \
Few people really enjoy the simple
pleasure of flying a kite Adam
W
you may not be seeing parse etc entries for cursor #0 merely because maybe by design,
cursor#0 gets invoked before trace gets activated. This way, you will never get cursor
#0 info.
You can tell, I am guessing but to get similar experience, start trace in an already
active session and you'll se
Thought I'd throw this out again now that more of the list is back from
holiday...
-Original Message-
Sent: Friday, January 02, 2004 12:29 PM
To: Multiple recipients of list ORACLE-L
Anyone messed with Rocks (http://www.rocksclusters.org) in an Oracle
capacity?
Rich
Rich Jesse
1 - 100 of 185 matches
Mail list logo