RE: Possibly moving to Sun Equipment

[Rao, Maheswara]

Steve,

We have a three 420R boxes, two 450 boxes, three 6500's. Each of our 420R's
configuration is ---  4 cpu's - 450 MHZ, 4 GB RAM.  We are using 420R boxes
for our development.  We have Oracle 817, WebLogic 6.1 and some middle tier
software loaded onto these 420Rs.  

These 420R boxes come initially with one disk controller card.  If you want
to add additional disks, then, you would need to purchase additional
controller cards.

Now, regarding performance, we were trying to benchmark how many TPS 420R
could send via WebLogic.  I cannot post the exact TPS figures to the list as
the damagement might interpret as revealing confidential info.

But, my opinion is the number of TPS are very less or throughput is very
less compared to E6500's.

Rao

-Original Message-
Sent: Thursday, November 29, 2001 7:00 PM
To: Multiple recipients of list ORACLE-L


Well I have just returned from the Sun site, and checked out the two
systems.  The 420r is a rackmount server in the Enterprise Server series.
It uses Sparciii processors, up to 4 at 450mhz.  I don't' think I would
consider this configuration an upgrade.  I also doubt you'd classify this
one as a screamer.

The 880 is one of the Sunfire series of servers sporting a pair of 2 900mhz
64 bit UltraSparciii processors.  This one sounds much more exciting to me.

As I type this, I am informed that the powers that be are also looking at
some HP UX boxes.  Well either way we go I don't think it will be too
traumatic for me.  I am hoping for that Sun 880 now.



-Original Message-
Sent: Thursday, November 29, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L

Steve - Is the 420R part of the new Sun Serengeti series? We had a test box
here and I recall the model number as being similar. If it is the same
thing, that box was a real screamer.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, November 29, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L


Sorry for the double posting.  I failed to include a subject line initially.
My first day back, and already a list faux paus.  Two I guess if you count
the double post.

Hello All,
It has been a while since I have been here, but I am back and properly s
ubscribed to the list again.  I am looking to draw from your experiences
here with hardware.  Our current database resides on a Data General Aviion
system with a Clarion drive cabinet.  While we are very pleased with the
system, and it's performance Data General is going the way of the Dinosaur,
so we need to look at other options.  The ones most currently floated have
been the Sparc 880 or the 420R either configured with dual gigahertz
processors.  The IT manager has a desk piled high with marketing
gobbledeegook, and has asked me if I know anything about either system.  All
I have been able to do is assure him that Solaris is essentially UNIX, and
tell him I would check with some knowledgeable folks here about the
hardware.  Our DG box sports a Gig of RAM, and 4 300 mhz Intel processors.
The best thing by far about our system is the Clarion drive cabinet that
handles all our drives.  The good news is I hear our cabinet is compatible
with Sun hardware, so that might come right along with us.  I have done a
bit of internet searching, and seen these Sun boxes priced under 20K.  My
question is this.  Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?

Steve McClure



-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT- Service Level Agreements

[Praveen Gautam]

All:

Has anyone service level agreements with theirdDatabase users and would be willing to 
share some
information?  I am in the processing of creating SLA with my Oracle database users and 
am looking
for templates.

TIA

-- 
+===+
|  Praveen K. Gautam|
|  Tellabs, Inc.|
+===+
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praveen Gautam
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Deleting Oracle8 on NT(cleaning Oracle8)

[Raghu Kota]

Hi Friends,

I need to clean Oracle8 database size 3Gb on one of my NT server, Is it 
possible that shutdown the database and delete all datafiles and all 
directories??? Or Is there any other way to clean all files and 
directories?? I appreciate all suggestions and responses.

Thanks in advance
Raghu.



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Determinants of control file

[Riyaj_Shamsudeen]

All right, Here is the complete query to get the information from the control file.

select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY
') , rsnum from x$kccrs
where indx in (3,4,2,9)
union all
select 'MAXLOGMEMBERS ',dimlm from x$kccdi
/

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






Riyaj Shamsudeen
12/03/01 09:46 AM


        To:        [EMAIL PROTECTED]
        cc:        
        Subject:        RE: Determinants of control fileLink

Hi
        v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except  maxlogmembers. Here is the query to pull the information..

select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs
where indx in (3,4,2,9)
/
DECODE(INDX,3      RSNUM
- --
MAXINSTANCES              8
MAXLOGFILES                 32
MAXDATAFILES         1022
MAXLOGHISTORY       907

which is matching with my controlfile dump.

CREATE CONTROLFILE REUSE DATABASE "mydb" NORESETLOGS ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 1022
    MAXINSTANCES 8
    MAXLOGHISTORY 907

        I am not sure where maxlogmembers is stored. I will do some more digging to find that..

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






Nirmal Kumar  Muthu Kumaran <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/01/01 08:25 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Determinants of control file


No. i already checked the view v$control_record_section, 
This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc
Nirmal. 
-Original Message- 
t size=1 face="Arial">K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, November 29, 2001 11:27 PM 
To:     Multiple recipients of list ORACLE-L 
oman"> RE: Determinants of control file 
Other than dumping/ tracing the control file, you can find the required details in the 
dynamic view V$controlfile_record_section. This view has all the information you want 
  
  
Best Regards, 
K Gopalakrishnan 
  
  
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane)
Sent: Thursday, November 29, 2001 3:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Determinants of control file 
  
Hi Nirmal, 
  
   Use 
  
alter database backup controlfile to trace; 
    
    You can find these details in the trace file, that will be dumped to your udump destination. 
  
HTH 
Srinivas. 
  
   
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 7:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Determinants of control file 
Hi all, 
The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., 
But after creation of control files, where should i get details about these parameter values?... 
i checked in v$controlfile and v$database... i didn't get enough info on it. 
And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files.
Where will i get the sequence# of other control files then... 
Nirmal, 

RE: Determinants of control file

[Riyaj_Shamsudeen]

Hi
        v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except  maxlogmembers. Here is the query to pull the information..

