date:20030403

instance recovery time is more manageable in 9i --
mttr_fast_start_target in the init.ora. 

For a time, in version 6, Oracle said you HAD to use shutdown abort,
that a shutdown immediate could corrupt the database (that was an
undocumented feature)

I've had cases where the regular, automated backup procedure did a
shutdown immediate. And because some programmer had left an ad hoc
query running, the database did not shut down, the backup did not
complete and when the users came in in the morning, they couldn't
access the database.

If you are going to use shutdown immediate, you need to be aware that
it could hang, and leave your database in an half-life state --
neither shutdown nor started up. Make sure you have a process that
monitors how long the shutdown immediate is taking and either alerts
you that the time is excessive or kills the shutdown immediate and does
a shutdown abort. And if you do a shutdown abort as standard practice,
I'd suggest following it immediate with startup restrict and then
shutdown for a clean shutdown


--- Mark Richard [EMAIL PROTECTED] wrote:
 I don't think the issue is so much about whether Oracle recovery can
 handle
 a database crash or not.  I think the issue is whether you want to
 spend
 the time of going through that process.  I'm sure recovery can also
 handle
 the server being powered cycled but how many people do that without
 shutting down Oracle first?
 
 Since we had a car analogy already in this thread...  I'm confident
 that
 the seat belts in my car work but I'm in no rush to test them out,
 and even
 if they do work I'm likely to end up bruised anyway.
 
 I guess the bruising my equate to overtime spent recovering the
 database...
 Oh, I hate trying to make really good analogies.
 
 
 
  
  
 Rachel   
  
 Carmichael   To: Multiple recipients
 of list ORACLE-L [EMAIL PROTECTED]   
 [EMAIL PROTECTED]   cc: 
  
 ahoo.comSubject: RE: dbshut
 script - shutdown or shutdown immediate   
 Sent by: 
  
 [EMAIL PROTECTED]   
  
 om   
  
  
  
  
  
 03/04/2003   
  
 12:33
  
 Please respond   
  
 to ORACLE-L  
  
  
  
  
  
 
 
 
 
 yeah so? are you suggesting that Oracle instance recovery can't
 handle
 a database crash? If so, better pray your server never crashes.
 
 
 --- Pardee, Roy E [EMAIL PROTECTED] wrote:
  Well... my official oracle instructor in dba larva school said that
  it's
  tantamount to crashing the db--or so I recall anyway.  This isn't
 so?
 
  Peace,
 
  -Roy
 
  Roy Pardee
  Programmer/Analyst
  SWFPAC Lockheed Martin IT
  Extension 8487
 
  -Original Message-
  Sent: Wednesday, April 02, 2003 2:09 PM
  To: Multiple recipients of list ORACLE-L
 
 
  On Wed, 2 Apr 2003, Chris Berry wrote:
 
   Shutdown abort is pretty drastic, are you sure shutdown immediate
   didn't work?
 
  What is drastic about shutdown abort?
 
  Never one to opt out of a shutdown abort thread,
  --
  Jeremiah Wilton
  http://www.speakeasy.net/~jwilton
 
  - Uses shutdown abort exclusively
  - successful shutdowns/startups: over 10,000
  - problems with shutdown abort: 0
  - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
  - still employed!
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services

Re: oracle full table scan

2003-04-03 Thread Peter . McLarty

Perhaps you need to do a trace to determine the real cause of you 
problems. Full table scans are not necessarily the problem. When you have 
trace for the program and the explain plain you have of the executing SQL 
you will have a better idea than assuming you need indexes to stop full 
table scans.

Cheers




--
=
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

=

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. 






Arvind Kumar [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/2003 02:58 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:oracle full table scan


Dear All,

  is there any way to find which tables (table name) are suffering 
from
full table scan ,so that  i can create indexes on them to enhance the
performance.


Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Jeremiah Wilton

Mark has hit on the crux of the issue.  Most of us have expectations
from users and management that we will have the databases available as
much as possible.  Downtime costs money and should be avoided.

That said, we will eventually need downtime for one reason or another.
The question becomes how do we minimize it.

I use shutdown abort to increase availability.  If you 'alter system
checkpoint' before you shutdown abort, then automatic crash recovery
is extremely fast, since only a few bytes of redo need to be applied.

On the other hand, if you shutdown immediate, you may be waiting all
day for those temp segments to get deallocated or for that large
transaction to get rolled back.  With abort, the deallocation doesn't
have to happen (it was unnecessary anyway), and the rollback is
deferred until after the database is open again and already available
to users.

So use your test systems, load them up like production, and try both.
I bet in 9 out of 10 cases, checkpoint+abort+startup will be much
faster than shutdown immediate+startup.

Of course, there are cases when you need a consistent database while
down.  Switching to archivelog mode is one example.  For those,
checkpoint+abort+startup restict+shutdown immediate should do the
trick.  This may only be useful if you are running a system that is
busy enough to have immediate take a long time.

I don't know why I am such a tyrant on this issue.  I guess I think it
exposes fuzzy thinking.  Yes I have driven to work many times without
accidents, but comparing this to many succesful aborts is inaccurate.
Cars are not designed in a fundamental way not to strike each other.
People have to be careful when driving not to hit each other.  Oracle,
on the other hand, is fundamentally designed to start up after a
shutdown abort.  I have reason to expect that I may have an accident
if I am not careful while driving.  But so far, nobody has produced
current bug numbers and issues or even solid reasoning that leads me
to believe that using shutdown abort is dangerous or won't work
consistently.  If abort is more dangerous than immediate, can we get a
list of other fully supported features of Oracle that are considered
dangerous?  We should call support and file a bug, no?

It reminds me of instructions for doing something I once found on
MetaLink: One of the steps read:

Start up the database carefully.

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

On Wed, 2 Apr 2003, Mark Richard wrote:

 I don't think the issue is so much about whether Oracle recovery can handle
 a database crash or not.  I think the issue is whether you want to spend
 the time of going through that process.  I'm sure recovery can also handle
 the server being powered cycled but how many people do that without
 shutting down Oracle first?
 
 Since we had a car analogy already in this thread...  I'm confident that
 the seat belts in my car work but I'm in no rush to test them out, and even
 if they do work I'm likely to end up bruised anyway.
 
 I guess the bruising my equate to overtime spent recovering the database...
 Oh, I hate trying to make really good analogies.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Anyone whom could explain this?

2003-04-03 Thread Hallas, John, Tech Dev

Is this procedure being run with a trigger Roland?

If so then the :new refers to the value of each row that is being inserted from the 
table 

To explain better

if an update triggger is on table roland with columns (road,town,country) and one row 
is in the table with values  Main Rd, Leeds, England
and the row is being updated to be New_Main Rd, Leeds, England then the following 
values will be in place
old:road  = Main Rd   new:road  = New_Main Rd
old:town = Leeds new:town=Leeds
old:country = England new:country=England.

That is about 100% of my PL/SQL knowledge so I hope I am correct

John

-Original Message-
Sent: 03 April 2003 11:09
To: Multiple recipients of list ORACLE-L


Hallo,

anone whom could explain what new. means
in this pl/sql procedure.

for instance: new.kundeoms := new.kundeoms + (in_diff);
  new.mva := new.mva + (in_diff_mva);

How do I get hold of it so i can see which sql it runsor is new.kundeoms just a value 
from a table?





PROCEDURE add_kundeoms(in_diff in number, in_diff_mva in number,
   in_diff_brtkr in number, in_flagg in varchar2) 
IS
lDetaljFunnet boolean;
  BEGIN

IF  in_flagg = '0' THEN
  new.kundeoms := new.kundeoms + (in_diff);
  new.mva := new.mva + (in_diff_mva);
  new.kostverdi := new.kostverdi + (in_diff - in_diff_mva - 
in_diff_brtkr);
ELSIF in_flagg = '1' THEN
  new.utg_pant := new.utg_pant + (in_diff);
ELSIF in_flagg = '9' THEN
  new.shop_in_shop := new.shop_in_shop + (in_diff);
ELSIF   in_flagg = '5' THEN
  new.rest_oms := new.rest_oms + (in_diff);
END IF;

BEGIN
  db_dagoms_detalj.find(new.dagoms_id, in_flagg);
  lDetaljFunnet := TRUE;
EXCEPTION
  WHEN OTHERS THEN
lDetaljFunnet := FALSE;
END;
IF lDetaljFunnet THEN
  db_dagoms_detalj.edit;
  db_dagoms_detalj.add_kundeoms(in_diff, in_diff_mva, in_diff_brtkr);
  db_dagoms_detalj.modify;
  db_dagoms_detalj.close;
END IF;
  END;
END;


Thanks in advance






Roland


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Hallas, John, Tech Dev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Interesting lesson on ARCHIVELOG mode

2003-04-03 Thread Biswas, Pradip

Good Posting, JIM . 
I had  once gone thru the exactly same experience. 

Oracle database  has some processes that work both independently , but
again, they work in tandem. Here is the peice where LGWR (in Archivelog) and
ARCH(s) are expected to work in tandem with each other (in ARCHIVELOG mode).

In Noarchivelog mode, ARCH(s) are not needed. SO LGWR works independently of
ARCHs. but you need to tell that to LGWR ( that archiving is NOT happening ,
the command alter database noarchivelog basically tells LGWR precisely
that) so that LGWR can recycle the log files to do a log switch ( log1 --
log2 --log1). 
In archivelogmode it will be 
  log1 --(arch_log2_ by arch) --log2 --( arch_log1_+1 by
arch) -- log1

I think, a good understanding of the Concepts DOC is the most imporatnt
thing for a Oracle DBA.



Pradip
-Original Message-
Sent: Wednesday, April 02, 2003 7:29 PM
To: Multiple recipients of list ORACLE-L


Some of you on the list might find this interesting.

I just wanted to relate a story with respect to an incident experienced in
the last few days on one of our test databases.  Environment is Compaq Tru64
Unix / Oracle 8.1.7.4.

A few days ago, I remember talking to a junior DBA who assists me in the
Oracle area, concerning excessive space usage on one of the Unix machines
running a test database environment.  I noted that the database was running
in ARCHIVELOG mode with automatic archiving (of course), and generating a
great many archived logs since there was considerable activity on that
instance/database.  We discussed the matter and agreed that there was no
need to have ARCHIVELOG mode turned on in this case.  So I told my assistant
DBA to go ahead and make the database NOARCHIVELOG, which I thought she
understood.

Yesterday, she comes to me with a host of problems she has been experiencing
on that test database, one of which was many failed attempts to import a 2
Million row table from another database's export.  It seemed that the import
would just hang after importing about 130,000 rows.  She repeatedly
cancelled the import, resorted to cycling the database, creating a another
table with just a subset of the columns of the original, limiting the number
of rows imported at one time, fooling with the buffer parameters of the
import control file, trying SQL*LOADER, and so on.  Quite frustrated, she
came to me for advice.

I had forgotten about the ARCHIVELOG mode issue a few days earlier, so I
began scratching my head as I looked unsuccessfully for signs of trouble in
alert logs and traces.  I thought maybe a rollback segment had run out of
room, lost its brains, or maybe temp space had become a problem.  But again,
no sign of any of these issues in alerts or traces.  Suspecting database
corruption, I took a full export to see if export would report any corrupted
blocks.  That worked flawlessly.  I began to wonder if we should just start
from scratch and recreate the database.  Then something interesting became
apparant.

Looking at V$DATABASE, I noticed that the database was still in ARCHIVELOG
mode!  When I asked about this, it seems that she thought that simply
commenting out the init.ora parameters:
 log_archive_start=true
 log_archive_dest=whatever
 log_archive_format=whatever
and then recycling the database would take care of the whole issue of
ARCHIVELOG mode, making the database become NOARCHIVELOG mode.  Well, guess
what.it didn't.

The lesson learned was that with the database still in ARCHIVELOG mode and
automatic archiving turned off, obviously enough DML would cause the
database to hang whenever it did a log switch, awaiting us DBAs to manually
archive the filled redo logs.  Realizing this, of course we then did the
prudent thing:
 alter database noarchivelog
and lived happily ever after.

Had I continued to assume database corruption and just had her recreate the
database, it WOULD have indeed solved the problem BUT ONLY because the
database would have come up in NOARCHIVELOG mode.  However, it certainly
would have bothered me as to why the database had become corrupted in the
first place.

I am very happy to know what actually happened, that the database wasn't
corrupted at all.  It was just someone's misunderstanding in not realizing
that ARCHIVELOG mode and automatic archiving are two related but totally
different things!

Jim Damiano

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

certifications was Re: Remote DBA

2003-04-03 Thread Joe Testa

Ramesh, since in your sig line you say you're brainbench and brainbuzz 
certified, do you really think those tests have any meaning, i took them 
and thought they were a joke.

joe

Ramesh Papnoi wrote:

It can be Unix as well as Windows. As I have to support various DB's

Best Regards
Ramesh D. Papnoihttp://www22.brinkster.com/rpapnoi
(Brainbench  Brainbuzz certified Oracle 8/8i DBA  Developer)
-Original Message-
Adar
Sent: Thursday, April 03, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
You did not mentioned what OS you are working on.
If the remote database is on your network, even via wan, you can activate
all the tools from your desktop.
We use RAS to connect to remote servers without network connections and then
you have SLOW network connection and your tools will work.
If the need arise you can use Netop or other PcAnywhere to take control of
the server and do your work from there.
We are on windows servers and clients.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:34 PM
 

Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate
   

if
 

any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]
TIA

Best Regards
Ramesh D. Papnoi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ramesh Papnoi
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Yechiel Adar
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
 

--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Oh Dear, Mr. Ellison's at it again

2003-04-03 Thread Boivin, Patrice J

Title: RE: Oh Dear, Mr. Ellison's at it again



19th 
Century... electric cars were being made in the late 1800s... not much progress 
since.

: 
)

Pat.

  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 2003 4:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oh Dear, Mr. Ellison's at it again
  Jeremy,
  
   True, you should watch what you wish for because it may 
  well come true!!
  
   RIP Oracle???
  
  Dick 
  Goulet
  
-Original Message-From: Jeremy Pulcifer 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 
2003 2:14 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Oh Dear, Mr. Ellison's at it 
again
 -Original Message-  
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]  Sent: Wednesday, April 02, 2003 10:45 AM  To: Multiple recipients of list ORACLE-L  Subject: Oh Dear, Mr. Ellison's at it again
Ellison: Linux Will Wipe Microsoft Out Of The Data Center   In dramatic terms, Oracle Corp. 
Chairman and CEO Larry  Ellison predicted the 
open-source operating system will wipe  
Microsoft "off the face of the earth" in the battle for the  data center market.  
 Wonder if anyone has clued him into MySql and 
PostGreSql yet!! 
Um, as he was talking about Linux, I suppose that MySQL and 
PostGres would actually bolster his claim. Perhaps to his own detriment, 
though...
However, I liked this... Quoting 
Larry, who is quoted in the ComputerWorld article mentioned: 
"The computer industry is finally moving from a cottage 
industry to an industrial industry. We're moving at breakneck pace toward 
the 19th century," he quipped.
Gotta say, that's pretty funny.

Re: Interesting lesson on ARCHIVELOG mode

2003-04-03 Thread Richard Foote

Hi James,

Hopefully the other lesson you've learnt is the importance of 
training, even for Junior DBAs so that such fundamentally basic but 
potentially costly mistakes can be avoided.

Cheers

Richard

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:58 PM


 Some of you on the list might find this interesting.
 
 I just wanted to relate a story with respect to an incident 
experienced in
 the last few days on one of our test databases.  Environment is 
Compaq Tru64
 Unix / Oracle 8.1.7.4.
 
 A few days ago, I remember talking to a junior DBA who assists me in 
the
 Oracle area, concerning excessive space usage on one of the Unix 
machines
 running a test database environment.  I noted that the database was 
running
 in ARCHIVELOG mode with automatic archiving (of course), and 
generating a
 great many archived logs since there was considerable activity on 
that
 instance/database.  We discussed the matter and agreed that there 
was no
 need to have ARCHIVELOG mode turned on in this case.  So I told my 
assistant
 DBA to go ahead and make the database NOARCHIVELOG, which I thought 
she
 understood.
 
 Yesterday, she comes to me with a host of problems she has been 
experiencing
 on that test database, one of which was many failed attempts to 
import a 2
 Million row table from another database's export.  It seemed that 
