date:20020228


This one is priceless!


At 2/28/02, you wrote:
>Cable-hoarding boss? Magic!
>
>We had a completely non-technical manager a while ago. Our main billing
>system developed silent memory errors that were corrupting the data until
>one day the system wouldn't come back (Ingres, don't ask). In a high-powered
>emergency meeting this manager, all red-faced and full of hell asks what the
>problem was. "Memory corruption" someone replies. "Right! Then why are we
>using memory! Get the database out of memory. I want it running off disk!"
>Classic!
>
>
>Cheers,
>
>Harry Lowes
>Database Administrator,
>npower Northern Limited
>mailto:[EMAIL PROTECTED]
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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: Manager decrees "his" data warehouse design. Help!


(laughing so hard I'm choking!)
My deepest, most sincere sympathies on such a boring work 
place!

At 2/27/02, you wrote:
wow .. 
now my place of work seems oh so normal !! kinda boring
really ... 

Nelson Flores 
Project Manager 
[EMAIL PROTECTED] 
-

Information Technology Center http://cti.intec.cl 
Corporación de investigación Tecnológica - Intec http://cti.intec.cl 
- 
Avda el condor 844 Ciudad Empresarial Huechuraba Santiago - Chile 
-Mensaje original- 
De: Bellows, Bambi [mailto:[EMAIL PROTECTED]] 
Enviado el: Miércoles, 27 de Febrero de 2002 15:29 
Para: Multiple recipients of list ORACLE-L 
Asunto: RE: Manager decrees "his" data warehouse design. Help! 
Both.  I was a consultant to this pharmaceutical company at the time and I 
honestly liked the job that I was doing, so I stuck it out.  After I got 
over the initial shock of having an insane boss, I found the whole thing 
amusing.  Seems he didn't trust the data center with cables for some weird 
reason, and after the company relieved him of his post (OH so gently), his 
garage had something like $30K worth of cables in it.  They didn't press 
charges.  But, MAN, there were some stories. 
-Original Message- 
Sent: Wednesday, February 27, 2002 12:14 PM 
To: Multiple recipients of list ORACLE-L 
Hi Bambi, 
> I once had a manager who was a paranoid schizophrenic. 
BEEN THERE! 

A former boss from hell got very angry (there's a reason they call it "mad") 
because he tried to fire me and found out he couldn't. Even so, he liked 
having me around because he needed me. I hung in there because the company 
was paying for my masters degree at the time. Later, after I got the degree, 
I left for greener pastures within the company. In the exit interview my 
former boss accused me of abandonning him, congratulated me on my move, and 
literally wept at my departure. He confessed he had been trying to "get my 
goat" because he was a 20 year military man who managed by intimidation. But 
he respected me because I was never intimidated, always stood my ground, 
behaved as a gentleman, and served him faithfully (his words). Two years 
later I saw my former boss from hell on the 6 o'clock news being put into a 
police squad car and with yellow crime scene ribbons around his house. Turns 
out that while he was being laid off he said things which were interpreted 
as threats on the lives of certain managers. This was taken seriously and 
the police confiscated all his guns. 

I guess the lesson is that eventually the truth will come out. The decision 
remains with us as to whether to put up with the insanity or move on. Do you 
have a high insanity tolerance level or are you just a masochist? 
Steve Orr 
-Original Message- 
Sent: Wednesday, February 27, 2002 9:23 AM 
To: Multiple recipients of list ORACLE-L 
I once had a manager who was a paranoid schizophrenic.  Very exciting, let 
me tell you.  But, one thing he told me in a rather roundabout paranoid way 
is that the way you deal with crazy bosses who were out to get you is to 
make friends with other people at your boss' level in the organization, 
hopefully who report to the same person your boss does, and let them know in 
a laughing kind of way what your boss wants you to do.  Never be 
confrontational or speak ill of your boss, because, of course, that will 
wind up biting you in the ass, too.  But, that way, when your boss starts 
badmouthing you and blaming you for everything that goes wrong that was his 
fault, you'll be insulated from having anything bad happen to you as your 
friends will close ranks around you and stop your boss from making your life 
a living hell. 
And then he threw his coffee cup across the room, turned bright red and 
started shrieking about how the VP of R&D had always hated him.  God, I 
loved that job.  Many, *MANY* wonderful stories came out of that place. 
Anyway, I never thought to follow this advice, let alone share it, but, it 
sounds like, in this case, you have a crazy boss, and if you stick around, 
you're going to need a little safety. 
Of course, posting your resume isn't a bad approach either. 
HTH, 
Bambi. 
-Original Message- 
Sent: Tuesday, February 26, 2002 11:48 PM 
To: Multiple recipients of list ORACLE-L 
I've lost patience, my temper, and I'm about to quit a job because the IT 
manager has decreed that we will have "his" data warehouse running within 
24 hours, and we will use his design. 
1 - We are NOT to use any kind of views, not even materailzed views. 
2 - we are not to do any computations, summaries or rollups 
3 - we are to have everything in one table 
4 - "the" table name and column names will be meaningful to any clerk 
5 - we are not to "start" or "snowflake" designs.  "That's just a bunch of 
high power talk." 
6 - all users will be trained to use MS Access to get at "their" 
data.

Re: HP-UX Oracle Install

2002-02-28 Thread hemantchitale


Can you explain the
"An old sys admin trick is to put a  file named -i in the directory that
you don't want touched. "

Does this prevent deletions of the files or rebooting or unmounting the
file system ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


[EMAIL PROTECTED] 28/02/2002 02:23 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: Re: HP-UX Oracle Install 

   

   

   







Hi

As long as you don't have issues with having data files mounted remotely ie
you have a pretty robust network between the server this shouldn't be a
problem just clearly mark/document  the directories that you use on the
server that you mount file systems from as sometimes clever sysadmins
delete directories that they cant find owners of files.
One issue that you can have a little problem but it is mostly cosmetic and
that is if you don't use common UID's in Unix. I always did consider
remotely mounting datafiles as not a bright idea but apparently NFS 3
alleviates most of those concerns.
Still you cant help someone rebooting the remote server.

An old sys admin trick is to put a  file named -i in the directory that you
don't want touched.


HTH
  
  
 --   
 =
 Peter McLarty   E-mail: [EMAIL PROTECTED] 
 Technical ConsultantWWW: http://www.mincom.com   
 APAC Technical Services Phone: +61 (0)7 3303 3461
 Brisbane,  AustraliaMobile: +61 (0)402 094 238   
Facsimile: +61 (0)7 3303 3048 
 =
 A great pleasure in life is doing what people say you cannot do. 
  
- Walter Bagehot (1826-1877 British Economist)
 =
 Mincom "The People, The Experience, The Vision"  
  
 =
  





  
   Sujatha Madan  
   <[EMAIL PROTECTED]>  To:Multiple recipients 
   Sent by: [EMAIL PROTECTED]   of list ORACLE-L   
   <[EMAIL PROTECTED]> 
   cc:
   28/02/2002 12:13 PM Fax to:
   Please respond to ORACLE-L  Subject:HP-UX Oracle   
   Install
  





Hi,

This may be more of a UNIX question, so please bear with me.

We have a "test" server that has 1GB free space. We need to test our Oracle
and application upgrade and there are no other servers other than this
"test" server. Obviously there is not enough space.

The powers above want to use two spare disks that are on our production
system. Unfortunately they are part of a disk array and we can't remove
them
seperately and install them onto the "test" system. So what they want is to
remotely mount these partitions (which are from the production server) onto
the "test" system. That way I have more space and should be able to install
Oracle.

Does anyone know if this would cause a problem when installing Oracle? The
production server already has two Oracle installations on seperate
partitions. Could there be a conflict?

I have a feeling there won't be a problem, but I just wanted to make sure.

Thanks

Sujatha
---
Sujatha M

RE: Funny?

2002-02-28 Thread Reardon, Bruce (CALBBAY)


Mark,
>From a previous posting, might you be running into bug 1359472 (or something similar)
"
-Original Message-
Sent: Thursday, 22 February 2001 12:51
To: Multiple recipients of list ORACLE-L


Came across an interesting bug in the rename command (8.1.6.0.0) (see bug
1359472). Seems if you rename a table, you can drop or truncate it without a
problem. However, if you rename a table, then later issue a 'drop user userame
cascade;', a bogus entry is placed into the obj$ table, an ora-0600 is
returned, and neither the table nor the user can be dropped.

This is rather unfortunate, as rename is a very convenient command.

Cheers,
GC
"

Regards,
Bruce Reardon

-Original Message-
Sent: Friday, 1 March 2002 11:58
To: Multiple recipients of list ORACLE-L


Strange.  Do those users have a few tables and/or many extents?

Try dropping the tables first.  I've had to do that on occasion.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/28/02 04:33 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Funny?


Hi All,

Anyone ever seen this before? 8.1.7 on a Win2K machine.

SQL> select username,
  2 account_status
  3from dba_users
  4   where username in ('MARK','SCOTT');

USERNAME   ACCOUNT_STATUS
-- 
SCOTT  OPEN
MARK   OPEN

SQL> drop user scott cascade;
drop user scott cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I can't drop *ANY* users! Not even logged in as SYS!

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: 
  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: Reardon, Bruce (CALBBAY)
  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: "Does anybody really know what time it is?"

2002-02-28 Thread Jonathan Gennick


What is a GMT epoch second? This curious mind wants to know.

I can get UTC time by:

alter session set time_zone='00:00';
select current_timestamp from dual;

But this doesn't get Steve the epoch seconds that he wants.

Oddly enough, with all this new time zone functionality, I
don't see any way to easily translate a TIMESTAMP WITH
TIMEZONE value from one time zone to another. For example,
if I have 2-Feb-2002 10:30:00.00 PM -05:00, how would I go
about converting that to Pacific Time (-07:00)? It seems
like there ought to be a function to do it for me (NEW_TIME
won't work here), but the solution doesn't appear that easy.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

Thursday, February 28, 2002, 5:56:01 PM, you wrote:
OS> I want to get the UTC (Coordinated Universal Time) from the database without
OS> having to escape to the O/S or write a stored proc. I want to get this time
OS> in GMT epoch seconds without needing to know what timezone the server is in.
OS> Can't find any Oracle supplied package for this and I'm appalled. 

OS> My current medulla oblongata init.ora setting is clues = 0.

OS> Suggestions?


OS> Steve Orr
OS> Bozeman, MT

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  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: Manager decrees "his" data warehouse design. Help!

Discoverer was my first thought too, especially since the folks in the wood 
panelled offices already use Discoverer.

I don't know that the all inclusive "management" came up with this one 
directly.  There is a very bright COO that probably spawned the idea of 
some kind of data mart or data warehouse because he knows that 2 of the 
cobol developers spend over 1/2 of their time running Powerhouse (Cognos) 
reports, often several times a day, just with different combination of 
where..., group by... or order by... differences.  The cobo, or if a 
legitimate request spawned an idea with the IT manager.

At 2/27/02, you wrote:
>Oracle Discoverer?  Users could poke around with that, without knowing SQL.
>They won't be very quick about it though.
>
>I don't know the context, why did management come up with this scenario, is
>there a history behind all this?
>
>Sounds a bit strange to try to impose an impossible situation that just
>won't work.  Decrees don't make reality.
>
>Even when the tools work and the data is there, sometimes users don't use
>systems because the informatics setup does not dovetail nicely with the way
>they go about their daily tasks.
>
>If it's not natural to them, or it complicates their lives, there will be
>resistance.
>
> From the description though it seems there is more than that to it here.
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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).

Control file sequential read

2002-02-28 Thread Godlewski, Melissa

Title: Control file sequential read





Listers,


On development I truncated a fairly large partitioned table, inserted the data from production via a db_link and then built partitioned indexes on the table.  I was watching the v$session_waits for the session and noticed several sets of control file sequential reads during the index builds.  I checked what file 2 was against the dba_data_files and it was showing rollback tablespace.  Is this due to delayed block cleanout?

  SID  SEQ# EVENT
- - 
P1TEXT  P1 P1RAW
 - 
P2TEXT  P2 P2RAW
 - 
P3TEXT  P3 P3RAW    WAIT_TIME
 -  -
SECONDS_IN_WAIT STATE
--- ---
   12 10086 control file sequential read
file#    2 0002
block#   1 0001
blocks   1 0001    -1
  0 WAITED SHORT TIME



FILE_NAME

  FILE_ID TABLESPACE_NAME    BYTES    BLOCKS STATUS    RELATIVE_FNO AUT  MAXBYTES
- -- - - -  --- -
MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-  -- ---
/u03/oradata/FDWD/rbs01.dbf
    2 RBS    630194176 76928 AVAILABLE    2 NO  0
    0    0  630185984   76927

RE: Manager decrees "his" data warehouse design. Help!

Oh, and does this one know buzzwords.

At a recent staff meeting, he decided it was time to test my knowledge 
about the technical merits that supported several buzzwords he tossed 
out.  I stepped way out of character, and in front of the other 18 people I 
apologized to him that I was not a walking dictionary of technical trivia 
but that I would be happy to add the "research" to my task list.  He moved 
on to other issues.

I later learned that he has an MO of trying to "hang" an employee in front 
of peers over academic issues like this.  A rather interesting display of 
control.

May I

At 2/27/02, you wrote:
>Hmmm ... in an old project we had a manager with similar ideas... his ideas
>of design were, what should I say? 'revolutionary'? We finally named his
>design technique as 'Rainfall Design' because the ideas would come down like
>a heavy rainfall and then drain away immediately when logic was applied.
>
>To quote Celine Dion's song ... "It's all coming back to me now .."
>
>Manager: One who knows more buzzwords than you
>
>Raj
>__
>Rajendra Jamadagni  MIS, ESPN Inc.
>Rajendra dot Jamadagni at ESPN dot com
>Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
>
>QOTD: Any clod can have facts, but having an opinion is an art!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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: Manager decrees "his" data warehouse design. Help!

My thanks to every one of you that posted!  The laugh meter has pegged.  I 
have refocused on the goal, and I'm off to get some very good Godivia 
chocolate ice cream.

...and the "team" is pulling out all stops to create and load the "single 
table" DW.  We are also pulling out all the stops to put together a pilot 
of what we think the design should be so that we will be able to meet the 
"You will have it fixed by tomorrow" requirement.

Don

At 2/26/02, you wrote:
>I've lost patience, my temper, and I'm about to quit a job because the IT 
>manager has decreed that we will have "his" data warehouse running within 
>24 hours, and we will use his design.
>
>1 - We are NOT to use any kind of views, not even materailzed views.
>2 - we are not to do any computations, summaries or rollups
>3 - we are to have everything in one table
>4 - "the" table name and column names will be meaningful to any clerk
>5 - we are not to "start" or "snowflake" designs.  "That's just a bunch of 
>high power talk."
>6 - all users will be trained to use MS Access to get at "their" 
>data.  (These are users that were just converted off from "green screen" 
>teminals within the last 45-days, to Windows 98 with 64k RAM.)
>7 - We are not to just copy the legacy transactions.
>8 - We are to load into "an" Oracle table, all legacy transction data 
>because "we don't want to limit how or what a user will look at"
>9 - It is not necessary to talk with the users to see what data they want 
>to look at, or the atomic level.  "They are smart enough to fighure this 
>out on their own.  We just need to provide them the data."
>10 - There shall be no long term maintenance required by "the" dw.
>
>
>Any ideas on how to deal with this situation?
>
>For tomorrow, I've done a CTAS from a materialized view that we created to 
>support one departments known requirements.
>
>
>Don
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Don
>  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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: Manager decrees "his" data warehouse design. Help!


Hi Yechiel,

Thx.  The hardest thing for me to do is step back and let management micro 
manage technical issues about which they know nothing, and apply resources 
where they see fit.  After a group therapy session with the cobol folks, we 
were all in a much better mood.

Did we meet the 24-hour deadline with the single table design the mngr 
wants?  We still don't know, because the IT mngr postponed the demo and is 
taking PTO until next week sometime.



At 2/28/02, you wrote:
>Hello Don
>
>In a more serious mood: DO IT.
>I also had some arguments with my boss over the years and except
>for 2-3 cases (in 20 years) that I told my boss that I will not do something
>and if he wants it he can do it himself, my motto was if he wants to waste
>resources for something that is obviously an error let him waste it.
>He wants you to waste time and disk space on a system that the users
>will not use: waste your time and the resources. He is management and
>he is the one who calls the shots.
>Just document everything to cover yourself later.
>
>Yechiel Adar, Mehish Computer Services
>[EMAIL PROTECTED]
>
> > -Original Message-
> > From: Don [SMTP:[EMAIL PROTECTED]]
> > Sent: Wed, February 27, 2002 8:48 AM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Manager decrees "his" data warehouse design.  Help!
> >
> > I've lost patience, my temper, and I'm about to quit a job because the IT
> > manager has decreed that we will have "his" data warehouse running within
> > 24 hours, and we will use his design.
> >
> > 1 - We are NOT to use any kind of views, not even materailzed views.
> > 2 - we are not to do any computations, summaries or rollups
> > 3 - we are to have everything in one table
> > 4 - "the" table name and column names will be meaningful to any clerk
> > 5 - we are not to "start" or "snowflake" designs.  "That's just a bunch of
> >
> > high power talk."
> > 6 - all users will be trained to use MS Access to get at "their"
> > data.  (These are users that were just converted off from "green screen"
> > teminals within the last 45-days, to Windows 98 with 64k RAM.)
> > 7 - We are not to just copy the legacy transactions.
> > 8 - We are to load into "an" Oracle table, all legacy transction data
> > because "we don't want to limit how or what a user will look at"
> > 9 - It is not necessary to talk with the users to see what data they want
> > to look at, or the atomic level.  "They are smart enough to fighure this
> > out on their own.  We just need to provide them the data."
> > 10 - There shall be no long term maintenance required by "the" dw.
> >
> >
> > Any ideas on how to deal with this situation?
> >
> > For tomorrow, I've done a CTAS from a materialized view that we created to
> >
> > support one departments known requirements.
> >
> >
> > Don
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Don
> >   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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
>   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: Don
  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: Manager decrees "his" data warehouse design. Help!

Getting anything in writing would be a challenge.  I have yet to figure out 
how to word an email that gets a response!

At 2/27/02, you wrote:
>You have this decree in writing?
>
>Okay, once you get that. Do what he wants, making sure everyone knows
>that this great new database design and application are all his idea
>(do this with a smile, with enthusiasm if you can manage it)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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: Manager decrees "his" data warehouse design. Help!


I believe he has already published "Dummies for Oracle8i".


At 2/27/02, you wrote:
>Buy him the 'Oracle8i For Dummies' as your departing gift, and suggest that
>he does this himself...
>Heck, if he can "design" it, let him have the privilege of "building" it as
>well :)
>
>Good Luck...
>
>- Kirti
>
>-Original Message-
>Sent: Wednesday, February 27, 2002 1:48 AM
>To: Multiple recipients of list ORACLE-L
>
>
>I've lost patience, my temper, and I'm about to quit a job because the
>IT
>manager has decreed that we will have "his" data warehouse running
>within
>24 hours, and we will use his design.
>
>1 - We are NOT to use any kind of views, not even materailzed views. 2 -
>we are not to do any computations, summaries or rollups 3 - we are to
>have everything in one table 4 - "the" table name and column names will
>be meaningful to any clerk 5 - we are not to "start" or "snowflake"
>designs.  "That's just a bunch of
>high power talk."
>6 - all users will be trained to use MS Access to get at "their"
>data.  (These are users that were just converted off from "green screen"
>
>teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We
>are not to just copy the legacy transactions. 8 - We are to load into
>"an" Oracle table, all legacy transction data
>because "we don't want to limit how or what a user will look at" 9 - It
>is not necessary to talk with the users to see what data they want
>to look at, or the atomic level.  "They are smart enough to fighure this
>
>out on their own.  We just need to provide them the data."
>10 - There shall be no long term maintenance required by "the" dw.
>
>
>Any ideas on how to deal with this situation?
>
>For tomorrow, I've done a CTAS from a materialized view that we created
>to
>support one departments known requirements.
>
>
>Don
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Don
>   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: Seefelt, Beth
>   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: Deshpande, Kirti
>   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: Don
  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: Manager decrees "his" data warehouse design. Help!

I'll take the hit on this one.  That should be 64M.

I find it interesting that the IT manager is intent on turning over a "dw" 
to all the users, yet the corp policy appears to be, give the the user a 
system that meets min requirements, don't give the user any admin rights on 
their own machine, and by all means, don't give them a CD or diskette 
drive.  "It's to reduce the calls to the help desk, when user messes 
everything up!".

At 2/27/02, you wrote:
>Point #6 - I did not know Win98 can run under 64k RAM. Tell your Boss he
>needs at least 16MB RAM for Win98   :  >
>
> > 6 - all users will be trained to use MS Access to get at "their"
> > data.  (These are users that were just converted off from "green screen"
> > teminals within the last 45-days, to Windows 98 with 64k RAM.)
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: ltiu
>   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: Don
  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: Funny?

2002-02-28 Thread Seefelt, Beth



Mark,

It sounds like some system table is missing.  Do the system.aq$_queue_tables and 
sys.user_history$ tables exist?

Beth

-Original Message-
Sent: Thursday, February 28, 2002 7:33 PM
To: Multiple recipients of list ORACLE-L


Hi All,

Anyone ever seen this before? 8.1.7 on a Win2K machine.

SQL> select username,
  2 account_status
  3from dba_users
  4   where username in ('MARK','SCOTT');

USERNAME   ACCOUNT_STATUS
-- 
SCOTT  OPEN
MARK   OPEN

SQL> drop user scott cascade;
drop user scott cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I can't drop *ANY* users! Not even logged in as SYS!

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: Seefelt, Beth
  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: Unix shell Question

2002-02-28 Thread Ji, Richard

Title: Unix shell Question



Not 
easily.  I wrote a script to do that.  Let me know if you want 
it.

  -Original Message-From: Yuval Arnon 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 28, 2002 
  4:38 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Unix shell Question
  Hi, Need help in Unix shell. 
  Is there a way to compute the previous date (similar to 
  sysdate - 1 in SQL) using the date expression?? 
  So if my date is 3/1/2002 I will get 2/28/20002. 
  
  TIA 
  Yuval.

Re: Funny?

2002-02-28 Thread Rajesh . Rao



rerun catproc.




   
 
"Mark Leith"   
 

ols.co.uk>   cc:   
 
Sent by: Subject: Funny?   
 
root@fatcity.  
 
com
 
   
 
   
 
February 28,   
 
2002 07:33 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




Hi All,

Anyone ever seen this before? 8.1.7 on a Win2K machine.

SQL> select username,
  2 account_status
  3from dba_users
  4   where username in ('MARK','SCOTT');

USERNAME   ACCOUNT_STATUS
-- 
SCOTT  OPEN
MARK   OPEN

SQL> drop user scott cascade;
drop user scott cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I can't drop *ANY* users! Not even logged in as SYS!

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  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: 
  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).

Deadlock Graph, ITL Slots, Remote DML

2002-02-28 Thread Larry Elkins


Listers,

Sun E10K, Solaris 2.7, 64 bit Oracle 8.1.7.2.?

I've dealt a little bit with reading deadlock graphs in trace files in the
past, and there is lots of information out there on Metalink (and
elsewhere), but I'm far from an expert on the subject. Ok, I'm quite a
novice and maybe have read and learned just enough to confuse myself ;-)
Anyway, if you get a deadlock and/or a distributed lock timeout (ORA-02049)
due to DML across a link on a remote table, is a trace file generated *when*
ITL issues are the cause?