select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs
where indx in (3,4,2,9)
/
DECODE(INDX,3      RSNUM
- --
MAXINSTANCES              8
MAXLOGFILES                 32
MAXDATAFILES         1022
MAXLOGHISTORY       907

which is matching with my controlfile dump.

CREATE CONTROLFILE REUSE DATABASE "mydb" NORESETLOGS ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 1022
    MAXINSTANCES 8
    MAXLOGHISTORY 907

        I am not sure where maxlogmembers is stored. I will do some more digging to find that..

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






Nirmal Kumar  Muthu Kumaran <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/01/01 08:25 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Determinants of control file


No. i already checked the view v$control_record_section, 
This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc
Nirmal. 
-Original Message- 
t size=1 face="Arial">K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, November 29, 2001 11:27 PM 
To:     Multiple recipients of list ORACLE-L 
oman"> RE: Determinants of control file 
Other than dumping/ tracing the control file, you can find the required details in the 
dynamic view V$controlfile_record_section. This view has all the information you want 
  
  
Best Regards, 
K Gopalakrishnan 
  
  
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane)
Sent: Thursday, November 29, 2001 3:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Determinants of control file 
  
Hi Nirmal, 
  
   Use 
  
alter database backup controlfile to trace; 
    
    You can find these details in the trace file, that will be dumped to your udump destination. 
  
HTH 
Srinivas. 
  
   
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 7:52 AM
To: Multiple recipients of list ORACLE-L
Subject: Determinants of control file 
Hi all, 
The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., 
But after creation of control files, where should i get details about these parameter values?... 
i checked in v$controlfile and v$database... i didn't get enough info on it. 
And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files.
Where will i get the sequence# of other control files then... 
Nirmal, 

RE: Deleting files on w2k

[Ken Janusz]

Title: RE: Deleting files on w2k









My
daughter works for Target in Minneapolis. 
They outsourced some of their support to IBM.  Guess who the IBM people come to when they can't solve a
problem?  

 

Ken

 

-Original
Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001
9:15 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Deleting files on w2k

 

You are!  The
problem is, by going with an os other than windoze of some sort, I am almost
guaranteed that the production hardware and software support will be outsourced
& moved to Denver, CO to IBM's datacenter there.  This stupid company
believes in paying ibm to do everything they are afraid to or can't do.  I
think I should go work for IBM.  The dev servers I will still have. 

I"ll have a linux
server at home yet :)


-Original
Message- 
From:   Kimberly
Smith [SMTP:[EMAIL PROTECTED]] 
Sent:   Monday,
December 03, 2001 9:51 AM 
To: Multiple
recipients of list ORACLE-L 
Subject:    RE:
Deleting files on w2k


Go with Linux.  That
way you could use your same servers:-)  Ain't I so useful!  HA 

-Original
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu,
Lisa
Sent: Monday, December 03, 2001
6:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Deleting files on w2k

Believe me, I wish...
if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000
we'd be there...  I'm stuck with this one.  

-Original
Message-
From:   Kimberly
Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Friday,
November 30, 2001 4:25 PM
To: Multiple
recipients of list ORACLE-L
Subject:    RE:
Deleting files on w2k 

Um, port it to Unix 

-Original
Message-
From: [EMAIL PROTECTED] [ ]On Behalf Of Koivu,
Lisa
Sent: Friday, November 30, 2001
12:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: Deleting files on w2k

I'm trying to test out
backup and recovery on w2k.  However, I can't remove or rename a file
while the database is running!  It says "file in use".  

Am I missing something
or is there a way to force this?  

Thanks 

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117 

rman restore & arclogs

[Koivu, Lisa]

Title: rman restore & arclogs





Good morning all - 


I've been practicing rman restores.  It's a lot easier than I originally thought.  I've noticed that when you restore and the arclogs are needed, it restores them.  Which is expected.  However, when I take another backup, these arclogs are included in the backup set.  This is unnecessary in my opinion and makes my backup files larger than they need to be. 

Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery?  I can verify what arclogs are where in the backup sets with a report.  

Any comments are appreciated.  Thanks


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

Re: Has anyone heard of "Mirror Accessible"?

[Ed]

The Logical Standby Database is listed in Oracle 9i's "New Features"
documentation on Technet, but there is nothing about it in the actual Data
Guard manual that I have found. Maybe it is a 9.0.2 feature as someone else
already indicated.

Best,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, December 01, 2001 9:35 PM


> AFAIK, 9iDataGuard in the current release is only a Physical Standby
> database
> (not "logical standby database").  This is similar to 8i except for the
> fact that, if you
> ensure that you do a clean failover-and-failback (ie have the controlfiles
> and
> online redo log files available) you can actually switch to and from the
> standby.
>
> Never tried it and wouldn't try it till 9.0.2 (at the minimum)
>
> Hemant
>
>
>
> "Miller, Jay" <[EMAIL PROTECTED]>01/12/2001 05:45 AM
> Sent by: [EMAIL PROTECTED]
>
> Please respond to ORACLE-L
>
>  To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>  cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
>  Subject: RE: Has anyone heard of "Mirror Accessible"?
>
>
>
>
>
>
>
>
> Can anyone confirm this?  I've been searching technet and metalink and
> can't
> turn up any details.
>
> -Original Message-
> Sent: Friday, November 30, 2001 3:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Isn't that just in release 2 though?  My understanding is that its not out
> yet.
>
> -Original Message-
> Sent: Friday, November 30, 2001 11:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Ah, this sounds likely.  And it might explain why they were keen on having
> us upgrade to 9i.  That's the problem with receiving the request filtered
> through two additional levels of people.
>
> Jay Miller
>
> -Original Message-
> Sent: Friday, November 30, 2001 1:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 9i has a new feature on standby databases that let's you run reports in
> read
> only while continuing the managed recovery.  I think they call it a
logical
> standby database.  See the 9i DataGuard manual for more information.  (I
> just happened to be looking into this lately).  This might be what they
are
> talking about.
>
> Best,
>
> Ed
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, November 30, 2001 12:05 PM
>
>
> > Only thing I can think of off the top of my head is a standby database
> > opened in read only mode.  Its one of the purposes totted for that
> >
> > -Original Message-
> > Sent: Friday, November 30, 2001 9:47 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > My CIO woes continue. My manager has been told by the CIO that Oracle
has
> a
> > product called "mirror accessible" which allows the database to be
> mirrored
> > for reporting purposes. He wants us to use this product.
> >
> > Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle
Standby
> > and Oracle Replication but he says it isn't any of these. Any idea what
> he
> > might be talking about?
> >
> > Jay Miller
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Miller, Jay
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Kimberly Smith
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ed
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spel