the import
 would just hang after importing about 130,000 rows.  She repeatedly
 cancelled the import, resorted to cycling the database, creating a 
another
 table with just a subset of the columns of the original, limiting 
the number
 of rows imported at one time, fooling with the buffer parameters 
of the
 import control file, trying SQL*LOADER, and so on.  Quite 
frustrated, she
 came to me for advice.
 
 I had forgotten about the ARCHIVELOG mode issue a few days earlier, 
so I
 began scratching my head as I looked unsuccessfully for signs of 
trouble in
 alert logs and traces.  I thought maybe a rollback segment had run 
out of
 room, lost its brains, or maybe temp space had become a problem.  
But again,
 no sign of any of these issues in alerts or traces.  Suspecting 
database
 corruption, I took a full export to see if export would report any 
corrupted
 blocks.  That worked flawlessly.  I began to wonder if we should 
just start
 from scratch and recreate the database.  Then something interesting 
became
 apparant.
 
 Looking at V$DATABASE, I noticed that the database was still in 
ARCHIVELOG
 mode!  When I asked about this, it seems that she thought that simply
 commenting out the init.ora parameters:
  log_archive_start=true
  log_archive_dest=whatever
  log_archive_format=whatever
 and then recycling the database would take care of the whole issue of
 ARCHIVELOG mode, making the database become NOARCHIVELOG mode.  
Well, guess
 what.it didn't.
 
 The lesson learned was that with the database still in ARCHIVELOG 
mode and
 automatic archiving turned off, obviously enough DML would cause the
 database to hang whenever it did a log switch, awaiting us DBAs to 
manually
 archive the filled redo logs.  Realizing this, of course we then did 
the
 prudent thing:
  alter database noarchivelog
 and lived happily ever after.
 
 Had I continued to assume database corruption and just had her 
recreate the
 database, it WOULD have indeed solved the problem BUT ONLY because 
the
 database would have come up in NOARCHIVELOG mode.  However, it 
certainly
 would have bothered me as to why the database had become corrupted 
in the
 first place.
 
 I am very happy to know what actually happened, that the database 
wasn't
 corrupted at all.  It was just someone's misunderstanding in not 
realizing
 that ARCHIVELOG mode and automatic archiving are two related but 
totally
 different things!
 
 Jim Damiano
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: James Damiano
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Richard Foote
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of

Can contracting rates beat minmum wage soon? (OT)

2003-04-03 Thread Johan Muller

At least at Joe's down the road I used to make tips? Dice proudly rewarded
me with this posting last night

Title:  SAP Database Administrator
Skills:  SAP, UNIX, Solaris, Oracle

Date:  4-2-2003
Location:  Dallas, TX
Area code:  214

Tax term:  CON_W2
Pay rate:  $22.23/HOURLY - $22.23/HOURLY
Length:  3 months

Position ID:  pr75243_rdh14923
Dice ID:  cxmnpwr

Job description:
This position is located in Dallas,Texas. Requirements: Time
management, task prioritation, able to work well in a team
environment with min. direction, project management,
self-starter, excellent written and verbal and interpersonal
skills and cross- train fellow team members. Must be a US
citizen. Min 3 yrs. exp. in SAP Basis(having been involved in
at least one full-cycle SAP Upgrade
implementation)UNIX(preferSolaris)/Oracle platform Min. 2
years SAP Security/Authorizations. Strong SAP Installation and
support (including UNIX, Oracle and Basis skills to perform).
WAS,BW,CRM,EBP,ITS,ESS installation exp. a plus. Multiple SAP
upgrade exp. Strong Transport Management Systems skills. SAP
Security/Authorizations and all aspects of Basis. MISC bolt-on
products(Vertex,iXOS, and JefForm)a plus. Exp. with EMC and
EDM a plus. Only qualified applicants please.

Job Title: SAP Database Administrator
Primary Skills: SAP; UNIX; Solaris; Oracle
Job Industry: Advertising/Marketing
Vacancies:
1
Job City: Dallas
Job Metro Area: Dallas
Job State: TX
Job Country: US
Salary: $22.23/HOURLY to $22.23/HOURLY
Hours per Week: 40
Start Date: asap
Job Duration: 0 - 3 months
Detailed Job Duration: 3 months
Degree Type: BS
Degree Area: IT
Experience Minimum: 3 Years
Certificates/Licences: none

Candidates responding to this posting must currently possess
the eligibility to work in the United States.

Examine Your Career Options! With over 250 worldwide offices,
Manpower Professional gives you an excellent opportunity to
choose your career path and customize your work experience.
To help you meet your career goals, we offer a wide range of
free IT and business training online through our Global
Learning Center. We provide other exceptional benefits to our
employees including medical and life insurance, holiday and
vacation pay, 401K, and a stock purchase plan (in most
locations). Servicing over 95% of the Fortune 500 companies
enables us to offer you a full range of placement options
including contract, direct and contract-to-hire.

Requirements:  SAP, UNIX, Solaris, Oracle
Travel required:  none
Telecommute:  no


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

2003-04-03 Thread Richard Foote

Hi Arvind,

A little test for you.

You have a table that contains 10,000,000 rows that is packed tightly 
into 1,000,000 data blocks.

You have an index that has a level of 4 and has 10,000 leaf blocks.

The table is well striped across a number of devices and you have 4 
CPUs on the box.

You write a simple select statement that queries the table based on 
the indexed column and *just 10%* of the data needs to be retrieved.

You determine that the CBO has performed a full table scan.

Do you break out into a nervous sweat or do you sigh thank goodness 
and worry about something else instead ?

Cheers

Richard (let me know if you want to know the comparative costs ;)

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 2:58 PM


 Dear All,
 
   is there any way to find which tables (table name) are 
suffering from
 full table scan ,so that  i can create indexes on them to enhance the
 performance.
 
 
 Thanks
 
 Arvind 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Arvind Kumar
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Richard Foote
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

2003-04-03 Thread Jamadagni, Rajendra

Title: RE: oracle full table scan





To answer the original question ...


1. use following query to see which tables are part of FTS ... it is a point in time information. (Query from www.ixora.com I think).

SELECT usr.name oowner, ob.name oname
 FROM ( SELECT obj
 FROM sys.X_$BH
 WHERE TO_NUMBER(bitand(flag, POWER(2,19)))  0
 GROUP BY obj) bh,
 sys.obj$ ob,
 sys.USER$ usr
WHERE ob.dataobj# = bh.obj
 AND ob.owner# = usr.USER#
ORDER BY usr.name, ob.name
/


2. FTS can happen for many reasons ... if Oracle is performing FTS on a small table, that's the way to do it. Remember when you create an index Oracle had to perform 2 IOs, one for INDEX lookup and (if required) one for Table lookup. Sometimes associated costs dictate that a FTS is cheaper than the combined cost (of index lookup and table lookup), so Oracle prefers that.

One upon a time, I used to think on the same lines, but the bright minds on this list have time and again proven that FTS, isn't a bad thing after all. Sometimes it is, but not ALL the times.

Creating indexes is not the solution, a careful analysis of the logic implemented in the SQL is also required, and you will be surprised that, just by making the query changes, the performance gain can be achieved.

PS: Stephane, you probably have this on the top of your Oracle Myth list ... right?
YMMV
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 2:58 PM



 Dear All,
 
 is there any way to find which tables (table name) are 
suffering from
 full table scan ,so that i can create indexes on them to enhance the
 performance.
 
 
 Thanks
 
 Arvind 
 -- 



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Anyone whom could explain this?

2003-04-03 Thread Ganesh Raja

New maybe a Package and the Variables may be Public variables.

HTH

Best Regards,
Ganesh R
DID : +65-6215-8413
HP  : +65-9067-8474 

-Original Message-
John, Tech Dev
Sent: Thursday, April 03, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L


Is this procedure being run with a trigger Roland?

If so then the :new refers to the value of each row that is being
inserted from the table 

To explain better

if an update triggger is on table roland with columns
(road,town,country) and one row is in the table with values  Main Rd,
Leeds, England and the row is being updated to be New_Main Rd, Leeds,
England then the following values will be in place
old:road  = Main Rd   new:road  = New_Main Rd
old:town = Leeds new:town=Leeds
old:country = England new:country=England.

That is about 100% of my PL/SQL knowledge so I hope I am correct

John

-Original Message-
Sent: 03 April 2003 11:09
To: Multiple recipients of list ORACLE-L


Hallo,

anone whom could explain what new. means
in this pl/sql procedure.

for instance: new.kundeoms := new.kundeoms + (in_diff);
  new.mva := new.mva + (in_diff_mva);

How do I get hold of it so i can see which sql it runsor is new.kundeoms
just a value from a table?





PROCEDURE add_kundeoms(in_diff in number, in_diff_mva in number,
   in_diff_brtkr in number, in_flagg
in varchar2) IS
lDetaljFunnet boolean;
  BEGIN

IF  in_flagg = '0' THEN
  new.kundeoms := new.kundeoms + (in_diff);
  new.mva := new.mva + (in_diff_mva);
  new.kostverdi := new.kostverdi + (in_diff -
in_diff_mva - in_diff_brtkr);
ELSIF in_flagg = '1' THEN
  new.utg_pant := new.utg_pant + (in_diff);
ELSIF in_flagg = '9' THEN
  new.shop_in_shop := new.shop_in_shop + (in_diff);
ELSIF   in_flagg = '5' THEN
  new.rest_oms := new.rest_oms + (in_diff);
END IF;

BEGIN
  db_dagoms_detalj.find(new.dagoms_id, in_flagg);
  lDetaljFunnet := TRUE;
EXCEPTION
  WHEN OTHERS THEN
lDetaljFunnet := FALSE;
END;
IF lDetaljFunnet THEN
  db_dagoms_detalj.edit;
  db_dagoms_detalj.add_kundeoms(in_diff, in_diff_mva,
in_diff_brtkr);
  db_dagoms_detalj.modify;
  db_dagoms_detalj.close;
END IF;
  END;
END;


Thanks in advance






Roland


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Hallas, John, Tech Dev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Ganesh Raja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Stefan Jahnke

Hi

I would suggest to increase the redo log size. Doesn't effect you during
daily operation, but prevents the database from hanging during nightly
batches. No side effects I can think of (except for the fact that, of
course, it will take you longer to backup the archived logs since the files
are bigger, duh ;).

Good luck
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. April 2003 10:04
An: Multiple recipients of list ORACLE-L
Betreff: Cannot allocate new log - checkpoint not complete



I think I am having problems with my redologs. Under normal
circumstances no errors arise, but if I do a massive import of data as I was
doing last night, this is what alertSID.log shows from time to time:

Wed Apr  2 23:29:52 2003
Thread 1 advanced to log sequence 557295
  Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log
Wed Apr  2 23:31:11 2003
Thread 1 cannot allocate new log, sequence 557296
Checkpoint not complete
  Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log
Wed Apr  2 23:31:50 2003

In that exact time, everything freezes and the database is dead
until a new redolog can be used.

I have 3 redologs 50 Mb each. I've read that the error is because
too much data is trying to get into the redologs and all of them are full,
Oracle does not have the time to reuse a redolog and has to wait until the
redolog is ready to be reused. 

So the solution seems to make these redolog files bigger or to
create new ones. What are the side effects of one or the other? will
performance under normal work be penalised?

..
Fermín Bernaus Berraondo
Dpto. de Informática
SAMMIC, S.A.
[EMAIL PROTECTED]
http://www.sammic.com
Telf. +34 - 943 157 331
Fax +34 - 943 151 276
..

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: daily clone

Jared,

Thanks for the reply. I will try next time. I just feel like  combine
the reuse and set together, seems not that logical.

Thanks,
Joan

[EMAIL PROTECTED] wrote:
 
 From TFM:
 
 Specify REUSE to indicate that existing control files identified by the 
 initialization
 parameter CONTROL_FILES can be reused, thus ignoring and overwriting any information 
 they may
 currently contain. If you omit this clause and any of these control files
 already exists, Oracle returns an error.
 
 So it would seem a valid syntax.
 
 Jared
 
 Joan Hsieh [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  04/02/2003 12:48 PM
  Please respond to ORACLE-L
 
 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:
 Subject:Re: daily clone
 
 Bill,
 
 Kind of curiosity, I don't know this syntax; I do create controlfile
 set database or create controlfile resue database. But never did
 reuse set. Is that a valid syntax? I don't have time to check it by
 myself. sorry to ask.
 
 Joan
 
 CREATE CONTROLFILE REUSE SET DATABASE SIDB RESETLOGS  NOARCHIVELOG
 
 Niall Litchfield wrote:
 
  Obviously the usual caveats of 'test this first' and ' don't just listen
  to some bloke off of email' apply but here would be my contributions.
 
  1. Don't copy temp - create a new one - it by definition has nothing in
  it.
  2. Don't copy online redo logs - resetlogs means that a) the old ones
  are useless and the SCN will be reset b) new ones will get created if
  necessary.
  3. I'm not quite clear what is going on with these read/write-read-only
  nfs files, are these genuinely copied across to a new location, or are
  they the actual datafiles mounted read-only in an nfs environment, or
  are they some sort of weird vendor-provided copy of the datafiles? This
  is probably all my stupidity in not reading you clearly enough.
 
  Niall
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
   [EMAIL PROTECTED]
   Sent: 26 March 2003 19:59
   To: Multiple recipients of list ORACLE-L
   Subject: daily clone
  
  
  
   Hello,
  
   Env: Oracle 9.2.0.2.0 on Solaris 9 (2 machines)
  
   I'm trying to set up a daily cloning process between 2 Oracle
   instances (SIDA is source, SIDB is target) using the CREATE
   CONTROLFILE  REUSE SET DATABASE SIDB ... method. The steps are:
  
   1) Shutdown immediate SIDB
   2) Shutdown immediate SIDA, startup restrict, shutdown normal
   3) Copy system datafile to target machine (I'm going to reset logs,
  dbs are shutdown, shouldn't require any recovery)
   4) Create read-only copy of all user datafiles using a vendor feature
  called checkpoints (not Oracle checkpoints)
   5) Startup SIDA
   6) Run the following script on SIDB (adapted from SIDA backup
   controlfile to trace)
  
   STARTUP NOMOUNT PFILE='/oracle_home_path/dbs/initDWQ.ora'
   CREATE CONTROLFILE REUSE SET DATABASE SIDB RESETLOGS  NOARCHIVELOG
   MAXLOGFILES 5
   MAXLOGMEMBERS 3
   MAXDATAFILES 512
   MAXINSTANCES 1
   MAXLOGHISTORY 1817
   LOGFILE
 GROUP 1 '/redo1/dws/redo01.log'  SIZE 100M,
 GROUP 2 '/redo1/dws/redo02.log'  SIZE 100M,
 GROUP 3 '/redo1/dws/redo03.log'  SIZE 100M
   DATAFILE
 '/dwdata1/dwq/sys/system01.dbf',
 '/rbs/dws/undotbs01.dbf',
 '/data1/dws/users.dbf',
 '/data1/dws/tools.dbf',
 '/dwdata1.chkpnt/ckpt1/dws/data/lvl1_data/LVL1_DATA01.dbf',
 '/dwdata2.chkpnt/ckpt1/dws/index/lvl1_ndex/LVL1_NDEX01.dbf',
 '/dwdata1.chkpnt/ckpt1/dws/data/lvl2_data/LVL2_DATA01.dbf',
 '/dwdata2.chkpnt/ckpt1/dws/index/lvl2_ndex/LVL2_NDEX01.dbf',
  ...
   CHARACTER SET WE8ISO8859P1
   ;
  
   ALTER DATABASE OPEN RESETLOGS;
   ALTER TABLESPACE TEMP ADD TEMPFILE '/oratmp1/dwq/temp01.dbf'
SIZE 2049M REUSE AUTOEXTEND OFF;
  
   There are a couple of twists. The datafiles listed with
   .chkpnt in their path are in a read-only nfs-mounted
   filesystem; when shutdown before copying, their status within
   Oracle was READ WRITE.
  
   The databases were both shutdown when the copies were made,
   SIDB is using RESETLOGS, so I'm thinking this will work OK
   and Oracle will not try and write anything to these when
   opening SIDB.
  
   Does this sound OK?
  
   The next question is, do I need to copy any redo logs, undo
   tblspc (using auto undo), or temp datafiles from SIDA to
   SIDB? Again, since I'm shutting
   down cleanly, and doing a resetlogs on opening, I am hoping
   that I can simply reuse the existing redo logs, undo tblspc
   and tempfile.
  
   The next twist is that we want to preserve some read write
   tablespaces in SIDB, like users.dbf and tools.dbf listed
   above, and not wipe them out when re-creating the controlfile
   each day. Again, since we shut down SIDB cleanly, and I list
   the existing datafiles under the datafile section of the
   CREATE CONTROLFILE command, I am hoping this will preserve
   their contents. Am I wrong?
  
   We will be testing these