A little background. 8 processes were inserting/updating/deleting 6 million
rows from a source DB across a DB link into a single table (215 million
rows, 34 partitions) on a remote DB. We soon found out that the table had
multiple bitmap indices (yes, that should have been known up front). One big
commit at the end of each process. Deadlock trace files with deadlock graphs
indicative of bitmap coverage issues were generated as well as the ORA-02049
error (distributed lock timeouts). The BMI's were dropped and the process
rerun overnight. Once again, the ORA-02049 error was generated for many of
the processes. The person responsible for the process noted that the PCTFREE
for each of the target table's partitions is 0 and INITRANS is 1. And there
are 8 simultaneous DML processes hitting that table. His suspicion is that
he may be encountering a deadlock due to ITL slots. Sounds very plausible
from what I have read. But, *no* deadlock trace files were generated on the
target system. In the case of the BMI coverage, deadlock trace files *were*
generated. So, I would have half expected trace files to be generated if
these were deadlocks due to ITL slot issues. I've asked that a TAR be opened
to ask this question.

DBA's confirm that there are zero transactions, batch jobs, processes, etc
running on the remote box that could account for a lock being held on the
object resulting in the distributed lock timeout. By the way, the now
undocumented parameter for distributed lock timeouts were upped to 300 some
few months ago but with the volume and a single commit at the end, locks
could be held for much longer than that. Still researching the various
causes of ORA-02049 as well. Oh yeah, one of the first questions asked was
could any of the 8 processes be trying to process the same row. This was
shot down -- a mod function on the PK value is used to for each process,
each using a different "seed" value, to avoid processing the same rows.
Tests were conducted to confirm and verify this.

In the meantime, event 20049 is being set in each session prior to doing the
remote DML. Maybe that will turn up more info -- I don't know since I've
never seen one. I guess we will see in the morning. If anyone has some
thoughts to share, I'm all ears. And why Oracle replication isn't being
used, and why Transportable Tablespaces, as well as other options aren't
being considered, is a long, and very political, story. And if some of the
info above is a bit sparse or doesn't make sense, it's because I've been
tossed into this and am not real familiar with all the details of the
process and much of the subject matter. But the folks are bound and
determined to make this process work and have asked for my thoughts.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

-- 
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).

Re: "Does anybody really know what time it is?"

2002-02-28 Thread Jared . Still


I seem to recall some other listers saying that you could do
this in 9i.  I'm not 9i literate myself yet, but you may want to
take a look.

Don't this can be done in 8i, given your requirements.

Jared






"Orr, Steve" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/28/02 02:56 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:"Does anybody really know what time it is?"


I want to get the UTC (Coordinated Universal Time) from the database 
without
having to escape to the O/S or write a stored proc. I want to get this 
time
in GMT epoch seconds without needing to know what timezone the server is 
in.
Can't find any Oracle supplied package for this and I'm appalled. 

My current medulla oblongata init.ora setting is clues = 0.

Suggestions?


Steve Orr
Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: 
  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:RE: PocketDBA


it's also at www.xb.com

they have an SA version as well

of course to use it, you have to have a PDA, right?


--- Bill Conner <[EMAIL PROTECTED]> wrote:
> At 01:48 PM 2/28/2002 -0800, you wrote:
> >Bambi,
> >
> > Well if Ari lurks, perhaps he'll catch on that someone else may
> be
> >interested in his product.  Yes, I do apply different standards to
> products
> >based on who I'm talking to and what they own, but also on what
> they've done.
> >Someone who has done a lot of Oracle admin gets a few extra points
> even if 
> >he is
> >the CEO.
> >
> >But darn, not another chief engineer/CEO running around!!  That can
> be
> >troublesome since there comes a time to shoot the engineer and get
> to 
> >shipping.
> >We have that situation around here & believe me you can always tell
> when he
> >re-spins the chips!!  Oh Well!!
> >
> >Ari,  If your in earshot my number is (978)749-3553.
> 
> i saw a demo of it here at training days in Colorado last week and it
> looked  very functional.  i just downloaded a demo of it,  guess i
> will
> play with it for a month (but it is not cheap) i am sure you already
> know but for anyone who does not, even thought they changed their
> name, they are still at www.pocketdba.com.
> 
> 
> >Dick Goulet
> >
> >Reply Separator
> >Author: "Bellows; Bambi" <[EMAIL PROTECTED]>
> >Date:   2/28/2002 2:45 PM
> >
> >
> >Dick --
> >
> >You're likely to get feedback from Ari Kaplan.  Be aware that he
> owns the
> >company, and will most certainly come through as very positive.  The
> only
> >reason I mention is that if Ari were to tell me about this
> magnificent
> >product, I would apply a lot of weight to it based upon who he is;
> however,
> >if the president of a software company were to tell me how terrific
> a
> >product is, I might apply different standards.  And who owns what is
> not
> >commonly known.  Looking at the demo he gave me, it looked good, but
> I
> >haven't used it personally.
> >
> >Bambi.
> >
> >-Original Message-
> >Sent: Thursday, February 28, 2002 1:19 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >Anyone on the list ever use this software?  Any feedback?
> >
> >Dick Goulet
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing
> Lists
> >
> >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:
> >   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: Bill Conner
>   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).