RE: Resume issues - (Not posting my resume)

[Rao, Maheswara]

Bambi,

Excellent one. Great. Printed it and filed in my personal file.

Rao

-Original Message-
Sent: Friday, November 30, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


Dennis --

I sent Kimberly my tips offline (and my resume) but thought I would forward
my tips based on nearly 24 years of experience to you folks in case you find
it of value.  If so, great, if not, oh well, but they were lessons learned
over the years and apply to all jobs, contract and perm.

If you have a boodle of experience, great.  Don't hide it.  But if your
resume is going to be over two pages, go ahead and add a page to the front.
The first page should be all the buzzwords that people are looking for,
broken up into categories:

Education
Hardware
Databases
Languages
Software
Security Clearances
Certifications
Publications
Major Industries That You Know Well (ie., not just database administration
but a good knowledge of a good segment of the industry itself)

That way, nobody has to fish on your resume for words like Oracle, Unix,
C++, PeopleSoft or "Oil and Gas".  If HR people are looking through a pile
of resumes for those buzzwords, the faster you can get into the smaller pile
of people who have those skills, the better off you are.  If someone has to
wade through 4 pages just to see a skill they're looking for, you can pretty
much assume they're not going to take the time.  A-Number-One rule in
job-hunting is Make Your Resume Friendly to The People Making Small Piles of
Big Piles.  The person you're actually going to be working for won't get to
be impressed by all the cool stuff you've done if he/she never gets the
resume.

Work experience (if you've been an employee most of your professional
career) or project experience (if you've been a consultant most of your
professional career) should follow.  Write about the major things you've
done at your jobs/clients in paragraphs.  Use whole sentences.  Pretend that
you are as comfortable with the written word as you are with grep and awk.
Some people say bullet points with action verbs are the way to go; I don't
agree.  You have a small amount of space to demonstrate "verbal and written
communication skills" (which is a requirement for EVERY JOB), make the most
of it.

As for which jobs to list and which not to, my rule of thumb is that if
you've been at a particular job/client for more than 6 months, it should be
listed by name, you might want to modify that to suit your experience.
Regardless, if you've been doing a bunch of short-term projects, you can
clump them in together in a single paragraph that shows a particular chunk
of time with only your major clients listed by name in there.  If you have
minor clients (companies nobody's ever heard of) in that chunk of time,
don't bother listing them, even if you have no major clients in there.
There's no shame in saying "small business" or "mid-size corporation" rather
than "Joe's Barbershop" or "Peppers Waterbeds".  When you have client with a
household name, their name should appear in the paragraph.

If you did vastly different things for different clients on a short-term
basis, it is still better to cluster them together than not to.  You'd
rather look like a stable person with a variety of skills than a huge
job-hopper who never stays anywhere very long (even if the latter is
substantially more true than the former).

One mistake to avoid:  if you've been at a client for 12 years, the
paragraph doesn't have to be long to prove it.  You may have a shorter
paragraph for a long job where your job function was clearly defined than a
much shorter job where you were a maverick/firefighter/janitor.

And if your resume has to be 5 pages, then it has to be 5 pages.  There's a
limit to how small you can make the type and how short you can make the
paragraphs.  You still need your resume to be your representative, and if
you've been in the field for a long time, you sometimes just can't be
represented by one page.  

Hope this helps...
Bambi.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Deleting files on w2k

[Koivu, Lisa]

Title: RE: Deleting files on w2k





You are!  The problem is, by going with an os other than windoze of some sort, I am almost guaranteed that the production hardware and software support will be outsourced & moved to Denver, CO to IBM's datacenter there.  This stupid company believes in paying ibm to do everything they are afraid to or can't do.  I think I should go work for IBM.  The dev servers I will still have. 

I"ll have a linux server at home yet :)


-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, December 03, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Deleting files on w2k


Go with Linux.  That way you could use your same servers:-)  Ain't I so useful!  HA


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Monday, December 03, 2001 6:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Deleting files on w2k




Believe me, I wish... if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be there...  I'm stuck with this one.  

-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, November 30, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Deleting files on w2k 


Um, port it to Unix 


-Original Message-
From: [EMAIL PROTECTED] [ ]On Behalf Of Koivu, Lisa
Sent: Friday, November 30, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Deleting files on w2k




I'm trying to test out backup and recovery on w2k.  However, I can't remove or rename a file while the database is running!  It says "file in use".  

Am I missing something or is there a way to force this?  


Thanks 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117 

RE: UTL_FILE_DIR problem

[Larry Elkins]

Connor,

Can you please test your code before posting ;-)

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Connor
> McDonald
> Sent: Monday, December 03, 2001 9:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: UTL_FILE_DIR problem
> 
> 
> In particular,
> 
> declare
>   f utl_file.file_type;
> begin
> for i in ( select name from v$datafile
>  order by file# desc ) loop
>f := utl_file.fopen(
>  substr(i.name,1,instr(i.name,'/',-1)),
>  substr(i.name,instr(i.name,'/',-1)+1),
>  'W');
>   utl_file.fclose(f);
> end loop;
> end;
> /
> 
> which (pending fixing any compile errors) will do its
> best to reduce all datafiles in the database to 0
> bytes finishing with SYSTEM.
> 
> Cheers
> Connor

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

DISK LAYOUT

[Harvinder Singh]

Title: RE: Deleting files on w2k



Hi,
We have to performance benchmark test for our application .
We have to check only scalibiliy and performance and not much concern for 
reliablity.
We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot 
disks).4 400MHZ cpu's
Expected database size is 250G..
1) Which raid level to use ...only for performance so may be no 
mirroring..
2) did i have to split hard disks on 2 sets for indexes and tables or single 
set of RAID 0 etc...
3) Where to place the log files , control files, oracle software , OS , 
tablespaces - System , Users(tables) , Temp, Indx (Indexes) , Rbs , 
Tools.
 
Thanks
-Harvinder

Re: Buffer Busy Waits -- Sanity check please

[Riyaj_Shamsudeen]