Re: dbshut script - shutdown or shutdown immediate

Chris,

We hang on shutdown immediate, not startup. That's why I choose to use
shutdown abort.

Joan

Chris Berry wrote:
 
Schauss, Peter wrote:
 I have one Oracle instance which supports an application
 server which always maintains a database connection.
 The UNIX system administrator tells me that this instance always
 hangs when she tries to shut down the system.  The other instances,
 which do not support a 24x7 process shut down properly.

 Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to
 sqlplus
 is
 connect internal
 shutdown

 Should I modify the script to shutdown immediate so that it kills
 any connections?

 Environment is Oracle 8.1.7 /AIX 4.3.3.
   From: Joan Hsieh [EMAIL PROTECTED]
   Peter,
   I modified to shutdown abort, starup then shutdown immediate.
  
   Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
   work?
 
 From: Joan Hsieh [EMAIL PROTECTED]
 At first, we do shutdown immediate, then startup. But we do have couple
 times hang there and couldn't do the cold backup. Since changed to
 shutdown abort, startup and shutdown immediate, we don't have any
 problem at all. our database is in archive mode. Since our production
 database has to refresh to reporting database nightly. I couldn't do
 checkpoint before shutdown abort. (some error, forgot on reporting
 database) otherwise, I will add to it.
 
 If it's hanging on the startup I recommend trying this:
 
 shutdown immediate
 startup nomount
 alter database mount
 alter database open
 
 You should get an error message at one of those steps that will lead you to
 the real problem.
 
 Chris Berry
 [EMAIL PROTECTED]
 Systems Administrator
 JM Associates
 
 Without change, something sleeps inside us, and seldom awakens.  The
 sleeper must awaken. -- Duke Leto Atreides
 
 _
 Add photos to your messages with MSN 8. Get 2 months FREE*.
 http://join.msn.com/?page=features/featuredemail
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Chris Berry
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

Hi Arvind,

I don't judge full table scan is good or not necessary bad.
this is the script might answer your question. 

-joan

The following scripts provide information on the full table scan
activity.
If your application is OLTP only, having long full table scans can be an
indicator of having missing or incorrect indexes or untuned SQL.

#

drop table Full_Table_Scans
/
create table Full_Table_Scans as
 select ss.username||'('||se.sid||') ' User Process,
 sum(decode(name,'table scans (short tables)',value)) Short Scans,
 sum(decode(name,'table scans (long tables)', value)) Long Scans,
 sum(decode(name,'table scan rows gotten',value)) Rows Retreived
   from v$session ss, v$sesstat se,  v$statname  sn
  where  se.statistic# = sn.statistic#
 and (name  like '%table scans (short tables)%'
 OR name  like '%table scans (long tables)%'
 OR name  like '%table scan rows gotten%' )
 and  se.sid = ss.sid
 and   ss.username is not null
group by ss.username||'('||se.sid||') ';

column  User Process format a20;
column  Long Scans   format 999,999,999;
column  Short Scans  format 999,999,999;
column  Rows Retreived   format 999,999,999;
column  Average Long Scan Length format 999,999,999;

ttitle ' Table Access Activity By User '

select User Process, Long Scans, Short Scans, Rows Retreived
  from Full_Table_Scans
 order by Long Scans desc;


Richard Foote wrote:
 
 Hi Arvind,
 
 A little test for you.
 
 You have a table that contains 10,000,000 rows that is packed tightly
 into 1,000,000 data blocks.
 
 You have an index that has a level of 4 and has 10,000 leaf blocks.
 
 The table is well striped across a number of devices and you have 4
 CPUs on the box.
 
 You write a simple select statement that queries the table based on
 the indexed column and *just 10%* of the data needs to be retrieved.
 
 You determine that the CBO has performed a full table scan.
 
 Do you break out into a nervous sweat or do you sigh thank goodness
 and worry about something else instead ?
 
 Cheers
 
 Richard (let me know if you want to know the comparative costs ;)
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, April 03, 2003 2:58 PM
 
  Dear All,
 
is there any way to find which tables (table name) are
 suffering from
  full table scan ,so that  i can create indexes on them to enhance the
  performance.
 
 
  Thanks
 
  Arvind
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Arvind Kumar
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  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.net
 --
 Author: Richard Foote
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

2003-04-03 Thread Alex Andriyashchenko

Hello Arvind,

Thursday, April 3, 2003, 5:58:38 AM, you wrote:

AK Dear All,

AK   is there any way to find which tables (table name) are suffering from
AK full table scan ,so that  i can create indexes on them to enhance the
AK performance.


AK Thanks

AK Arvind 
AK -- 
AK Please see the official ORACLE-L FAQ: http://www.orafaq.net

Use SQL_TRACE feature to find all statements which used FTS.

-- 
Best regards,
 Alexmailto:[EMAIL PROTECTED]

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Pardee, Roy E

I am certainly not suggesting that recovery can't handle a crash--I'm just
trying to make sure that I understand what shutdown abort does.  Some posts
have implied that it's no big deal, which is counter-intuitive to me.  To
me, crashing a program on purpose seems like a drastic measure.  No doubt
desperate times can call for desperate measures, but I would have guessed
that optimally, you'd try immediate first  then abort if immediate takes
too long.  But I'm just learning this stuff...

Cheers,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, April 02, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L


yeah so? are you suggesting that Oracle instance recovery can't handle
a database crash? If so, better pray your server never crashes.


--- Pardee, Roy E [EMAIL PROTECTED] wrote:
 Well... my official oracle instructor in dba larva school said that
 it's
 tantamount to crashing the db--or so I recall anyway.  This isn't so?
 
 Peace,
 
 -Roy
 
 Roy Pardee
 Programmer/Analyst
 SWFPAC Lockheed Martin IT
 Extension 8487
 
 -Original Message-
 Sent: Wednesday, April 02, 2003 2:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 On Wed, 2 Apr 2003, Chris Berry wrote:
 
  Shutdown abort is pretty drastic, are you sure shutdown immediate
  didn't work?
 
 What is drastic about shutdown abort?
 
 Never one to opt out of a shutdown abort thread,
 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton
 
 - Uses shutdown abort exclusively
 - successful shutdowns/startups: over 10,000
 - problems with shutdown abort: 0
 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
 - still employed!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Cannot allocate new log - checkpoint not complete

Fermin - Connor's reply sparked an idea. By any chance do you have your redo
logs on the same device as your data files? 

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, April 03, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L


Basically as the message suggests the redo cannot be
recycled until the checkpoint has completed flushing
out the cache.  

A *workaround* is to add redo log (size or number) but
its really a heads-up about your I/O subsystem not
being up to keep up under stress.

hth
connor

 --- Fermin Bernaus Berraondo [EMAIL PROTECTED]
wrote:  
   I think I am having problems with my redologs.
 Under normal circumstances no errors arise, but if I
 do a massive import of data as I was doing last
 night, this is what alertSID.log shows from time to
 time:
 
 Wed Apr  2 23:29:52 2003
 Thread 1 advanced to log sequence 557295
   Current log# 3 seq# 557295 mem# 0:
 /baandata/oradata/baan/redobaan03.log
 Wed Apr  2 23:31:11 2003
 Thread 1 cannot allocate new log, sequence 557296
 Checkpoint not complete
   Current log# 3 seq# 557295 mem# 0:
 /baandata/oradata/baan/redobaan03.log
 Wed Apr  2 23:31:50 2003
 
   In that exact time, everything freezes and the
 database is dead until a new redolog can be used.
 
   I have 3 redologs 50 Mb each. I've read that the
 error is because too much data is trying to get into
 the redologs and all of them are full, Oracle does
 not have the time to reuse a redolog and has to wait
 until the redolog is ready to be reused. 
 
   So the solution seems to make these redolog files
 bigger or to create new ones. What are the side
 effects of one or the other? will performance under
 normal work be penalised?
 
 ..
 Fermín Bernaus Berraondo
 Dpto. de Informática
 SAMMIC, S.A.
 [EMAIL PROTECTED]
 http://www.sammic.com
 Telf. +34 - 943 157 331
 Fax +34 - 943 151 276
 ..
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Fermin Bernaus Berraondo
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 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
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]

GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day

__
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Remote DBA

2003-04-03 Thread Jesse, Rich

Nelson, have you tried the free TightVNC from http://www.tightvnc.com ?  It
has a few performance features that seem to work slightly better than the
standard VNC, especially over slower links like VPN over a 768Kb DSL.
I've been about as happy as I can be with TightVNC for my setup.


Rich

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


-Original Message-
Sent: Wednesday, April 02, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


Chris,
VNC and OpenSSH are slow and VNC is still a little unstable (IMHO), I
personally manage my windows 2000 Oracle DB with a VPN and then a Terminal
server window direct to my desktop - from there I have all the tools that I
usually have - notepad, mspaint, dir :). 
I hate to have to plug windows products, but if it were linux or unix, then
it would be a different story, seeing as though it matters little where you
are physically on a Linux/Unix box (SSH Telnet, or an XWindow Session with
the display set to your own IP)...

Anyone knows what Big Larry uses to connect to his Database? :)  

Nelson Flores 
Project Manager
Intec



-Mensaje original-
De: Chris Berry [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 02 de Abril de 2003 19:09
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Remote DBA

I do both platforms, my recommendation is OpenSSH + VNC, they work great, 
they're free, and they're available for both platforms.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Fermin Bernaus Berraondo


I dissagree, they will be bigger but there will be less of them. If the amount 
of processed data does not change, I do not think changing the size of the redolog 
files should affect the total amount fo bytes to be backeup up

Thanks for the recommendation anyway ;)

Cheers,

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Stefan Jahnke
Enviado el: jueves, 03 de abril de 2003 15:44
Para: Multiple recipients of list ORACLE-L
Asunto: AW: Cannot allocate new log - checkpoint not complete


Hi

I would suggest to increase the redo log size. Doesn't effect you during
daily operation, but prevents the database from hanging during nightly
batches. No side effects I can think of (except for the fact that, of
course, it will take you longer to backup the archived logs since the files
are bigger, duh ;).

Good luck
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. April 2003 10:04
An: Multiple recipients of list ORACLE-L
Betreff: Cannot allocate new log - checkpoint not complete



I think I am having problems with my redologs. Under normal
circumstances no errors arise, but if I do a massive import of data as I was
doing last night, this is what alertSID.log shows from time to time:

Wed Apr  2 23:29:52 2003
Thread 1 advanced to log sequence 557295
  Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log
Wed Apr  2 23:31:11 2003
Thread 1 cannot allocate new log, sequence 557296
Checkpoint not complete
  Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log
Wed Apr  2 23:31:50 2003

In that exact time, everything freezes and the database is dead
until a new redolog can be used.

I have 3 redologs 50 Mb each. I've read that the error is because
too much data is trying to get into the redologs and all of them are full,
Oracle does not have the time to reuse a redolog and has to wait until the
redolog is ready to be reused. 

So the solution seems to make these redolog files bigger or to
create new ones. What are the side effects of one or the other? will
performance under normal work be penalised?

..
Fermín Bernaus Berraondo
Dpto. de Informática
SAMMIC, S.A.
[EMAIL PROTECTED]
http://www.sammic.com
Telf. +34 - 943 157 331
Fax +34 - 943 151 276
..

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Fermin Bernaus Berraondo
  INET: [EMAIL PROTECTED]

Fat City Network

Purpose of OraclePeerSNMPMasterAgent ?

2003-04-03 Thread Prem Khanna J

Guys,

What is the purpose of OraclePeerSNMPMasterAgent Service ?
It is listed in the o/s SERVICES list.

I need to administer an oracle instance on server A from
server B with DBA Studio.

For this to be done , do i need OraclePeerSNMPMasterAgent running
on server A.

will stopping this service , affect normal functioning of my instance ?
when one need to run this service ?

The setup is oracle 8.1.6/Win2k server.

Kindly let me know guys.

Thanks.
Prem Khanna J.  




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

the problem is, if immediate hangs and you have automated the
process... nothing happens. it doesn't time out so you sit. and sit and
sit. and hope that whatever is keeping the database active will
eventually end.

In version 7 (7.3.2) I found that while using a third party monitoring
package that had a job in the job queue that ran frequently enough (and
you WANT monitoring software to monitor things!) that we could never
use a shutdown immediate


--- Pardee, Roy E [EMAIL PROTECTED] wrote:
 I am certainly not suggesting that recovery can't handle a crash--I'm
 just
 trying to make sure that I understand what shutdown abort does.  Some
 posts
 have implied that it's no big deal, which is counter-intuitive to me.
  To
 me, crashing a program on purpose seems like a drastic measure.  No
 doubt
 desperate times can call for desperate measures, but I would have
 guessed
 that optimally, you'd try immediate first  then abort if immediate
 takes
 too long.  But I'm just learning this stuff...
 
 Cheers,
 
 -Roy
 
 Roy Pardee
 Programmer/Analyst
 SWFPAC Lockheed Martin IT
 Extension 8487
 
 -Original Message-
 Sent: Wednesday, April 02, 2003 6:34 PM
 To: Multiple recipients of list ORACLE-L
 
 
 yeah so? are you suggesting that Oracle instance recovery can't
 handle
 a database crash? If so, better pray your server never crashes.
 
 
 --- Pardee, Roy E [EMAIL PROTECTED] wrote:
  Well... my official oracle instructor in dba larva school said that
  it's
  tantamount to crashing the db--or so I recall anyway.  This isn't
 so?
  
  Peace,
  
  -Roy
  
  Roy Pardee
  Programmer/Analyst
  SWFPAC Lockheed Martin IT
  Extension 8487
  
  -Original Message-
  Sent: Wednesday, April 02, 2003 2:09 PM
  To: Multiple recipients of list ORACLE-L
  
  
  On Wed, 2 Apr 2003, Chris Berry wrote:
  
   Shutdown abort is pretty drastic, are you sure shutdown immediate
   didn't work?
  
  What is drastic about shutdown abort?
  
  Never one to opt out of a shutdown abort thread,
  --
  Jeremiah Wilton
  http://www.speakeasy.net/~jwilton
  
  - Uses shutdown abort exclusively
  - successful shutdowns/startups: over 10,000
  - problems with shutdown abort: 0
  - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
  - still employed!
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Pardee, Roy E
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

Tables are not suffering, they're rather cruel and coldhearted.
As in the Tom Godwin's story, The Cold Equations, it's always
the users who pay the price. You might try with tuning the SQL 
statements that access tables. Occasionally, that does the trick.

-Original Message-
Sent: Wednesday, April 02, 2003 11:59 PM
To: Multiple recipients of list ORACLE-L


Dear All,

  is there any way to find which tables (table name) are suffering from
full table scan ,so that  i can create indexes on them to enhance the
performance.


Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

Arvind - If you want to locate tables that are being scanned and the SQL
statement, I have found the following script posted by Mohammed to work
quite effectively.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