__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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)

Re: Funny?

2002-02-28 Thread Jared . Still


Strange.  Do those users have a few tables and/or many extents?

Try dropping the tables first.  I've had to do that on occasion.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/28/02 04:33 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Funny?


Hi All,

Anyone ever seen this before? 8.1.7 on a Win2K machine.

SQL> select username,
  2 account_status
  3from dba_users
  4   where username in ('MARK','SCOTT');

USERNAME   ACCOUNT_STATUS
-- 
SCOTT  OPEN
MARK   OPEN

SQL> drop user scott cascade;
drop user scott cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I can't drop *ANY* users! Not even logged in as SYS!

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: 
  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: show prompt and accept variable in NT/2000 bat file???

2002-02-28 Thread Reardon, Bruce (CALBBAY)


In W2K it is easy, you can use set/p - type set/? to get the help and see below.
H:\>set/p  fred=[input value for fred]
[input value for fred]oracleis?

H:\>echo %fred%
oracleis?

H:\>


Or you can call sqlplus and have sqlplus do the prompting and then have it host out to 
the bat file and pass in the parameters.
Or you could Perl or a Unix emulator or I imagine their are many shareware / freeware 
utilities.

Under NT4 other options are not easy and I have listed a number of ways and links that 
show how you can achieve this:

Or from a Tom Lavedas posting on the newsgroup alt.msdos.batch.nt
(dated Tue, 05 Jun 2001 09:04:04 -0400  entitled "prompting for a parameter"
"
Old problem - batches were initially assumed to run unattended -
therefore, there was no need for user interaction.  However, in the
PC/Windows environment, they are useful for scripting many redundant
tasks, even some that require/benefit user interaction.
 
MS finally added recognized this fact by adding the /P (prompt)
functionality to the SET statement in Win 2000 (but not before that).
So, if you are in a pure Win 2000 environment, type SET/? at a command
prompt to get information on the use of the /P switch.
 
If you are using NT 4 or are in a mixed NT/2000 environment, there is no
'perfect' solution.  I have been interested in the subject of user input
for a long time and have developed and collected various techniques,
which I offer for your consideration:
 
1.  Get a third party utility like, Strings.com from PC Magazine,
(e.g. see ftp://ftp.zdnet.com/pcmag/1992/1222/strings.zip) -
recently reported to be broken in NT.  A third party utility is
probably the most viable solution for use in Win NT, though
AFAIK all of the little utilities out there were written for
the original DOS (pre-NT).  See http://www.Simtel.net
 
2.  Another NT approach, posted by Bennett Benson, is explained at
this link:  http://www.jsiinc.com/TIP0300/rh0323.htm
[this doesn't seem to be working as at 1-Mar-2002]
 
3.  Write a Win Script Host script using the InputBox function
(requires Win 98, Win NT 4.0, IE 5 or a free download from MS),
 
For example ...
 
  Dim Input
  Input = InputBox("Enter your name")
  MsgBox ("You entered: " & Input)
 
(see http://msdn.microsoft.com/scripting/default.htm to get
started)
 
4.  A variation on the theme of 3 above is a hybrid WSH script/batch
function
 
:: InWSH.bat - A WSH/Batch hybrid string input routine.
:: Requires Windows Script Host version 1.0 or later.
:: Use optional command line argument UCASE to convert
:: input to all uppercase or LCASE for lowercase.
:: With WSH V2+, EVAL allows math operations, as well.
:: Tom Lavedas <[EMAIL PROTECTED]>
:: http://www.pressroom.com/~tglbatch/
 @echo off
  Set _T=%temp%\~tmp
  echo Set oFS=CreateObject("Scripting.FileSystemObject")>%_T%.vbs
  Echo oFS.OpenTextFile("CON",2).Write "Enter a string: ">>%_T%.vbs
  echo S=%1(Trim(oFS.OpenTextFile("CON",1).Readline))>>%_T%.vbs
  echo Wscript.Echo "set Input="+CStr(S)>>%_T%.vbs
  cscript.exe //nologo %_T%.vbs > %_T%.bat
  for %%v in (%_T%.bat del) do call  %%v %_T%.???
  set _T=
  % For Example % echo You typed %Input%
 
  If you call this with a single command line parameter of Ucase or
  LCase, it will return the string input by the user in the
  appropriate case.  If you have WSH v5.1+ and use EVAL as the command
  line argument, it will do math operations as well, as in 
 
C:\> inwsh eval
Enter a string: 11 * 12
You typed 132
 
  This approach will work with Win 98 and Win 2000 and probably NT
  right out of the box.
 
5.  In Win2K the following works:
 
  SET /P variable=[promptString]
 
6. Finally, this NT specific approach, originally given by Walter
   Zachery, improved and supplied by Clay Calvert, 
 
  @echo off
  echo.
  echo Enter Input:
  for /f "tokens=*" %%a in (
'format/f:160 a: ^|find "..."') do set Input=%%a
  set Input=%Input:~30%
 
  This approach will spin the floppy drive, but won't change
  anything.  The drive does not need to be occupied.
---
 
Tom Lavedas http://www.pressroom.com/~tglbatch/
"


I have seen a web site showing how to do it using label (similar to the format 
command).
 
You Can also use choice command - available from 
ftp://ftp.microsoft.com/Services/TechNet/Windows/msdos/RESKIT/suppdisk/choice.com

And from another alt.msdos.batch.nt posting:
"
Date:   Tue, 20 Feb 2001 16:28:40 -0800 
...
Here's one way that will work in WinNT4.0.  If you are using Win2000,
you can use 'SET /P' instead.
 
==begin file C:\cmd\TEST\ZZZINPUT.CMD ==
001. @echo off
002. echo.
003. call rdstring ZQusername   "Please enter your name:"
004. call rdstring ZQuserphone  "Phone:"
005. call rdstring ZQaddress1   "Street Address:"
006. call rdstring ZQcity   "City:"
007. call r

RE: Anybody against using views?

2002-02-28 Thread cjgait


View positives: 

They simplify what the developer and user see, thus making SQL 
logically simple

You can put hints on a view, thus forcing the optimizer to use the 
view as you know best. This can sometimes be the only way to 
optimize a third party application that puts all its SQL in a black 
box.

View negatives

They're just stored SQL, so the impression that they are some kind 
of table can lull users and developers into thinking that it's perfectly 
alright to nest the heck out of them in statements...which is bad in 
almost all cases

They hide the reality of underlying physical objects. Sometimes 
when you carve away all the views you find that you should 
redesign the tables themselves to allow for cleaner SQL.

And finally one item that is neither positive nor negative. A 
materialized view (aka snapshot) can get you massive performance 
gains if used well, but that's more like a table than it is a view.

> -Original Message-
> Sent: Thursday, February 21, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> We have several applications that use views extensively.  On the other hand
> there are several apps that use no views at all.  We have a new developer
> who wants to use views when writing reports in Crystal Reports.  The
> application administrator is leery of using views and ask the DBA group what
> we think.  I can see several reasons to use views and a few reasons not to
> use them.  I was just wondering what the rest of the group thought.
> 
> Ron Smith
> DBA
> Kerr-McGee Corp
> -- 

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

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

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: RE: PocketDBA

2002-02-28 Thread Mark Leith


Dick,

You're going to love me ;P

We are now the UK distributor of the Pocket products, and I have to say it
has picked up *great* over here!

I'll pass on your interest to the US guys!

Regards

Mark  Leith ;P

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


-Original Message-
[EMAIL PROTECTED]
Sent: 28 February 2002 21:49
To: Multiple recipients of list ORACLE-L


Bambi,

Well if Ari lurks, perhaps he'll catch on that someone else may be
interested in his product.  Yes, I do apply different standards to products
based on who I'm talking to and what they own, but also on what they've
done.
Someone who has done a lot of Oracle admin gets a few extra points even if
he is
the CEO.

But darn, not another chief engineer/CEO running around!!  That can be
troublesome since there comes a time to shoot the engineer and get to
shipping.
We have that situation around here & believe me you can always tell when he
re-spins the chips!!  Oh Well!!

Ari,  If your in earshot my number is (978)749-3553.

Dick Goulet

Reply Separator
Author: "Bellows; Bambi" <[EMAIL PROTECTED]>
Date:   2/28/2002 2:45 PM


Dick --

You're likely to get feedback from Ari Kaplan.  Be aware that he owns the
company, and will most certainly come through as very positive.  The only
reason I mention is that if Ari were to tell me about this magnificent
product, I would apply a lot of weight to it based upon who he is; however,
if the president of a software company were to tell me how terrific a
product is, I might apply different standards.  And who owns what is not
commonly known.  Looking at the demo he gave me, it looked good, but I
haven't used it personally.

Bambi.

-Original Message-
Sent: Thursday, February 28, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L

Anyone on the list ever use this software?  Any feedback?

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

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

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:
  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: Mark Leith
  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: iSQLPlus Problem

2002-02-28 Thread Mark Leith

Title: Message



This 
is the same as mine on a Win2K box. 
 
Take a 
look at:
 
C:\Oracle\ora90\sqlplus\admin\iplus\readme.htm
 
HTHMark

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of KENNETH JANUSZSent: 28 
  February 2002 19:59To: Multiple recipients of list 
  ORACLE-LSubject: Re: iSQLPlus Problem
  Yes.
  
- Original Message - 
From: 
Michael 
Cupp 
To: Multiple recipients of list ORACLE-L 

Sent: Thursday, February 28, 2002 11:33 
AM
Subject: RE: iSQLPlus Problem

Are you sure you can see hidden 
dirs?

  
  -Original Message-From: KENNETH 
  JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 
  2002 10:03 AMTo: Multiple recipients of list 
  ORACLE-LSubject: iSQLPlus Problem
  I have a DELL 8200 with XP Prof. and I have installed 9i 
  (9.0.1).
   
  When I look at installed products with the Universal 
  Installer it says that iSQL Plus is installed at:
   
  c:\oracle\ora90\oracle_prod\
   
  However, when I look at my C: drive I only 
  have:
   
  c:\oracle\ora90\    
  "oracle_prod" is not there and neither are any apps for iSQL 
  Plus.  
   
  What is wrong?
   
  Thanks,
  Ken Janusz, 
CPIM

Funny?

2002-02-28 Thread Mark Leith


Hi All,

Anyone ever seen this before? 8.1.7 on a Win2K machine.

SQL> select username,
  2 account_status
  3from dba_users
  4   where username in ('MARK','SCOTT');

USERNAME   ACCOUNT_STATUS
-- 
SCOTT  OPEN
MARK   OPEN

SQL> drop user scott cascade;
drop user scott cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I can't drop *ANY* users! Not even logged in as SYS!

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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).

OEM service problem ???

2002-02-28 Thread Andrea Oracle


Hi,

After I installed 9i on win2000, the OEM 9.0.1 is
automatically installed.  I configured a database for
OEM repository, the config went fine.  But when I
tried to start ManagementService, I got: 

Could not start the OracleORA9iManagementServer
service on Local Computer.
Error 1053: The service did not respond to the start
or control request in a timely fashion.

I rebooted and restarted and still got this.

What went wrong ???  What should I do?

Thank you!

Andrea

__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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).

AW: "Does anybody really know what time it is?"

2002-02-28 Thread Haunschmidt Andreas VASL.FAS


Hi!

got same problem - no solution found,
I'd be interested too in suggestions

thx

> --
> Von:  Orr, Steve[SMTP:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 28. Februar 2002 23:56
> An:   Multiple recipients of list ORACLE-L
> Betreff:  "Does anybody really know what time it is?"
> 
> I want to get the UTC (Coordinated Universal Time) from the database
> without
> having to escape to the O/S or write a stored proc. I want to get this
> time
> in GMT epoch seconds without needing to know what timezone the server is
> in.
> Can't find any Oracle supplied package for this and I'm appalled. 
> 
> My current medulla oblongata init.ora setting is clues = 0.
> 
> Suggestions?
> 
> 
> Steve Orr
> Bozeman, MT
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Orr, Steve
>   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: Haunschmidt Andreas VASL.FAS
  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:RE: PocketDBA

2002-02-28 Thread dgoulet


Now that's a glowing recommendation.  Who could argue with that?  :-)

Reply Separator
Author: "Orr; Steve" <[EMAIL PROTECTED]>
Date:   2/28/2002 2:22 PM

I highly recommend PocketDBA because Ari bought us beer at OOW and it looked
real good afterwards.   ;-)



-Original Message-
Sent: Thursday, February 28, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Anyone on the list ever use this software?  Any feedback?

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

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

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: Orr, Steve
  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: 
  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: Parallelizing RMAN Backup

2002-02-28 Thread Peter Gram


Hi Pat

I don't know where you got the information on the Rman will not parallel 
the backup without using the filesperset
parameter. I only use the filesperset parameter when backing up archive 
files. It is the allocation of multiple channels
that determinate if it is possible to do backup's in parallel.

Pat Howe wrote:

>>I am researching RMAN and I am trying to understand how to parallelize the
>>backup.
>>I have come across the following statement in various papers and in the 8i
>>Backup and Recovery Course Material :
>>
>>It is important to set FILESPERSET in the backup.  
>>This will ensure that each allocated channel only processes the specified
>>number of files.
>>If you DO NOT specify FILESPERSET then the backup would only be undertaken
>>by "1 channel" and "all other allocated channels would sit idle".
>>
>>Yet in the "8.1.6 RMAN User's Guide and Reference" it contradicts this (pg
>>1-31) :
>>
>>The number of channels that you allocate affects the degree of parallelism
>>within the command.
>>RMAN internally handles parallelization.  You only need to specify : 
>> > 1 'allocate channel' command
>> The objects that you want to backup
>>Parallelism is exploited only within the context of a single command.
>>
>>So it does not mention that you HAVE TO specify the FILESPERSET statement.
>>
>>On digging further into the FILESPERSET statement the manual states (pg
>>1-36) :
>>The default value of this parm is calculated by RMAN as follows ;
>>RMAN takes the lower of the following 2 values ; 64 or
>>number-of-files/number-of-channels.
>>
>>Page 1-37 gives an example of using the Default FILESPERSET - and how RMAN
>>would parallelize the backup.
>>
>>Which is right ?  
>>Do you have to specifically specify the FILESPERSET parm in the BACKUP
>>command for RMAN to parallelize the backup operation?
>>or
>>Can you leave it out of the BACKUP command and use the default value ?
>>
>>
>>Thanks in advance
>>
>>_ 
>> Patrick J. Howe 
>> Oracle DBA 
>> Illuminet Inc. (Carrier Division of Verisign) 
>> 4501 Intelco Loop SE 
>> Olympia, WA 98507 
>> Email  : [EMAIL PROTECTED]  
>>
>>

-- 

/regards

Peter Gram

Phone : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Målev
http://miracleas.dk




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  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).