Jared
        Say, process A is interested in reading a block, then it hashes the data block address of the block to find the hash bucket in the buffer cache. If that specific block is in the buffer cache, then it must be attached with that hash bucket. Holding the hash bucket latch, the process A will look for the buffer in that hash chain with that data block address . If the buffer is found in the buffer cache, then that process has to examine the state of the buffer before proceeding further.
        If another process B is operating on the buffer, i.e. reading a database block from the disk in to the buffer (for FTS or otherwise), then the process B will pin the buffer and the buffer is not available until the read is completed. So, the process A will wait for the buffer to be unpinned, posting 'buffer busy event'. Since this event can happen in various points in the buffer lifecycles, p3 indicates details about the wait itself.
        Point being that, two processes can not  operate on the same buffer simultaneously. Even though readers do not block readers in terms of locks, they could be blocked due to buffer unavailability, but this event is usually very brief.
        As malcolm suggested, probably, the processes are chasing one another.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






Jared Still <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/02/01 10:15 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Buffer Busy Waits -- Sanity check please



Interesting.  Any idea of what the point is in preventing other processes
from reading a block in the buffer?  

Jared

On Saturday 01 December 2001 20:10, MacGregor, Ian A. wrote:
> The P3 value of 130 on the buffer busy waits does indicate that the block
> is being read by another process as Malcolm stated that's the process doing
> the scattered read (Full table scan).  Oracle needs to protect the block
> while it is being read.   The others sessions are waiting until the read of
> that block is complete.
>
> For a definition of the P3 values see Steve Adam's website
> http://www.ixora.com.au/
>
> His full explanation of P3 id 130 is
>
>
>    1013    Block is being read by another session and no other
>  or 130    suitable block image was found, so we wait until the read
>            is completed. This may also occur after a buffer cache
>            assumed deadlock. The kernel can't get a buffer in a
>            certain amount of time and assumes a deadlock. Therefore it
>            will read the CR version of the block.
>
>
> Ian MacGregor
>
> -Original Message-
> Sent: Saturday, December 01, 2001 6:20 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Malcolm,
>
> The paragraph below would indicate that readers are blocking.
>
> Readers don't block in Oracle.  The only reason I can think of at
> the moment for a SELECT to cause buffer busy waits is delayed
> block cleanout, of which there has been a lot of discussion lately.
>
> I could be all mixed up here I guess,  it's Saturday and I dont' want
> to think too hard about all this. Don't have time to break out the FM
> so I'll just sit back and wait for you to agree or refute.  ;)
>
> Jared
>
> On Tuesday 27 November 2001 00:25, Thorns, Malcolm (NESL-IT) wrote:
> > Jeff,
> >
> > The 3 sessions are doing the same (or similar) queries.  In this case
> > count(*) which is forcing a full table scan of the table in each session.
> > The 3 sessions are thus trying to access the same blocks from the SGA, 
> > in the same order.  Only 1 session can access a block in the SGA at a
> > time - this is the session showing 'db file scattered read'. The other 2
> > sessions need to wait for the block (these waits show as 'buffer busy
> > waits' - ie waiting for the block in the SGA).  You will see the block id
> > (and perhaps the file id) changing as the FTS's progress.  Thus the
> > sessions are 'chasing' each other through the blocks - holding each other
> > up with SGA block contention - which shows up as 'buffer busy waits'. 
> > Hope that explains things.
> >
> > Regards,
> >
> > Malcolm
> >
> > -Original Message-
> > Sent: Monday, November 26, 2001 11:21 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > We recently had a new website go live.   Since then, I'm seeing constant
> > buffer busy waits
> > and after a period of time, I see sessions hung on the same block#.   
> > The SQL query
> > is always a COUNT(*) (below).   It's almost as though one session has a
> > lock
> >
> > of some sort in the buffer cache and other sessions are blocked.
> > Although, I've checked and
> > there's no DML ongoing, so I'm unsure as to why we would see this.   Note
> > that v$session shows
> > 78 and 393 to be INACTIVE, while 159 is ACTIVE.    So it's like 159 can't
> > write to
> > the buffer cache because 78 and 393 have a lo

RE: UTL_FILE_DIR problem

[Connor McDonald]

In particular,

declare
  f utl_file.file_type;
begin
for i in ( select name from v$datafile
 order by file# desc ) loop
   f := utl_file.fopen(
 substr(i.name,1,instr(i.name,'/',-1)),
 substr(i.name,instr(i.name,'/',-1)+1),
 'W');
  utl_file.fclose(f);
end loop;
end;
/

which (pending fixing any compile errors) will do its
best to reduce all datafiles in the database to 0
bytes finishing with SYSTEM.

Cheers
Connor


 --- "Thomas, Kevin" <[EMAIL PROTECTED]>
wrote: > >if I set UTL_FILE_DIR = *
> >would there be any security issue ?
> 
> In a word yes...this allows read/write access to
> *all* directories and there
> is bound to be particular ones you don't want people
> to see.
> 
> 
> 
> -Original Message-
> Sent: 03 December 2001 11:40
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> I got one problem about UTL_FILE_DIR.
> My oracle version is 8i 8.1.6
> Platform is unix sun solaris.
> 
> I have set UTL_FILE_DIR to : /customer/ShopA
> and I write PL/SQL code to write a log file (A.txt
> )into /customer/ShopA
> When I execute the PL/SQL job through SQLPLUS,
> I hit error message saying that I can't write to the
> directory.
> the /customer/ShopA directory permission is  set to
> 664.
> Let's say owner is A, and the group is A1
> 
> Can I tell the program to access the directory and
> write to the file as
> another user ?
> If I'm not wrong, the program will try to write into
> the directory using
> oracle unix account.
> Note : I don't want to set the write permission to
> other group.
> I have tried to include oracle in A1 group using
> secondary group, but it
> couldn't work.
> 
> Can somebody tell me how to let oracle write into
> the directory and the file
> as well without
> changing the directory / file permission.
> 
> if I set UTL_FILE_DIR = *
> would there be any security issue ?
> 
> Any help will be greatly appreciated.
> 
> Thanks & Regards
> Herman
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Herman Susantio
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Nokia 5510 looks weird sounds great. 
Go to http://uk.promotions.yahoo.com/nokia/ discover and win it! 
The competition ends 16 th of December 2001.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Deleting files on w2k

[Adrian Roe]

Title: RE: Deleting files on w2k



Unlike 
UNIX, NT will not let you delete a file while another process (ie. 
Oracle) has got a hold on it. I assume Win2K is the 
same.
 
 
-Original Message-From: Koivu, 
Lisa [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001 
14:20To: Multiple recipients of list ORACLE-LSubject: RE: 
Deleting files on w2k

  Believe me, I wish... if we could get a 
  bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be 
  there...  I'm stuck with this one.  
  
-Original Message- From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent:   Friday, November 30, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Deleting files on w2k 
Um, port it to Unix 

  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, 
  LisaSent: Friday, November 30, 2001 12:40 PMTo: Multiple 
  recipients of list ORACLE-LSubject: Deleting files on 
  w2k
  I'm trying to test out backup and recovery on 
  w2k.  However, I can't remove or rename a file while the database is 
  running!  It says "file in use".  
  Am I missing something or is there a way to force 
  this?  
  Thanks 
  Lisa KoivuOracle Database MonkeyFairfield Resorts, 
  Inc.954-935-4117 


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.


==

RE: Deleting files on w2k

[Kimberly Smith]

Title: RE: Deleting files on w2k



Go 
with Linux.  That way you could use your same servers:-)  Ain't I so 
useful!  HA

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Monday, December 03, 2001 6:20 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Deleting files on w2k
  Believe me, I wish... if we could get a 
  bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be 
  there...  I'm stuck with this one.  
  
-Original Message- From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent:   Friday, November 30, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Deleting files on w2k 
Um, port it to Unix 

  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, 
  LisaSent: Friday, November 30, 2001 12:40 PMTo: Multiple 
  recipients of list ORACLE-LSubject: Deleting files on 
  w2k
  I'm trying to test out backup and recovery on 
  w2k.  However, I can't remove or rename a file while the database is 
  running!  It says "file in use".  
  Am I missing something or is there a way to force 
  this?  
  Thanks 
  Lisa KoivuOracle Database MonkeyFairfield Resorts, 
  Inc.954-935-4117 

RE: Deleting files on w2k

[Koivu, Lisa]

Title: RE: Deleting files on w2k





Believe me, I wish... if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be there...  I'm stuck with this one.  

-Original Message-
From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, November 30, 2001 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Deleting files on w2k


Um, port it to Unix


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Friday, November 30, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Deleting files on w2k




I'm trying to test out backup and recovery on w2k.  However, I can't remove or rename a file while the database is running!  It says "file in use".  

Am I missing something or is there a way to force this?  


Thanks 


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117 

RE: Doubts reg :Export and import

[SARKAR, Samir]

Mark,

The COMPRESS=Y option is basically used to combine multiple extents into a 
single large extent while importing...it is useful when u r trying to 
defragment the segment.
If u export 5 extents of 100MB using this option, it will b imported 
as one single extent of 500 MB which means that the initial extent of
the storage clause of the extent will b changed to 500M.
There is a flipside to this. If u have a large table, and the size of the 
table is greater than the largest block of free space in ur database, then
u wont b able to import it back as one single extent and ur import will fail
since extents cannot span datafiles.

Hope this helps.

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 03 December 2001 10:50
To: Multiple recipients of list ORACLE-L


OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..

When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to 5
extents of 100Mb - or one of 500Mb?

My thought would be that it imports in to 5 extents of 100Mb, but logic
sometimes doesn't prevail - so just curious :)

Cheers

Mark

-Original Message-
Shrinivas (MED, Keane)
Sent: 01 December 2001 05:10
To: Multiple recipients of list ORACLE-L


If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.

you must be carefule to use compress=y.

'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)

eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)

HTH
Srinivas
-Original Message-
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L


The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:
>
> Another one that apparently has access to e-mail but not to the
internet to
> RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
> read e-mails but cannot read FM etc.
>
> Alex Hillman
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
> > Sent: Wednesday, November 28, 2001 12:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Doubts reg :Export and import
> >
> >
> > hi list,
> >
> > what is the exact use of mentioning 'compress' yes
> > or no while exportingwill this store the .dmp file
> > in compressed format in system,if given 'yes'.
> >
> > while importing the dumpfile why is it necessary to
> > give 'fromuser',is 'touser' not enough.
> >
> > sangeetha
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sangeetha
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alex Hillman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)