REM From: Mohammed Shakir [mailto:[EMAIL PROTECTED]
REM Sent: Thursday, October 10, 2002 5:14 PM
REM To: Multiple recipients of list ORACLE-L
REM Subject: RE: Table Scans
REM Try the following script. I am not sure where I found it on the web.
REM However, this script I use to find the bottlenecks in the system.
REM Run it while your application is running.
REM Look for wait event 'db_file_scattered_read'.
REM Check the related SQL.
REM You can remove other wait events if you do not need them.
set echo off feedback off timing off pause off
set pages 100 lines 500 trimspool on trimout on space 1 recsep each

col sid format 990
col program format a15 word_wrap
col event format a8 word_wrap
col ospid format 990 heading Srvr|PID
col name format a15 word_wrap heading OBJECT NAME
col sql_text format a30 word_wrap
select /*+ rule */
w.sid,
w.event,
s.program,
p.spid ospid,
e.owner || '.' || e.segment_name || ' (' || e.segment_type || ')'
name,
a.sql_text
fromsys.v_$sqlarea  a,
sys.dba_extents e,
sys.v_$process  p,
sys.v_$session  s,
sys.v_$session_wait w
where   w.event in ('write complete waits',
'latch free',
'log buffer space',
'free buffer waits',
'buffer busy waits',
'db file scattered read',
'db file sequential read',
'library cache pin',
'log file switch completion',
'enqueue',
'log file parallel write',
'db file parallel write',
'log file sync',
'file open',
'direct path write',
'library cache lock')
and s.sid = w.sid
and p.addr = s.paddr
and e.file_id = to_number(w.p1)
and to_number(w.p2) between e.block_id and (e.block_id + (e.blocks -
1))
and a.address (+) = s.sql_address;  

-Original Message-
Sent: Wednesday, April 02, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L


Dear All,

  is there any way to find which tables (table name) are suffering from
full table scan ,so that  i can create indexes on them to enhance the
performance.


Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

few questions on 9i

2003-04-03 Thread Shibu MB






Hi 
all
Can any body 
help in answering these questions 
1. What features of Oracle 
9i do you recommend to use? Why?
2. What are the features 
of Oracle 9i you do not recommend? Why?
3. Have you had any 
problems with any of the Oracle 9i features? Please elaborate. If any, how did 
you solve or get around those problems?


Thanks
shibuDISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return  e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited.  Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.

RE: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Nelson, Allan

Oh, I wan't advocating a kill -9, just comparing it to a shutdown abort.
AFAICT (as far as I can tell) there isn't a great deal of difference.  I
did, once on Oracle 7.3, have to shutdown the db with a shutdown abort
and then just could never get it to open again.  Could not recover it
and eventually had to go to backups to get it back.  I was very
fortunate that it was a dev instance.

Allan

-Original Message-
Sent: Wednesday, April 02, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L


I think I would still prefer a shutdown abort over a kill -9. There
might 
be even a slight level of control and error management in a shutdown
abort 
but not in a kill -9 nothing and I repeat nothing can avoid a kill -9
and 
there is no cleanup by the process that is killed. 

Cheers


--
=
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

=

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. 






Nelson, Allan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/2003 09:14 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: 
Subject:RE: dbshut script - shutdown or shutdown
immediate


Suppose you have a database with a sid of mydb running on unix. Shutdown
abort is like doing the following from the unix command line: ps -ef |
grep mydb | grep -v grep | xargs kill -9.  All the processes that make
up the instance or processes that are connected to that instance are
killed.  The database will require instance recovery on the next start.

Allan

-Original Message-
Sent: Wednesday, April 02, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L


Well... my official oracle instructor in dba larva school said that it's
tantamount to crashing the db--or so I recall anyway.  This isn't so?

Peace,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, April 02, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L


On Wed, 2 Apr 2003, Chris Berry wrote:

 Shutdown abort is pretty drastic, are you sure shutdown immediate
 didn't work?

What is drastic about shutdown abort?

Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).




__
This email is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. 
Copying, forwarding or distributing this message by persons or entities 
other than the addressee is prohibited. If you have received this email
in

RE: 9i startup on Linux

Title: 9i startup on Linux

Well,
there is this little file called "/etc/oratab" and the dbca leaves a value of
"N" in the last field.
The
allowed values are "N" for No, "Y" for Yes and M for Maybe. The last field
is there to determine
whether dbstart should start the oracle instance or
not. The value of "M" is applicable only to
Win2k
versions. If there is "N" in the /etc/oratab, dbstart will not start that
database.

-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]Sent: Thursday, April 03,
2003 3:39 AMTo: Multiple recipients of list
ORACLE-LSubject: 9i startup on Linux
Hi!
I am having problems getting 9.2.0.3 started on Red Hat Linux
8. I've done the standard linking in rc3.d and the like.
But when I reboot the machine, Oracle is not automatically
started when using an SPFILE. If I dump the spfile to a text init.ora, the
output is a follows:
[EMAIL PROTECTED] root]# /bin/su - $ORA_OWNER -c
$ORA_HOME/bin/dbstart
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Apr 3 08:25:26
2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
SQL ERROR: ORA-12162: TNS:service
name is incorrectly specified
SQL ORA-12162: TNS:service name is incorrectly
specified SQL Database ""
warm started.
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Apr 3 08:25:27
2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
SQL Connected to an idle instance. SQL ORACLE instance started.
Total System Global Area 105976704 bytes
Fixed
Size
451456 bytes Variable
Size
83886080 bytes Database
Buffers 20971520
bytes Redo
Buffers
667648 bytes Database mounted. Database opened. SQL Disconnected from
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
Database "OLLIE" warm started.
Is there anything special about dbstart/dbshut in regard to
9i?
Thanks, Helmut

Re: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Denny Koovakattu



  Using immediate or abort is a matter of personal preference. Use whichever 
option that works for you. But I would not agree that using shutdown abort is 
risky or should be avoided. (I don't know of any bugs with shutdown abort. 
There could be, but then a lot of other things also could go wrong. The bug 
with the UNDO tablespace with 9.0.1 for instance. Can we be sure something 
similar will not happen again ? So do we stop using that feature altogether ?) 
My personal preference is to use shutdown abort and I have been using it ever 
since I can remember. Never had any problems. If I want the database in a 
consistent state for whatever reason, then I would rather start it up again and 
shut it down. Most of the times the databases are not shutdown manually. The 
shutdown scripts get called when the box is going down and immediate or normal 
would not be the right choice in this scenario. Of course it would not be a lot 
different if we don't shutdown the databases when the box is going down ;) But 
if I have the startup script in place as well have the shutdown script too.

  I am not suggesting one option should be used instead of the other. Its a 
question of personal preference. The point I am trying to make is if the 
situation demands shutdown abort, then it doesn't make sense jumping through 
hoops not to use it.

Regards,
Denny

Quoting Daniel W. Fink [EMAIL PROTECTED]:

 Shutdown Immediate v. Shutdown abort (Tastes Great...Less Filling!)
 
 I'll admit to being in the Immediate camp. Why? I like the database to
 come down in a consistent state except in emergency circumstances. There
 have been bugs related to shutdown abort causing database problems.
 Do those in the Abort camp have valid reasons? Absolutely! Recovery is
 quicker and problems are extremely rare.
 
 I have a higher level of comfort in immediate. That is why I use it. Can
 I use abort/startup restrict/normal without incurring problems? Yes,
 except in rare cases. Almost certainly more rare than the times when the
 immediate takes longer than expected.
 
 I don't think this issue is one of black and white/right and wrong, but
 rather varying shades of gray.
 
 Okay, Connor...your turn!
 
 -- 
 Daniel W. Fink
 http://www.optimaldba.com
 
 IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i
 SQL
Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: certifications was Re: Remote DBA

2003-04-03 Thread Hallas, John, Tech Dev

Say what you think Joe,
When I have been looking for contacts several agencies have asked me to take those 
tests as a means of ensuring that I know what I am supposed to know.
They act as a pre-interview filter
If it sorts the wheat  from the chaff then I don't think they perform a bad service in 
that respect.
However as far as being touted as a professional qualification as Ramesh is using them 
then I think I would forget about it.

I think anybody who contributes to this list claiming to be this, that or the other is 
setting himself up for a fall.

Dennis has got the idea by having 40% OCP in his sig (however that has been there so 
long now that the exams probably need re-taking now )

John  


-Original Message-
Sent: 03 April 2003 12:24
To: Multiple recipients of list ORACLE-L


Ramesh, since in your sig line you say you're brainbench and brainbuzz 
certified, do you really think those tests have any meaning, i took them 
and thought they were a joke.

joe


Ramesh Papnoi wrote:

It can be Unix as well as Windows. As I have to support various DB's

Best Regards
Ramesh D. Papnoi   http://www22.brinkster.com/rpapnoi
(Brainbench  Brainbuzz certified Oracle 8/8i DBA  Developer)

-Original Message-
Adar
Sent: Thursday, April 03, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


You did not mentioned what OS you are working on.
If the remote database is on your network, even via wan, you can activate
all the tools from your desktop.
We use RAS to connect to remote servers without network connections and then
you have SLOW network connection and your tools will work.
If the need arise you can use Netop or other PcAnywhere to take control of
the server and do your work from there.

We are on windows servers and clients.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:34 PM


  

Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate


if
  

any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

  


-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Hallas, John, Tech Dev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 OCI JDBC Driver Not Recommended for Multiprocessor Mac

2003-04-03 Thread Richard Ji

Title: Message



The 
performance of JDBC OCI vs Thin really depends on what you are trying to 
do. Thin driver can perform better
than 
OCI and in some situations doesn't. Also there are limitations in Thin 
driver such as you can't return
a 
PL/SQL table using Thin driver, you can't do TAF etc.

Richard Ji

  -Original Message-From: Jeremy Pulcifer 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 2003 
  12:14 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle OCI JDBC Driver Not Recommended for Multiprocessor 
  Mac
  I've 
  gone to using the thin driver exclusively, as (counter-intuitively, I know) it 
  performs better than the OCI driver. Plus it's easier to 
  port...
  

-Original Message-From: Rick 
Stephenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 
02, 2003 7:29 AMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle OCI JDBC Driver Not Recommended for 
Multiprocessor Machine


Sun's FAQ on java hotspot 
VM performance (http://java.sun.com/docs/hotspot/PerformanceFAQ.html)includes 
this interesting question:



My application uses a database 
and doesn't seem to scale well. What could be going on? 


Oracle provides two types of database drivers: a 
type-2 driver, called the OCI (Oracle Call Interface) driver that utilizes 
native code, and a type-4 pure Java driver called the thin driver. In single 
processor environments, the thin driver works somewhat better than the OCI 
driver because of the JNI overhead associated with the OCI driver. On 
multi-processor configuations, synchronization points within Solaris used by 
the OCI driver become big bottlenecks and prevent scaling. We recommend 
using the thin driver in all cases. 


Is this actually the case? Does 
anyone have more information on this?

Thanks,

Rick 
Stephenson
This email and any files transmitted with it are 
confidential and intended solely for the use of the individual or entity to 
which they are addressed. This message contains confidential information and 
is intended only for the individual named. If you are not the named 
addressee you should not disseminate, distribute or copy this e-mail. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. If you are not the intended 
recipient you are notified that disclosing, copying, forwarding or otherwise 
distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

RE: Anyone whom could explain this?

Things like :new.value and :old.value are commonly associated
with the beasts called triggers. You can find triggers on oracle
tables and guns. For the rest, please read the fine manual.

-Original Message-
Sent: Thursday, April 03, 2003 5:09 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anone whom could explain what new. means
in this pl/sql procedure.

for instance: new.kundeoms := new.kundeoms + (in_diff);
  new.mva := new.mva + (in_diff_mva);

How do I get hold of it so i can see which sql it runsor is new.kundeoms
just a value from a table?





PROCEDURE add_kundeoms(in_diff in number, in_diff_mva in number,
   in_diff_brtkr in number, in_flagg in
varchar2) IS
lDetaljFunnet boolean;
  BEGIN

IF  in_flagg = '0' THEN
  new.kundeoms := new.kundeoms + (in_diff);
  new.mva := new.mva + (in_diff_mva);
  new.kostverdi := new.kostverdi + (in_diff - in_diff_mva -
in_diff_brtkr);
ELSIF in_flagg = '1' THEN
  new.utg_pant := new.utg_pant + (in_diff);
ELSIF in_flagg = '9' THEN
  new.shop_in_shop := new.shop_in_shop + (in_diff);
ELSIF   in_flagg = '5' THEN
  new.rest_oms := new.rest_oms + (in_diff);
END IF;

BEGIN
  db_dagoms_detalj.find(new.dagoms_id, in_flagg);
  lDetaljFunnet := TRUE;
EXCEPTION
  WHEN OTHERS THEN
lDetaljFunnet := FALSE;
END;
IF lDetaljFunnet THEN
  db_dagoms_detalj.edit;
  db_dagoms_detalj.add_kundeoms(in_diff, in_diff_mva,
in_diff_brtkr);
  db_dagoms_detalj.modify;
  db_dagoms_detalj.close;
END IF;
  END;
END;


Thanks in advance






Roland


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Table Size?

2003-04-03 Thread Hamid Alavi

Dear List,

I have a database with 500 tables I want to put these tables based on size
to Three different TBS,Small size tables less than 5 M on TBS1 with extend
size 160K ,Tables less than 160 M and bigger than 5 M on TBS2 with extend
size 5 M and tables bigger than 160 M on TBS3 with extend size 160 M, My
question is do I have to calculate the size of tables for the life cycle of
database(for example 5 years) or Some thing else?
Example:   tableA   size = 10M in first year so this table must be multiple
5 and assume as Medium size or NOT?
Thanks,

Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-416-5095






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

RMAN: What blocks are backed up with a full backup?

2003-04-03 Thread Keith Moore

Our RMAN backup is backing up much more than the actual data blocks when
doing a full backup. I know that it backs up all blocks that have ever been
used, but I'm trying to figure out exactly what that means. My first
thought was that it backs up all blocks below the HWM, but I analyzed the
tables and that is not the case.

Sometimes it backs up more blocks than exist below the HWM for the tables
and sometimes it backs up fewer blocks than those below the HWM.

We are doing this to determine what we can do to reduce the size of the
backup.

Anyone have an idea how this works?

Keith


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

Where to set LD_LIBRARY_PATH in Database for 3rd Party Utilities

2003-04-03 Thread Scott Graves









I hope someone on the list can help.



Environment:

 Oracle
9.2.0.1

 Red Hat Linux



Im in the process of trying to connect to a Progress database via Java
Stored Procedures in Oracle 9.2.0.1.
The Progress JDBC driver is a type 2 driver, which means that it has shared
libraries that it must access. 



The java test code works outside of the database. The connection to the Progress database
is successful. The library path
for the Progress JDBC driver was added to the LD_LIBRARY_PATH variable.



The Progress JDBC driver was loaded into the database via the loadjava
utility. When I run the test
program though the database, I get an error indicating that the library files
could not be found. The Oracle
users profile has the additions to the LD_LIBRARY_PATH for the Progress JDBC
driver, but this didnt help.



I was able to find one forum note on Metalink where someone got this to
work, but no details. Where should
I set the LD_LIBRARY_PATH variable for the database to be able to find this 3rd
party library files? Any ideas
would be appreciated. As you
can probably tell, Im new to Unix/Linux.





Thanks in Advance,



Scott Graves

Sr. Systems Programmer

NISC RDQ-STP

Email: [EMAIL PROTECTED]

Phone: 636-922-9122 x7616

Fax: 636-922-2080

RE: upgrade q

2003-04-03 Thread Leyden, Joseph

We're running Oracle 8.0.5 for 3 years now
and want to go to Oracle9i.

Should I 
a) upgrade OR
b) exp the db and do an install of 9i then imp
   (this is a lenghty process)

what say you? TIA.
Joe

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 OCI JDBC Driver Not Recommended for Multiprocessor Mac

Rick - In Java Programming for Oracle by Don Bales, he ran some comparative
tests showing the comparative advantages of each interface under different
circumstances.
 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
H
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
0Hisbn=059600088Xitm=2 isbn=059600088Xitm=2
 


Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, April 03, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


The performance of JDBC OCI vs Thin really depends on what you are trying to
do.  Thin driver can perform better
than OCI and in some situations doesn't.  Also there are limitations in Thin
driver such as you can't return
a PL/SQL table using Thin driver, you can't do TAF etc.
 
Richard Ji

-Original Message-
Sent: Wednesday, April 02, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L


I've gone to using the thin driver exclusively, as (counter-intuitively, I
know) it performs better than the OCI driver. Plus it's easier to port...

-Original Message-
Sent: Wednesday, April 02, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L



Sun's FAQ on java hotspot VM  performance (
http://java.sun.com/docs/hotspot/PerformanceFAQ.html)
http://java.sun.com/docs/hotspot/PerformanceFAQ.html)  includes this
interesting question:

 

BM_24My application uses a database and doesn't seem to scale well. What
could be going on? 

Oracle provides two types of database drivers: a type-2 driver, called the
OCI (Oracle Call Interface) driver that utilizes native code, and a type-4
pure Java driver called the thin driver. In single processor environments,
the thin driver works somewhat better than the OCI driver because of the JNI
overhead associated with the OCI driver. On multi-processor configuations,
synchronization points within Solaris used by the OCI driver become big
bottlenecks and prevent scaling. We recommend using the thin driver in all
cases.  http://java.sun.com/docs/hotspot/PerformanceFAQ.html 

 