Parallelizing RMAN Backup

2002-02-28 Thread Pat Howe



> I am researching RMAN and I am trying to understand how to parallelize the
> backup.
> I have come across the following statement in various papers and in the 8i
> Backup and Recovery Course Material :
> 
> It is important to set FILESPERSET in the backup.  
> This will ensure that each allocated channel only processes the specified
> number of files.
> If you DO NOT specify FILESPERSET then the backup would only be undertaken
> by "1 channel" and "all other allocated channels would sit idle".
> 
> Yet in the "8.1.6 RMAN User's Guide and Reference" it contradicts this (pg
> 1-31) :
> 
> The number of channels that you allocate affects the degree of parallelism
> within the command.
> RMAN internally handles parallelization.  You only need to specify : 
>  > 1 'allocate channel' command
>  The objects that you want to backup
> Parallelism is exploited only within the context of a single command.
> 
> So it does not mention that you HAVE TO specify the FILESPERSET statement.
> 
> On digging further into the FILESPERSET statement the manual states (pg
> 1-36) :
> The default value of this parm is calculated by RMAN as follows ;
> RMAN takes the lower of the following 2 values ; 64 or
> number-of-files/number-of-channels.
> 
> Page 1-37 gives an example of using the Default FILESPERSET - and how RMAN
> would parallelize the backup.
> 
> Which is right ?  
> Do you have to specifically specify the FILESPERSET parm in the BACKUP
> command for RMAN to parallelize the backup operation?
> or
> Can you leave it out of the BACKUP command and use the default value ?
> 
> 
> Thanks in advance
> 
> _ 
>  Patrick J. Howe 
>  Oracle DBA 
>  Illuminet Inc. (Carrier Division of Verisign) 
>  4501 Intelco Loop SE 
>  Olympia, WA 98507 
>  Email  : [EMAIL PROTECTED]  
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pat Howe
  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: RE: PocketDBA

2002-02-28 Thread Post, Ethan

*PocketDBA is licensed for one year at $600 per database instance plus $50
per user including technical support. A one year license of PocketAdmin is
$500 per server and $50 per user including technical support. 

>From the site.  Doesn't look too expensive to me.

- Ethan

-Original Message-
Sent: Thursday, February 28, 2002 4:32 PM
To: Multiple recipients of list ORACLE-L

At 01:48 PM 2/28/2002 -0800, you wrote:
>Bambi,
>
> Well if Ari lurks, perhaps he'll catch on that someone else may be
>interested in his product.  Yes, I do apply different standards to products
>based on who I'm talking to and what they own, but also on what they've
done.
>Someone who has done a lot of Oracle admin gets a few extra points even if 
>he is
>the CEO.
>
>But darn, not another chief engineer/CEO running around!!  That can be
>troublesome since there comes a time to shoot the engineer and get to 
>shipping.
>We have that situation around here & believe me you can always tell when he
>re-spins the chips!!  Oh Well!!
>
>Ari,  If your in earshot my number is (978)749-3553.

i saw a demo of it here at training days in Colorado last week and it
looked  very functional.  i just downloaded a demo of it,  guess i will
play with it for a month (but it is not cheap) i am sure you already
know but for anyone who does not, even thought they changed their
name, they are still at www.pocketdba.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  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).

"Does anybody really know what time it is?"

2002-02-28 Thread Orr, Steve


I want to get the UTC (Coordinated Universal Time) from the database without
having to escape to the O/S or write a stored proc. I want to get this time
in GMT epoch seconds without needing to know what timezone the server is in.
Can't find any Oracle supplied package for this and I'm appalled. 

My current medulla oblongata init.ora setting is clues = 0.

Suggestions?


Steve Orr
Bozeman, MT
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Unix shell Question

2002-02-28 Thread lembark




-- Yuval Arnon <[EMAIL PROTECTED]> on 02/28/02 13:37:59 -0800

> 
> Hi, 
> Need help in Unix shell. 
> Is there a way to compute the previous date (similar to sysdate - 1 in SQL)
> using the date expression?? 

With gnu date use "date --date='yesterday'", with Perl
Date::Manip will handle "$count days before", $otherdate.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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: RE: PocketDBA

2002-02-28 Thread Bellows, Bambi


Dick --

I would hope so.  I'm sure you'll like what you see.  But if you're going to
put the product through its paces, let us know what your thoughts are.  

Bambi.

-Original Message-
Sent: Thursday, February 28, 2002 3:49 PM
To: Bellows; Bambi; [EMAIL PROTECTED]

Bambi,

Well if Ari lurks, perhaps he'll catch on that someone else may be
interested in his product.  Yes, I do apply different standards to products
based on who I'm talking to and what they own, but also on what they've
done. 
Someone who has done a lot of Oracle admin gets a few extra points even if
he is
the CEO.

But darn, not another chief engineer/CEO running around!!  That can be
troublesome since there comes a time to shoot the engineer and get to
shipping. 
We have that situation around here & believe me you can always tell when he
re-spins the chips!!  Oh Well!!

Ari,  If your in earshot my number is (978)749-3553.

Dick Goulet

Reply Separator
Author: "Bellows; Bambi" <[EMAIL PROTECTED]>
Date:   2/28/2002 2:45 PM


Dick --

You're likely to get feedback from Ari Kaplan.  Be aware that he owns the
company, and will most certainly come through as very positive.  The only
reason I mention is that if Ari were to tell me about this magnificent
product, I would apply a lot of weight to it based upon who he is; however,
if the president of a software company were to tell me how terrific a
product is, I might apply different standards.  And who owns what is not
commonly known.  Looking at the demo he gave me, it looked good, but I
haven't used it personally.

Bambi.

-Original Message-
Sent: Thursday, February 28, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L

Anyone on the list ever use this software?  Any feedback?

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

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

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: Bellows, Bambi
  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: Unix shell Question

2002-02-28 Thread Bellows, Bambi

Title: Unix shell Question









Date and string functions are not terribly
easy in Unix, and generally involve parsing cal.  So, if you want to do sysdate-1, what
you would do is this:

 

DAY=`date +%d`

MONTH=`date +%m`

YEAR=`date +%C%y`

echo $DAY $MONTH $YEAR 

if [ $DAY = 1 ] ;

then

    if
[ $MONTH = 1 ] ;

    then

   
CAL_MONTH=12

   
CAL_YEAR=`expr $YEAR - 1`

    else

   
CAL_MONTH=`expr $MONTH - 1`

   
CAL_YEAR=$YEAR

    fi

    CAL_DAY=`cal $CAL_MONTH $CAL_YEAR|tail -2|head -1|awk '{print $NF}'`

else

    CAL_DAY=`expr
$DAY - 1`

    CAL_MONTH=$MONTH

    CAL_YEAR=$YEAR

fi

echo "Yesterday was $CAL_MONTH $CAL_DAY $CAL_YEAR"

 

or, you could do this:

 

sqlplus << EOF
scott/tiger

spool date

select sysdate-1 from dual;

exit

EOF 

grep -v SQL date.lst|tail -2|head -1

 

 

Whichever.

 

HTH,

Bambi.

 

-Original Message-
From: Yuval Arnon
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, February 28, 2002
3:38 PM
To: Multiple recipients of list
ORACLE-L
Subject: Unix shell Question

 

Hi, 
Need help in Unix shell.

Is there a way to compute the
previous date (similar to sysdate - 1 in SQL) using the date expression??


So if my date is 3/1/2002 I will get 2/28/20002.


 

TIA 

Yuval.

RE: poor query performance

2002-02-28 Thread Jack C. Applewhite


Bill,

Try this:

Delete
>From  T1
Where F1 In
(
 Select F1
 From   T1
 Minus
 Select PK
 From   T2
);

This will delete T1 rows for which there's no matching PK in T2 and will
most likely be quicker than the Not Exists query, though you never can say
for sure!   ;-)

Oh, and the Cost that Explain Plan reports is purely relative and can't be
used for comparison across different queries.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Bill
Sent: Thursday, February 28, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L


I have a query that deletes rows from a table with 57K rows, as follows

delete from T1 where not exists
(select T2.PK from T2
where T2.PK = T1.F1);

T2.PK is the Primary Key on Table T2
T1.F1 is an indexed field on table T1

Explain plan shows a low cost (80) but the delete takes about 10+ minutes.
T1 has about 57K rows
T2 has about 29500 rows

other queries with costs in the 700 range are pretty quick - this one's a
dog

any ideas?

thanks

Bill Magaliff
Framework, Inc.
914-631-2322



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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:RE: PocketDBA

2002-02-28 Thread Bill Conner


At 01:48 PM 2/28/2002 -0800, you wrote:
>Bambi,
>
> Well if Ari lurks, perhaps he'll catch on that someone else may be
>interested in his product.  Yes, I do apply different standards to products
>based on who I'm talking to and what they own, but also on what they've done.
>Someone who has done a lot of Oracle admin gets a few extra points even if 
>he is
>the CEO.
>
>But darn, not another chief engineer/CEO running around!!  That can be
>troublesome since there comes a time to shoot the engineer and get to 
>shipping.
>We have that situation around here & believe me you can always tell when he
>re-spins the chips!!  Oh Well!!
>
>Ari,  If your in earshot my number is (978)749-3553.

i saw a demo of it here at training days in Colorado last week and it
looked  very functional.  i just downloaded a demo of it,  guess i will
play with it for a month (but it is not cheap) i am sure you already
know but for anyone who does not, even thought they changed their
name, they are still at www.pocketdba.com.


>Dick Goulet
>
>Reply Separator
>Author: "Bellows; Bambi" <[EMAIL PROTECTED]>
>Date:   2/28/2002 2:45 PM
>
>
>Dick --
>
>You're likely to get feedback from Ari Kaplan.  Be aware that he owns the
>company, and will most certainly come through as very positive.  The only
>reason I mention is that if Ari were to tell me about this magnificent
>product, I would apply a lot of weight to it based upon who he is; however,
>if the president of a software company were to tell me how terrific a
>product is, I might apply different standards.  And who owns what is not
>commonly known.  Looking at the demo he gave me, it looked good, but I
>haven't used it personally.
>
>Bambi.
>
>-Original Message-
>Sent: Thursday, February 28, 2002 1:19 PM
>To: Multiple recipients of list ORACLE-L
>
>Anyone on the list ever use this software?  Any feedback?
>
>Dick Goulet
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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:
>   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: Bill Conner
  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: Clash of the DBs in eWeek

2002-02-28 Thread Fisher, Julie


And if you go to their web site www.mysql.com, they "crash me" compare
against Oracle 8.1.6 and damn, they appear to look good.  "They gots lots
more green stars than Oracle, by george."  Of course most of those
categories are SQL functions/capabilities.  They don't even touch on memory
allocation, types of backups/archiving, so on and so forth.  And of course
the lack of column constraints,table constraints, foreign keys... just
noise.  Wait!! Dammit Oracle!! Give me the tinyint type!  MySQL has it!

...maybe I'm just being fussy


Julie Fisher
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator


-Original Message-
Sent: Thursday, February 28, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L


Also the article did not mention that in a lot of ways, MySQL is not nearly
ready for prime time...

MOYMMV

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  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: Fisher, Julie
  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: Non-partitioned table to Hash Partitioned table

2002-02-28 Thread Connor McDonald


I haven't done any stress testing - but check out
DBMS_REDEFINITION

hth
connor

 --- "Toepke, Kevin M" <[EMAIL PROTECTED]> wrote:
> Hello!
> 
> I am trying to figure out the best way to convert a
> non-partitioned table
> with approx 20 million rows into a hash-partitioned
> table. This should be
> done with minimal down-time. This will be in an
> Oracle 9i environment done
> at a time when only SELECTs are occuring on the
> table.
> 
> The best way I can figure is to create a second
> table and copy the data
> over; create the indexes; and rename the tables.
> 
> I would appreciate any hints on what section of TFM
> to read.
> 
> Kevin Toepke
> [EMAIL PROTECTED]
>

>

> 
> The information in this electronic mail message is
> Trilegiant Confidential
> and may be legally privileged. It is intended solely
> for the addressee(s).
> Access to this Internet electronic mail message by
> anyone else is
> unauthorized. If you are not the intended recipient,
> any disclosure,
> copying, distribution or action taken or omitted to
> be taken in reliance on
> it is prohibited and may be unlawful.
>

>

> 
> The sender believes that this E-mail and any
> attachments were free of any
> virus, worm, Trojan horse, and/or malicious code
> when sent. This message and
> its attachments could have been infected during
> transmission. By reading the
> message and opening any attachments, the recipient
> accepts full
> responsibility for taking protective and remedial
> action about viruses and
> other defects. Trilegiant Corporation is not liable
> for any loss or damage
> arising in any way from this message or its
> attachments.
>

>

> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Toepke, Kevin M
>   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"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
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: PocketDBA

2002-02-28 Thread Orr, Steve