--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author

RE: UTL_FILE_DIR problem

[Thomas, Kevin]

>if I set UTL_FILE_DIR = *
>would there be any security issue ?

In a word yes...this allows read/write access to *all* directories and there
is bound to be particular ones you don't want people to see.



-Original Message-
Sent: 03 December 2001 11:40
To: Multiple recipients of list ORACLE-L


Hi all,

I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.

I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message saying that I can't write to the directory.
the /customer/ShopA directory permission is  set to 664.
Let's say owner is A, and the group is A1

Can I tell the program to access the directory and write to the file as
another user ?
If I'm not wrong, the program will try to write into the directory using
oracle unix account.
Note : I don't want to set the write permission to other group.
I have tried to include oracle in A1 group using secondary group, but it
couldn't work.

Can somebody tell me how to let oracle write into the directory and the file
as well without
changing the directory / file permission.

if I set UTL_FILE_DIR = *
would there be any security issue ?

Any help will be greatly appreciated.

Thanks & Regards
Herman









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Herman Susantio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: UTL_FILE_DIR problem

[Ball, Terry]

It seems to me, I remember something like this.  If I do remember correctly,
you need the execute permissions for the directory, so it would need to be
775.

Terry

-Original Message-
Sent: Monday, December 03, 2001 5:40 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.

I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message saying that I can't write to the directory.
the /customer/ShopA directory permission is  set to 664.
Let's say owner is A, and the group is A1

Can I tell the program to access the directory and write to the file as
another user ?
If I'm not wrong, the program will try to write into the directory using
oracle unix account.
Note : I don't want to set the write permission to other group.
I have tried to include oracle in A1 group using secondary group, but it
couldn't work.

Can somebody tell me how to let oracle write into the directory and the file
as well without
changing the directory / file permission.

if I set UTL_FILE_DIR = *
would there be any security issue ?

Any help will be greatly appreciated.

Thanks & Regards
Herman









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Herman Susantio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ball, Terry
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN disaster recovery

[Mercadante, Thomas F]

Dennis,

And even if there is a problem with the Rman trying to use a link, pointing
to another directory, you can always create a new mount point /ora01 on the
box provided to you, right?  I think what you are trying to do is very
feasible and covered within the Oracle docs.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, November 30, 2001 6:20 PM
To: Multiple recipients of list ORACLE-L