Is this actually the case?  Does anyone have more information on this?

 

Thanks,

 

Rick Stephenson



This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to which they are addressed.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. If you are not the intended recipient you are
notified that disclosing, copying, forwarding or otherwise distributing or
taking any action in reliance on the contents of this information is
strictly prohibited. 



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

Oracle 8i Service Shutdown Crashes Database on Win2K

2003-04-03 Thread Gary W. Parker

Gurus,

I am running Oracle 8.1.7.4.1 on a Win2K Advanced Server platform using 2 ZEON P4
processors.

The problem I have is that when I stop the Service for the DB (OracleServiceLIMS), it
crashes the database instead of performing a clean shutdown.

The registry entry is set to allow 5 minutes for the shutdown to complete, yet the
system behaves as if the entry is not there.  The registry entries are as follows:

 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

  ORA_LIMS_AUTOSTART:REG_EXPAND_SZ:TRUE
  ORA_LIMS_PFILE:REG_EXPAND_SZ:c:\Oracle\admin\LIMS\pfile\initLIMS.ora
  ORA_LIMS_SHUTDOWN:REG_EXPAND_SZ:TRUE
  ORA_LIMS_SHUTDOWN_TIMEOUT:REG_EXPAND_SZ:300
  ORA_LIMS_SHUTDOWNTYPE:REG_EXPAND_SZ:i
  ORACLE_BASE:REG_SZ:c:\oracle
  ORACLE_CWD:REG_SZ:c:\Oracle\admin\LIMS\log
  ORACLE_GROUP_NAME:REG_SZ:Oracle - OraHome817
  ORACLE_HOME:REG_SZ:c:\oracle\ora817
  ORACLE_HOME_KEY:REG_SZ:Software\ORACLE\HOME0
  ORACLE_HOME_NAME:REG_SZ:OraHome817
  ORACLE_SID:REG_SZ:LIMS

The service will open the database whenever it's started, but it crashes the DB when
the service is stopped.

I have used the ORADIM utility to drop and recreate the service with no change in
behavior.

Any suggestions would be appreciated.

TIA

GWP



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: certifications was Re: Remote DBA

John - Thanks for the encouragement. I'll get cracking on the next exam this
weekend!!

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, April 03, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L


Say what you think Joe,
When I have been looking for contacts several agencies have asked me to take
those tests as a means of ensuring that I know what I am supposed to know.
They act as a pre-interview filter
If it sorts the wheat  from the chaff then I don't think they perform a bad
service in that respect.
However as far as being touted as a professional qualification as Ramesh is
using them then I think I would forget about it.

I think anybody who contributes to this list claiming to be this, that or
the other is setting himself up for a fall.

Dennis has got the idea by having 40% OCP in his sig (however that has been
there so long now that the exams probably need re-taking now )

John  


-Original Message-
Sent: 03 April 2003 12:24
To: Multiple recipients of list ORACLE-L


Ramesh, since in your sig line you say you're brainbench and brainbuzz 
certified, do you really think those tests have any meaning, i took them 
and thought they were a joke.

joe


Ramesh Papnoi wrote:

It can be Unix as well as Windows. As I have to support various DB's

Best Regards
Ramesh D. Papnoi   http://www22.brinkster.com/rpapnoi
(Brainbench  Brainbuzz certified Oracle 8/8i DBA  Developer)

-Original Message-
Adar
Sent: Thursday, April 03, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


You did not mentioned what OS you are working on.
If the remote database is on your network, even via wan, you can activate
all the tools from your desktop.
We use RAS to connect to remote servers without network connections and
then
you have SLOW network connection and your tools will work.
If the need arise you can use Netop or other PcAnywhere to take control of
the server and do your work from there.

We are on windows servers and clients.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:34 PM


  

Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate


if
  

any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

  


-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Hallas, John, Tech Dev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message

RE: Table Size?

Hamid
  Be sure to read How to Stop Defragmenting and Start Living very
carefully so you really understand the concepts. These concepts free you
from being overly concerned about details.
  Myself, I try to plan for 1 year of growth. The future gets too
unpredictable past that. 

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, April 03, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Dear List,

I have a database with 500 tables I want to put these tables based on size
to Three different TBS,Small size tables less than 5 M on TBS1 with extend
size 160K ,Tables less than 160 M and bigger than 5 M on TBS2 with extend
size 5 M and tables bigger than 160 M on TBS3 with extend size 160 M, My
question is do I have to calculate the size of tables for the life cycle of
database(for example 5 years) or Some thing else?
Example:   tableA   size = 10M in first year so this table must be multiple
5 and assume as Medium size or NOT?
Thanks,

Hamid Alavi

Office  :  818-737-0526
Cell phone  :  818-416-5095






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN: What blocks are backed up with a full backup?

Keith
   Here is my understanding (don't rely on this one). When Oracle allocates
tablespace, the disk blocks are cleared. My interpretation is that when RMAN
encounters a clear block, it doesn't write it to the backup piece. I don't
think it spends a lot of time trying to figure out above HWM and such.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, April 03, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Our RMAN backup is backing up much more than the actual data blocks when
doing a full backup. I know that it backs up all blocks that have ever been
used, but I'm trying to figure out exactly what that means. My first
thought was that it backs up all blocks below the HWM, but I analyzed the
tables and that is not the case.

Sometimes it backs up more blocks than exist below the HWM for the tables
and sometimes it backs up fewer blocks than those below the HWM.

We are doing this to determine what we can do to reduce the size of the
backup.

Anyone have an idea how this works?

Keith


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN - Some basic Qs.

2003-04-03 Thread Gaja Krishna Vaidyanatha

Vivek,

Answers to your questions embedded. You may want to
read up on the manuals for more details. BTW, you
don't have to copy my e-mail id in your replies, given
that I belong to the list, just as many others. I am
trying to avoid getting 2 copies of every e-mail that
you send.

Cheers,

Gaja

--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
 Gaja ,
 
 Good indeed to see you back on the List . 
 
 My Qs. in CAPITALS below :-
 
 
 -Original Message-
 Sent: Wednesday, April 02, 2003 2:14 AM
 To: Multiple recipients of list ORACLE-L
 
 
 All,
 
 The primary reason why RMAN does not generate
 excessive redo is because because it does not put
 the
 tablespace in hot backup mode. Thus any blocks
 belonging to a given tablespace that are modified
 before the END BACKUP command is processed, do not
 require block-level before and after images. Hence
 the
 reduction in redo generation.
 
 So how does RMAN backup without hot backups?
 
 RMAN is aware of the format of an Oracle datafile,
 and
 reads datafiles for the backup in DB_BLOCK_SIZE
 chunks. This is not the case with most OS utilities
 (tar, cpio, cp, dd etc.), which read files in
 512-byte
 OS blocksize chunks.
 
 IS BACKUP DATA AS AT POINT-OF-TIME OF START OF RMAN
 BACKUP ?
 IF SO , HOW IS DATA INTEGRITY ACROSS DATAFILES
 MAINTAINED ?
 HOW ARE BLOCK DATA VALUES AS AT POINT OF BACKUP
 MAINTAINED WITHOUT STOPPING DMLs TO IT ?
 

Gaja: 

There is no concept of backup data at point-of-time
start of the RMAN backup. Backups as such do not
require read consistency. A recovered
tablespace/database requires consistency. This
consistency is achieved by recovering the datafile or
the entire database (if relevant) to the point noted
in the controlfile, using the relevant online and
archived redo logs. Ofcourse things are different for
incomplete recovery scenarios. 

The backup is done whenever it is done. Again, the
issue of consistency arises only when a recovery is
done. In the case of hot backups or RMAN backups, the
redo generation continues during the backup (as
required) and the issue of consistency is dealt with
when recovery is performed. With hot backups, Oracle
plays it safe and generates more redo, to protect
against block-fracture on the backed-up files. This
is required due to the 512-byte read-chunk-size that
OS utilities use, which is different than
DB_BLOCK_SIZE on most databases. This not relevant in
RMAN backups due to DB_BLOCK_SIZE read-chunk-size and
the relevant synchronization methods that RMAN uses.

 
 As a result, the issue of a fractured block (for
 which
 block-level before/after images are taken) on the
 destination where the backup is done, does not come
 into play in RMAN. 
 
 MY UNDERSTANDING OF HOT BACKUP :-
 
 ASSUME 1 TABLESPACE HAS 2 DATAFILES  DMLs HAPPENING
 ONLY TO FILE 2.
 AFTER SWITCHING TABLESPACE TO BEGIN BACKUP . 
 ASSUMING SEQUENTIAL O.S. BACKUP OF DATAFILES , WHILE
 BACKUP OF THE 1ST FILE IS UNDERWAY , 
 BEFORE IMAGES OF ALL DMLs HAPPENING TO FILE 2 ARE
 BEING ARCHIVED .
 THEREAFTER FILE 2 IS BACKED UP .
 FINALLY TABLESPACE END BACKUP IS ISSUED.
 
 THUS USING THE BEFORE IMAGES OF BLOCKS OF FILE 2 ,
 THE TABLESPACE CAN BE BROUGHT TO 
 DATA EXISTING  AS AT POINT OF START OF HOT BACKUP.
 

Gaja: See previous explanation. Your understanding is
not fully accurate, please read the manuals for more
details. Basically, it is OK for the backup copy of
File#1 to be different from File# 2. The issue of
consistency is dealt with during recovery and Oracle
does a great job of it, by dealing with the logs that
need to be applied, on a per file basis.

 Hope that helps,
 
 Gaja
 

==stuff deleted==

=


__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Autoallocate vs Uniform extent performance

2003-04-03 Thread Gaja Krishna Vaidyanatha

Totally agree with Connor. Just to add a comment to
his note. 

A usage model recommended for UNIFORM vs. AUTOALLOCATE
follows:

If you know the data volume and growth of your
segments and they are predictable, then use UNIFORM.

If you are completely in the dark with:

1) How much data is going to be persisted in the
segments? 
2) What growth patterns the segments are going to
exhibit?

Then use AUTOALLOCATE.

Of course, if you do change your mind, after the fact,
you can use the MOVE command to the tablespace of
choice with the extent allocation of your choice.

Cheers,

Gaja

--- Connor McDonald [EMAIL PROTECTED] wrote:
 I don't believe that was the case.  auto and uniform
 in all of the (admittedly rudimentary and
 subjective)
 tests I've done appear the same in terms of
 performance.
 
 I prefer uniform purely for the reasons of:
 
 - more thorough elimination of fragmentation
 - predictability of next extent sizes
 
 hth
 connor
 
  --- [EMAIL PROTECTED] wrote:  Hi all
  
  Some time ago there was a discussion about the use
  of the different extent 
  management types and that if my memory serves me
  that there was a 
  perception  that Auto allocate extents had some
  performance issues against 
  Uniform extents.
  
  Was this correct and can it be backed up with some
  definitive testing, has 
  someone done a whitepaper???
  
  Cheers
  
  
  --
  =
  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
  
  =
  
  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. 
  
  
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.net
  -- 
  Author: 
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051
  http://www.fatcity.com
  San Diego, California-- Mailing list and
 web
  hosting services
 

-
  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
 web: http://www.oracledba.co.uk
 web: http://www.oaktable.net
 email: [EMAIL PROTECTED]
 
 GIVE a man a fish and he will eat for a day. But
 TEACH him how to fish, and...he will sit in a boat
 and drink beer all day
 
 __
 Yahoo! Plus
 For a better Internet experience
 http://www.yahoo.co.uk/btoffer
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: =?iso-8859-1?q?Connor=20McDonald?=
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 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! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

[no subject]

2003-04-03 Thread Madhavan Amruthur

Hi,

I have been grappling with this for sometime

I have a table a_user_groups

   USER_ID SECURITY_GROUP_ID   GROUP_ID
-- - --
  1005  1012   1010
  1005  1012   1011
  1006  1013   1010
  1007  1017   1016
  1008  1018   1010
  1008  1018   1011

The security_group_id currently is uniquely generated every time a user
is added and a group_id is associated with the user_id.
For eg: user_id 1005 is associated with groups 1010 and 1011. User 1008
has the same combination but the security_group_id is generated
differently.
The generation happens from C code and there is an option to correct the
problem in the C code but I am trying to see if I can prevent that

The requirement is that user_id 1008 and any other users with the same
group_id combination should have the same security_group_id 1012, 
basically the first occurrence for the combination. 
In the case of user_id 1006 the value for security_group_id is 1013 and
the group_id the user_id belongs to is 1016. So all the user_ids with a
group_id association 
of 1016 (1016 in a combination does not count) down the line will have to
be updated to 1013.

I found a solution for the case where I associate a group to a user_id in
this existing table by creating another table that converted the above
table into a hierarchy

Table b_hier_user_groups

   USER_ID   CGID PARENT_VALUE CHILD_VALUE
-- --  ---
  1005   1012 1010
  1005   1012 10101011
  1006   1013 1010
  1007   1017 1016
  1008   1018 1010
  1008   1018 10101011

Then using a PL/SQL script I generated the tree using sys_connect_by_path
I determined if the user had a path that already. 
For eg: in the above case if the user 1006 was being associated with
group_id 1011, then I would check the exsiting trees to see if there was
a path already as in 1010,1011.
In this case it does exist and the cgid (equivalent to security_group_id
in the above table) is 1012 and update the user_id 1006 to cgid 1012. But
I am not for some reason able
to apply this solution to the existing rows. I have a feeling that I am
missing something simple

The requirement that I am grappling with is to update the values in the
existing table. I can get the table b_hier_user_groups created from the
a_user_groups.

Please let me know if you need more information
The table structures are as below

a_user_groups

Name  Null?Type
- 

USER_ID   NOT NULL NUMBER
SECURITY_GROUP_ID NOT NULL NUMBER
GROUP_ID  NOT NULL NUMBER


Table b_hier_user_groups

Name  Null?Type
- 

USER_IDNUMBER
CGID  --- same as security_Group_id from above)   NUMBER
PARENT_VALUE   NUMBER
CHILD_VALUENUMBER

Thanks for your time and help in advance.
Regards,
Madhavan
http://www.dpapps.com
-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://www.fastmail.fm - Same, same, but different
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Madhavan Amruthur
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread JayMiller

Correct.

The only potential disadvantage is that recovery will take longer when
bringing up the database after a crash.


Jay Miller

-Original Message-
Sent: Thursday, April 03, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L



I dissagree, they will be bigger but there will be less of them. If
the amount of processed data does not change, I do not think changing the
size of the redolog files should affect the total amount fo bytes to be
backeup up

Thanks for the recommendation anyway ;)

Cheers,

Fermin.

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Stefan Jahnke
Enviado el: jueves, 03 de abril de 2003 15:44
Para: Multiple recipients of list ORACLE-L
Asunto: AW: Cannot allocate new log - checkpoint not complete


Hi

I would suggest to increase the redo log size. Doesn't effect you during
daily operation, but prevents the database from hanging during nightly
batches. No side effects I can think of (except for the fact that, of
course, it will take you longer to backup the archived logs since the files
are bigger, duh ;).

Good luck
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. April 2003 10:04
An: Multiple recipients of list ORACLE-L
Betreff: Cannot allocate new log - checkpoint not complete



I think I am having problems with my redologs. Under normal
circumstances no errors arise, but if I do a massive import of data as I was
doing last night, this is what alertSID.log shows from time to time:

Wed Apr  2 23:29:52 2003
Thread 1 advanced to log sequence 557295
  Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log
Wed Apr  2 23:31:11 2003
Thread 1 cannot allocate new log, sequence 557296
Checkpoint not complete
  Current log# 3 seq# 557295 mem# 0: /baandata/oradata/baan/redobaan03.log
Wed Apr  2 23:31:50 2003

In that exact time, everything freezes and the database is dead
until a new redolog can be used.

I have 3 redologs 50 Mb each. I've read that the error is because
too much data is trying to get into the redologs and all of them are full,
Oracle does not have the time to reuse a redolog and has to wait until the
redolog is ready to be reused. 

So the solution seems to make these redolog files bigger or to
create new ones. What are the side effects of one or the other? will
performance under normal work be penalised?

..
Fermín Bernaus Berraondo
Dpto. de Informática
SAMMIC, S.A.
[EMAIL PROTECTED]
http://www.sammic.com
Telf. +34 - 943 157 331
Fax +34 - 943 151 276
..

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

Re: Sun HA Monitoring and Oracle 9

2003-04-03 Thread Scott Canaan





