RE: Slow Export
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <rlsmith@xxxxxxx>, <tanel.poder.003@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 16:14:41 -0500
Hmm....so, they explicitly deperm access to the truss binary? On most Sun
servers, it's in /usr/bin, and you should not need root permission to truss an
oracle owned process. If you can login as the user who started the database
(presumably oracle), that should be good enough to do the trace. Unless they
really do explicitly deperm the binary. If that's true, I'd argue that's a
battle you need to fight, in order to do you job well, you need access to O/S
level tools like truss. (I know, I know, easier said than done....;-))
As for the V$SESSION_WAIT output, what do you mean by "looks low"? Are you
seeing waits? What are they?
Also, regarding Tanel's last question, are you exporting locally, or over the
network?
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and
those who don't."
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Smith, Ron
Sent: Tuesday, January 31, 2006 3:55 PM
To: tanel.poder.003@xxxxxxx; ORACLE-L
Subject: RE: Slow Export
I had to restart the export. Ran 8.5 hours this time.
V$Session_Wait looks low right now.
I have never used the Truss command. Unix admins don't give us access.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel Põder
Sent: Tuesday, January 31, 2006 2:45 PM
To: ORACLE-L
Subject: Re: Slow Export
Are you exporting over network or locally in the server?
V$SESSION_EVENT, V$SESSION_WAIT and truss -c should sufficient to
reveal the cause..
Tanel.
----- Original Message -----
From: Smith, Ron <mailto:rlsmith@xxxxxxx>
To: tanel.poder.003@xxxxxxx ; ORACLE-L
<mailto:oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, January 31, 2006 2:36 PM
Subject: RE: Slow Export
There are several exports in different databases, exporting
various size objects. The thing is, this started about the middle of December.
Before that, everything was fine.
Ron
Important Notice!
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this
message by mistake,
then delete the e-mail message.
Thank you.
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