> I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
> SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN 
> will be fine with that?

I vaguely recall that prior versions of the docs did not support this but
now I see no such "non-support warning" from Oracle (in the 817 docs) so
symbolic links "should" be fine as long as you ensure that they resolve to
the same name as occurs in the control files. Quoting page 10-123 of the
manual:

"If datafile filenames are symbolic links, that is, files that point to
other files, then the control file contains the filenames of the link files
but RMAN performs I/O on the datafiles pointed to by the link files. If a
link file is lost and you restore a datafile without first re-creating the
symbolic link, however, then RMAN restores the datafile to the location of
the link file rather than to the location pointed to by the link."

Of course you should test this... and let us know how it turns out. :-)

If you have trouble with the symbolic links then you can always fall back to
the "Oracle sanctioned" method Tom pointed out. It's in the section titled,
"Moving the Target Database to a New Host with a Different File System,"
page 6-7. I did this using control files (nocatalog) and it worked just
fine.

For comfort factor, I'd recommend that you create the smallest test database
you can and prove the 11 steps in this section by restoring your small test
DB to another machine. Besides, it's a fun thing to do. :-)

Steve Orr
Bozeman, MT


P.S. 
Speaking of "backups," I got my OOW badge and I'm leaving Walt here to hold
down the fort. Between the two of us we've somehow fooled damagement into
thinking that they really need us... but the down side is that we can't both
be out of town at the same time. So when Walt goes to IOUG I have to stay
here as his backup. If you have any more questions about RMAN for the next
week feel free to pummel Walt. Along with other folks on this list, he's one
of the gurus listed in the Acknowledgments of the new "Oracle RMAN Pocket
Reference" from O'Reilly. :-) 



-Original Message-
Sent: Friday, November 30, 2001 2:05 PM
To: Multiple recipients of list ORACLE-L

Thanks for the input, Cherie, Kimberly, Tom

The part I'm still uncertain is as follows - see the sentence in caps below:
On my current system let's say I have RMAN write its backup file to
a disk location "/ora01". I also have my RMAN catalog on a separate server,
and have written an export to my backup tape also.
After my disaster, my hardware vendor offers me the use of a
comparable system at a different location. I grab my backup tape and get in
the car. And if it is a real disaster, maybe it is the older backup out of
the off-site vault.
Let's assume that Oracle is already installed on this new system
just to move the story along as Hollywood would say.
I load my RMAN catalog.
I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN will be
fine with that?
I fire up RMAN and start the recovery process. Using the syntax Tom
provided, I should be able to account for any other device naming or path
naming problems.

Kimberly - we aren't quite talking about the need for a standby database.
This manager's point, and I feel it is a good one, is that if you have been
making backups and storing them off-site, you should be able to mount those
backups on a new machine and get your system back. Eventually. Given a lot
of time. If something catastrophic happens and you say that because the
company didn't spend the big bucks for a duplicate remote data center with a
standby database, the recovery will take a week, that would be survivable.
But if you say that because you switched to this really keen backup method
there is just no way to ever get the data back, well you better make sure
your resume was off-site as well. 
Naturally before we quit making weekly cold backups we are going to
have to actually test this scenario. I assume that the same applies to your
sites also.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, November 30, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L