Barb,
 This isn't an Oracle limitation. It's a Sun HA limitation. Oracle 9i
will run on Sun Solaris HA 2.2, with no problem. We've installed it and
built an instance and run it. The problem comes in when you want to HA monitor
the database. HA 2.2 won't even run when it gets to the Oracle 9i instance.
The problem is so bad that the program just exits as soon as it hits that
instance, so it ends up not monitoring anything, not even the 8i instances.
 Our SA called Sun and was told that HA 2.2 only works with Oracle through
8i. If we want to use it with Oracle 9i, then we have to buy HA 3.0 (it's
not an upgrade, they consider it a new product). They did say that HA 3.0
will support Oracle 8i and 9i, but nothing before Oracle 8i. Unfortunately,
the changeover means that we would have to do a complete rebuild of the Sun
Cluster, which is not possible. We can't have that much downtime (about
1 week). If we get the funding, our plan is to buy 2 more Sun machines,
build a 2-node cluster with HA 3.0, migrate the applications to that cluster,
then bring 2 of the original Sun machines into that cluster, making it a
4-node cluster again.

Barbara Baker wrote:

  Scott (or anyone runing HA 2.2 wishing to upgrade to
9i):  I noticed you did not receive a response from
this message a couple of months back.

We're in same situation (Sun Cluster 2.2, wishing to
upgrade to Oracle 9i).  It's not clear from the Oracle
certification matrix if this is supported.  (Clearly
not supported if you're running RAC, but we're not)
We're not convinced we want to upgrade to Sun cluster
3.0 (and certainly not clear we want to pay for it.)

I'm wondering if there are others with this
configuration, and if so what you decided to do.
Thanks in advance for any information.

Barb



  
  
-Original Message-
Sent: Monday, January 06, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L


Here's a little background.  We are currently
running Oracle
8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster.  We
use HA monitoring
for failover, in case there is a problem with any of
the nodes.  The
version of HA is 2.2.  We installed Oracle 9.2.0.1
on the cluster and
created a new database using it.  When the SA tried
to start the HA
monitoring, it wouldn't run.  We ended up recreating
the database in
8.1.7.4.  When the SA contacted Sun, he was told
that HA version 2.2
only supports up to Oracle 8.1.7.  In order to
monitor Oracle 9, we had
to buy (not upgrade to) HA 3.0, which would require
a rebuild of the
entire cluster.

Has anyone else run into this problem?  If so,
what have you done to
get around it?  Let me know if I forgot any
important piece of
information.

Thank you.

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it
depends on what you put
into it." - Tom Lehrer.


  
  

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://platinum.yahoo.com
  


-- 
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

RE: oracle full table scan

Raj,

Indexing small tables is a good thing if you are doing single row lookups.

An index read and lookup by rowid is much more scalable than
doing an  FTS, even if the table is only 2 blocks.

Jared






Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 05:28 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: oracle full table scan


To answer the original question ... 
1. use following query to see which tables are part of FTS ... it is a 
point in time information. (Query from www.ixora.com I think).
SELECT usr.name oowner, ob.name oname 
  FROM ( SELECT obj 
   FROM sys.X_$BH 
  WHERE TO_NUMBER(bitand(flag, POWER(2,19)))  0 
  GROUP BY obj) bh, 
   sys.obj$ ob, 
   sys.USER$ usr 
 WHERE ob.dataobj# = bh.obj 
   AND ob.owner#   = usr.USER# 
 ORDER BY usr.name, ob.name 
/ 
2. FTS can happen for many reasons ... if Oracle is performing FTS on a 
small table, that's the way to do it. Remember when you create an index 
Oracle had to perform 2 IOs, one for INDEX lookup and (if required) one 
for Table lookup. Sometimes associated costs dictate that a FTS is cheaper 
than the combined cost (of index lookup and table lookup), so Oracle 
prefers that.
One upon a time, I used to think on the same lines, but the bright minds 
on this list have time and again proven that FTS, isn't a bad thing after 
all. Sometimes it is, but not ALL the times.
Creating indexes is not the solution, a careful analysis of the logic 
implemented in the SQL is also required, and you will be surprised that, 
just by making the query changes, the performance gain can be achieved.
PS: Stephane, you probably have this on the top of your Oracle Myth list 
... right? 
YMMV 
Raj 
 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 2:58 PM 

 Dear All, 
 
   is there any way to find which tables (table name) are 
suffering from 
 full table scan ,so that  i can create indexes on them to enhance the 
 performance. 
 
 
 Thanks 
 
 Arvind 
 -- 

This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: oracle full table scan

2003-04-03 Thread Jamadagni, Rajendra

Title: RE: oracle full table scan





Thanks Jared,


What if my developer is selecting all or most of the records from the table and not all the columns in the select list are in the index that should have been used?

I understand your point, in fact to use Jonathan's words .. should a small lookup table BE an index (IOT)? ... I am testing this approach here and have found some performance benefit out of it. 

Cheers
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 03, 2003 1:01 PM
To: [EMAIL PROTECTED]
Cc: Jamadagni, Rajendra
Subject: RE: oracle full table scan
Importance: High



Raj,


Indexing small tables is a good thing if you are doing single row lookups.


An index read and lookup by rowid is much more scalable than
doing an FTS, even if the table is only 2 blocks.


Jared







Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 05:28 AM
Please respond to ORACLE-L



 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc: 
 Subject: RE: oracle full table scan



To answer the original question ... 
1. use following query to see which tables are part of FTS ... it is a 
point in time information. (Query from www.ixora.com I think).
SELECT usr.name oowner, ob.name oname 
 FROM ( SELECT obj 
 FROM sys.X_$BH 
 WHERE TO_NUMBER(bitand(flag, POWER(2,19)))  0 
 GROUP BY obj) bh, 
 sys.obj$ ob, 
 sys.USER$ usr 
WHERE ob.dataobj# = bh.obj 
 AND ob.owner# = usr.USER# 
ORDER BY usr.name, ob.name 
/ 
2. FTS can happen for many reasons ... if Oracle is performing FTS on a 
small table, that's the way to do it. Remember when you create an index 
Oracle had to perform 2 IOs, one for INDEX lookup and (if required) one 
for Table lookup. Sometimes associated costs dictate that a FTS is cheaper 
than the combined cost (of index lookup and table lookup), so Oracle 
prefers that.
One upon a time, I used to think on the same lines, but the bright minds 
on this list have time and again proven that FTS, isn't a bad thing after 
all. Sometimes it is, but not ALL the times.
Creating indexes is not the solution, a careful analysis of the logic 
implemented in the SQL is also required, and you will be surprised that, 
just by making the query changes, the performance gain can be achieved.
PS: Stephane, you probably have this on the top of your Oracle Myth list 
... right? 
YMMV 
Raj 
 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 2:58 PM 


 Dear All, 
 
 is there any way to find which tables (table name) are 
suffering from 
 full table scan ,so that i can create indexes on them to enhance the 
 performance. 
 
 
 Thanks 
 
 Arvind 
 -- 



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: oracle full table scan

Comparing users to Marilyn Cross.

Naive, not overly bright, sentenced to death.

Is that too harsh for users?

Jared






Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 07:18 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: oracle full table scan


Tables are not suffering, they're rather cruel and coldhearted.
As in the Tom Godwin's story, The Cold Equations, it's always
the users who pay the price. You might try with tuning the SQL 
statements that access tables. Occasionally, that does the trick.

-Original Message-
Sent: Wednesday, April 02, 2003 11:59 PM
To: Multiple recipients of list ORACLE-L


Dear All,

  is there any way to find which tables (table name) are suffering 
from
full table scan ,so that  i can create indexes on them to enhance the
performance.


Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Goulet, Dick

SQL*Server doesn't crash, it's a disorganized retreat. *-)

Dick Goulet

-Original Message-
Sent: Wednesday, April 02, 2003 11:14 PM
To: Multiple recipients of list ORACLE-L


Oracle crash??? What's that :)??? Isn't that a bug in SQL Server only ?


-Mensaje original-
De: Rachel Carmichael [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 02 de Abril de 2003 22:34
Para: Multiple recipients of list ORACLE-L
Asunto: RE: dbshut script - shutdown or shutdown immediate

yeah so? are you suggesting that Oracle instance recovery can't handle
a database crash? If so, better pray your server never crashes.


--- Pardee, Roy E [EMAIL PROTECTED] wrote:
 Well... my official oracle instructor in dba larva school said that
 it's
 tantamount to crashing the db--or so I recall anyway.  This isn't so?
 
 Peace,
 
 -Roy
 
 Roy Pardee
 Programmer/Analyst
 SWFPAC Lockheed Martin IT
 Extension 8487
 
 -Original Message-
 Sent: Wednesday, April 02, 2003 2:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 On Wed, 2 Apr 2003, Chris Berry wrote:
 
  Shutdown abort is pretty drastic, are you sure shutdown immediate
  didn't work?
 
 What is drastic about shutdown abort?
 
 Never one to opt out of a shutdown abort thread,
 --
 Jeremiah Wilton
 http://www.speakeasy.net/~jwilton
 
 - Uses shutdown abort exclusively
 - successful shutdowns/startups: over 10,000
 - problems with shutdown abort: 0
 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
 - still employed!
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jeremiah Wilton
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
 -- 
 Author: Pardee, Roy E
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Nelson  Flores
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

SQL Question

2003-04-03 Thread Madhavan Amruthur

Hi,
Sorry for reposting.
Just wanted to put in a subject...

I have been grappling with this for sometime and thought it will be best
for others to take a look at it.

I have a table a_user_groups

   USER_ID SECURITY_GROUP_ID   GROUP_ID
-- - --
  1005  1012   1010
  1005  1012   1011
  1006  1013   1010
  1007  1017   1016
  1008  1018   1010
  1008  1018   1011

The security_group_id currently is uniquely generated every time a user
is added and a group_id is associated with the user_id.
For eg: user_id 1005 is associated with groups 1010 and 1011. User 1008
has the same combination but the security_group_id is generated
differently.
The generation happens for C code and there is an option to correct the
problem in the C code but I am trying to see if I can prevent that

The requirement is that user_id 1008 and any other users with the same
group_id combination should have the same security_group_id 1012, 
basically the first occurrence for the combination. 
In the case of user_id 1006 the value for security_group_id is 1013 and
the group_id the user_id belongs to is 1016. So all the user_ids with a
group_id association 
of 1016 (1016 in a combination does not count) down the line will have to
be updated to 1013.

I found a solution for the case where I associate a group to a user_id in
this existing table by creating another table that converted the above
table into a hierarchy

Table b_hier_user_groups

   USER_ID   CGID PARENT_VALUE CHILD_VALUE
-- --  ---
  1005   1012 1010
  1005   1012 10101011
  1006   1013 1010
  1007   1017 1016
  1008   1018 1010
  1008   1018 10101011

Then using a PL/SQL script I generated the tree using sys_connect_by_path
I determined if the user had a path that already. 
For eg: in the above case if the user 1006 was being associated with
group_id 1011, then I would check the exsiting trees to see if there was
a path already as in 1010,1011.
In this case it does exist and the cgid (equivalent to security_group_id
in the above table) is 1012 and update the user_id 1006 to cgid 1012. But
I am not for some reason able
to apply this solution to the existing rows. I have a feeling that I am
missing something simple

The requirement that I am grappling with is to update the values in the
existing table. I can get the table b_hier_user_groups created from the
a_user_groups.

Please let me know if you need more information
The table structures are as below

a_user_groups

Name  Null?Type
 - 
 
 USER_ID   NOT NULL NUMBER
 SECURITY_GROUP_ID NOT NULL NUMBER
 GROUP_ID  NOT NULL NUMBER


Table b_hier_user_groups

Name  Null?Type
 - 
 
 USER_IDNUMBER
 CGID  --- same as security_Group_id from above)   NUMBER
 PARENT_VALUE   NUMBER
 CHILD_VALUENUMBER

Thanks for your time and help in advance.
Regards,
Madhavan
http://www.dpapps.com



-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://www.fastmail.fm - I mean, what is it about a decent email service?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Madhavan Amruthur
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

Jared, I like you more and more every day.

-Original Message-
Sent: Thursday, April 03, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L


Comparing users to Marilyn Cross.

Naive, not overly bright, sentenced to death.

Is that too harsh for users?

Jared






Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 07:18 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: oracle full table scan


Tables are not suffering, they're rather cruel and coldhearted.
As in the Tom Godwin's story, The Cold Equations, it's always
the users who pay the price. You might try with tuning the SQL 
statements that access tables. Occasionally, that does the trick.

-Original Message-
Sent: Wednesday, April 02, 2003 11:59 PM
To: Multiple recipients of list ORACLE-L


Dear All,

  is there any way to find which tables (table name) are suffering 
from
full table scan ,so that  i can create indexes on them to enhance the
performance.


Thanks

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

2003-04-03 Thread Stephane Faroult

 Jamadagni, Rajendra wrote:

 
 PS: Stephane, you probably have this on the top of your Oracle Myth
 list ... right?
 YMMV
 Raj

Indeed, together with 'always replace NOT IN with NOT EXISTS ...' -
another case today ...
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 11i/8.1.7.4/login.sql

I got same problem. what I did is before call sqlplus /nolog, I rename
the glogin.sql to something else and change back after the jobs done.
That is most easy step I need to do.

Joan

John Carlson wrote:
 
 The way I do it is to create another login.sql script for batch jobs only and place 
 that in another directory.  I have also created a file I call .cronenv under 
 $HOME.  This sets environment variables needed for cron jobs.  In it, I set SQLPATH 
 so the first place it looks is the directory I placed my new login.sql file.
 
 SQLPATH=$HOME/cron_out:.:$HOME/dbacommon/tools/sqlscripts:$SQLPATH
 
 Then I put:
 . $HOME/.cronenv  /dev/null 21
 into all my batch jobs.
 
 This works for me.
 HTH,
 John
 
 -Original Message-
 Sent: Tuesday, March 25, 2003 9:29 AM
 To: Multiple recipients of list ORACLE-L
 
 Greetings Everyone!
 
 I have a LOGIN.SQL script that I've customized to fit my
 preferences.  However, when I use SQLPLUS /NOLOG, it fails
 miserably since there is no connection to the database.
 
 Is there a way - other than undefining ORACLE_PATH - that the
 LOGIN.SQL script can be skipped or ignored when using the
 /NOLOG parameter?
 
 Thanks,
 Mike
 
 ---
 ===
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
 --
 Author: John Carlson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Deshpande, Kirti

Precisely.
I am trying to propose the abort option, but I am not the majority around this place I 
call work.. :)
 
On a more than dozen times in the last few months, I had to kill oracle processes to 
get the database to shutdown (with immediate), so the scheduled reboot of the machine 
will continue... And on a number of occasions, the Sunday reboot actually took the 
server down (and brought it up) on Monday mornings when users complained that they 
could not get to databases that were shutdown properly with 'shutdown immediate'.  

- Kirti 

-Original Message-
Sent: Thursday, April 03, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L


the problem is, if immediate hangs and you have automated the
process... nothing happens. it doesn't time out so you sit. and sit and
sit. and hope that whatever is keeping the database active will
eventually end.

In version 7 (7.3.2) I found that while using a third party monitoring
package that had a job in the job queue that ran frequently enough (and
you WANT monitoring software to monitor things!) that we could never
use a shutdown immediate


--- Pardee, Roy E [EMAIL PROTECTED] wrote:
 I am certainly not suggesting that recovery can't handle a crash--I'm
 just
 trying to make sure that I understand what shutdown abort does.  Some
 posts
 have implied that it's no big deal, which is counter-intuitive to me.
  To
 me, crashing a program on purpose seems like a drastic measure.  No
 doubt
 desperate times can call for desperate measures, but I would have
 guessed
 that optimally, you'd try immediate first  then abort if immediate
 takes
 too long.  But I'm just learning this stuff...
 
 Cheers,
 
 -Roy
 
 Roy Pardee
 Programmer/Analyst
 SWFPAC Lockheed Martin IT
 Extension 8487
 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Remote DBA

2003-04-03 Thread Nelson Flores

Chris,
No i haven´t tried TightVNC... I'll go and check it out ... 
Also I forgot to mention that there is an excellent client SW that permits a
Linux/unix box to connect to a Windows 2000 Terminal Server. If anyone is
interested, go to http://www.rdesktop.org/..
Pretty impressed with it ... :)