I highly recommend PocketDBA because Ari bought us beer at OOW and it looked
real good afterwards.   ;-)



-Original Message-
Sent: Thursday, February 28, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Anyone on the list ever use this software?  Any feedback?

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

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

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: Orr, Steve
  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: exp/imp question

2002-02-28 Thread Connor McDonald


I would take a look at v$session_wait whilst the
import is running and see what pops up.

My understanding of NESTED_TABLE_SET_REFS is to get at
the hidden columns when object data types are used. 
I'm not sure why it always seems to be so prevalent in
import - possibly they just do it with any old table
and the hint is ignored except in the object case

hth
connor

 --- Ron Rogers <[EMAIL PROTECTED]> wrote: > List,
> Source database 7.3.4 OS Novell 4.2
> Target database 8.1.7 OS Linux RedHat 7.2
> 
> Table is 5 columns ,indexes on  columns 1,2PK,  1,3
> , 3 for application
> usage
> Export of a table is 750K rows and takes about 2
> minutes with a DMP
> file the size of 20 Meg.
> Import command in the V$SQLAREA shows "INSERT
> /*NESTED_TABLE_SET_REFS*/
> INTO "DRITV" ("COL1","COL2","COL3","COL4","COL5")
> VALUES(:1,:2,:3,:4,:5)" and takes 1.5+ hours. The
> table is truncated
> because this is a copy of data from production to a
> test database.
> Question is why could it be taking such a long time
> to load and I have
> not been able to find the hint info in my of my
> doc's. The table is not
> a nested table and the hint confuses me. What does
> it mean.
> I am going to truncate the table again and do a copy
> across the network
> to get the time for that action. 
> Thanks,
> Ron
> ROR mª¿ªm
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ron Rogers
>   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"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
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: HP-UX Oracle Install

2002-02-28 Thread Sujatha Madan




Thanks 
for your information Peter and Ayyappan.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, 28 February 2002 
  5:23 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: HP-UX Oracle InstallHi As long as you don't 
  have issues with having data files mounted remotely ie you have a pretty 
  robust network between the server this shouldn't be a problem just clearly 
  mark/document  the directories that you use on the server that you mount 
  file systems from as sometimes clever sysadmins delete directories that they 
  cant find owners of files. One issue 
  that you can have a little problem but it is mostly cosmetic and that is if 
  you don't use common UID's in Unix. I always did consider remotely mounting 
  datafiles as not a bright idea but apparently NFS 3 alleviates most of those 
  concerns. Still you cant help someone 
  rebooting the remote server. An 
  old sys admin trick is to put a  file named -i in the directory that you 
  don't want touched. HTH 
  
  


  --=Peter 
McLarty               E-mail: 
[EMAIL PROTECTED]Technical Consultant       
 WWW: http://www.mincom.comAPAC Technical Services   
  Phone: +61 (0)7 3303 3461Brisbane,  Australia   
     Mobile: +61 (0)402 094 238      
                    
 Facsimile: +61 (0)7 3303 
3048=A great 
pleasure in life is doing what people say you cannot do.  
 - Walter Bagehot (1826-1877 British 
Economist)=Mincom 
"The People, The Experience, The 
Vision"=
  
  


  
  Sujatha Madan 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
28/02/2002 12:13 PM Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Fax to:                 Subject:   
     HP-UX Oracle 
  InstallHi,This may be more of a UNIX question, so please bear with 
  me.We have a "test" server that has 1GB free space. We need to test 
  our Oracleand application upgrade and there are no other servers other 
  than this"test" server. Obviously there is not enough space.The 
  powers above want to use two spare disks that are on our productionsystem. 
  Unfortunately they are part of a disk array and we can't remove 
  themseperately and install them onto the "test" system. So what they want 
  is toremotely mount these partitions (which are from the production 
  server) ontothe "test" system. That way I have more space and should be 
  able to installOracle.Does anyone know if this would cause a 
  problem when installing Oracle? Theproduction server already has two 
  Oracle installations on seperatepartitions. Could there be a 
  conflict?I have a feeling there won't be a problem, but I just wanted 
  to make 
  sure.ThanksSujatha--- 
  Sujatha Madan Database Administrator Custom Management Centre 
  Optus Business Operations 'yes' OPTUSPH # +61 2 9775 5316 
  Mobile # +61 402 354 347 FAX # +61 2 9775 5360 Email 
  [EMAIL PROTECTED]  WEB 
  http://www.optusbusiness.com.au/ 
  --- -- Please see 
  the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Sujatha 
  Madan INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California        -- Public Internet access / 
  Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).-- This transmission is for the intended addressee only and 
  is confidential information. If you have received this transmission in error, 
  please delete it and notify the sender. The contents of this e-mail are the 
  opinion of the writer only and are not endorsed by the Mincom Group of 
  companies unless expressly stated 
otherwise.

RE: SNP0...SNPx Memory Hogs

2002-02-28 Thread Jack C. Applewhite


Ruth,

I'm sure they're Oracle Job Queue processes because the lines below show up
in my Alert.Log when I stop and start them by issuing the commands in the
first two lines.  That's when up to 500MB of memory is freed by the Oracle
Process.

BTW, SNMP stands for Simple Network Management Protocol (I'm pretty sure, at
least).  It's a TCP-related thingey - a technical term  ;-).  That's totally
different (again, I'm pretty sure) from the Oracle SNP Job Queue processes.

>From Alert.Log:
--
...
ALTER SYSTEM SET job_queue_processes=0;
ALTER SYSTEM SET job_queue_processes=4;
Thu Feb 28 07:01:19 2002
Restarting dead background process SNP0
SNP0 started with pid=8
Thu Feb 28 07:01:19 2002
Restarting dead background process SNP1
SNP1 started with pid=9
Thu Feb 28 07:01:19 2002
Restarting dead background process SNP2
SNP2 started with pid=10
Thu Feb 28 07:01:20 2002
Restarting dead background process SNP3
SNP3 started with pid=11
...
---

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Gramolini
Sent: Thursday, February 28, 2002 8:53 AM
To: Multiple recipients of list ORACLE-L


At least in 8.0.x the oracle intelligent agent process are dbsnmp processes.
Are you sure that these are oracle processes and not OS related.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 4:20 PM


> 8.1.7.2.5 under Win2k Server
>
> I just discovered that my four SNP processes were sitting around, doing no
> work, taking up about 500MB of RAM.  Is this normal?
>...



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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: Clash of the DBs in eWeek

2002-02-28 Thread Orr, Steve


Well there's prime time then there's prime time...
i.e. Prime time on the major networks vs. prime time on Nickelodian

MySQL is in "prime time" production on many substantial web sites but it's
not a major network or an Amazon.com/Oracle type of prime time.

There's a place for Nickelodian too.

MySQL 4.X appears to be a substantial upgrade from MySQL 3.X but someone
else on the list said MySQL 4.0 isn't supposed to be released until the
end of the year. It almost seems like eWeek is trying to put MySQL is a
good light but who knows. 


Steve Orr



-Original Message-
Sent: Thursday, February 28, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L


Also the article did not mention that in a lot of ways, MySQL is not nearly
ready for prime time...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: Clash of the DBs in eWeek

2002-02-28 Thread Jon Baker

Title: RE: Clash of the DBs in eWeek





I agree.  I've been following MySQL for a while and it does have it's place, but would not want a data warehouse on it.

 http://www.eweek.com/article/0,3658,s=708&a=18266,00.asp


Another article on MySQL from same source.


Jon


-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Clash of the DBs in eWeek



Also the article did not mention that in a lot of ways, MySQL is not nearly
ready for prime time...


MOYMMV


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration


The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  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:RE: PocketDBA

2002-02-28 Thread dgoulet


Bambi,

Well if Ari lurks, perhaps he'll catch on that someone else may be
interested in his product.  Yes, I do apply different standards to products
based on who I'm talking to and what they own, but also on what they've done. 
Someone who has done a lot of Oracle admin gets a few extra points even if he is
the CEO.

But darn, not another chief engineer/CEO running around!!  That can be
troublesome since there comes a time to shoot the engineer and get to shipping. 
We have that situation around here & believe me you can always tell when he
re-spins the chips!!  Oh Well!!

Ari,  If your in earshot my number is (978)749-3553.

Dick Goulet

Reply Separator
Author: "Bellows; Bambi" <[EMAIL PROTECTED]>
Date:   2/28/2002 2:45 PM


Dick --

You're likely to get feedback from Ari Kaplan.  Be aware that he owns the
company, and will most certainly come through as very positive.  The only
reason I mention is that if Ari were to tell me about this magnificent
product, I would apply a lot of weight to it based upon who he is; however,
if the president of a software company were to tell me how terrific a
product is, I might apply different standards.  And who owns what is not
commonly known.  Looking at the demo he gave me, it looked good, but I
haven't used it personally.

Bambi.

-Original Message-
Sent: Thursday, February 28, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L

Anyone on the list ever use this software?  Any feedback?

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

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

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: 
  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: Unused users for the last 30 and 60 days.

That should work, I was using oracle 7 (so it wouldn't have worked then)
at the time and we had varying levels that we had to deal with > 30 days
we had to send an e-mail > 60 days we had to disable. This could be done
with the account management features of 9 also . I don't believe the aging
is that discriminating. But if you had one level and you were using 8,
8i or 9i I'm thinking I could get your idea to work as well.

John

[EMAIL PROTECTED] wrote:

wouldn't it be easier to create a new profile or change the defaultprofile so that there was a password_life_time of 30 or 60 and then setthe grace period to a day or so and then check for users whose accountsare locked?--- Ora NT DBA <[EMAIL PROTECTED]> wrote:

Hi Deepender,I know of know builtin oracle view that will tell you thisinfomation. At a formerjob we were required to disable accounts that had not been used inthe last 60days. It has been a little while since I worked there (7 years to be exact)butbasically this is what we did1. created a tablecalled dbs_user_info with the fields (username, create_date, last_login_date)2. copied the username and create field from dba_users into thefields, initially we set last_login_date to be = create;3. Turned on auditing in the init.ora and audited successful logins4. at night we went through the sys.aud$ table and for each userthat existed updated the last_login_date truncating sys.aud$ when done5. weekly ran a batch job that found all users that last_login_datewas > 30 daysBeginning in 8i it might be easier to do this with an after log
in trigger rather than auditingHope this helps,Johnthat contained the username,[EMAIL PROTECTED] wrote:

Hi All,I want to have report of all the users who has not used their Oracleusername for the last 30 and 60 days.Any views how can I get the report.Thanks,Deepender

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

__Do You Yahoo!?Yahoo! Greetings - Send FREE e-cards for every occasion!http://greetings.yahoo.com

Unix shell Question

2002-02-28 Thread Yuval Arnon

Title: Unix shell Question





Hi,
Need help in Unix shell.
Is there a way to compute the previous date (similar to sysdate - 1 in SQL) using the date expression??


So if my date is 3/1/2002 I will get 2/28/20002.




TIA


Yuval.

RE: MS Access migration to oracle

2002-02-28 Thread Whittle Jerome Contr NCI


It's just not Access developers. I was handed an old Oracle db where less than half of 
the 300+ tables have a primary key or unique constraint and no tables have a foreign 
key.

Think about it.

Jerry Whittle

> -Original Message-
> From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
> 
> Waleed, you saved my life! I don't know why was I expecting Access97
> application designers to define minor details like the primary keys.
> I most certainly owe you one.
> 
> > -Original Message-
> > From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
> > 
> > Either it's the privileges on the tables or
> > the tables do not have primary keys or unique keys.
> > 
> > Access will put the table in read only mode if it does not 
> > have PK or Unique
> > key.
> > 
> > Waleed
> 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
  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).

poor query performance

2002-02-28 Thread Magaliff, Bill


I have a query that deletes rows from a table with 57K rows, as follows

delete from T1 where not exists
(select T2.PK from T2
where T2.PK = T1.F1);

T2.PK is the Primary Key on Table T2
T1.F1 is an indexed field on table T1

Explain plan shows a low cost (80) but the delete takes about 10+ minutes.
T1 has about 57K rows
T2 has about 29500 rows

other queries with costs in the 700 range are pretty quick - this one's a
dog

any ideas?

thanks

Bill Magaliff
Framework, Inc.
914-631-2322

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  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: Clash of the DBs in eWeek


Also the article did not mention that in a lot of ways, MySQL is not nearly
ready for prime time...

MOYMMV

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  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: PocketDBA


I have seen it in action at the past IOUG-A and OOW conf (away from the
Exhibit floors:)
We are interested in acquiring it. 
My damager is in touch with Ari's folks.  
Hope the damager finds some $$ this year :)

- Kirti 


-Original Message-
Sent: Thursday, February 28, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L


it's now Expand Beyond, they've changed the company name.

Ari does lurk, he'll also be presenting to the NYOUG on March 21, for
any of you who want to talk to him in person about it


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> I have.  It is pretty cool.  I believe the creator, Ari Kaplan, lurks
> on this list.  I bet they'll send you a demo device if you ask.  Try
> out Pocket SA too.
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Thu, 28 Feb 2002, [EMAIL PROTECTED] wrote:
> 
> > Anyone on the list ever use this software?  Any feedback?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jeremiah Wilton
>   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).


__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Deshpande, Kirti
  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: oracle 8.1.7 patch 2 or 3

2002-02-28 Thread Xiaohong Yang (Sharon)

To: [EMAIL PROTECTED]
Date: Thu, 28 Feb 2002 10:33:29 -0600
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain

What vendor, what product?

The vendor is InforMax, the product is called GenoMax.

Sharon
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xiaohong Yang (Sharon)
  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: moving from unix to NT

2002-02-28 Thread Jared . Still


> On NT oracle.exe runs as "OracleService" service.
> Hence UTL_FILE will be executed under whatever OS account
> "OracleService" service runs.

Well, I just tested it, and I can open a file on a local drive, but not on 
a network
drive. 

This is because the VOS is running as a service, somewhat as you stated.
The Oracle instance itself does not run as a service. 

The VOS ( virtual operating system ) does, and this is the code 
responsible for writing to disk.

Here's the workaround from Oracle.  Maybe there's a step you were missing 
in trying
to get the Oracle Service to run as a user other than SYSTEM?