Also, if that is the type of recovery he wants then sell him on
a standby database.  If you lose your server that severely you
will only be able to get back to the last backup regardless of
where your recovery catalog is (hopefully on another 

RE: RMAN disaster recovery

[Cherie_Machler]

Dennis,

I believe that Note 73974.1 - "Restoring and RMAN Backup to Another Node"
has the details you are looking for.

Essentially, when you need to recover to another server that does not have
mount points or file systems directory
names that match in name and size, you need to rename your datafiles and
then do a switch datafiles before you recover the database.

If you want to, you can restore the datafiles you need to files of
different names that include the different, new file directory while you
are
restoring them.   It's pretty cool.   Following is an excerpt from a
restore to a different host that I was doing this weekend:

run {

allocate channel c1 type 'sbt_tape';


set newname for datafile  1 to '/oraprd01/DWPRD02/DWPRD02_system_01.dbf';
set newname for datafile  2 to '/oraprd01/DWPRD02/DWPRD02_rbs_01.dbf';
set newname for datafile  3 to '/oraprd01/DWPRD02/DWPRD02_rbs2_01.dbf';
set newname for datafile  4 to '/oraprd01/DWPRD02/DWPRD02_temp_01.dbf';
.
.
.
set newname for datafile 146 to
'/oraqatmp/DWPRD02/DWPRD02_exp_rpt_hdr_data_01.d
bf';
set newname for datafile 147 to
'/oraqatmp/DWPRD02/DWPRD02_lg_data02_21.dbf';
set newname for datafile 148 to
'/oraqatmp/DWPRD02/DWPRD02_precise_temp02.dbf';

restore database;

# There is no need to manually catalog any archivelogs before the recovery,
# as Recovery Manager does an implicit catalog resync from the current
# control file.
# But, once an RMAN recover database command fails, manual restoring
archivelogs
# and using Server Manager to recover may be required.

switch datafile all;

recover database;

HTH,

Cherie Machler
Oracle DBA
Gelco Information Network


   

DENNIS WILLIAMS

  
TOUCH.COM>cc:  

Sent by:  Subject: RE: RMAN disaster recovery  

[EMAIL PROTECTED]

m  

   

   

11/30/01 03:05 

PM 

Please respond 

to ORACLE-L

   

   





Thanks for the input, Cherie, Kimberly, Tom

The part I'm still uncertain is as follows - see the sentence in caps
below:
   On my current system let's say I have RMAN write its backup file
to
a disk location "/ora01". I also have my RMAN catalog on a separate server,
and have written an export to my backup tape also.
   After my disaster, my hardware vendor offers me the use of a
comparable system at a different location. I grab my backup tape and get in
the car. And if it is a real disaster, maybe it is the older backup out of
the off-site vault.
   Let's assume that Oracle is already installed on this new system
just to move the story along as Hollywood would say.
   I load my RMAN catalog.
   I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE
NEW
SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN will be
fine with that?
   I fire up RMAN and start the recovery process. Using the syntax
Tom
provided, I should be able to account for any other device naming or path
naming problems.

Kimberly - we aren't quite talking about the need for a standby database.
This manager's point, and I feel it is a good one, is that if you have been
making backups and storing them off-site, you should be able to mount those
backups on a new machine and get your system back. Eventually. Given a lot
of time. If something catastrophic happens and you say that because the
company didn't spend the big bucks for a duplicate remote data center with
a
standby database, the recovery will take a week, that would be survivable.
But if you say that because you switched to this really keen backup method
there is just no way to ever get the data back, well you bett

RE: Export/Import Job

[Hallas John]

Re-reading my e-mail I had better jump in and correct 
the first line to read exporting/importing rather than exporting!!. Obviosuly 
exporting a schema is fully supported
 
John

  -Original Message-From: Hallas John 
  [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001 
  12:10To: Multiple recipients of list ORACLE-LSubject: 
  RE: Export/Import Job
  Exporting an individual schema within APPS (GL /PA 
  etc) is not recommended due to the number of constraints that cross schemas 
  (to fnd tables for instance).
  So 
  changing the block size is essentially non Apps specific and is just a 
  straight export /import.
  Depending on your hardware and plan I would have 
  expected you to be able to start on a Saturday and complete on Sunday 
  (sometime).
  Run 
  as much archiving/purging as you can (certainly tables like fnd_requests 
  should be tidied down as much as possible).
  Have 
  a few dummy runs so that the the scripts are all fully tested and you have a 
  good checklist of all the scripts and expected timings.
  Most 
  importantly of all ensure that you can revert back from your backup safely and 
  as quickly as possible.
  Hopefully you will have the space to pre-create the 
  instance (dummy sid) and then rename it once you have completed the export of 
  live (Come to think of it, if you have that space you can retain both 
  instances and that certainly helps if you decide to abandon the build or 
  revert for any reason)
   
   
  PS 
  Unless the database really needs re-building what other benefits do you expect 
  from changing the block size?
   
  HTH
   
  John
   
   
  
-Original Message-From: Nick Wagner 
[mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 
21:05To: Multiple recipients of list ORACLE-LSubject: 
Export/Import Job
If anyone out 
there has a good time estimate for the following export/import job I would 
appreciate it.  The goal is to change the DB_BLOCK_SIZE.  

 
Application: 
Oracle Apps 11i
Database Size: 
100GB, actually only about 80GB is used space.
2 CPU HP L-Class 
machine.  
 
I just need a 
couple of good estimates of how many days/hours this will take.   
I'm guessing around 3 days...  but I have never done anything this 
large before. 
 
Thanks!! 

 
Nick>>This 
  electronic message contains information from the mmO2 plc Group which may 
  be privileged or confidential. The information is intended to be for the 
  use of the individual(s) or entity named above. If you are not the 
  intended recipient be aware that any disclosure, copying, distribution or 
  use of the contents of this information is prohibited. If you have 
  received this electronic message in error, please notify us by telephone 
  or email (to the numbers or address above) 
  immediately.>>

RE: Export/Import Job

[Hallas John]

Exporting an individual schema within APPS (GL /PA etc) 
is not recommended due to the number of constraints that cross schemas (to fnd 
tables for instance).
So 
changing the block size is essentially non Apps specific and is just a straight 
export /import.
Depending on your hardware and plan I would have 
expected you to be able to start on a Saturday and complete on Sunday 
(sometime).
Run as 
much archiving/purging as you can (certainly tables like fnd_requests should be 
tidied down as much as possible).
Have a 
few dummy runs so that the the scripts are all fully tested and you have a good 
checklist of all the scripts and expected timings.
Most 
importantly of all ensure that you can revert back from your backup safely and 
as quickly as possible.
Hopefully you will have the space to pre-create the 
instance (dummy sid) and then rename it once you have completed the export of 
live (Come to think of it, if you have that space you can retain both instances 
and that certainly helps if you decide to abandon the build or revert for any 
reason)
 
 
PS 
Unless the database really needs re-building what other benefits do you expect 
from changing the block size?
 
HTH
 
John
 
 

  -Original Message-From: Nick Wagner 
  [mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 
  21:05To: Multiple recipients of list ORACLE-LSubject: 
  Export/Import Job
  If anyone out 
  there has a good time estimate for the following export/import job I would 
  appreciate it.  The goal is to change the DB_BLOCK_SIZE.  
  
   
  Application: 
  Oracle Apps 11i
  Database Size: 
  100GB, actually only about 80GB is used space.
  2 CPU HP L-Class 
  machine.  
   
  I just need a 
  couple of good estimates of how many days/hours this will take.   
  I'm guessing around 3 days...  but I have never done anything this large 
  before. 
   
  Thanks!! 
  
   
  Nick

>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

UTL_FILE_DIR problem

[Herman Susantio]

Hi all,

I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.

I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message saying that I can't write to the directory.
the /customer/ShopA directory permission is  set to 664.
Let's say owner is A, and the group is A1

Can I tell the program to access the directory and write to the file as
another user ?
If I'm not wrong, the program will try to write into the directory using
oracle unix account.
Note : I don't want to set the write permission to other group.
I have tried to include oracle in A1 group using secondary group, but it
couldn't work.

Can somebody tell me how to let oracle write into the directory and the file
as well without
changing the directory / file permission.

if I set UTL_FILE_DIR = *
would there be any security issue ?

Any help will be greatly appreciated.

Thanks & Regards
Herman









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Herman Susantio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Snapshot Problems

[A. Bardeen]

Jeff,

Sorry, I didn't read your original email properly
(geez, I hate it when I do that) and now I see that
you're getting this error on creating the snapshot,
not refreshing it, so my previous answer won't help
you much.

What versions are the db's involved?  If the master
site is not 8.0.6 or 8.1.5 then you may be able to
workaround this by creating the snapshot via offline
instantiation (see Note: 1057037.6, the only change
for 8i is that the snapshot base table is no longer
prefixed with SNAP$_).

Another alternative, if the snapshot site is 8i, may
be to use prebuilt tables if you can prevent changes
to the master table during the time it takes you to do
the CTAS against the master table and then perform a
fast refresh.

HTH,

-- Anita

--- "A. Bardeen" <[EMAIL PROTECTED]> wrote:
> Jeff,
> 
> This sounds like bug 893259 "CREATE SNAPSHOT ON
> TABLE
> W/ VARCHAR2(4000) TRUNCATES COLUMN TO
> VARCHAR2(2000)"
> that's fixed in 8.1.6 and later.
> 
> The bug causes the snapshot to be incorrectly
> created
> with a varchar2(2000) column instead of the larger
> column from the base table.  
> 
> Have you compared the column definitions between the
> master and snapshot table?  If the only difference
> is
> that the snapshot has columns of a shorter length
> than
> the master table, I should think you'd be able to
> workaround this by altering the snapshot base table
> to
> increase the column length of those columns to match
> the column lengths of the master table.  The refresh
> should then work properly.
> 
> HTH,
> 
> -- Anita
> 
> --- Jeff Wiegard <[EMAIL PROTECTED]>
> wrote:
> > Good Day.
> > 
> > I have a problem with recreating some snapshots. I
> > would like to
> > add to the current set of snapshots. They were
> > created in the
> > following manner:
> > 
> > create snapshot snap_test as select * from
> > test@test_DB;
> > 
> > They are executed nightly in the following manner:
> > 
> > execute DBMS_SNAPSHOT.REFRESH('SCOTT.TEST','?');
> > 
> > 
> > However, when I try and create them, I get an
> > ORA-01406 error, due
> > to truncation of the varchar2(4000) . According to
> > Oracle, this is a
> > bug. Does someone know of a work-around?  
> > 
> > Jeff
> 
> 
> __
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
> 


__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Time Machine

[MCUK]

--Boundary-00=_9KJR12S0
Content-Type: Multipart/Alternative;
  boundary="Boundary-00=_9KJRBHK0"


--Boundary-00=_9KJRBHK0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi List,=0D
=0D
(Oracle 8i, SunOS 5.7)=0D
=0D
Can anyone tell me if resetting the time on our production machine (for
example at 23:55, resetting to 23:50 and then doing this every 5 minutes =
for
approximately 5 or 6 times) would have any adverse effect on our database=
=2E=0D
We can assume that the nightly hot backups would run some hours after thi=
s
exercise has finished.=0D
Our sys. admins. have been tasked with this to allow for some (unorthodox=
)
month end processing.=0D
=0D
Thanks in advance,=0D
=0D
Ron
--Boundary-00=_9KJRBHK0
Content-Type: Text/HTML;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



=0D=0A=







  Hi List,
   
  (Oracle 8i, SunOS 5.7)
   
  Can anyone tell me if resetting the time on our production mac=
hine=20
  (for example at 23:55, resetting to 23:50 and then doing this every=
 5=20
  minutes for approximately 5 or 6 times) would have any adverse effe=
ct on=20
  our database.
  We can assume that the nightly hot backups would run some hour=
s after=20
  this exercise has finished.
  Our sys. admins. have been tasked with this to allow for some=20
  (unorthodox) month end processing.
   
  Thanks in advance,
   
  Ron





=09
=09
=09
=09
=09
=09
=09




http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9";>cid:IMSTP.gif"; align=3Dbaseline border=3D0> =20
IncrediMail - Email has finally evolved - http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9";>Click=20
Here


--Boundary-00=_9KJRBHK0--

--Boundary-00=_9KJR12S0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-ID: 

R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gLwAA
ACH/C05FVFNDQVBFMi4wAwEh+QQJFAAIACwAFAAPAAAEVRDJSaudJuudrxlEKI6B
URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt
E30tVVRscMHDqV/u+AgAIfkEBWQACAAsABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE
CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ
AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAFAAPAAAEEhDJ
Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj
1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5
BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs=

--Boundary-00=_9KJR12S0--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MCUK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Doubts reg :Export and import

[Mark Leith]

OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..

When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to 5
extents of 100Mb - or one of 500Mb?

My thought would be that it imports in to 5 extents of 100Mb, but logic
sometimes doesn't prevail - so just curious :)

Cheers

Mark

-Original Message-
Shrinivas (MED, Keane)
Sent: 01 December 2001 05:10
To: Multiple recipients of list ORACLE-L


If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.

you must be carefule to use compress=y.

'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)

eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)

HTH
Srinivas
-Original Message-
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L


The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:
>
> Another one that apparently has access to e-mail but not to the
internet to
> RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
> read e-mails but cannot read FM etc.
>
> Alex Hillman
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
> > Sent: Wednesday, November 28, 2001 12:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Doubts reg :Export and import
> >
> >
> > hi list,
> >
> > what is the exact use of mentioning 'compress' yes
> > or no while exportingwill this store the .dmp file
> > in compressed format in system,if given 'yes'.
> >
> > while importing the dumpfile why is it necessary to
> > give 'fromuser',is 'touser' not enough.
> >
> > sangeetha
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sangeetha
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alex Hillman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)

--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
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, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to

Re: killing system user

[Jared Still]

The session is rolling back, you can't kill it.

This is why the serial# is changing.

The following query can be used to track its progress.

select s.osuser
  ,s.username
  ,s.sid
  ,r.segment_name
  ,t.space
  ,t.recursive
  ,t.noundo
  ,t.used_ublk
  ,t.used_urec
  ,t.log_io
  ,t.phy_io
  ,substr(sa.sql_text,1,200) txt
from v$session s,
 v$transaction t,
 dba_rollback_segs r,
 v$sqlarea sa
where s.taddr=t.addr
and   t.xidusn=r.segment_id(+)
and   s.sql_address=sa.address(+);

Jared


On Sunday 02 December 2001 22:55, Tatireddy, Shrinivas (MED, Keane) wrote:
> Hi lists,
>
> Solaris 2.7
> oracle 8i
>
> I have a session "SYSTEM" doing import into a table. (logged into server
> thru telnet from win 98 PC)
>
> Suddenly the power outage occurred to my PC.
>
> When I logged into the server thru telnet, I found that the session is
> active.
> By mistake, I killed the process at o/s level.
>
> For somereasons,I tried to drop the table. But I failed to do it, as it
> is locked by import process.
>
> I tried to kill the user "SYSTEM". But the oracle is giving  error that
> there is not user with such sid and serial number.
>
> The serial# number is often getting changed when I query from v$session.
>
> Is there a way to kill this user, without shutting down the database.
>
> And why different serial# number each time, I query v$SESSION.?
>
> Any clues?
>
> Thnx and Regards,
>
> Srinivas
-- 
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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).