Nelson Flores
Project Manager
INTEC


-Mensaje original-
De: Jesse, Rich [mailto:[EMAIL PROTECTED] 
Enviado el: Jueves, 03 de Abril de 2003 10:54
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Remote DBA

Nelson, have you tried the free TightVNC from http://www.tightvnc.com ?  It
has a few performance features that seem to work slightly better than the
standard VNC, especially over slower links like VPN over a 768Kb DSL.
I've been about as happy as I can be with TightVNC for my setup.


Rich

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


-Original Message-
Sent: Wednesday, April 02, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


Chris,
VNC and OpenSSH are slow and VNC is still a little unstable (IMHO), I
personally manage my windows 2000 Oracle DB with a VPN and then a Terminal
server window direct to my desktop - from there I have all the tools that I
usually have - notepad, mspaint, dir :). 
I hate to have to plug windows products, but if it were linux or unix, then
it would be a different story, seeing as though it matters little where you
are physically on a Linux/Unix box (SSH Telnet, or an XWindow Session with
the display set to your own IP)...

Anyone knows what Big Larry uses to connect to his Database? :)  

Nelson Flores 
Project Manager
Intec



-Mensaje original-
De: Chris Berry [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 02 de Abril de 2003 19:09
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Remote DBA

I do both platforms, my recommendation is OpenSSH + VNC, they work great, 
they're free, and they're available for both platforms.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Nelson  Flores
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

only for some. unfortunately not for most of mine
--- [EMAIL PROTECTED] wrote:
 Comparing users to Marilyn Cross.
 
 Naive, not overly bright, sentenced to death.
 
 Is that too harsh for users?
 
 Jared
 
 
 
 
 
 
 Gogala, Mladen [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  04/03/2003 07:18 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: oracle full table scan
 
 
 Tables are not suffering, they're rather cruel and coldhearted.
 As in the Tom Godwin's story, The Cold Equations, it's always
 the users who pay the price. You might try with tuning the SQL 
 statements that access tables. Occasionally, that does the trick.
 
 -Original Message-
 Sent: Wednesday, April 02, 2003 11:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Dear All,
 
   is there any way to find which tables (table name) are
 suffering 
 from
 full table scan ,so that  i can create indexes on them to enhance the
 performance.
 
 
 Thanks
 
 Arvind 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Arvind Kumar
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
 -- 
 Author: Gogala, Mladen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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.net
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 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! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 we have INSTANTIATE command in 9i Dataguard as in Oracle8i DG?

2003-04-03 Thread CSP2201

Hi All,

I have been trying to upgrade our Oracle environment which is presently using Oracle8i 
with DataGuard setup, using the GUI based - DataGuard Manager, but so far not been 
successful, I am constantly and consistently getting DataGuard Remote Process startup 
failed, even though, I have followed all the instructions given in various metalink 
documents. 

Now, I want to give up using the GUI to setup/recreate the standby databasse, and want 
use something similar to INSTANTIATE command,  we had in Oracle8i Dataguard 3.0.2 to 
create the standby environment. I looked up the documentation and couldn't find a 
similar command in Oracle9i Dataguard documents. Do we have some thing similar? 

Please help with this. INSTANTIATE command is/was really great, there should be one 
(may be with different name) in Oracle9i. 

Thanks in advance. 
CP

__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Jacques Kilchoer

Title: RE: dbshut script - shutdown or shutdown immediate





 -Original Message-
 From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]

 ...
 
 So use your test systems, load them up like production, and try both.
 I bet in 9 out of 10 cases, checkpoint+abort+startup will be much
 faster than shutdown immediate+startup.

 ...


Is


alter system checkpoint
startup force restrict
shutdown immediate


any different than


alter system checkpoint
shutdown abort
startup restrict
shutdown immediate


I am of the belief that the two are identical. I use the first three statements.


TFM (8.1.7) says STARTUP FORCE: Shuts down the current Oracle instance (if it is running) with SHUTDOWN mode ABORT, before restarting it. If the current instance is running and FORCE is not specified, an error results. FORCE is useful while debugging and under abnormal circumstances. It should not normally be used.

Why would there be a warning for STARTUP FORCE saying It should not normally be used when there is no such warning for SHUTDOWN ABORT?

uregnt help

2003-04-03 Thread AK




I am getting following in alert log 
file
internal error code, arguments: [17090], [], [], 
[], [], [], [], [] .

its a hp-ux 8.1.6 system .
It happens only when two user does the same thing 
.
any idea ?

-ak

RE: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Jacques Kilchoer

Title: RE: dbshut script - shutdown or shutdown immediate





 -Original Message-
 From: Pardee, Roy E [mailto:[EMAIL PROTECTED]]
 
 I would 
 have guessed
 that optimally, you'd try immediate first  then abort if 
 immediate takes
 too long.


I've read that some people on the list have done this. I am curious as to how this is implemented.
How long is too long? And how is this coded? I'm trying to think how you would write this with shell scripts for example.

RE: oracle full table scan

If you can change it to an IOT, it may be beneficial.

There's no blanket clause to be used that says 'Always do this'.

I higly encourage folks on this list to setup and use the run_stats
method of comparing different access methods.  This is something
Tom Kyte put together.  It is very simple to use.

URL:  http://osi.oracle.com/~tkyte/runstats.html

I've attached my versions of the scripts for your convenience.

You can use these to easily compare unindexed vs indexed
reads on small tables, indexed vs IOT, etc.

Jared







Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 10:05 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: oracle full table scan


Thanks Jared, 
What if my developer is selecting all or most of the records from the 
table and not all the columns in the select list are in the index that 
should have been used?
I understand your point, in fact to use Jonathan's words .. should a 
small lookup table BE an index (IOT)? ... I am testing this approach here 
and have found some performance benefit out of it. 
Cheers 
Raj 
 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 

-Original Message- 
Sent: Thursday, April 03, 2003 1:01 PM 
To: [EMAIL PROTECTED] 
Cc: Jamadagni, Rajendra 
Importance: High 

Raj, 
Indexing small tables is a good thing if you are doing single row lookups. 
An index read and lookup by rowid is much more scalable than 
doing an  FTS, even if the table is only 2 blocks. 
Jared 








view.sql
Description: Binary data
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.


grants.sql
Description: Binary data
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.


run_stats.sql
Description: Binary data
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

 Runstats.sql This is the test harness I use to try out different ideas. It 
shows two vital sets of statistics for me The elapsed time difference between 
two approaches. It very simply shows me which approach is faster by the wall 
clock How many resources each approach takes. This can be more meaningful then 
even the wall clock timings. For example, if one approach is faster then the 
other but it takes thousands of latches (locks), I might avoid it simply 
because it will not scale as well. The way this test harness works is by saving 
the system statistics and latch information into a temporary table. We then run 
a test and take another snapshot. We run the second test and take yet another 
snapshot. Now we can show the amount of resources used by approach 1 and 
approach 2. 

Requirements 

In order to run this test harness you must at a minimum have: Access to 
V$STATNAME, V$MYSTAT, and V$LATCH If you want to use the view as I have, you 
must be granted select DIRECTLY on SYS.V_$STATNAME, SYS.V_$MYSTAT, and 
SYS.V_$LATCH. It will not work to have select on these via a ROLE. You can 
still run the test harness, you just will not be using the view STATS I have 
below (substitute in the query text in the PLSQL block where I reference the 
view STATS). The ability to create a table -- run_stats -- to hold the before, 
during and after information. You should note also that the LATCH information 
is collected on a SYSTEM WIDE basis. If you run this on a multi-user system, 
the latch information may be technically incorrect as you will count the 
latching information for other sessions - not just your

Re: Oracle 8i Service Shutdown Crashes Database on Win2K

Gary,

Check doc # 136214.1  on MetaLink.

There are some other non-Oracle reg entries that affect shutdown.

Jared






Gary W. Parker [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 09:03 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Oracle 8i Service Shutdown Crashes Database on Win2K


Gurus,

I am running Oracle 8.1.7.4.1 on a Win2K Advanced Server platform using 2 
ZEON P4
processors.

The problem I have is that when I stop the Service for the DB 
(OracleServiceLIMS), it
crashes the database instead of performing a clean shutdown.

The registry entry is set to allow 5 minutes for the shutdown to complete, 
yet the
system behaves as if the entry is not there.  The registry entries are as 
follows:

 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

  ORA_LIMS_AUTOSTART:REG_EXPAND_SZ:TRUE
  ORA_LIMS_PFILE:REG_EXPAND_SZ:c:\Oracle\admin\LIMS\pfile\initLIMS.ora
  ORA_LIMS_SHUTDOWN:REG_EXPAND_SZ:TRUE
  ORA_LIMS_SHUTDOWN_TIMEOUT:REG_EXPAND_SZ:300
  ORA_LIMS_SHUTDOWNTYPE:REG_EXPAND_SZ:i
  ORACLE_BASE:REG_SZ:c:\oracle
  ORACLE_CWD:REG_SZ:c:\Oracle\admin\LIMS\log
  ORACLE_GROUP_NAME:REG_SZ:Oracle - OraHome817
  ORACLE_HOME:REG_SZ:c:\oracle\ora817
  ORACLE_HOME_KEY:REG_SZ:Software\ORACLE\HOME0
  ORACLE_HOME_NAME:REG_SZ:OraHome817
  ORACLE_SID:REG_SZ:LIMS

The service will open the database whenever it's started, but it crashes 
the DB when
the service is stopped.

I have used the ORADIM utility to drop and recreate the service with no 
change in
behavior.

Any suggestions would be appreciated.

TIA

GWP



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: upgrade q

Joseph.
   I prefer to exp/imp when possible. You get a chance to change anything
you like. With 8.0.5, you may have to upgrade in two steps. You could test
the exp/imp on your test system and get an idea of how much system downtime
your users would experience. Then ask them if that would be acceptable. I
think either route would work fine.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, April 03, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L


We're running Oracle 8.0.5 for 3 years now
and want to go to Oracle9i.

Should I 
a) upgrade OR
b) exp the db and do an install of 9i then imp
   (this is a lenghty process)

what say you? TIA.
Joe

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: uregnt help

2003-04-03 Thread Ray Stell



No human should have to run 8.1.6. 

Maybe Note:29616.1.

ORA-600 [17090] Empty error stack when signalling error

Note: 
For additional ORA-600 related information please read
[NOTE:146580.1]  

PURPOSE:   
This article discusses the
internal error ORA-600 [17090], whatit means and possible
actions. The information here is only applicableto the versions
listed and is provided only for guidance.   

ERROR: ORA-600 [17090][a][b][c][d][e]   
VERSIONS:   7.3.X to 8.1.X   
DESCRIPTION:

The internal error [17090] refers to
the condition when the kernel   error handling layer is called to pop
and resignal the topmost   error on the errorstack and it finds the
stack empty.You may see this error while running sqlldr or import
on   an 8.0.X database and also run into space management issues   such
as ORA-1658 or ORA-1654 errors for example. 

Reference [NOTE:1015930.102] 
FUNCTIONALITY: GENERIC CODE LAYER
IMPACT:PROCESS FAILURE   
NON CORRUPTIVE - No underlying data corruption.   
SUGGESTIONS:   
 This is not a fatal error.
 Address the underlying   space management error to correct. 




On Thu, Apr 03, 2003 at 11:29:04AM -0800, AK wrote:
 I am getting following in alert log file
 internal error code, arguments: [17090], [], [], [], [], [], [], [] .
 
 its a hp-ux 8.1.6 system .
 It happens only when two user does the same thing .
 any idea ?
 
 -ak
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: another chance for 9i CDs - Beware!

2003-04-03 Thread Smith, Ron L.

I purchased this CD-ROM last week and I must say the quality of the copy is
very poor.  The graphics are poor and the sound is so low you can hardly
hear it.  I emailed them about the quality but they did not bother to reply.
Just thought I would let you all know.

Ron

-Original Message-
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 25, 2003 11:13 AM
To: [EMAIL PROTECTED]


Hello,

Because of strong demand from our customere, we've had more Oracle9i
training CDs duplicated.

This CD-ROM includes training that will teach and prepare you for the
Oracle9i OCA Track which includes the following two exams:

 Introduction to Oracle9i SQL
 Oracle9i DBA Fundamentals I

Since we are in the last week of March, I'm going to include 2 FREE BONUSES
to anyone who places their order before midnight on Monday (March 31st).

1.  Free Shipping to Anywhere in the World.

2.  Free Access to Our Oracle Certified Mentors.  I'll provide you the
secret URL to our Mentor Forum and Chat Rooms so that you can get all your
Oracle questions answered.

To order your Oracle9i OCA CD-ROM set, and get the 2 Free Bonuses NOW, click
the link below:

http://www.webcontactpro.net/app/adtrack.asp?AdID=1978

If the above link is still 'Live', you're in luck.  As soon as this new
inventory of CDs have been sold, I'll be taking the page down.

You can also call my associate Miranda at 888-320-4775 or 732-333-1112
Option #1 to order by phone.

All the best,
Ed Haskins, OCP
OraKnowledge, Inc.
732.333.1115

P.S.  To take advantage of the 2 FREE BONUSES mentioned above, you must
order by Monday (March 31st)






PLEASE DO NOT REPLY TO THIS MESSAGE. Your reply would be automatically
deleted from the system.


If you no longer wish to receive communication from us:
http://www.webcontactpro.net/app/r.asp?ID=212087ARID=0

To update your contact information:
http://www.webcontactpro.net/app/r.asp?c=1ID=212087


If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: uregnt help

2003-04-03 Thread Ron Rogers

oramagic,
 Only let one user do it at a time.
 What are the two users doing?
Are they doing it at the same time.
Are they the only ones that are able to do it?

Damn if I don't sound like my father right now
Ron

 [EMAIL PROTECTED] 04/03/03 02:29PM 
I am getting following in alert log file
internal error code, arguments: [17090], [], [], [], [], [], [], [] .

its a hp-ux 8.1.6 system .
It happens only when two user does the same thing .
any idea ?

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

Jacques - We have used SHUTDOWN IMMEDIATE for over 5 years now for cold
backups, with zero problems. Weekend before last we had 3 production
databases that didn't go down for backup (all of our databases scheduled for
cold backups). When I checked the following morning they were just hanging.
The problem hasn't occurred since. Naturally I'll be checking this weekend
:-) We are running RMAN, just haven't gotten authorization to turn off cold
backups.
   If you are doing it interactively, you can check the processes in Unix
with ps to see if one of the Oracle processes is doing a lot of work. I've
seen it take 20 minutes to clean everything up and shut down. When a problem
has occurred, that can be a LONG 20 minutes. That is part of the DBA skill
set -- how to divert the attention of the people standing around your desk
while you wait :-)



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, April 03, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L



 -Original Message- 
 From: Pardee, Roy E [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] 
 
 I would 
 have guessed 
 that optimally, you'd try immediate first  then abort if 
 immediate takes 
 too long. 

I've read that some people on the list have done this. I am curious as to
how this is implemented. 
How long is too long? And how is this coded? I'm trying to think how you
would write this with shell scripts for example.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: uregnt help

You can look it up at:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=153788.1

Jared





AK [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 11:29 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:uregnt help


I am getting following in alert log file
internal error code, arguments: [17090], [], [], [], [], [], [], [] .
 
its a hp-ux 8.1.6 system .
It happens only when two user does the same thing .
any idea ?
 
-ak


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Remote DBA

It isn't often you find a tool that compiles and runs flawlessly in a few 
minutes.

Just installed on RH80, works perfect.  Very cool tool.

Thanks for the pointer.

Jared






Nelson Flores [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 10:53 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Remote DBA


Chris,
No i haven´t tried TightVNC... I'll go and check it out ... 
Also I forgot to mention that there is an excellent client SW that permits 
a
Linux/unix box to connect to a Windows 2000 Terminal Server. If anyone is
interested, go to http://www.rdesktop.org/..
Pretty impressed with it ... :)


Nelson Flores
Project Manager
INTEC


-Mensaje original-
De: Jesse, Rich [mailto:[EMAIL PROTECTED] 
Enviado el: Jueves, 03 de Abril de 2003 10:54
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Remote DBA

Nelson, have you tried the free TightVNC from http://www.tightvnc.com ?  It
has a few performance features that seem to work slightly better than the
standard VNC, especially over slower links like VPN over a 768Kb DSL.
I've been about as happy as I can be with TightVNC for my setup.


Rich

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


-Original Message-
Sent: Wednesday, April 02, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


Chris,
VNC and OpenSSH are slow and VNC is still a little unstable (IMHO), I
personally manage my windows 2000 Oracle DB with a VPN and then a Terminal
server window direct to my desktop - from there I have all the tools that 
I
usually have - notepad, mspaint, dir :). 
I hate to have to plug windows products, but if it were linux or unix, 
then
it would be a different story, seeing as though it matters little where 
you
are physically on a Linux/Unix box (SSH Telnet, or an XWindow Session with
the display set to your own IP)...

Anyone knows what Big Larry uses to connect to his Database? :) 