I followed the instructions, and then successfully created a file on the 
same network
drive where the attempt failed previously.  Here's the code I used:

DECLARE
   relink_log UTL_FILE.FILE_TYPE;
   log_dir varchar2(80) := 'F:\tmp';
   log_fname varchar2(80) := 'utl.txt';
BEGIN

   relink_log := UTL_FILE.FOPEN(log_dir, log_fname, 'w');

   if utl_file.is_open( relink_log ) then
  utl_file.put_line(relink_log, 'The utl file is open');
  UTL_FILE.FFLUSH(relink_log);
  UTL_FILE.FCLOSE(relink_log);
   else
  raise_application_error(-20100,'Open failed on ' || log_dir || '/' 
|| log_fname );
   end if;

END;
/


HTH

Jared




Doc ID: 
 Note:1034188.6
  Subject: 
 INVALID_OPERATION Exception from UTL_FILE when
 Writing to/from Network Drive
  Type: 
 PROBLEM
  Status: 
 PUBLISHED

 Content Type: 
 TEXT/PLAIN
 Creation Date: 
 30-JUL-1997
 Last Revision 
Date: 
 29-JUN-2000



  Problem Description
  ---

  On the Windows NT platform, the UTL_FILE package raises the 
  INVALID_OPERATION exception when attempting to write to, or 
  read from, a network or compressed drive.

  If the exception is not handled, then you receive the following
  error:

 ERROR at line 1:
 ORA-06510: PL/SQL: unhandled user-defined exception
 ORA-06512: at "SYS.UTL_FILE", line 98
 ORA-06512: at "SYS.UTL_FILE", line 157
 ORA-06512: at "SCOTT.MYFILE", line 9
 ORA-06512: at line 1


  Problem Explanation
  ---

  The process that is attempting to perform the read or write operation 
  is the Oracle RDBMS Service.  The OracleService service runs as 
  the SYSTEM account by default.  The SYSTEM account, however, has no 
  access to shares that are set up by the user who is currently logged in. 
 
  Therefore, the Oracle RDBMS service can only read and write files on 
  local hard drives.


  Solution Description
  

  Start the Oracle service as a user who has the same permissions as 
SYSTEM,
  and also who has access to the shared directory.


  Solution Explanation
  

  When the Oracle service is started, it is done so as the user SYSTEM. 
  SYSTEM is unable to see any shared directories therefore UTL_FILE is 
  restricted to accessing local drives only.  Hence, Oracle must be 
  started as a user who can see the relevant shares. 

  This user must have full permissions in order for Oracle to run 
  successfully.  In addition, we recommend that you alter the Oracle 
SQL*Net 
  Listener Service to log on as the same user.

  For a full description refer to the following article:

 [NOTE:45172.1]   Running UTL_FILE on Windows NT

  Another approach is to alter the SYSTEM user so that it can see shared 
  directories, however, Microsoft does not recommend this because it is 
  a security risk.  Refer to the following Microsoft article:

  ' Q124184:Service Running as System Account Fails Accessing Network '
  ( http://support.microsoft.com/support/kb/articles/q124/1/84.asp )


  Reference
  -

  [BUG:493693]   UTL_FILE CANNOT WRITE ON NETWORK DRIVE
  .







"Igor Neyman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/28/02 11:49 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: moving from unix to NT


Jared,

On NT oracle.exe runs as "OracleService" service.
Hence UTL_FILE will be executed under whatever OS account
"OracleService" service runs.
And I was not able to make it running properly under any other than SYSTEM
account.
Remember, on NT Oracle is one big (though multithreaded) process, unlike 
it
is on UNIX.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 1:03 PM


> I don't have any experience with UTL_FILE on NT.  I've used it a little
> on unix.  Don't know why it wouldn't work on NT.  As stated by others,
> it might be a problem if writing to network drives, as the SYSTEM user
> does not have access to those when run as a service.
>
> This doesn't seem reasonable though, as the in

Re: Unused users for the last 30 and 60 days.


wouldn't it be easier to create a new profile or change the default
profile so that there was a password_life_time of 30 or 60 and then set
the grace period to a day or so and then check for users whose accounts
are locked?




--- Ora NT DBA <[EMAIL PROTECTED]> wrote:
> Hi Deepender,
> 
> I know of know builtin oracle view that will tell you this
> infomation. 
>  At a former
> job we were required to disable accounts that had not been used in
> the 
> last 60
> days.  
> 
> It has been a little while since I worked there (7 years to be exact)
> but
> basically this is what we did
> 
> 1.  created a tablecalled dbs_user_info with the fields (username, 
> create_date, last_login_date)
> 
> 2.  copied the username and create field from dba_users into the
> fields, 
> initially we set last_login_date to be = create;
> 
> 3.  Turned on auditing in the init.ora and audited successful logins
> 
> 4.  at night we went through the sys.aud$ table and for each user
> that 
> existed updated the last_login_date  truncating sys.aud$ when done
> 
> 5.  weekly ran a batch job that found all users that last_login_date
> was 
>  > 30 days
> 
> Beginning in 8i it might be easier to do this with an after login 
> trigger rather than auditing
> 
> Hope this helps,
> John
> that contained the username,
> 
> [EMAIL PROTECTED] wrote:
> 
> >Hi All,
> >
> >I want to have report of all the users who has not used their Oracle
> >username for the last 30 and 60 days.
> >Any views how can I get the report.
> >
> >Thanks,
> >Deepender
> >
> >
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ora NT DBA
>   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).


__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Clash of the DBs in eWeek




HI Igor,

All I meant was that I couldn't get to the article because sql server couldn't
except
more connections.  

I have only "browsed" the article but found it interesting that the
db that was hard to use "dusted" all the ones that were "easy" when they
had no
help from "Oracle Experts".  

John


[EMAIL PROTECTED] wrote:

  Do you mean it was SQL Server DBAs tuning Oracle in this test, becausethat's what they are using for their web-site?Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, February 28, 2002 1:58 PM
  
Interesting,  I went to the web page and clicked on the link"Putting database performance to the test"  and  got the following messageCould not Connect to DB:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does notexist or access denied.Oh well,  maybe they were mad because they lost!John[EMAIL PROTECTED] wrote:

  At first glance it looks like they could have done more to tune Oracle.Certain tables could have been cached (or buffer pools could have beenused). They're only using a 4K db block so it would have been nice to seetests with 8K and 16K db blocks. Sort area size may need tuning. I'd like
  
  
  to
  

  see some tkprof on the queries and see what the most expensive queries
  
  
  are
  

  in terms of CPU, I/O, and number of executions. It would be nice to seedatabase results on Linux... It would be cool to see what some focusedtuning efforts could do but who has time for that?Anyone have any other tuning suggestions for eWeek?Time for the tuning DBA guru's to shine. :-)-Original Message-Sent: Thursday, February 28, 2002 9:53 AMTo: Multiple recipients of list ORACLE-LAnybody happen to see the cover story on the 02/25/2002 iss of eWeek
  
  
  titled
  

  "Database Clash"?The pretty graphs say that their tests showed that Oracle and MySQL
  
  
  rocked
  

  the other DBs they tested (including MS SQueaL Server).  So I
  
  
  investigated.
  

  I went to http://www.eweek.com/ and downloaded the "Online Exclusive:Download our configuration and tuning scripts".According to the Oracle setup docs in there, they're NOT using MTS andprocesses in init.ora is 150.  So then how did they test for 1000"concurrent Web clients"?Anyone have a thought?Rich Jesse   System/Database Administrator[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
  
  
  USA
  
--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ora NT DBA  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).

How to know gap between PctUsed and PctFree

2002-02-28 Thread Pablo ksksksk


Hi list

Is there a way to know the gap that exists, (in bytes)
for each block of a table, between pctused and
pctfree? 

THANKS


___
Do You Yahoo!?
Yahoo! Messenger
Comunicación instantánea gratis con tu gente.
http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  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: PocketDBA


it's now Expand Beyond, they've changed the company name.

Ari does lurk, he'll also be presenting to the NYOUG on March 21, for
any of you who want to talk to him in person about it


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> I have.  It is pretty cool.  I believe the creator, Ari Kaplan, lurks
> on this list.  I bet they'll send you a demo device if you ask.  Try
> out Pocket SA too.
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Thu, 28 Feb 2002, [EMAIL PROTECTED] wrote:
> 
> > Anyone on the list ever use this software?  Any feedback?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jeremiah Wilton
>   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).


__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: TRANSPORTABLE TABLESPACE


Exporting/Importing (transportable) tablespaces involve physical copying of
the data files. This will not eliminate fragmentation. It will transport it
to the other database as well :(

Time to visit http://tahiti.oracle.com  ??? 

- Kirti 

-Original Message-
Sent: Thursday, February 28, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L



Hi
If i can use transporable tablespace export and import mode then is this 
elimintae the fragmentation?
Thx
-Seema


_
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: Seema Singh
  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: Deshpande, Kirti
  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: TRANSPORTABLE TABLESPACE

2002-02-28 Thread Gogala, Mladen


No, it doesn't eliminate the fragmentation because you're importing
only the dictionary information, not the tables itself. If you do the
full export/import, then you will get rid of the fragmentation. It's
especially funny thing to do on a >1TB system.

> -Original Message-
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 28, 2002 2:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: TRANSPORTABLE TABLESPACE
> 
> 
> 
> Hi
> If i can use transporable tablespace export and import mode 
> then is this 
> elimintae the fragmentation?
> Thx
> -Seema
> 
> 
> _
> 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: Seema Singh
  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: Gogala, Mladen
  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: Clash of the DBs in eWeek

2002-02-28 Thread Jesse, Rich

On the MTS part, my faux pas.  I saw the first "dispatchers" commented out
along with the other "mts%" params.

Also, on closer inspection, I was looking at
"create_nile2_database_details.htm" in the "C - Create Benchmark Database"
folder in the .zip file when I saw that "processes" was set to 150.  Perhaps
they made changes to the init.ora (from the "B - Configure Database Server"
folder) after an initial GUI DB create?

Thanks, Brian, and thanks all else that pointed out the JDBC connection
pooling.  I've been trying to take a look at that stuff, but I've got no
time here at work and I can't run Oracle at home on my Linux/Alpha box.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Thursday, February 28, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L

Which docs?  I looked at the init.ora file, and it had:

processes=530

and MTS enabled.

Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
--

Rachel Carmichael wrote:

> they lie?
>
> --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> > Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
> > titled
> > "Database Clash"?
> >
> > The pretty graphs say that their tests showed that Oracle and MySQL
> > rocked
> > the other DBs they tested (including MS SQueaL Server).  So I
> > investigated.
> > I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> > Download our configuration and tuning scripts".
> >
> > According to the Oracle setup docs in there, they're NOT using MTS
> > and
> > processes in init.ora is 150.  So then how did they test for 1000
> > "concurrent Web clients"?
> >
> > Anyone have a thought?
> >
> >
> > Rich Jesse   System/Database Administrator
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: Unused users for the last 30 and 60 days.


You could audit connects and use that to determine which accounts have
not connected to the database in the last 30-60 days. Connect auditing will
have 0 performance impacts, but you will need to manage the audit table and
write a good SQL script to give you the info you need.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Thursday, February 28, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L



Hi All,

I want to have report of all the users who has not used their Oracle
username for the last 30 and 60 days.
Any views how can I get the report.

Thanks,
Deepender



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

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

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: Freeman, Robert
  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: PocketDBA

2002-02-28 Thread Jeremiah Wilton


I have.  It is pretty cool.  I believe the creator, Ari Kaplan, lurks
on this list.  I bet they'll send you a demo device if you ask.  Try
out Pocket SA too.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 28 Feb 2002, [EMAIL PROTECTED] wrote:

> Anyone on the list ever use this software?  Any feedback?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: Clash of the DBs in eWeek



In additon.. here's a quote from the article: 

"Microsoft and Oracle both declined to be involved in the test-with their
database servers, we did all tuning ourselves with no vendor input." 

Not at all bad for Oracle to score high without any 'expert' tuning advice. 

But was this test worth ignoring for Larry??

The on-line poll on the web site was interesiting, though.. 
(Which server database is most critical to you organization?). 
Oracle 33.26% MySQL 19.99% SQLServer 15.91% when I voted.. 

- Kirti 



 

-Original Message-
Sent: Thursday, February 28, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L


At first glance it looks like they could have done more to tune Oracle.
Certain tables could have been cached (or buffer pools could have been
used). They're only using a 4K db block so it would have been nice to see
tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to
see some tkprof on the queries and see what the most expensive queries are
in terms of CPU, I/O, and number of executions. It would be nice to see
database results on Linux... It would be cool to see what some focused
tuning efforts could do but who has time for that? 

Anyone have any other tuning suggestions for eWeek? 

Time for the tuning DBA guru's to shine. :-)



-Original Message-
Sent: Thursday, February 28, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L


Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled
"Database Clash"?

The pretty graphs say that their tests showed that Oracle and MySQL rocked
the other DBs they tested (including MS SQueaL Server).  So I investigated.
I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
Download our configuration and tuning scripts".

According to the Oracle setup docs in there, they're NOT using MTS and
processes in init.ora is 150.  So then how did they test for 1000
"concurrent Web clients"?

Anyone have a thought?


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: Orr, Steve
  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: Deshpande, Kirti
  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).

TRANSPORTABLE TABLESPACE

2002-02-28 Thread Seema Singh



Hi
If i can use transporable tablespace export and import mode then is this 
elimintae the fragmentation?
Thx
-Seema


_
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: Seema Singh
  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: Clash of the DBs in eWeek

2002-02-28 Thread James McCann


I was involved in a similar thing a while ago, with a couple of different
databases including a new in memory database, which is meant to be 10 times
faster than Oracle.

And it was, until Oracle was tuned. It was a different story then!

Jim



-Original Message-
Sent: 28 February 2002 19:43
To: Multiple recipients of list ORACLE-L


Do you mean it was SQL Server DBAs tuning Oracle in this test, because
that's what they are using for their web-site?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 1:58 PM


> Interesting,  I went to the web page and clicked on the link
>
> "Putting database performance to the test"  and  got the following message
>
> Could not Connect to DB:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
>
> Oh well,  maybe they were mad because they lost!
>
> John
>
> [EMAIL PROTECTED] wrote:
>
> >At first glance it looks like they could have done more to tune Oracle.
> >Certain tables could have been cached (or buffer pools could have been
> >used). They're only using a 4K db block so it would have been nice to see
> >tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like
to
> >see some tkprof on the queries and see what the most expensive queries
are
> >in terms of CPU, I/O, and number of executions. It would be nice to see
> >database results on Linux... It would be cool to see what some focused
> >tuning efforts could do but who has time for that?
> >
> >Anyone have any other tuning suggestions for eWeek?
> >
> >Time for the tuning DBA guru's to shine. :-)
> >
> >
> >
> >-Original Message-
> >Sent: Thursday, February 28, 2002 9:53 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
titled
> >"Database Clash"?
> >
> >The pretty graphs say that their tests showed that Oracle and MySQL
rocked
> >the other DBs they tested (including MS SQueaL Server).  So I
investigated.
> >I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> >Download our configuration and tuning scripts".
> >
> >According to the Oracle setup docs in there, they're NOT using MTS and
> >processes in init.ora is 150.  So then how did they test for 1000
> >"concurrent Web clients"?
> >
> >Anyone have a thought?
> >
> >
> >Rich Jesse   System/Database Administrator
> >[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ora NT DBA
>   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: Igor Neyman
  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: James McCann
  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: iSQLPlus Problem

2002-02-28 Thread KENNETH JANUSZ

Title: Message



Yes.

  - Original Message - 
  From: 
  Michael 
  Cupp 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, February 28, 2002 11:33 
  AM
  Subject: RE: iSQLPlus Problem
  
  Are 
  you sure you can see hidden dirs?
  

-Original Message-From: KENNETH JANUSZ 
[mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:03 
AMTo: Multiple recipients of list ORACLE-LSubject: 
iSQLPlus Problem
I have a DELL 8200 with XP Prof. and I have installed 9i 
(9.0.1).
 
When I look at installed products with the Universal 
Installer it says that iSQL Plus is installed at:
 
c:\oracle\ora90\oracle_prod\
 
However, when I look at my C: drive I only 
have:
 
c:\oracle\ora90\    
"oracle_prod" is not there and neither are any apps for iSQL 
Plus.  
 
What is wrong?
 
Thanks,
Ken Janusz, 
CPIM

Re: moving from unix to NT

2002-02-28 Thread Igor Neyman


Jared,

On NT oracle.exe runs as "OracleService" service.
Hence UTL_FILE will be executed under whatever OS account
"OracleService" service runs.
And I was not able to make it running properly under any other than SYSTEM
account.
Remember, on NT Oracle is one big (though multithreaded) process, unlike it
is on UNIX.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 1:03 PM


> I don't have any experience with UTL_FILE on NT.  I've used it a little
> on unix.  Don't know why it wouldn't work on NT.  As stated by others,
> it might be a problem if writing to network drives, as the SYSTEM user
> does not have access to those when run as a service.
>
> This doesn't seem reasonable though, as the instance itself does not
> run as a service.  The VOS runs as a service, but not the instance.
>
> Best bet is to try it.
>
> The biggest problem will likely be your code.  If you have paths hard
> coded in it, you will have to rewrite.  If they are stored in a table,
> just
> change the data.
>
> If you're interested in Perl, I can send you the same email I sent
> Dave Farnsworth.  I can do that tonight from home if you like.
>
> Jared
>
>
>
>
>
>
> John Dunn <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 02/28/02 02:08 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:RE: moving from unix to NT
>
>
> Jared
>
> It would be useful if you could point me in the right direction.
>
> I guess the real question for me is will UTL_FILE work properly when I
> move
> to NT, including on Network drives?. There seems to be some doubt amongst
> the listers as to whether it does.
>
>
>
> John.
>
>
> > -Original Message-
> > From:  [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent:  27 February 2002 18:35
> > To:Multiple recipients of list ORACLE-L
> > Subject:   RE: moving from unix to NT
> >
> > Perl is *much* more flexible than UTL_FILE for flat file operations.
> >
> > There is simply no basis for comparison.
> >
> > The question in your case is this:  Can you easily replace the PL/SQL
> > procedures that are using UTL_FILE with a process that runs outside
> > of the database?
> >
> > If so, myself and others on this list can point you in the right
> > direction, as
> > basics in Perl/Oracle/DBI are really not too hard.
> >
> > If your PL/SQL is part of a larger application and not easily removed,
> you
> > may just have to deal with modifying  the PL/SQL.
> >
> > Of course, if you had made this stuff data driven ( meta data, if you
> will
> >
> > ),
> > this would be a  non-issue.  :)
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > John Dunn <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 02/27/02 01:53 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject:RE: moving from unix to NT
> >
> >
> > Thanks to everyone for their input into this. The only real issue seems
> to
> > be UTL_FILE on network drives.
> >
> > 1. I was interested in the many references to Perl as an alternative to
> > using UTL_FILE. Could any of you provide more detail. I know nothing
> about
> > Perl so would be interested in how to replace the use of UTL_FILE in
> > PL/SQL
> > with Perl. We use UTL_FILE quite a lot for reading and writing flat
> files.
> >
> >
> >
> > 2. With regard to external procedures, On Unix we currently use this to
> > call
> > a C routine that calls the system command to run Unix commands and
> > scripts(Korn Shell). I presume we will need to amend these commands to
> > their
> > NT equivalents(or can I call Windows API directly from PL/SQL? on NT)
> and
> > re-write the scripts...presumably in Perl?
> >
> >
> > It will probbably be Oracle 9i on NT.
> >
> >
> > John
> >
> >
> > > -Original Message-
> > > From:  [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > > Sent:  26 February 2002 21:37
> > > To:Multiple recipients of list ORACLE-L
> > > Subject:   Re: moving from unix to NT
> > >
> > > I haven't tried to do this with Oracle, I just knew that you could.
> > >
> > > My use has been to change the account that is used for some of my
> > > monitors that need to see network drives.  I've never had a need
> > > to make Oracle run as other than System.
> > >
> > > As for UTL_FILE, I avoid it like the plague.  Perl is much cleaner
> > > and easier to use.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Igor Neyman" <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > > 02/26/02 10:53 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <[EMAIL PROTECTED]>
> > > cc:
> > > Subject:Re: moving from unix to NT
> > >

PocketDBA

2002-02-28 Thread dgoulet


Anyone on the list ever use this software?  Any feedback?

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

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

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: Unused users for the last 30 and 60 days.

Hi Deepender,

I know of know builtin oracle view that will tell you this infomation. 
 At a former
job we were required to disable accounts that had not been used in the 
last 60
days.  

It has been a little while since I worked there (7 years to be exact) but
basically this is what we did

1.  created a tablecalled dbs_user_info with the fields (username, 
create_date, last_login_date)

2.  copied the username and create field from dba_users into the fields, 
initially we set last_login_date to be = create;

3.  Turned on auditing in the init.ora and audited successful logins

4.  at night we went through the sys.aud$ table and for each user that 
existed updated the last_login_date  truncating sys.aud$ when done

5.  weekly ran a batch job that found all users that last_login_date was 
 > 30 days

Beginning in 8i it might be easier to do this with an after login 
trigger rather than auditing

Hope this helps,
John
that contained the username,

[EMAIL PROTECTED] wrote:

>Hi All,
>
>I want to have report of all the users who has not used their Oracle
>username for the last 30 and 60 days.
>Any views how can I get the report.
>
>Thanks,
>Deepender
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  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: Clash of the DBs in eWeek

They used weblogic for the webserver. Typically it will keep several 
connections open, pooling them in essence. The article indicated that
*they* did all the Oracle tuning, and that Oracle did not send anyone
to help with the tuning process (unlike MySQL), so it's probably amazing
that they got the results they did. I don't think they lied, but I don't
think they probably realized that they could have possible eeked out
some additional performance had they worked it a bit harder with a
knowledgeable web DBA.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

-Original Message-
Sent: Thursday, February 28, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L

they lie?

--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
> titled
> "Database Clash"?
> 
> The pretty graphs say that their tests showed that Oracle and MySQL
> rocked
> the other DBs they tested (including MS SQueaL Server).  So I
> investigated.
> I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> Download our configuration and tuning scripts".
> 
> According to the Oracle setup docs in there, they're NOT using MTS
> and
> processes in init.ora is 150.  So then how did they test for 1000
> "concurrent Web clients"?
> 
> Anyone have a thought?
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex,
> WI USA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jesse, Rich
>   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).

__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Freeman, Robert
  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: Clash of the DBs in eWeek

2002-02-28 Thread Igor Neyman


Do you mean it was SQL Server DBAs tuning Oracle in this test, because
that's what they are using for their web-site?

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 1:58 PM


> Interesting,  I went to the web page and clicked on the link
>
> "Putting database performance to the test"  and  got the following message
>
> Could not Connect to DB:
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist or access denied.
>
> Oh well,  maybe they were mad because they lost!
>
> John
>
> [EMAIL PROTECTED] wrote:
>
> >At first glance it looks like they could have done more to tune Oracle.
> >Certain tables could have been cached (or buffer pools could have been
> >used). They're only using a 4K db block so it would have been nice to see
> >tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like
to
> >see some tkprof on the queries and see what the most expensive queries
are
> >in terms of CPU, I/O, and number of executions. It would be nice to see
> >database results on Linux... It would be cool to see what some focused
> >tuning efforts could do but who has time for that?
> >
> >Anyone have any other tuning suggestions for eWeek?
> >
> >Time for the tuning DBA guru's to shine. :-)
> >
> >
> >
> >-Original Message-
> >Sent: Thursday, February 28, 2002 9:53 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
titled
> >"Database Clash"?
> >
> >The pretty graphs say that their tests showed that Oracle and MySQL
rocked
> >the other DBs they tested (including MS SQueaL Server).  So I
investigated.
> >I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> >Download our configuration and tuning scripts".
> >
> >According to the Oracle setup docs in there, they're NOT using MTS and
> >processes in init.ora is 150.  So then how did they test for 1000
> >"concurrent Web clients"?
> >
> >Anyone have a thought?
> >
> >
> >Rich Jesse   System/Database Administrator
> >[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ora NT DBA
>   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: Igor Neyman
  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: replication gui

2002-02-28 Thread Suzy Vordos

On Unix it's part of DBAStudio, maybe the same on NT.

> "Bunyamin K. Karadeniz" wrote:
> 
> I have oracle ent. edition on my machine (NT) but do not have the link
> of adv. replication manager in start panel .
> What is the name of exe starting the Replication manager ?
> thank you
> bunyamin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  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: ORA-00600 errors

2002-02-28 Thread MacGregor, Ian A.


The itar creation process now includes a utility where you can either lookup  Ora-600 
messages or have it examine the stack trace from an ORA-7445 dump.  I had it analyze a 
stack trace this morning.  The result of using the utility is a list of links to 
articles Metalink considers germane to the problem.  None, however, seem to match my 
particular problem.  I also found that I had to use another web window to actually 
bring up the listed documents via Metalink's advanced search facility using the 
document id, or through the bug query screen.  Simply clicking on the link did nothing.

Perhaps the Ora-600 portion of the facility works a bit better?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 4:28 AM
To: Multiple recipients of list ORACLE-L


>> From: John Dunn <[EMAIL PROTECTED]>
>> Date: Mon, 25 Feb 2002 16:01:54 -
>> Subject: ORA-00600 errors
>>
>>can anyone tell me waht these errors might mean?
>>
>>Errors in file /u01/app/oracle/admin/vaddev/udump/vaddev_ora_6942.trc:
>>ORA-00600: internal error code, arguments: [17172], [0], [], [], [], [],
[],
>>[]
>>Thu Feb 21 03:10:56 2002
>>Errors in file /u01/app/oracle/admin/vaddev/bdump/vaddev_snp2_10163.trc:
>>ORA-00600: internal error code, arguments: [17090], [], [], [], [], [],
[],
>>[]

John,

There is info for the 17090 error on MetaLink.  Navigate as follows:

Top Tech Docs>
Data Server>
Database Administration>
ORacle Internal Errors.
Which will point you to
Note 153788.1 "ORA-600 Argument Lookup"

HTH,
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  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: MacGregor, Ian A.
  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: Total Extents

2002-02-28 Thread Post, Ethan


Thanks Connor, that is a lot faster.  I think I will go with the idea of
just watching for any dramatic drops in DBA_FREE_SPACE.  I have everything
tied down pretty tight but if a single object on a near empty tablespace
started to grow uncontrollably I wouldn't pick it up till tablespace hit 75%
or so or the next time I review my daily reports.  This way I will get
notified a bit sooner. 

- Ethan

-Original Message-
Sent: Thursday, February 28, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L


dba_segments is a view on sys_dba_segs which is:

all "normal" segments
union all
all temp segs
union all
all rollback segs

the last two of which we rarely care about when it
comes to checking space etc.  You can get (some) gains
by creating your own view on just the "normal" segs

hth
connor
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  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).

Install hanging issue

2002-02-28 Thread Harvinder Singh


Hi,

We are applying patch 9.0.1.1.0 on sun solaris and it looks like 
when we run ./runInstaller it hangs while analyzing dependencies..
I check the cpu usage and jre is using 98% of cpu.
What can be the possible cause of hanging ans so high cpu usage

Thanks
--Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: MS Access migration to oracle

2002-02-28 Thread Gogala, Mladen


Waleed, you saved my life! I don't know why was I expecting Access97
application designers to define minor details like the primary keys.
I most certainly owe you one.

> -Original Message-
> From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 28, 2002 9:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MS Access migration to oracle
> 
> 
> Either it's the privileges on the tables or
> the tables do not have primary keys or unique keys.
> 
> Access will put the table in read only mode if it does not 
> have PK or Unique
> key.
> 
> Waleed
> 
> -Original Message-
> Sent: Thursday, February 28, 2002 8:13 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I've been told to migrate one  MS-Access 97 database to oracle. Oracle
> Migration Workbench did the 
> trick in  an extremely clean, quick and complete way. Tables 
> are created,
> populated with data and it is 
> now when the problem starts.  The people that were using this Access
> database  were doing so by means 
> of an ancient VB piece of ... code and they don't want or 
> they don't know to
> adjust it. They expect the program 
> to somehow  find the new Oracle 8.1.7.3  instance and 
> continue to work as it
> did before. I created a new access database
> containing ODBC links to the Oracle tables, but the program 
> is complaining
> that the "links" are read only. Is there any way 
> in this world or beyond to make these tables writable? I'm 
> inclined to tell
> them that they should do some coding, which is
> very likely to make them go back to Access.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Gogala, Mladen
>   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: Khedr, Waleed
>   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: Gogala, Mladen
  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: Manager decrees "his" data warehouse design. Help!

2002-02-28 Thread Mercadante, Thomas F


Rach,

good point.  boy, do we live in a tough world  :)


-Original Message-
Sent: Thursday, February 28, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L


But Tom, there will be a short time period where people are asking "who
designed this piece of crap?" and the manager who designed it will be
pointing to the DBA... so you need the paper trail

--- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> That's what step #3 is for.  Everyone will forget how "bad" the first
> warehouse was once the true properly designed warehouse is in place
> and
> delivering the goods.  It sounds like there is pressure to deliver
> "something" right away - as usual, no time to design it properly.  A
> manager
> I used to work for had the best philosophy:  "Lets hurry up and do it
> wrong
> so that we can fix it later".  Sounds strange, but "that's the
> business we
> choose to be in" (ala The Godfather).  *Nobody* wants to spend time
> and
> resources doing research to desig n a system.  In a way, it's our
> (the IT
> industry's) fault.  We have promised for years that we can develop
> programs
> faster and faster.  Now, the managers expect it.  But most of them
> realize
> that it's a mistake, but easier to fix after the fact.
> 
> my little 2 cents.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Thursday, February 28, 2002 9:08 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Just make sure it's documented that the original idea is NOT yours :)
> 
> 
> --- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> wrote:
> > Don,
> > 
> > I agree with Yechiel.  You do, after all, work for this guy, and by
> > extension, the company.  You need to learn to pick your fights.  In
> > the
> > larger picture, does it really matter that much?  Are your kids at
> > home
> > going to be disappointed in you if you build this POC?  Take the
> > advice of
> > most of the members of this list.  Build this thing as quickly as
> > possible,
> > and deliver it to the users.  It sounds like they :
> > 1).  will not use it, so you will get to throw it away in a year
> > 2).  will use it, and will be disappointed with it and stop using
> it
> > - in
> > which case you get to throw it away in a year
> > 3).  once it is built, re-design it the way you want (in a new
> > schema) and,
> > when the original fails, announce that you have been "studying the
> > matter"
> > and have a better version waiting to implement.  You will become
> the
> > hero
> > all the way around.  Your boss will be glad that he delivered the
> > first
> > "warehouse".  He will be happy that, when problems arise from the
> > first
> > version, that you are "on the spot" with version #2 to solve his
> > problems
> > and make him look good again.
> > 
> > In the meantime, go home, kiss your wife, hug your kids, pet the
> dog,
> > read a
> > good book, go for a walk, throw a baseball with your kids, go to
> the
> > movies
> > with your wife, and realize that, like food poisoning, this too
> will
> > pass.
> > 
> > Hope this helps.
> > 
> > Tom Mercadante
> > Oracle Certified Professional
> > 
> > 
> > -Original Message-
> > Sent: Thursday, February 28, 2002 3:23 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello Don
> > 
> > In a more serious mood: DO IT.
> > I also had some arguments with my boss over the years and except
> > for 2-3 cases (in 20 years) that I told my boss that I will not do
> > something
> > and if he wants it he can do it himself, my motto was if he wants
> to
> > waste
> > resources for something that is obviously an error let him waste
> it.
> > He wants you to waste time and disk space on a system that the
> users
> > will not use: waste your time and the resources. He is management
> and
> > he is the one who calls the shots.
> > Just document everything to cover yourself later.
> > 
> > Yechiel Adar, Mehish Computer Services
> > [EMAIL PROTECTED]
> > 
> > > -Original Message-
> > > From: Don [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wed, February 27, 2002 8:48 AM
> > > To:   Multiple recipients of list ORACLE-L
> > > Subject:  Manager decrees "his" data warehouse design.  Help!
> > > 
> > > I've lost patience, my temper, and I'm about to quit a job
> because
> > the IT 
> > > manager has decreed that we will have "his" data warehouse
> running
> > within 
> > > 24 hours, and we will use his design.
> > > 
> > > 1 - We are NOT to use any kind of views, not even materailzed
> > views.
> > > 2 - we are not to do any computations, summaries or rollups
> > > 3 - we are to have everything in one table
> > > 4 - "the" table name and column names will be meaningful to any
> > clerk
> > > 5 - we are not to "start" or "snowflake" designs.  "That's just a
> > bunch of
> > > 
> > > high power talk."
> > > 6 - all users will be trained to use MS Access to get at "their" 
> > > data.  (These are users that were just converted off from "green
> > scree

Re: 32 or 64 bit

2002-02-28 Thread Suzy Vordos

http://www.vampired.net/forums/viewtopic.php?topic=32&forum=15&0

> Harvinder Singh wrote:
> 
> Hi,
> 
> How to check the  database and sun unix system is 32 bit or 64 bit.
> 
> Thanks
> --Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  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: Clash of the DBs in eWeek


Interesting,  I went to the web page and clicked on the link

"Putting database performance to the test"  and  got the following message

Could not Connect to DB:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not 
exist or access denied.

Oh well,  maybe they were mad because they lost!

John

[EMAIL PROTECTED] wrote:

>At first glance it looks like they could have done more to tune Oracle.
>Certain tables could have been cached (or buffer pools could have been
>used). They're only using a 4K db block so it would have been nice to see
>tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to
>see some tkprof on the queries and see what the most expensive queries are
>in terms of CPU, I/O, and number of executions. It would be nice to see
>database results on Linux... It would be cool to see what some focused
>tuning efforts could do but who has time for that? 
>
>Anyone have any other tuning suggestions for eWeek? 
>
>Time for the tuning DBA guru's to shine. :-)
>
>
>
>-Original Message-
>Sent: Thursday, February 28, 2002 9:53 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled
>"Database Clash"?
>
>The pretty graphs say that their tests showed that Oracle and MySQL rocked
>the other DBs they tested (including MS SQueaL Server).  So I investigated.
>I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
>Download our configuration and tuning scripts".
>
>According to the Oracle setup docs in there, they're NOT using MTS and
>processes in init.ora is 150.  So then how did they test for 1000
>"concurrent Web clients"?
>
>Anyone have a thought?
>
>
>Rich Jesse   System/Database Administrator
>[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  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: oracle 8.1.7 patch 2 or 3?


Be careful with the 8.1.7.3 patchset if you use the dbms_describe or
odbsidescribe functions as the output format has changed in them
between 8.1.7.2 and 8.1.7.3 and 9.0.1.1 and 9.0.1.2...

If you are not using this functionality, then there is not problem. If
you are using it, make sure you exercise any code using it for any
potential problems.



RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Thursday, February 28, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Thanks Bill.  I will keep that in mind.  Sometimes the vendor doesn't want 
to spend time to help out and find this as the reason to do so.
Sharon
--On Thursday, February 28, 2002 11:32 AM -0500 bill thater 
<[EMAIL PROTECTED]> wrote:

> [EMAIL PROTECTED] wrote:
>
>> Hi,
>>
>> I am managing a software that uses a set of 8 oracle databases.  I am
>> preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then
>> apply a patch to the oracle software installation after the upgrade.
>> The software that uses these databases are only certified on patch 2
>> level at the time of release.  Since now the patchset 3 for 817 is
>> available, I would like to get advice in whether to apply patch 3
>> instead of patch 2. Same amount of work, more benefits.  The only
>> thing is that the application vendor does not officially support the
>> patch3.
>
> this can lead to problems getting support for the third party
> applications.  i have had support withdrawn when i was at anon supported
> patch level.  before doing this i'd check with the support of the
> application.
>
>
> --
> --
> Bill "Shrek" Thater  ORACLE DBA
> [EMAIL PROTECTED]
> 
> You gotta program like you don't need the money,
> You gotta compile like you'll never get hurt,
> You gotta run like there's nobody watching,
> It's gotta come from the heart if you want it to work.
> 
> [Unix] is not necessarily evil, like OS/2.  - Peter Norton
>
>
>
>
>
>



--
Xiaohong Yang (Sharon)
certified Oracle DBA
Center for Bioinfomatics, CB#7100
School of Medicine
UNC-CH
919-843-6016 (o)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xiaohong Yang (Sharon)
  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: Freeman, Robert
  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: Clash of the DBs in eWeek

2002-02-28 Thread Suzy Vordos



I'm guessing JDBC connection pooling within WebLogic.

"Jesse, Rich" wrote:
> 
> Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled
> "Database Clash"?
> 
> The pretty graphs say that their tests showed that Oracle and MySQL rocked
> the other DBs they tested (including MS SQueaL Server).  So I investigated.
> I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> Download our configuration and tuning scripts".
> 
> According to the Oracle setup docs in there, they're NOT using MTS and
> processes in init.ora is 150.  So then how did they test for 1000
> "concurrent Web clients"?
> 
> Anyone have a thought?
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   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: Suzy Vordos
  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: Non-partitioned table to Hash Partitioned table


Oracle9i provides on online data move facility that will allow you to
do this with a minimum of restrictions. I discuss this, and give an example
in my Oracle Press book, Oracle9i New Features. This is facilitated
throughout the new dbms_redefinition package.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Thursday, February 28, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


Hello!

I am trying to figure out the best way to convert a non-partitioned table
with approx 20 million rows into a hash-partitioned table. This should be
done with minimal down-time. This will be in an Oracle 9i environment done
at a time when only SELECTs are occuring on the table.

The best way I can figure is to create a second table and copy the data
over; create the indexes; and rename the tables.

I would appreciate any hints on what section of TFM to read.

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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: Freeman, Robert
  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: Total Extents


Gopal,
 Thanks for the info..

- Kirti 

-Original Message-
Sent: Thursday, February 28, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L


Kirti,

In LMT you can query the X$KTFBUE which is roughly equivalent to UET$ in
DMTs.


select v.name "FILE NAME",count(x.KTFBUEFNO) "TOTAL # of EXTENTS"
from V$datafile v, X$KTFBUE x
where v.file#=X.ktfbuefno
group by v.name;

Ethan, Is this what you are looking for or something else?



Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Kirti
Sent: Thursday, February 28, 2002 7:13 AM
To: Multiple recipients of list ORACLE-L


That's what I thought too, but it will skip extents from any LMTs in use.
And getting extents info when LMTs are is use will be slower as compared to
DMTs due the way this info is stored in the bitmap in each datafile for the
LMT.

- Kirti

-Original Message-
Sent: Wednesday, February 27, 2002 4:47 PM
To: Multiple recipients of list ORACLE-L



How about counting rows from uet$? I have not tried it.

Raj


"Post, Ethan"


s.net>   cc:

Sent by: Subject: Total Extents

root@fatcity.

com





February 27,

2002 05:13 PM

Please

respond to

ORACLE-L


Anyone recommend a faster access path for getting the total number of
extents in the database?  select sum(extents) from dba_segments is too slow
for my purposes.

Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
  INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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: Deshpande, Kirti
  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: Clash of the DBs in eWeek

2002-02-28 Thread Brian McGraw


Which docs?  I looked at the init.ora file, and it had:

processes=530

and MTS enabled.

Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
--

Rachel Carmichael wrote:

> they lie?
>
> --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> > Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
> > titled
> > "Database Clash"?
> >
> > The pretty graphs say that their tests showed that Oracle and MySQL
> > rocked
> > the other DBs they tested (including MS SQueaL Server).  So I
> > investigated.
> > I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> > Download our configuration and tuning scripts".
> >
> > According to the Oracle setup docs in there, they're NOT using MTS
> > and
> > processes in init.ora is 150.  So then how did they test for 1000
> > "concurrent Web clients"?
> >
> > Anyone have a thought?
> >
> >
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech International, Sussex,
> > WI USA
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jesse, Rich
> >   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).
>
> __
> Do You Yahoo!?
> Yahoo! Greetings - Send FREE e-cards for every occasion!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   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: Brian McGraw
  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: Clash of the DBs in eWeek

2002-02-28 Thread lembark




-- "Orr, Steve" <[EMAIL PROTECTED]> on 02/28/02 10:08:30 -0800

> At first glance it looks like they could have done more to tune Oracle.

One of the specific points made in the article was that 
Oracle is something of a pain to tune. "Tunability" is 
only useful up to the point where competent people can
actually do it; after that it becomes a liability.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

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: Clash of the DBs in eWeek


they lie?


--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote:
> Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
> titled
> "Database Clash"?
> 
> The pretty graphs say that their tests showed that Oracle and MySQL
> rocked
> the other DBs they tested (including MS SQueaL Server).  So I
> investigated.
> I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> Download our configuration and tuning scripts".
> 
> According to the Oracle setup docs in there, they're NOT using MTS
> and
> processes in init.ora is 150.  So then how did they test for 1000
> "concurrent Web clients"?
> 
> Anyone have a thought?
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex,
> WI USA
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jesse, Rich
>   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).


__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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).

Upgrade to 64bit HP-UX 11.0

2002-02-28 Thread Kirsch, Walter J (Northrop Grumman)


We're running 4 instances of Oracle 8.1.6/7 on a 2Gig, 32 bit HP-UX 11.0  To
move up to 9i, will a simple doubling of RAM be underkill? overkill?  
Will disk requirements stay roughly the same for Oracle?  for the OS?
Any experiences you share will be gratefully accepted.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kirsch, Walter J (Northrop Grumman)
  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).

Unused users for the last 30 and 60 days.

2002-02-28 Thread Deepender . Gupta



Hi All,

I want to have report of all the users who has not used their Oracle
username for the last 30 and 60 days.
Any views how can I get the report.

Thanks,
Deepender



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

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

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: Manager decrees "his" data warehouse design. Help!