Nelson Flores 
Project Manager
Intec



-Mensaje original-
De: Chris Berry [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 02 de Abril de 2003 19:09
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Remote DBA

I do both platforms, my recommendation is OpenSSH + VNC, they work great, 
they're free, and they're available for both platforms.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Nelson  Flores
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread JayMiller

Here's how we do it:
We have 2 cron jobs, one of which runs 10 minutes after the first.
 
The first does a shutdown immediate.  The second checks if oracle is running
and, if so, does a shutdown abort.

-Original Message-
Sent: Thursday, April 03, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L



 -Original Message- 
 From: Pardee, Roy E [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] ] 
 
 I would 
 have guessed 
 that optimally, you'd try immediate first  then abort if 
 immediate takes 
 too long. 

I've read that some people on the list have done this. I am curious as to
how this is implemented. 
How long is too long? And how is this coded? I'm trying to think how you
would write this with shell scripts for example.

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: dbshut script - shutdown or shutdown immediate

Here's one way to do it:


OS_USER=jkstill
USERNAME=jkstill
PASSWORD=$(pwc.pl -username $USERNAME -instance $ORACLE_SID)

echo $PASSWORD

unset SQLPATH

# emulating a 10 second shutdown

(
sqlplus -s /nolog EOF
connect $USERNAME/[EMAIL PROTECTED];
exec dbms_lock.sleep(10)
EOF
)

BG=$!

echo BG: $BG

# we only want to wait 5 seconds for shutdown
# we are very impatient

sleep 5

STILL_RUNNING=$(ps -flu${OS_USER}|awk '{print $4}'|grep ^${BG}$)
echo STILL_RUNNING: $STILL_RUNNING

[ -z $STILL_RUNNING ] || {
echo Took too long. You could run shutdown abort here
ps -flu${OS_USER}
kill -9 $BG
ps -flu${OS_USER}
}







Jacques Kilchoer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 11:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: dbshut script - shutdown or shutdown immediate


 -Original Message- 
 From: Pardee, Roy E [mailto:[EMAIL PROTECTED] 
 
 I would 
 have guessed 
 that optimally, you'd try immediate first  then abort if 
 immediate takes 
 too long. 
I've read that some people on the list have done this. I am curious as to 
how this is implemented. 
How long is too long? And how is this coded? I'm trying to think how you 
would write this with shell scripts for example.


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 full table scan

Sorry, the attachments didn't make it, though they were only text.

I can put them some accessible via the web if anyone wants them.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 11:34 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: oracle full table scan


If you can change it to an IOT, it may be beneficial.

There's no blanket clause to be used that says 'Always do this'.

I higly encourage folks on this list to setup and use the run_stats
method of comparing different access methods.  This is something
Tom Kyte put together.  It is very simple to use.

URL:  http://osi.oracle.com/~tkyte/runstats.html

I've attached my versions of the scripts for your convenience.

You can use these to easily compare unindexed vs indexed
reads on small tables, indexed vs IOT, etc.

Jared







Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 04/03/2003 10:05 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
cc: 
Subject:RE: oracle full table scan


Thanks Jared, 
What if my developer is selecting all or most of the records from the 
table and not all the columns in the select list are in the index that 
should have been used?
I understand your point, in fact to use Jonathan's words .. should a 
small lookup table BE an index (IOT)? ... I am testing this approach here 

and have found some performance benefit out of it. 
Cheers 
Raj 
 

Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 

-Original Message- 
Sent: Thursday, April 03, 2003 1:01 PM 
To: [EMAIL PROTECTED] 
Cc: Jamadagni, Rajendra 
Importance: High 

Raj, 
Indexing small tables is a good thing if you are doing single row lookups. 

An index read and lookup by rowid is much more scalable than 
doing an  FTS, even if the table is only 2 blocks. 
Jared 






The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.




view.sql
Description: Binary data
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing

RE: SQL Question

2003-04-03 Thread Chelur, Jayadas {PBSG}

Madhavan,

I have created a similiar table and inserted the data
as follows :-

=

CREATE TABLE UT
(
U   NUMBER(4),
S   NUMBER(4),
G   NUMBER(4)
);

INSERT INTO UT VALUES(2005,1012,1010);
INSERT INTO UT VALUES(2005,1012,1011);
INSERT INTO UT VALUES(2006,1013,1010);
INSERT INTO UT VALUES(2007,1017,1016);
INSERT INTO UT VALUES(2008,1018,1010);
INSERT INTO UT VALUES(2008,1018,1011);

INSERT INTO UT VALUES(2009,1019,1016);
INSERT INTO UT VALUES(2001,1020,1010);
INSERT INTO UT VALUES(2001,1020,1011);

COMMIT;

===

this query will identify all the security groups and the
minimum security group id of the identical one ...


SELECT  DISTINCT
S2.SORIGINAL_SG,/* original security group  */
S3.SEQUIV_SG/* equivalent security group*/
FROM(
SELECT  S, COUNT(*) RECS
FROMUT
GROUP   BY S
) S1,   /* security groups and their group counts - table1 */
(
SELECT  S, COUNT(*) RECS
FROMUT
GROUP   BY S
) S2,   /* security groups and their group counts - table2 */
(
SELECT  DISTINCT S
FROMUT
) S3/* just the unique security groups  */
WHERE   S1.RECS = S2.RECS   /* match the sec. groups with the same record
counts */
AND S1.S S2.S /* make sure they are NOT the same security
group*/
AND NOT EXISTS  /* make sure they include identical group ids
*/
(
SELECT  G FROM UT WHERE S = S1.S 
MINUS
SELECT  G FROM UT WHERE S = S2.S
)
AND S3.S = ( /* see note */
   SELECT MIN(S)
   FROM   UT
   WHERE  G IN
  (
  SELECT  G
  FROMUT
  WHERE   S = S1.S
  )
   )

/* note :
this is to find the minimum value of the security id which has the same
group
id records as that any of the matching security groups. this minimum value
can
be used to update the security group ids of all other identical security
groups
at a later point of time
*/




you can either change the query to update all the eligible security id to
their corresponding minimum values or generate equivalent update statements
using this query and run them as a batch ...

HTH ...


-Original Message-
Sent: Thursday, April 03, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L


Hi,
Sorry for reposting.
Just wanted to put in a subject...

I have been grappling with this for sometime and thought it will be best
for others to take a look at it.

I have a table a_user_groups

   USER_ID SECURITY_GROUP_ID   GROUP_ID
-- - --
  1005  1012   1010
  1005  1012   1011
  1006  1013   1010
  1007  1017   1016
  1008  1018   1010
  1008  1018   1011

The security_group_id currently is uniquely generated every time a user
is added and a group_id is associated with the user_id.
For eg: user_id 1005 is associated with groups 1010 and 1011. User 1008
has the same combination but the security_group_id is generated
differently.
The generation happens for C code and there is an option to correct the
problem in the C code but I am trying to see if I can prevent that

The requirement is that user_id 1008 and any other users with the same
group_id combination should have the same security_group_id 1012, 
basically the first occurrence for the combination. 
In the case of user_id 1006 the value for security_group_id is 1013 and
the group_id the user_id belongs to is 1016. So all the user_ids with a
group_id association 
of 1016 (1016 in a combination does not count) down the line will have to
be updated to 1013.

I found a solution for the case where I associate a group to a user_id in
this existing table by creating another table that converted the above
table into a hierarchy

Table b_hier_user_groups

   USER_ID   CGID PARENT_VALUE CHILD_VALUE
-- --  ---
  1005   1012 1010
  1005   1012 10101011
  1006   1013 1010
  1007   1017 1016
  1008   1018 1010
  1008   1018 10101011

Then using a PL/SQL script I generated the tree using sys_connect_by_path
I determined if the user had a path that already. 
For eg: in the above case if the user 1006 was being associated with
group_id 1011, then I would check the exsiting trees to see if there was
a path already as in 1010,1011.
In this case it does exist and the cgid (equivalent to security_group_id
in the above table) is 1012 and

alter table add

2003-04-03 Thread AK




I added a column using alter table add 
...
i can see it from sql . can select it from sql . 
But if I try to use it in a pl/sql block or procedure .It can't find that column 
.
is it a bug ? 

8.1.6. hp-ux

-ak

RE: oracle full table scan

I got the attachments... 


--- [EMAIL PROTECTED] wrote:
 Sorry, the attachments didn't make it, though they were only text.
 
 I can put them some accessible via the web if anyone wants them.
 
 Jared
 
 
 
 
 
 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  04/03/2003 11:34 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: oracle full table scan
 
 
 If you can change it to an IOT, it may be beneficial.
 
 There's no blanket clause to be used that says 'Always do this'.
 
 I higly encourage folks on this list to setup and use the run_stats
 method of comparing different access methods.  This is something
 Tom Kyte put together.  It is very simple to use.
 
 URL:  http://osi.oracle.com/~tkyte/runstats.html
 
 I've attached my versions of the scripts for your convenience.
 
 You can use these to easily compare unindexed vs indexed
 reads on small tables, indexed vs IOT, etc.
 
 Jared
 
 
 
 
 
 
 
 Jamadagni, Rajendra [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
  04/03/2003 10:05 AM
  Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: oracle full table scan
 
 
 Thanks Jared, 
 What if my developer is selecting all or most of the records from the
 
 table and not all the columns in the select list are in the index
 that 
 should have been used?
 I understand your point, in fact to use Jonathan's words .. should a
 
 small lookup table BE an index (IOT)? ... I am testing this approach
 here 
 
 and have found some performance benefit out of it. 
 Cheers 
 Raj 


 
 
 Rajendra dot Jamadagni at nospamespn dot com 
 All Views expressed in this email are strictly personal. 
 QOTD: Any clod can have facts, having an opinion is an art ! 
 
 -Original Message- 
 Sent: Thursday, April 03, 2003 1:01 PM 
 To: [EMAIL PROTECTED] 
 Cc: Jamadagni, Rajendra 
 Importance: High 
 
 Raj, 
 Indexing small tables is a good thing if you are doing single row
 lookups. 
 
 An index read and lookup by rowid is much more scalable than 
 doing an  FTS, even if the table is only 2 blocks. 
 Jared 
 
 
 
 
 
 
 The previous attachment was filtered out by the ListGuru mailing
 software at fatcity.com because binary attachments are not
 appropriate
 for mailing lists.  If you want a copy of the attachment which was
 removed, contact the sender directly and ask for it to be sent to
 you by private E-mail.
 
 This warning is inserted into all messages containing binary
 attachments which have been removed by ListGuru.  If you have
 questions
 about this message, contact [EMAIL PROTECTED] for clarification.
 The previous attachment was filtered out by the ListGuru mailing
 software at fatcity.com because binary attachments are not
 appropriate
 for mailing lists.  If you want a copy of the attachment which was
 removed, contact the sender directly and ask for it to be sent to
 you by private E-mail.
 
 This warning is inserted into all messages containing binary
 attachments which have been removed by ListGuru.  If you have
 questions
 about this message, contact [EMAIL PROTECTED] for clarification.
 The previous attachment was filtered out by the ListGuru mailing
 software at fatcity.com because binary attachments are not
 appropriate
 for mailing lists.  If you want a copy of the attachment which was
 removed, contact the sender directly and ask for it to be sent to
 you by private E-mail.
 
 This warning is inserted into all messages containing binary
 attachments which have been removed by ListGuru.  If you have
 questions
 about this message, contact [EMAIL PROTECTED] for clarification.
 The previous attachment was filtered out by the ListGuru mailing
 software at fatcity.com because binary attachments are not
 appropriate
 for mailing lists.  If you want a copy of the attachment which was
 removed, contact the sender directly and ask for it to be sent to
 you by private E-mail.
 
 This warning is inserted into all messages containing binary
 attachments which have been removed by ListGuru.  If you have
 questions
 about this message, contact [EMAIL PROTECTED] for clarification.
 The previous attachment was filtered out by the ListGuru mailing
 software at fatcity.com because binary attachments are not
 appropriate
 for mailing lists.  If you want a copy of the attachment which was
 removed, contact the sender directly and ask for it to be sent to
 you by private E-mail.
 
 This warning is inserted into all messages containing binary
 attachments which have been removed by ListGuru.  If you have
 questions
 about this message, contact [EMAIL PROTECTED] for clarification.
 
 
 

 ATTACHMENT part 2 application/octet-stream name=view.sql
 The previous attachment was filtered out by the ListGuru mailing
 software at fatcity.com because binary

RE: RMAN: What blocks are backed up with a full backup?

2003-04-03 Thread Freeman Robert - IL

Actually this is how RMAN works. It writes all blocks up to the HWM of a
given table,
even empty ones. So, if your HWM is artifically high, you will encounter
backups
that are larger than they need to be.

Oracle9i RMAN Backup and Recovery On bookshelves now!

RF


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/3/2003 11:19 AM

Keith
   Here is my understanding (don't rely on this one). When Oracle
allocates
tablespace, the disk blocks are cleared. My interpretation is that when
RMAN
encounters a clear block, it doesn't write it to the backup piece. I
don't
think it spends a lot of time trying to figure out above HWM and such.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, April 03, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L


Our RMAN backup is backing up much more than the actual data blocks when
doing a full backup. I know that it backs up all blocks that have ever
been
used, but I'm trying to figure out exactly what that means. My first
thought was that it backs up all blocks below the HWM, but I analyzed
the
tables and that is not the case.

Sometimes it backs up more blocks than exist below the HWM for the
tables
and sometimes it backs up fewer blocks than those below the HWM.

We are doing this to determine what we can do to reduce the size of the
backup.

Anyone have an idea how this works?

Keith


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: certifications was Re: Remote DBA

2003-04-03 Thread Ramesh Papnoi

Joe,Dennis  John
U must b knowing OCP takes $$ and these were free of cost, done around 1~1.5
years back. Now these are also chargeable. Anyway I am going to remove those
from my signature!! (Offcourse, I am not adding a new signature as
ListMember for [EMAIL PROTECTED] :)

Best Regards
Ramesh D. Papnoihttp://www22.brinkster.com/rpapnoi

-Original Message-
WILLIAMS
Sent: Thursday, April 03, 2003 10:44 PM
To: Multiple recipients of list ORACLE-L


John - Thanks for the encouragement. I'll get cracking on the next exam this
weekend!!

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, April 03, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L


Say what you think Joe,
When I have been looking for contacts several agencies have asked me to take
those tests as a means of ensuring that I know what I am supposed to know.
They act as a pre-interview filter
If it sorts the wheat  from the chaff then I don't think they perform a bad
service in that respect.
However as far as being touted as a professional qualification as Ramesh is
using them then I think I would forget about it.

I think anybody who contributes to this list claiming to be this, that or
the other is setting himself up for a fall.

Dennis has got the idea by having 40% OCP in his sig (however that has been
there so long now that the exams probably need re-taking now )

John


-Original Message-
Sent: 03 April 2003 12:24
To: Multiple recipients of list ORACLE-L


Ramesh, since in your sig line you say you're brainbench and brainbuzz
certified, do you really think those tests have any meaning, i took them
and thought they were a joke.

joe


Ramesh Papnoi wrote:

It can be Unix as well as Windows. As I have to support various DB's

Best Regards
Ramesh D. Papnoi   http://www22.brinkster.com/rpapnoi
(Brainbench  Brainbuzz certified Oracle 8/8i DBA  Developer)

-Original Message-
Adar
Sent: Thursday, April 03, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


You did not mentioned what OS you are working on.
If the remote database is on your network, even via wan, you can activate
all the tools from your desktop.
We use RAS to connect to remote servers without network connections and
then
you have SLOW network connection and your tools will work.
If the need arise you can use Netop or other PcAnywhere to take control of
the server and do your work from there.

We are on windows servers and clients.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:34 PM




Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate


if


any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).




--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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

RE: RMAN: What blocks are backed up with a full backup?