RE: Strange Query Result,... urgent please

[Wendry]

Thanks for the reply Tim,

I will try to look at the index and bad blocks at the datafile or
restart the database again. The type column for QTY_SOLD_SO is number.

Regards,

Wendry.

-Original Message-
Sent: Saturday, January 17, 2004 9:15 PM
To: 'Wendry'

I would suspect some problems with indexes on the tables.

I would recreate the tables using different names for testing, with the
same
data
and see if you get the same problems.

If it is still does not work maybe it is bad blocks on the database or
damaged Oracle proccess in which case restart the database.
Also try turning on tracing and check the output.

It could also be a bug with the group by function check to see what
column
type SO and QTY_SOLD_SO is and check metalink to see if it is a bug with
using group by on your version of Oracle with that particular data type.

-Original Message-
Sent: Saturday, January 17, 2004 2:59 PM
To: LazyDBA.com Discussion

Dear All,

I need help on the following query, the following has been simplified to
show you the exact problem. Due to this error, the sql query is giving
unstable result which affects on production reporting in my company. I
wonder what's the real problem?

SQL> SELECT COUNT(1) FROM
  2  (SELECT SO,SUM(QTY_SOLD_SO) AS QTY_SOLD
  3   FROM IVC_DET IVC
  4   GROUP BY SO
  5  );

  COUNT(1)
--
 44087

SQL> l
  1  SELECT COUNT(1) FROM
  2  (SELECT SO,SUM(QTY_SOLD_SO) AS QTY_SOLD
  3   FROM IVC_DET IVC
  4   GROUP BY SO
  5* )
SQL> /

  COUNT(1)
--
 44085

>From the above query nobody has changed any record in my production
database but the result is unstable. After I remove group function it
becomes stable as below.

SQL> SELECT COUNT(1) FROM
  2  (SELECT SO
  3   FROM IVC_DET IVC
  4   GROUP BY SO
  5  );

  COUNT(1)
--
 50770

SQL> /

  COUNT(1)
--
 50770

Now my opinion is the sort process has been ruined. I checked alert.log
but
I found no entries regarding this problem. So I check the sort ratio
through
performance manager and it shows almost 100% hit ratio. Well, just in
case,
next I checked on my Temporary tablespace and it still has a lot of room
to
do sorts. Anyone has experience this before? Please give me some light,
ideas or suggestion to correct this, since I have a lot of very complex
queries. I feel like a bomb is ticking for other complex queries. Thank
you
all in advance.

Regards,

Wendry.



Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM
questions Oracle documentation is here: http://tahiti.oracle.com To
unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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: Strange Query Result,... urgent please

[Tanel Poder]

Hi!

Use SET TRANSACTION READ ONLY before your run the queries and run them again
(without any commits or rollbacks in the middle). That way you can be sure
that any hidden changes to data won't be reflected.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, January 17, 2004 3:54 PM


>
>
> Dear All,
>
> I need help on the following query, the following has been simplified to
> show you the exact problem. Due to this error, the sql query is giving
> unstable result which affects on production reporting in my company. I
> wonder what's the real problem?
>
> SQL> SELECT COUNT(1) FROM
>   2  (SELECT SO,SUM(QTY_SOLD_SO) AS QTY_SOLD
>   3   FROM IVC_DET IVC
>   4   GROUP BY SO
>   5  );
>
>   COUNT(1)
> --
>  44087
>
> SQL> l
>   1  SELECT COUNT(1) FROM
>   2  (SELECT SO,SUM(QTY_SOLD_SO) AS QTY_SOLD
>   3   FROM IVC_DET IVC
>   4   GROUP BY SO
>   5* )
> SQL> /
>
>   COUNT(1)
> --
>  44085
>
> >From the above query nobody has changed any record in my production
> database but the result is unstable. After I remove group function it
> becomes stable as below.
>
> SQL> SELECT COUNT(1) FROM
>   2  (SELECT SO
>   3   FROM IVC_DET IVC
>   4   GROUP BY SO
>   5  );
>
>   COUNT(1)
> --
>  50770
>
> SQL> /
>
>   COUNT(1)
> --
>  50770
>
> Now my opinion is the sort process has been ruined. I checked alert.log
> but I found no entries regarding this problem. So I check the sort ratio
> through performance manager and it shows almost 100% hit ratio. Well,
> just in case, next I checked on my Temporary tablespace and it still has
> a lot of room to do sorts. Anyone has experience this before? Please
> give me some light, ideas or suggestion to correct this, since I have a
> lot of very complex queries. I feel like a bomb is ticking for other
> complex queries. Thank you all in advance.
>
> Regards,
>
> Wendry.
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Wendry
>   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: Tanel Poder
  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).

Strange Query Result,... urgent please

[Wendry]

Dear All,

I need help on the following query, the following has been simplified to
show you the exact problem. Due to this error, the sql query is giving
unstable result which affects on production reporting in my company. I
wonder what's the real problem?

SQL> SELECT COUNT(1) FROM
  2  (SELECT SO,SUM(QTY_SOLD_SO) AS QTY_SOLD
  3   FROM IVC_DET IVC
  4   GROUP BY SO
  5  );

  COUNT(1)
--
 44087

SQL> l
  1  SELECT COUNT(1) FROM
  2  (SELECT SO,SUM(QTY_SOLD_SO) AS QTY_SOLD
  3   FROM IVC_DET IVC
  4   GROUP BY SO
  5* )
SQL> /

  COUNT(1)
--
 44085

>From the above query nobody has changed any record in my production
database but the result is unstable. After I remove group function it
becomes stable as below.

SQL> SELECT COUNT(1) FROM
  2  (SELECT SO
  3   FROM IVC_DET IVC
  4   GROUP BY SO
  5  );

  COUNT(1)
--
 50770

SQL> /

  COUNT(1)
--
 50770

Now my opinion is the sort process has been ruined. I checked alert.log
but I found no entries regarding this problem. So I check the sort ratio
through performance manager and it shows almost 100% hit ratio. Well,
just in case, next I checked on my Temporary tablespace and it still has
a lot of room to do sorts. Anyone has experience this before? Please
give me some light, ideas or suggestion to correct this, since I have a
lot of very complex queries. I feel like a bomb is ticking for other
complex queries. Thank you all in advance.

Regards,

Wendry.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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: Problem with archive log when testing recovery..., urgent

[Wendry]

Well, I think I forget the alter system switch logfile before shutdown
and after restart. I'll try that n let you all know the result.

Regards,

Wendry.

-Original Message-
Sent: Tuesday, January 13, 2004 6:07 PM
To: Wendry

Nothing major amiss there, that is exactly what I do.

However, remember to do an alter system switch logfile, before
shutting the DB, then backup, restart, alter system switch logfile,
and take all the logfiles upto and including that created on the
second logfile switch.

I'd suspect that not switching before shutting down may be the
cause, but I'm working on the logic as to why.

Let me know how it goes.

Cheers

GJC

The fifty dwarves were reduced to eight,
before anyone suspected hungry.

__ 
Gary Colbran

System/Database Administrator 
Telkom SA 
55 Oak Avenue
Centurian
South Africa
Ph: 012-680 1315.
Ph: 082-786 6592.
[EMAIL PROTECTED]   
   
  
**Disclaimer**
**

Information contained in this E-MAIL being proprietary to Telkom SA
and is 
'privileged' and 'confidential' and intended for use only by the
individual
 or entity to which it is addressed. You are notified that any use,
copying 
or dissemination of the information contained in the E-MAIL in any
manner 
whatsoever is strictly prohibited.

**
*



-Original Message-
Sent: 12 January 2004 16:09
To: Gary Colbran (GJ); Multiple recipients of list ORACLE-L


Thank you for your reply,

Yes, you're quite right, I think the archive next to the cold backup
is
corrupted. The hot backup is always succeeded. But I wonder why is my
cold backup is largely end up with internal error or corrupted archive
log files. 

All I do for closed  backup is shutdown immediate, copy all
controlfiles, datafiles and redo log files to backup destination, and
then reopen the database. Is there any steps that I left which cause
the
archive log to be corrupted? Thank you in advance.

Regards,

Wendry.


-Original Message-
Sent: Monday, January 12, 2004 12:36 PM
To: Wendry

In which order did you perform the backups ?

Say you do the cold backup, and the next archive is corrupted.

You then do a hot backup. Restore the cold backup and the
archive needs to be applied.

Restore the hot backup, and it is after the corrupted archive.

Does the corruption occur with an archive used by the cold
backup, but not the hot backup ?

Cheers

GJC

The fifty dwarves were reduced to eight,
before anyone suspected hungry.

__ 
Gary Colbran

System/Database Administrator 
Telkom SA 
55 Oak Avenue
Centurian
South Africa
Ph: 012-680 1315.
Ph: 082-786 6592.
[EMAIL PROTECTED]   
   
  
**Disclaimer**
**

Information contained in this E-MAIL being proprietary to Telkom SA
and is 
'privileged' and 'confidential' and intended for use only by the
individual
 or entity to which it is addressed. You are notified that any use,
copying 
or dissemination of the information contained in the E-MAIL in any
manner 
whatsoever is strictly prohibited.

**
*



-Original Message-
Sent: 16 January 2004 03:16
To: LazyDBA.com Discussion




 Hi all,

 I have done closed and open backup on my database. Later on I try to
test
my
 backup. So I try the closed backup that I've taken. The backup
database can
 be opened succesfully. But when I try to recover database using
backup
 controlfile, the archive logs giving me internal error (sometimes
after
 applying 1st to 5th archive log), sometimes it gave me notification
that
the
 archive logs is corrupted.

 Strangely when I test my open backup, and recover it using the same
set of
 archive logs, the process went smoothly. So what is the real problem
here,
I
 really don't have any idea. Is there somebody have the same
experience? Now
 I'm in doubt of planning my backup schedule, please help... Thanks a
lot.

 Regards,

 Wendry.




Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to
[EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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 f

Re: Problem with archive log when testing recovery..., urgent

[Tim Gorman]

Are you certain that SHUTDOWN IMMEDIATE succeeded?  There are lots of bugs
in MetaLink where it "hangs" or fails with ORA-00600...


on 1/12/04 7:04 AM, Wendry at [EMAIL PROTECTED] wrote:

> Thank you for your reply,
> 
> Yes, you're quite right, I think the archive next to the cold backup is
> corrupted. The hot backup is always succeeded. But I wonder why is my
> cold backup is largely end up with internal error or corrupted archive
> log files. 
> 
> All I do for closed  backup is shutdown immediate, copy all
> controlfiles, datafiles and redo log files to backup destination, and
> then reopen the database. Is there any steps that I left which cause the
> archive log to be corrupted? Thank you in advance.
> 
> Regards,
> 
> Wendry.
> 
> 
> -Original Message-
> Sent: Monday, January 12, 2004 12:36 PM
> To: Wendry
> 
> In which order did you perform the backups ?
> 
> Say you do the cold backup, and the next archive is corrupted.
> 
> You then do a hot backup. Restore the cold backup and the
> archive needs to be applied.
> 
> Restore the hot backup, and it is after the corrupted archive.
> 
> Does the corruption occur with an archive used by the cold
> backup, but not the hot backup ?
> 
> Cheers
> 
> GJC
> 
> The fifty dwarves were reduced to eight,
> before anyone suspected hungry.
> 
> __
> Gary Colbran
> 
> System/Database Administrator
> Telkom SA 
> 55 Oak Avenue
> Centurian
> South Africa
> Ph: 012-680 1315.
> Ph: 082-786 6592.
> [EMAIL PROTECTED] 
> 
> 
> **Disclaimer**
> **
> 
> Information contained in this E-MAIL being proprietary to Telkom SA
> and is 
> 'privileged' and 'confidential' and intended for use only by the
> individual
> or entity to which it is addressed. You are notified that any use,
> copying 
> or dissemination of the information contained in the E-MAIL in any
> manner 
> whatsoever is strictly prohibited.
> 
> **
> *
> 
> 
> 
> -Original Message-
> Sent: 16 January 2004 03:16
> To: LazyDBA.com Discussion
> 
> 
> 
> 
> Hi all,
> 
> I have done closed and open backup on my database. Later on I try to
> test
> my
> backup. So I try the closed backup that I've taken. The backup
> database can
> be opened succesfully. But when I try to recover database using
> backup
> controlfile, the archive logs giving me internal error (sometimes
> after
> applying 1st to 5th archive log), sometimes it gave me notification
> that
> the
> archive logs is corrupted.
> 
> Strangely when I test my open backup, and recover it using the same
> set of
> archive logs, the process went smoothly. So what is the real problem
> here,
> I
> really don't have any idea. Is there somebody have the same
> experience? Now
> I'm in doubt of planning my backup schedule, please help... Thanks a
> lot.
> 
> Regards,
> 
> Wendry.
> 
> 
> 
> 
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to
> [EMAIL PROTECTED]
> To subscribe:   send a blank email to [EMAIL PROTECTED]
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  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: Problem with archive log when testing recovery..., urgent

[Wendry]

Thank you for your reply,

Yes, you're quite right, I think the archive next to the cold backup is
corrupted. The hot backup is always succeeded. But I wonder why is my
cold backup is largely end up with internal error or corrupted archive
log files. 

All I do for closed  backup is shutdown immediate, copy all
controlfiles, datafiles and redo log files to backup destination, and
then reopen the database. Is there any steps that I left which cause the
archive log to be corrupted? Thank you in advance.

Regards,

Wendry.


-Original Message-
Sent: Monday, January 12, 2004 12:36 PM
To: Wendry

In which order did you perform the backups ?

Say you do the cold backup, and the next archive is corrupted.

You then do a hot backup. Restore the cold backup and the
archive needs to be applied.

Restore the hot backup, and it is after the corrupted archive.

Does the corruption occur with an archive used by the cold
backup, but not the hot backup ?

Cheers

GJC

The fifty dwarves were reduced to eight,
before anyone suspected hungry.

__ 
Gary Colbran

System/Database Administrator 
Telkom SA 
55 Oak Avenue
Centurian
South Africa
Ph: 012-680 1315.
Ph: 082-786 6592.
[EMAIL PROTECTED]   
   
  
**Disclaimer**
**

Information contained in this E-MAIL being proprietary to Telkom SA
and is 
'privileged' and 'confidential' and intended for use only by the
individual
 or entity to which it is addressed. You are notified that any use,
copying 
or dissemination of the information contained in the E-MAIL in any
manner 
whatsoever is strictly prohibited.

**
*



-Original Message-
Sent: 16 January 2004 03:16
To: LazyDBA.com Discussion




 Hi all,

 I have done closed and open backup on my database. Later on I try to
test
my
 backup. So I try the closed backup that I've taken. The backup
database can
 be opened succesfully. But when I try to recover database using
backup
 controlfile, the archive logs giving me internal error (sometimes
after
 applying 1st to 5th archive log), sometimes it gave me notification
that
the
 archive logs is corrupted.

 Strangely when I test my open backup, and recover it using the same
set of
 archive logs, the process went smoothly. So what is the real problem
here,
I
 really don't have any idea. Is there somebody have the same
experience? Now
 I'm in doubt of planning my backup schedule, please help... Thanks a
lot.

 Regards,

 Wendry.




Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to
[EMAIL PROTECTED]
To subscribe:   send a blank email to [EMAIL PROTECTED]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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: Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please

[John Flack]

For one thing, please don't install 8.1.6.  Install at least 8.1.7 and upgrade it to 
8.1.7.4.  You will be much better off.  Actually, providing your system meets or 
exceeds the minimum requirements stated in the installation manual, this install goes 
fairly easily.  DO read the installation manual and read me docs.  Ask if you have 
more specific questions.

-Original Message-
Sent: Friday, January 09, 2004 8:29 AM
To: Multiple recipients of list ORACLE-L
9i, urgent.. please


Hi all,

I'd like to ask you about any steps that I should do additionally on
installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os
of windows 2000. I need to get this working by 2 days. So I really need
help on this, thanks.

Regards

Wendry.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  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).

Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please

[Wendry]

Hi all,

I'd like to ask you about any steps that I should do additionally on
installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os
of windows 2000. I need to get this working by 2 days. So I really need
help on this, thanks.

Regards

Wendry.

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

Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please

[Wendry]

Hi all,

I'd like to ask you about any steps that I should do additionally on
installing oracle 8.1.6.0.0 and 9i on server HP proliant ML 350, with os
of windows 2000. I need to get this working by 2 days. So I really need
help on this, thanks.

Regards

Wendry.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  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: recreate constraints script - URGENT

[Austin Hackett]

TOAD has a 'Generate Schema script' function and if I recall correctly
you can specify the objects that you want the script to include. You can
download an evaluation copy at
http://www.quest.com/solutions/download.asp
On Tue, 2003-12-30 at 19:24, system manager wrote:
> Dear all, I have a script to generate constraints for a single table
> but I need a script to generate constraints for a schema owner .   Can
> anyone send me  a copy?
> 
> Many thanks,
> 
> _
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
> Looking for friendships,romance and more?
> http://www.MyOwnFriends.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Austin Hackett
  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: recreate constraints script - URGENT

[Tanel Poder]

Yep, that's a good call, although there was some bug with paritioned tables
I think...

Also, metalink note 1016836.6 has a script for capturing constraints.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 11:49 PM


>
> For 9i DBs, DBMS_METADATA will (re)create DDL for every (at least most)
> object in the DB.
>
>
> -- 
> 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: Tanel Poder
  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: Re:Re: recreate constraints script - URGENT

[Tanel Poder]

There are probably such scripts in internet, or you can write your own in
few minutes, but if you need it only once, then one easy way would be just
to use TOAD (free/shareware ver) or similar tools to extract scripts of your
constraints from database.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 11:09 PM


> Thanks Ron, I got this recreate constraints script from our list but
> lost it.It was really good script and it can re-generate all the
> constraints under a schema owner.
> --
> Original Message
> Date: Tue, 30 Dec 2003 12:14:26 -0800
>
> >dba_constraint will inform you of the tables that have constraints and
> >what type of constraint they are.
> >Further digging into the dba_  tables will provide the information you
> >desire. Keep the scripts as part of the database documentation and
> >update when needed.
> >Third party software can provide the scripts for the entire database.
> >Ron
> >
>  [EMAIL PROTECTED] 12/30/2003 2:24:25 PM >>>
> >
> >Dear all, I have a script to generate constraints for a single
> >table
> >but I need a script to generate constraints for a schema owner .   Can
> >anyone send me  a copy?
> >
> >Many thanks,
> >
> >_
> >Free email with personality! Over 200 domains!
> >http://www.MyOwnEmail.com
> >Looking for friendships,romance and more?
> >http://www.MyOwnFriends.com
> >
> >-- 
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >-- 
> >Author: system manager
> >  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: 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).
> >
>
> _
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
> Looking for friendships,romance and more?
> http://www.MyOwnFriends.com
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: system manager
>   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: Tanel Poder
  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: recreate constraints script - URGENT

[Charlie_Mengler]

For 9i DBs, DBMS_METADATA will (re)create DDL for every (at least most)
object in the DB.


-- 
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: recreate constraints script - URGENT

[Jared . Still]

If you have one to generate the constraints for a table, just modify
it slightly to include a whole schema.

Just checked, I don't have such a beastie.

Check orafaq.com, likely there is one there.

Jared








"system manager" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/30/2003 11:24 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        recreate constraints script - URGENT



Dear all,     I have a script to generate constraints for a single table
but I need a script to generate constraints for a schema owner .   Can
anyone send me  a copy?

Many thanks,

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: system manager
  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:RE: recreate constraints script - URGENT

[system manager]

Thanks Rajendra, Good idea but I have 1200  tables :(I got a good
script from our list long time ago but lost it.That script can capiture
constraints for the schema owner.
--
Original Message
Date: Tue, 30 Dec 2003 11:39:26 -0800

>run the same script for every table for the schema owner and spool
everything to the same file 
>... there you have it.
>
>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: Tuesday, December 30, 2003 2:24 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Dear all, I have a script to generate constraints for a single table
>but I need a script to generate constraints for a schema owner .   Can
>anyone send me  a copy?
>
>Many thanks,
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>Looking for friendships,romance and more?
>http://www.MyOwnFriends.com
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: system manager
>  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: Jamadagni, Rajendra
>  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).
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: system manager
  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:Re: recreate constraints script - URGENT

[system manager]

Thanks Ron, I got this recreate constraints script from our list but
lost it.It was really good script and it can re-generate all the
constraints under a schema owner.
--
Original Message
Date: Tue, 30 Dec 2003 12:14:26 -0800

>dba_constraint will inform you of the tables that have constraints and
>what type of constraint they are.
>Further digging into the dba_  tables will provide the information you
>desire. Keep the scripts as part of the database documentation and
>update when needed.
>Third party software can provide the scripts for the entire database.
>Ron
>
 [EMAIL PROTECTED] 12/30/2003 2:24:25 PM >>>
>
>Dear all, I have a script to generate constraints for a single
>table
>but I need a script to generate constraints for a schema owner .   Can
>anyone send me  a copy?
>
>Many thanks,
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com 
>Looking for friendships,romance and more?
>http://www.MyOwnFriends.com 
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net 
>-- 
>Author: system manager
>  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: 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).
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: system manager
  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: recreate constraints script - URGENT

[Ron Rogers]

dba_constraint will inform you of the tables that have constraints and
what type of constraint they are.
Further digging into the dba_  tables will provide the information you
desire. Keep the scripts as part of the database documentation and
update when needed.
Third party software can provide the scripts for the entire database.
Ron

>>> [EMAIL PROTECTED] 12/30/2003 2:24:25 PM >>>

Dear all, I have a script to generate constraints for a single
table
but I need a script to generate constraints for a schema owner .   Can
anyone send me  a copy?

Many thanks,

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com 
Looking for friendships,romance and more?
http://www.MyOwnFriends.com 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: system manager
  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: 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: recreate constraints script - URGENT

[Jamadagni, Rajendra]

run the same script for every table for the schema owner and spool everything to the 
same file ... there you have it.

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: Tuesday, December 30, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L



Dear all, I have a script to generate constraints for a single table
but I need a script to generate constraints for a schema owner .   Can
anyone send me  a copy?

Many thanks,

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: system manager
  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: Jamadagni, Rajendra
  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).

recreate constraints script - URGENT

[system manager]

Dear all, I have a script to generate constraints for a single table
but I need a script to generate constraints for a schema owner .   Can
anyone send me  a copy?

Many thanks,

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: system manager
  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: SQL*Plus question - a bit urgent - Can we suppress 'Connected

[Stephen.Lee]

My reply was probably a bit too brief.  The most robust way for doing this
would be to use pattern matching utilities such as sed and awk (Perl? What's
Perl?) to parse that output for stuff like
ORA- (N is a digit of a number)
TNS-
SP-
etc.

But for a quick and dirty approach, select an additional dummy word in the
select statement then parse for that word as the first word in the line;
that's what the "read" statement does for you.  You could add another
condition outside the "while read" loop to see if the value you got is
reasonable.  For example set MY_VARIABLE='BROKE' before running sqlplus,
then see if MY_VARIABLE is still BROKE or empty when the loop is done.

> -Original Message-
> 
> I take back that statement of mine. Gotta take Unix lessons.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San 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: SQL*Plus question - a bit urgent - Can we suppress 'Connected

[Charu Joshi]

-- I don't know if a return value can be gathered in a
-- shell variable except by using ` chars.


Sorry, Stephen had already mentioned one other way:



} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"  # << Will do.



I take back that statement of mine. Gotta take Unix lessons.

Thanks & regards,
Charu.

-Original Message-
Sent: 06 November 2003 10:09
To: [EMAIL PROTECTED]
'Connected

Thanks Stephen,

The reason for using ` characters was because I wanted the output
(a filename) in a variable. After that, the variable would be
passed to other scripts for file creation, FTP etc. I don't know
if a return value can be gathered in a shell variable except by
using ` chars.

I was trying to suppress 'Connected.' line using SQL*Plus itself.
Once Stephane suggested grep (i.e. suppress from Unix),
possibilities broadened considerably. I will keep the 'while read'
option in mind for future.

Thanks & regards,
Charu.

-Original Message-
Behalf Of
[EMAIL PROTECTED]
Sent: 05 November 2003 21:15
To: Multiple recipients of list ORACLE-L
'Connected

Rather than try to get output using the ` characters, see what you
can do
with this method:

{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages 
set whatever else
do this;
do that;
do the other thing;
XXX
} | while read LINE; do
parse $LINE with sed, awk, whatever
if [ this is true ]; then
do something
fi
done

If all you want is to do a simple select that is supposed to
return one
line, one cheap, but not especially robust, way of doing it is
like

{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages 
set whatever else
select 'DOINK',name from v$database;
-- or select 'DOINK '||name from v$database;
XXX
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"
fi
done

Now, if one is proficient in sed and awk, more elegant and robust
means can
be devised.

> -Original Message-
> From: Charu Joshi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 6:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Plus question - a bit urgent - Can we suppress
> 'Connected.'
> message?
>
>
> Hello all,
>
> I am calling SQL*Plus from a unix shell script and storing the
> results of the query executed in a shell variable. It goes like
> this:
>
> FL_SUFFIX=`sqlplus -s /nolog <SET ECHO OFF
>SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>CONN $ORA_ID/$ORA_PASS
>
>SELECT dummy FROM dual; -- Dummy query.. unrelated to
> the question.
>
>EXIT SQL.SQLCODE
>
> EndOfSQL`
>
> But the contents of the FL_SUFFIX are 'Connected.' instead of
the
> value returned by the query.
>
> This is obviously because of the 'CONN $ORA_ID/$ORA_PASS'
> statement. Is there a way to suppress the 'Connected.' message
> that comes on connecting to database?
>
> I have thought about 2 solutions:
>
> 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last
> alternative in case everything else fails .. obviously from
> security point of view.
>
> 2. Create a .sql script as:
>
> SET ECHO OFF
> SET FEEDBACK OFF
> SET VERIFY OFF
> SET PAGESIZE 0
>
> SET TERMOUT OFF  -- The important bits.
> SPOOL /dev/null  --
> CONN $ORA_ID/$ORA_PASS
> SPOOL OFF  --
> SET TERMOUT ON -- The important bits.
>
> SELECT dummy FROM dual; -- Dummy query.
>
> EXIT SQL.SQLCODE
>
> and then call this script as
>
> FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
> I think solution 2 will work, but I am loathe to writing a
script
> for a single SQL statement unless there is no other way.
>
> Any new ideas would be greatly appreciated, the quicker the
> better.
>
> Thanks & regards,
> Charu.
>
> *
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *
>
> Visit us at http://www.mahindrab

RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected

[Charu Joshi]

Thanks Stephen,

The reason for using ` characters was because I wanted the output
(a filename) in a variable. After that, the variable would be
passed to other scripts for file creation, FTP etc. I don't know
if a return value can be gathered in a shell variable except by
using ` chars.

I was trying to suppress 'Connected.' line using SQL*Plus itself.
Once Stephane suggested grep (i.e. suppress from Unix),
possibilities broadened considerably. I will keep the 'while read'
option in mind for future.

Thanks & regards,
Charu.

-Original Message-
Behalf Of
[EMAIL PROTECTED]
Sent: 05 November 2003 21:15
To: Multiple recipients of list ORACLE-L
'Connected

Rather than try to get output using the ` characters, see what you
can do
with this method:

{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages 
set whatever else
do this;
do that;
do the other thing;
XXX
} | while read LINE; do
parse $LINE with sed, awk, whatever
if [ this is true ]; then
do something
fi
done

If all you want is to do a simple select that is supposed to
return one
line, one cheap, but not especially robust, way of doing it is
like

{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages 
set whatever else
select 'DOINK',name from v$database;
-- or select 'DOINK '||name from v$database;
XXX
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"
fi
done

Now, if one is proficient in sed and awk, more elegant and robust
means can
be devised.

> -Original Message-
> From: Charu Joshi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 6:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Plus question - a bit urgent - Can we suppress
> 'Connected.'
> message?
>
>
> Hello all,
>
> I am calling SQL*Plus from a unix shell script and storing the
> results of the query executed in a shell variable. It goes like
> this:
>
> FL_SUFFIX=`sqlplus -s /nolog <SET ECHO OFF
>SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>CONN $ORA_ID/$ORA_PASS
>
>SELECT dummy FROM dual; -- Dummy query.. unrelated to
> the question.
>
>EXIT SQL.SQLCODE
>
> EndOfSQL`
>
> But the contents of the FL_SUFFIX are 'Connected.' instead of
the
> value returned by the query.
>
> This is obviously because of the 'CONN $ORA_ID/$ORA_PASS'
> statement. Is there a way to suppress the 'Connected.' message
> that comes on connecting to database?
>
> I have thought about 2 solutions:
>
> 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last
> alternative in case everything else fails .. obviously from
> security point of view.
>
> 2. Create a .sql script as:
>
> SET ECHO OFF
> SET FEEDBACK OFF
> SET VERIFY OFF
> SET PAGESIZE 0
>
> SET TERMOUT OFF  -- The important bits.
> SPOOL /dev/null  --
> CONN $ORA_ID/$ORA_PASS
> SPOOL OFF  --
> SET TERMOUT ON -- The important bits.
>
> SELECT dummy FROM dual; -- Dummy query.
>
> EXIT SQL.SQLCODE
>
> and then call this script as
>
> FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
> I think solution 2 will work, but I am loathe to writing a
script
> for a single SQL statement unless there is no other way.
>
> Any new ideas would be greatly appreciated, the quicker the
> better.
>
> Thanks & regards,
> Charu.
>
> *
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *
>
> Visit us at http://www.mahindrabt.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Charu Joshi
>   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

RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected

[Stephen.Lee]

Rather than try to get output using the ` characters, see what you can do
with this method:

{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages 
set whatever else
do this;
do that;
do the other thing;
XXX
} | while read LINE; do
parse $LINE with sed, awk, whatever
if [ this is true ]; then
do something
fi
done

If all you want is to do a simple select that is supposed to return one
line, one cheap, but not especially robust, way of doing it is like


{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages 
set whatever else
select 'DOINK',name from v$database;
-- or select 'DOINK '||name from v$database;
XXX
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"
fi
done

Now, if one is proficient in sed and awk, more elegant and robust means can
be devised.


> -Original Message-
> From: Charu Joshi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 6:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Plus question - a bit urgent - Can we suppress 
> 'Connected.'
> message?
> 
> 
> Hello all,
> 
> I am calling SQL*Plus from a unix shell script and storing the
> results of the query executed in a shell variable. It goes like
> this:
> 
> FL_SUFFIX=`sqlplus -s /nolog <SET ECHO OFF
>SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
> 
>CONN $ORA_ID/$ORA_PASS
> 
>SELECT dummy FROM dual; -- Dummy query.. unrelated to
> the question.
> 
>EXIT SQL.SQLCODE
> 
> EndOfSQL`
> 
> But the contents of the FL_SUFFIX are 'Connected.' instead of the
> value returned by the query.
> 
> This is obviously because of the 'CONN $ORA_ID/$ORA_PASS'
> statement. Is there a way to suppress the 'Connected.' message
> that comes on connecting to database?
> 
> I have thought about 2 solutions:
> 
> 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last
> alternative in case everything else fails .. obviously from
> security point of view.
> 
> 2. Create a .sql script as:
> 
> SET ECHO OFF
> SET FEEDBACK OFF
> SET VERIFY OFF
> SET PAGESIZE 0
> 
> SET TERMOUT OFF  -- The important bits.
> SPOOL /dev/null  --
> CONN $ORA_ID/$ORA_PASS
> SPOOL OFF  --
> SET TERMOUT ON -- The important bits.
> 
> SELECT dummy FROM dual; -- Dummy query.
> 
> EXIT SQL.SQLCODE
> 
> and then call this script as
> 
> FL_SUFFIX=`sqlplus -s /nolog @a.sql`
> 
> I think solution 2 will work, but I am loathe to writing a script
> for a single SQL statement unless there is no other way.
> 
> Any new ideas would be greatly appreciated, the quicker the
> better.
> 
> Thanks & regards,
> Charu.
> 
> *
> Disclaimer
> 
> This message (including any attachments) contains 
> confidential information intended for a specific 
> individual and purpose, and is protected by law. 
> If you are not the intended recipient, you should 
> delete this message and are hereby notified that 
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it, 
> is strictly prohibited.
> 
> *
> 
> Visit us at http://www.mahindrabt.com
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Charu Joshi
>   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: <[EMAIL PROTECTED]
  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: SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?

[Charu Joshi]

Thanks Stephane,

Your solution 3 has done the job for me.

Regards,
Charu.

-Original Message-
Stephane Faroult
Sent: 05 November 2003 18:10
To: Multiple recipients of list ORACLE-L
'Connected.' message?

You have multiple solutions; one would be to use an externally identified Oracle 
account; another one to use the hide.c program (should find it with google) to prevent 
people from seeing command arguments through 'ps'; another one to write something such 
as

myvar=`echo "your stuff here
 blabla
 exit" | sqlplus -s /nolog | grep -iv connected`

. just a few ideas.

HTH

SF

>- --- Original Message --- -
>From: "Charu Joshi" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Wed, 05 Nov 2003 04:04:38
>
>Hello all,
>
>I am calling SQL*Plus from a unix shell script and
>storing the
>results of the query executed in a shell variable.
>It goes like
>this:
>
>FL_SUFFIX=`sqlplus -s /nolog <   SET ECHO OFF
>   SET FEEDBACK OFF
>   SET VERIFY OFF
>   SET PAGESIZE 0
>
>   CONN $ORA_ID/$ORA_PASS
>
>   SELECT dummy FROM dual; -- Dummy query..
>unrelated to
>the question.
>
>   EXIT SQL.SQLCODE
>
>EndOfSQL`
>
>But the contents of the FL_SUFFIX are 'Connected.'
>instead of the
>value returned by the query.
>
>This is obviously because of the 'CONN
>$ORA_ID/$ORA_PASS'
>statement. Is there a way to suppress the
>'Connected.' message
>that comes on connecting to database?
>
>I have thought about 2 solutions:
>
>1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would
>be the last
>alternative in case everything else fails ..
>obviously from
>security point of view.
>
>2. Create a .sql script as:
>
>SET ECHO OFF
>SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>SET TERMOUT OFF  -- The important bits.
>SPOOL /dev/null  --
>CONN $ORA_ID/$ORA_PASS
>SPOOL OFF  --
>SET TERMOUT ON -- The important bits.
>
>SELECT dummy FROM dual; -- Dummy query.
>
>EXIT SQL.SQLCODE
>
>and then call this script as
>
>FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
>I think solution 2 will work, but I am loathe to
>writing a script
>for a single SQL statement unless there is no other
>way.
>
>Any new ideas would be greatly appreciated, the
>quicker the
>better.
>
>Thanks & regards,
>Charu.
>
-- 
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).

*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*

Visit us at http://www.mahindrabt.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Charu Joshi
  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: SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?

[Stephane Faroult]

You have multiple solutions; one would be to use an externally identified Oracle 
account; another one to use the hide.c program (should find it with google) to prevent 
people from seeing command arguments through 'ps'; another one to write something such 
as

myvar=`echo "your stuff here
 blabla
 exit" | sqlplus -s /nolog | grep -iv connected`

.. just a few ideas.

HTH

SF

>- --- Original Message --- -
>From: "Charu Joshi" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Wed, 05 Nov 2003 04:04:38
>
>Hello all,
>
>I am calling SQL*Plus from a unix shell script and
>storing the
>results of the query executed in a shell variable.
>It goes like
>this:
>
>FL_SUFFIX=`sqlplus -s /nolog <   SET ECHO OFF
>   SET FEEDBACK OFF
>   SET VERIFY OFF
>   SET PAGESIZE 0
>
>   CONN $ORA_ID/$ORA_PASS
>
>   SELECT dummy FROM dual; -- Dummy query..
>unrelated to
>the question.
>
>   EXIT SQL.SQLCODE
>
>EndOfSQL`
>
>But the contents of the FL_SUFFIX are 'Connected.'
>instead of the
>value returned by the query.
>
>This is obviously because of the 'CONN
>$ORA_ID/$ORA_PASS'
>statement. Is there a way to suppress the
>'Connected.' message
>that comes on connecting to database?
>
>I have thought about 2 solutions:
>
>1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would
>be the last
>alternative in case everything else fails ..
>obviously from
>security point of view.
>
>2. Create a .sql script as:
>
>SET ECHO OFF
>SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>SET TERMOUT OFF  -- The important bits.
>SPOOL /dev/null  --
>CONN $ORA_ID/$ORA_PASS
>SPOOL OFF  --
>SET TERMOUT ON -- The important bits.
>
>SELECT dummy FROM dual; -- Dummy query.
>
>EXIT SQL.SQLCODE
>
>and then call this script as
>
>FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
>I think solution 2 will work, but I am loathe to
>writing a script
>for a single SQL statement unless there is no other
>way.
>
>Any new ideas would be greatly appreciated, the
>quicker the
>better.
>
>Thanks & regards,
>Charu.
>
-- 
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).

SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?

[Charu Joshi]

Hello all,

I am calling SQL*Plus from a unix shell script and storing the
results of the query executed in a shell variable. It goes like
this:

FL_SUFFIX=`sqlplus -s /nolog 

Re: URGENT REPORTS

[Ed Lewis]

Gene,    
    Good stuff. Thanks for the tip.
        ed

  - Original Message - 
  From: 
  Gene Sais 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, September 24, 2003 6:29 
  PM
  Subject: RE: URGENT REPORTS
  
  What I like about VNC, is that all you need for a client is a 
  browser.  http://ip.address:5800 
  gets you a nice java client connection.
  Gene>>> [EMAIL PROTECTED] 09/24/03 
  06:14PM >>>If y'all do choose a VNC route, I'd highly recommend 
  the free and GPL'dTightVNC from http://www.tightvnc.com/Better 
  compression, better security, and better performance then 
  otherRFB-compliant VNC flavors.RichRich 
  Jesse   
  System/Database 
  Administrator[EMAIL PROTECTED]  
  Quad/Tech Inc, Sussex, WI USA-Original 
  Message-Sent: Wednesday, September 24, 2003 4:20 PMTo: Multiple 
  recipients of list ORACLE-LSetting up vnc server and directing 
  DISPLAY to that is easier, I think. Ihave a Apps reports server setup 
  which has run for few years for now withvnc server.Tanel.-- 
  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.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

RE: URGENT REPORTS

[Paula_Stankus]

Title: RE: URGENT REPORTS



Thanks.

  -Original Message-From: Binley Lim 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 
  1:05 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: URGENT REPORTS
  An X-DISPLAY application (Reports) needs to 
  access an X-display terminal in order for it to run. You can either give 
  it a real X-terminal, or you can simulate the functionality (pretend X 
  terminal) with software, either Xvbf or VNC. Since the application doesn't 
  need to really display anything, it doesn't know any better, so runs along 
  quite happily.
  
- Original Message - 
From: 
[EMAIL PROTECTED] 

To: Multiple recipients of list ORACLE-L 

Sent: Friday, September 26, 2003 4:15 
AM
Subject: RE: URGENT REPORTS

Guys, 
This is a stupid question but how is directing DISPLAY for 
reports with xterminal services versus the VNC route?  
-Original Message- From: 
Jesse, Rich [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 24, 2003 6:15 PM 
To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS 
If y'all do choose a VNC route, I'd highly recommend the 
free and GPL'd TightVNC from http://www.tightvnc.com/ 
Better compression, better security, and better performance 
then other RFB-compliant VNC flavors. 

Rich 
Rich 
Jesse   
System/Database Administrator [EMAIL PROTECTED]  
Quad/Tech Inc, Sussex, WI USA 
-Original Message- Sent: 
Wednesday, September 24, 2003 4:20 PM To: Multiple 
recipients of list ORACLE-L 
Setting up vnc server and directing DISPLAY to that is 
easier, I think. I have a Apps reports server setup 
which has run for few years for now with vnc 
server.   Tanel. 
-- 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: URGENT REPORTS

[Binley Lim]

Title: RE: URGENT REPORTS



An X-DISPLAY application (Reports) needs to access 
an X-display terminal in order for it to run. You can either give it a real 
X-terminal, or you can simulate the functionality (pretend X terminal) with 
software, either Xvbf or VNC. Since the application doesn't need to really 
display anything, it doesn't know any better, so runs along quite 
happily.

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, September 26, 2003 4:15 
  AM
  Subject: RE: URGENT REPORTS
  
  Guys, 
  This is a stupid question but how is directing DISPLAY for 
  reports with xterminal services versus the VNC route?  
  -Original Message- From: 
  Jesse, Rich [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, September 24, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS 
  If y'all do choose a VNC route, I'd highly recommend the free 
  and GPL'd TightVNC from http://www.tightvnc.com/ 
  Better compression, better security, and better performance 
  then other RFB-compliant VNC flavors. 
  Rich 
  Rich 
  Jesse   
  System/Database Administrator [EMAIL PROTECTED]  
  Quad/Tech Inc, Sussex, WI USA 
  -Original Message- Sent: 
  Wednesday, September 24, 2003 4:20 PM To: Multiple 
  recipients of list ORACLE-L 
  Setting up vnc server and directing DISPLAY to that is easier, 
  I think. I have a Apps reports server setup which has 
  run for few years for now with vnc server. 
    Tanel. -- 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: URGENT REPORTS

[Tanel Poder]

Title: RE: URGENT REPORTS



You got to have xvnc server installed somewhere, 
then you can direct any X app to it as you would do with normal X. So the app 
appears on vnc virtual display and if you want to see it, you have to connect to 
this virtual display using vncviewer.
 
Tanel.
 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, September 25, 2003 7:15 
  PM
  Subject: RE: URGENT REPORTS
  
  Guys, 
  This is a stupid question but how is directing DISPLAY for 
  reports with xterminal services versus the VNC route?  
  -Original Message- From: 
  Jesse, Rich [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, September 24, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT REPORTS 
  If y'all do choose a VNC route, I'd highly recommend the free 
  and GPL'd TightVNC from http://www.tightvnc.com/ 
  Better compression, better security, and better performance 
  then other RFB-compliant VNC flavors. 
  Rich 
  Rich 
  Jesse   
  System/Database Administrator [EMAIL PROTECTED]  
  Quad/Tech Inc, Sussex, WI USA 
  -Original Message- Sent: 
  Wednesday, September 24, 2003 4:20 PM To: Multiple 
  recipients of list ORACLE-L 
  Setting up vnc server and directing DISPLAY to that is easier, 
  I think. I have a Apps reports server setup which has 
  run for few years for now with vnc server. 
    Tanel. -- 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: URGENT REPORTS

[Paula_Stankus]

Title: RE: URGENT REPORTS





Guys,


This is a stupid question but how is directing DISPLAY for reports with xterminal services versus the VNC route?  


-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 24, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT REPORTS



If y'all do choose a VNC route, I'd highly recommend the free and GPL'd
TightVNC from http://www.tightvnc.com/


Better compression, better security, and better performance then other
RFB-compliant VNC flavors.



Rich


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




-Original Message-
Sent: Wednesday, September 24, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L



Setting up vnc server and directing DISPLAY to that is easier, I think. I
have a Apps reports server setup which has run for few years for now with
vnc server.
 
Tanel.
-- 
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: URGENT REPORTS

[Gene Sais]

What I like about VNC, is that all you need for a client is a 
browser.  http://ip.address:5800 gets 
you a nice java client connection.
Gene>>> [EMAIL PROTECTED] 09/24/03 06:14PM 
>>>If y'all do choose a VNC route, I'd highly recommend the free 
and GPL'dTightVNC from http://www.tightvnc.com/Better 
compression, better security, and better performance then otherRFB-compliant 
VNC flavors.RichRich 
Jesse   
System/Database 
Administrator[EMAIL PROTECTED]  
Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: 
Wednesday, September 24, 2003 4:20 PMTo: Multiple recipients of list 
ORACLE-LSetting up vnc server and directing DISPLAY to that is 
easier, I think. Ihave a Apps reports server setup which has run for few 
years for now withvnc server.Tanel.-- 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.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: URGENT REPORTS

[Jesse, Rich]

If y'all do choose a VNC route, I'd highly recommend the free and GPL'd
TightVNC from http://www.tightvnc.com/

Better compression, better security, and better performance then other
RFB-compliant VNC flavors.


Rich

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



-Original Message-
Sent: Wednesday, September 24, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L


Setting up vnc server and directing DISPLAY to that is easier, I think. I
have a Apps reports server setup which has run for few years for now with
vnc server.
 
Tanel.
-- 
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: URGENT REPORTS

[Ron Thomas]

You can't.  As of about a year or so ago, there must be a buffer available for 
reports.  vnc works
nicley for this.  Many notes/articles on Metalink concerning this.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


   
   
  [EMAIL PROTECTED]
  
  state.fl.us   To:   [EMAIL PROTECTED]

  Sent by:  cc:
   
  [EMAIL PROTECTED]Subject:  RE: URGENT REPORTS
  
  com  
   
   
   
   
   
  09/24/2003 01:54 
   
  PM   
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Never mind.  Was a bad rep_mdmdmd.conf file.

However, does anyone know if there is a way to run reports services without
have a DISPLAY variable set?  We don't have a dedicated machine for this one
purpose.

-Original Message-
Sent: Wednesday, September 24, 2003 1:56 PM
To: '[EMAIL PROTECTED]'


  REP-110: Unable to open file 'alc4.rep'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'alc4.rep'.






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Thomas
  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: URGENT REPORTS

[Tanel Poder]

Title: RE: URGENT REPORTS



Setting up vnc server and directing DISPLAY to that 
is easier, I think. I have a Apps reports server setup which has run for 
few years for now with vnc server.
 
Tanel.
 

  - Original Message - 
  From: 
  Johnston, 
  Tim 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, September 24, 2003 11:09 
  PM
  Subject: RE: URGENT REPORTS
  
  Check out Xvfb...  It the virtual frame buffer...  I think it 
  will accomplish what you are looking for...
   
  HTH
  Tim
   
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 
24, 2003 3:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT REPORTS
Never mind.  Was a bad rep_mdmdmd.conf file.  

However, does anyone know if there is a way to run reports 
services without have a DISPLAY variable set?  We don't have a 
dedicated machine for this one purpose.
-Original Message- From: 
Stankus, Paula G Sent: Wednesday, September 24, 2003 
1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS 
  REP-110: Unable to open file 'alc4.rep'. 
REP-1070: Error while opening or saving a document. 
REP-0110: Unable to open file 'alc4.rep'. 

RE: URGENT REPORTS

[Paula_Stankus]

Title: RE: URGENT REPORTS



Thanks.

  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 
  4:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT REPORTS
  Check out Xvfb...  It the virtual frame buffer...  I think it 
  will accomplish what you are looking for...
   
  HTH
  Tim
   
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 
24, 2003 3:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT REPORTS
Never mind.  Was a bad rep_mdmdmd.conf file.  

However, does anyone know if there is a way to run reports 
services without have a DISPLAY variable set?  We don't have a 
dedicated machine for this one purpose.
-Original Message- From: 
Stankus, Paula G Sent: Wednesday, September 24, 2003 
1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS 
  REP-110: Unable to open file 'alc4.rep'. 
REP-1070: Error while opening or saving a document. 
REP-0110: Unable to open file 'alc4.rep'. 

RE: URGENT REPORTS

[Johnston, Tim]

Title: RE: URGENT REPORTS



Check 
out Xvfb...  It the virtual frame buffer...  I think it 
will accomplish what you are looking for...
 
HTH
Tim
 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 
  24, 2003 3:55 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT REPORTS
  Never mind.  Was a bad rep_mdmdmd.conf file.  
  
  However, does anyone know if there is a way to run reports 
  services without have a DISPLAY variable set?  We don't have a dedicated 
  machine for this one purpose.
  -Original Message- From: 
  Stankus, Paula G Sent: Wednesday, September 24, 2003 
  1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS 
    REP-110: Unable to open file 'alc4.rep'. 
  REP-1070: Error while opening or saving a document. 
  REP-0110: Unable to open file 'alc4.rep'. 
   

RE: URGENT REPORTS

[Paula_Stankus]

Title: RE: URGENT REPORTS





Never mind.  Was a bad rep_mdmdmd.conf file.  


However, does anyone know if there is a way to run reports services without have a DISPLAY variable set?  We don't have a dedicated machine for this one purpose.

-Original Message-
From: Stankus, Paula G 
Sent: Wednesday, September 24, 2003 1:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: URGENT REPORTS



  REP-110: Unable to open file 'alc4.rep'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'alc4.rep'.


 

RE: URGENT REPORTS

[Paula_Stankus]

Title: RE: URGENT REPORTS





  REP-110: Unable to open file 'alc4.rep'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'alc4.rep'.


 

Re: +++Need an urgent info+++

[M Rafiq]

Kirti,

Welcome back after a while. Hope you have finisihed your new book. Banglore 
may  be a better choice in terms of better salary and level of living. I 
think Oracle Corp also hring for Banglore too.

Regards
Rafiq
_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 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: +++Need an urgent info+++

[Stephane Faroult]

For what I have heard, Bangalore is a more pleasant place than Hyderabad :-). I 
personally know neither, but somebody on this list worked for Oracle India in 
Hyderabad, he might tell you more about this ...

SF 

PS : Please don't have this tragical vision of life (importance of decision etc). 
There's life outside Oracle.

>- --- Original Message --- -
>From: Ora DBA <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Wed, 17 Sep 2003 05:44:36
>
>
>Dear Friends,
>
>Good day. Hope doing well , sorry for OFF topic.
>
>My Friend has got an offer with Oracle India at
>Hyderabad (as a support engineer in Indian support
>centre , Hyderabad, India ).
>
>I need your suggestions , inputs and valuable
>thoughts for making a decision. What will be the
>work environment , benifits and so on..(probs
>and cons ).
>
>Please share your thoughts, have 2 make an
>important decision in life.
>
>Thanks a lot.
>
>Cheers,
>
>Oracle DBA.
>
-- 
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: +++Need an urgent info+++

[Kirtikumar Deshpande]

Find out what are the job responsibilities of a "Support Engineer". 
If your friend needs a job badly, and if the salary is acceptable, this could be a 
good opp to
learn on the job while helping the Customers.
Hyderabad is an interesting but a crowded city (no surprise there, it's India :) with 
a mix of old
and new culture. Language can pose some challenges in some parts. Great spicy food, 
though! 

HTH, 
- Kirti 

> 
>   - Original Message - 
>   From: Ora DBA 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Wednesday, September 17, 2003 4:44 PM
>   Subject: +++Need an urgent info+++
> 
> 
>   Dear Friends,
> 
>   Good day. Hope doing well , sorry for OFF topic.
> 
>   My Friend has got an offer with Oracle India at Hyderabad (as a support engineer 
> in Indian
> support centre , Hyderabad, India ).
> 
>   I need your suggestions , inputs and valuable thoughts for making a decision. What 
> will be the
> work environment , benifits and so on..(probs and cons ).
> 
>   Please share your thoughts, have 2 make an important decision in life.
> 
>   Thanks a lot.
> 
>   Cheers,
> 
>   Oracle DBA.
> 
> 
> 
> --
>   Do you Yahoo!?
>   Yahoo! SiteBuilder - Free, easy-to-use web site design software

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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: +++Need an urgent info+++

[Tanel Poder]

Erm... would "42" be a sufficient 
answer?
 
Tanel.
 

  - Original Message - 
  From: 
  Ora DBA 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, September 17, 2003 4:44 
  PM
  Subject: +++Need an urgent info+++
  
  
  Dear Friends,
  Good day. Hope doing well , sorry for OFF topic.
  My Friend has got an offer with Oracle India at Hyderabad (as a support 
  engineer in Indian support centre , Hyderabad, India ).
  I need your suggestions , inputs and valuable thoughts for making a 
  decision. What will be the work environment , benifits and so on..(probs 
  and cons ).
  Please share your thoughts, have 2 make an important decision in life.
  Thanks a lot.
  Cheers,
  Oracle DBA.
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software

+++Need an urgent info+++

[Ora DBA]

Dear Friends,
Good day. Hope doing well , sorry for OFF topic.
My Friend has got an offer with Oracle India at Hyderabad (as a support engineer in Indian support centre , Hyderabad, India ).
I need your suggestions , inputs and valuable thoughts for making a decision. What will be the work environment , benifits and so on..(probs and cons ).
Please share your thoughts, have 2 make an important decision in life.
Thanks a lot.
Cheers,
Oracle DBA.
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

Re: RE: RE: RE: RE: Bus Error (Urgent)

[Mladen Gogala]

As I've said earlier, take a look at the server. Look in the alert.log.
On 2003.09.12 19:09, bhabani s pradhan wrote:
yes that problem is resolved
actually there are two problems:
1] Solaris Error: 12: Not enough space
sys admin killed some processes and now other client machines can
connect and work on the db
2]tnsping and sqlplus on one particular client machine give
Bus Error (core dumped)
seems its a disk corruption error (can that be?)

 from oracle's side where else can i see for this "Bus Error (core
dumped)" error.
Regards
---
On Sat, 13 Sep 2003 Mladen Gogala wrote :
>Then, you have a problem with the number of processes on the OS
>level. The
>investigation should continue on the server.
>
>--
>Mladen Gogala
>Oracle DBA
>
>
>
> > -Original Message-
> > From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 12, 2003 5:46 PM
> > To: Mladen Gogala
> > Subject: Re: RE: RE: RE: Bus Error (Urgent)
> >
> >
> > its a 2gig memory
> >
> > shmsys:shminfo_shmmax=4294967295
> > shmsys:shminfo_shmmin=1
> >
> > parameter processes = 150
> >
> > and v$process returns 25
> >
> > ---
> >
> >
> >
> > On Sat, 13 Sep 2003 Mladen Gogala wrote :
> > >You don't have enough oracle processes on the server.
>Increase
> > >"PROCESSES"
> > >parameter.
> > >You might need to adjust SHMMAX and SEMMNS in /etc/system
> > >
> > >--
> > >Mladen Gogala
> > >Oracle DBA
> > >
> > >
> > >
> > > > -Original Message-
> > > > From: bhabani s pradhan
>[mailto:[EMAIL PROTECTED]
> > > > Sent: Friday, September 12, 2003 5:34 PM
> > > > To: Mladen Gogala
> > > > Subject: Re: RE: RE: Bus Error (Urgent)
> > > >
> > > >
> > > > donot know much about unix
> > > > shell variables are exported
> > > >
> > > >  from the client machine it soes not return anything:
> > WW_WS> truss
> > > > -o /tmp/truss.out -af tnsping tradedb1 WW_WS>
> > > >
> > > >
> > > >
> > > > i got this from the listener.log
> > > >
> > > > 12-SEP-2003 11:24:45 *
> > > >
> >
> >(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trad
> > > > e-host2)(USER=rubix)))
> > > > * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.27)(PORT=40838))
>*
> > establish
> > > > * TRADEDB1 * 12500
> > > > TNS-12500: TNS:listener failed to start a dedicated server
>process
> > > >   TNS-12540: TNS:internal limit restriction exceeded
> > > >TNS-12560: TNS:protocol adapter error
> > > > TNS-00510: Internal limit restriction exceeded
> > > >  Solaris Error: 12: Not enough space
> > > >
> > > >
> > > > Regards
> > > > ===
> > > >
> > > >
> > > >
> > > > On Sat, 13 Sep 2003 Mladen Gogala wrote :
> > > > >OK, this seems to have been created with netca. Are
>your
> > >shell
> > > > >variables
> > > > >exported? You should do "truss -o /tmp/truss.out -af
> > >tnsping
> > > > >tradedb1".
> > > > >That should tell you where does the error occur. Bus
>error
> > >means
> > > > >that the
> > > > >process cannot connect to the server. It's very similar
>in
> > >nature
> > > > >to
> > > > >ORA-3113.
> > > > >If it was oracle process you were trying to connect,
>you'd
> > >get an
> > > > >oracle
> > > > >error,
> > > > >but your're getting bus error, which means that the
>problem
> > >is on
> > > > >the OS
> > > > >level.
> > > > >Turn on tracing (TRACE_LEVEL=ADMIN in sqlnet.ora on
>both
> > >server
> > > > >and client)
> > > > >and
> > > > >see what that gives you. What else can you tell me? Is
> > >there
> > > > >anything
> > > > >unusual
> > > > >in that combination? Did it work before? What has
>changed?
> > >How
> > > > >much
> > > > >experience
> > > > >do you have with Unix and oracle?
> &g

Re: RE: RE: RE: RE: Bus Error (Urgent)

[bhabani s pradhan]

yes that problem is resolved
actually there are two problems:
1] Solaris Error: 12: Not enough space
sys admin killed some processes and now other client machines can 
connect and work on the db

2]tnsping and sqlplus on one particular client machine give
Bus Error (core dumped)

seems its a disk corruption error (can that be?)

 from oracle's side where else can i see for this "Bus Error (core 
dumped)" error.

Regards
---

On Sat, 13 Sep 2003 Mladen Gogala wrote :
>Then, you have a problem with the number of processes on the OS 
>level. The
>investigation should continue on the server.
>
>--
>Mladen Gogala
>Oracle DBA
>
>
>
> > -Original Message-
> > From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 12, 2003 5:46 PM
> > To: Mladen Gogala
> > Subject: Re: RE: RE: RE: Bus Error (Urgent)
> >
> >
> > its a 2gig memory
> >
> > shmsys:shminfo_shmmax=4294967295
> > shmsys:shminfo_shmmin=1
> >
> > parameter processes = 150
> >
> > and v$process returns 25
> >
> > ---
> >
> >
> >
> > On Sat, 13 Sep 2003 Mladen Gogala wrote :
> > >You don't have enough oracle processes on the server. 
>Increase
> > >"PROCESSES"
> > >parameter.
> > >You might need to adjust SHMMAX and SEMMNS in /etc/system
> > >
> > >--
> > >Mladen Gogala
> > >Oracle DBA
> > >
> > >
> > >
> > > > -Original Message-
> > > > From: bhabani s pradhan 
>[mailto:[EMAIL PROTECTED]
> > > > Sent: Friday, September 12, 2003 5:34 PM
> > > > To: Mladen Gogala
> > > > Subject: Re: RE: RE: Bus Error (Urgent)
> > > >
> > > >
> > > > donot know much about unix
> > > > shell variables are exported
> > > >
> > > >  from the client machine it soes not return anything:
> > WW_WS> truss
> > > > -o /tmp/truss.out -af tnsping tradedb1 WW_WS>
> > > >
> > > >
> > > >
> > > > i got this from the listener.log
> > > >
> > > > 12-SEP-2003 11:24:45 *
> > > >
> > 
> >(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trad
> > > > e-host2)(USER=rubix)))
> > > > * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.27)(PORT=40838)) 
>*
> > establish
> > > > * TRADEDB1 * 12500
> > > > TNS-12500: TNS:listener failed to start a dedicated server 
>process
> > > >   TNS-12540: TNS:internal limit restriction exceeded
> > > >TNS-12560: TNS:protocol adapter error
> > > > TNS-00510: Internal limit restriction exceeded
> > > >  Solaris Error: 12: Not enough space
> > > >
> > > >
> > > > Regards
> > > > ===
> > > >
> > > >
> > > >
> > > > On Sat, 13 Sep 2003 Mladen Gogala wrote :
> > > > >OK, this seems to have been created with netca. Are 
>your
> > >shell
> > > > >variables
> > > > >exported? You should do "truss -o /tmp/truss.out -af
> > >tnsping
> > > > >tradedb1".
> > > > >That should tell you where does the error occur. Bus 
>error
> > >means
> > > > >that the
> > > > >process cannot connect to the server. It's very similar 
>in
> > >nature
> > > > >to
> > > > >ORA-3113.
> > > > >If it was oracle process you were trying to connect, 
>you'd
> > >get an
> > > > >oracle
> > > > >error,
> > > > >but your're getting bus error, which means that the 
>problem
> > >is on
> > > > >the OS
> > > > >level.
> > > > >Turn on tracing (TRACE_LEVEL=ADMIN in sqlnet.ora on 
>both
> > >server
> > > > >and client)
> > > > >and
> > > > >see what that gives you. What else can you tell me? Is
> > >there
> > > > >anything
> > > > >unusual
> > > > >in that combination? Did it work before? What has 
>changed?
> > >How
> > > > >much
> > > > >experience
> > > > >do you have with Unix and oracle?
> > > > >
> > > > >--
> > > > >Mladen Gogala
> > > > >

RE: RE: RE: RE: Bus Error (Urgent)

[Mladen Gogala]

Then, you have a problem with the number of processes on the OS level. The
investigation should continue on the server.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: bhabani s pradhan [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 12, 2003 5:46 PM
> To: Mladen Gogala
> Subject: Re: RE: RE: RE: Bus Error (Urgent)
> 
> 
> its a 2gig memory
> 
> shmsys:shminfo_shmmax=4294967295
> shmsys:shminfo_shmmin=1
> 
> parameter processes = 150
> 
> and v$process returns 25
> 
> ---
> 
> 
> 
> On Sat, 13 Sep 2003 Mladen Gogala wrote :
> >You don't have enough oracle processes on the server. Increase
> >"PROCESSES"
> >parameter.
> >You might need to adjust SHMMAX and SEMMNS in /etc/system
> >
> >--
> >Mladen Gogala
> >Oracle DBA
> >
> >
> >
> > > -Original Message-
> > > From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
> > > Sent: Friday, September 12, 2003 5:34 PM
> > > To: Mladen Gogala
> > > Subject: Re: RE: RE: Bus Error (Urgent)
> > >
> > >
> > > donot know much about unix
> > > shell variables are exported
> > >
> > >  from the client machine it soes not return anything: 
> WW_WS> truss 
> > > -o /tmp/truss.out -af tnsping tradedb1 WW_WS>
> > >
> > >
> > >
> > > i got this from the listener.log
> > >
> > > 12-SEP-2003 11:24:45 *
> > > 
> >(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trad
> > > e-host2)(USER=rubix)))
> > > * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.27)(PORT=40838)) * 
> establish 
> > > * TRADEDB1 * 12500
> > > TNS-12500: TNS:listener failed to start a dedicated server process
> > >   TNS-12540: TNS:internal limit restriction exceeded
> > >TNS-12560: TNS:protocol adapter error
> > > TNS-00510: Internal limit restriction exceeded
> > >  Solaris Error: 12: Not enough space
> > >
> > >
> > > Regards
> > > ===
> > >
> > >
> > >
> > > On Sat, 13 Sep 2003 Mladen Gogala wrote :
> > > >OK, this seems to have been created with netca. Are your
> >shell
> > > >variables
> > > >exported? You should do "truss -o /tmp/truss.out -af
> >tnsping
> > > >tradedb1".
> > > >That should tell you where does the error occur. Bus error
> >means
> > > >that the
> > > >process cannot connect to the server. It's very similar in
> >nature
> > > >to
> > > >ORA-3113.
> > > >If it was oracle process you were trying to connect, you'd
> >get an
> > > >oracle
> > > >error,
> > > >but your're getting bus error, which means that the problem
> >is on
> > > >the OS
> > > >level.
> > > >Turn on tracing (TRACE_LEVEL=ADMIN in sqlnet.ora on both
> >server
> > > >and client)
> > > >and
> > > >see what that gives you. What else can you tell me? Is
> >there
> > > >anything
> > > >unusual
> > > >in that combination? Did it work before? What has changed?
> >How
> > > >much
> > > >experience
> > > >do you have with Unix and oracle?
> > > >
> > > >--
> > > >Mladen Gogala
> > > >Oracle DBA
> > > >
> > > >
> > > >
> > > > > -Original Message-
> > > > > From: bhabani s pradhan
> >[mailto:[EMAIL PROTECTED]
> > > > > Sent: Friday, September 12, 2003 5:03 PM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > > Cc: Mladen Gogala
> > > > > Subject: Re: RE: Bus Error (Urgent)
> > > > >
> > > > >
> > > > > both client and server on Sun OS 5.8
> > > > >
> > > > > ORACLE_HOME and ORACLE_SID in .profile
> > > > >
> > > > > tnsnames.ora
> > > > > 
> > > > > TRADEDB1 =
> > > > >(DESCRIPTION =
> > > > >  (ADDRESS_LIST =
> > > > >(ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT
> >=
> > > > > 1521))
> > > > >  )
> > > > >  (CONNECT_DATA =
> > > > >(SERVICE_NAME = TRADEDB1)
> > > 

Re: Re: Bus Error (Urgent)

[bhabani s pradhan]

listener is running okay
it has refused some connections:

WW_DB> lsnrctl stat

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003 
14:49:01

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER

Alias LISTENER
Version   TNSLSNR for Solaris: Version 8.1.7.0.0 - 
Production
Start Date01-MAY-2003 16:13:23
Uptime133 days 22 hr. 35 min. 38 sec
Trace Level   off
Security  OFF
SNMP  OFF
Listener Parameter File   
/export/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File 
/export/oracle/product/8.1.7/network/log/listener.log
Services Summary...
   PLSExtProchas 1 service handler(s)
   TRADEDB1  has 1 service handler(s)
   TRADEDB1  has 2 service handler(s)
The command completed successfully
WW_DB> lsnrctl services

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003 
14:49:07

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
   PLSExtProchas 1 service handler(s)
 DEDICATED SERVER established:0 refused:0
   LOCAL SERVER
   TRADEDB1  has 1 service handler(s)
 DEDICATED SERVER established:2 refused:0
   LOCAL SERVER
   TRADEDB1  has 2 service handler(s)
 DISPATCHER established:0 refused:0 current:0 max:1022 
state:ready
   D000 
   
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=trade-db2.webwayllc.com)(PORT=32804))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))
   Presentation: oracle.aurora.server.SGiopServer
 DEDICATED SERVER established:213656 refused:4442
   LOCAL SERVER
The command completed successfully
WW_DB>


the  problem is with One particular client machine.

Regards


On Sat, 13 Sep 2003 [EMAIL PROTECTED] wrote :
>
>Oddly enough,  I received the same error today on one of our 
>Solaris
>servers while trying to start a listener.  I ran 'top' and 
>noticed that all
>of the available swap space on the machine was being used.  After 
>the
>guilty process was killed, I was able to start the listener.  
>FYI, the
>process was picld, an O/S process that is known to have a memory 
>leak.
>
>Hope that helps...
>
>Alan
>
>
>Alan Aschenbrenner
>Oracle DBA
>IHS Group
>[EMAIL PROTECTED]
>
>
>
>
>   "bhabani s
>   pradhan"  To:   
>Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   <[EMAIL PROTECTED]cc:
>   ffmail.com>   Subject:  Re: 
>Bus Error (Urgent)
>   Sent by:
>   [EMAIL PROTECTED]
>   com
>
>
>   09/12/2003 04:14
>   PM
>   Please respond to
>   ORACLE-L
>
>
>
>
>
>
>  From the listener.log I am getting:
>
>12-SEP-2003 11:24:20 *
>(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM
>=)(HOST=trade-host2)(USER=rubix)))
>* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) *
>establish * TRADEDB1 * 12500
>TNS-12500: TNS:listener failed to start a dedicated server
>process
>   TNS-12540: TNS:internal limit restriction exceeded
>TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
>  Solaris Error: 12: Not enough space
>
>Regards
>
>--
>On Sat, 13 Sep 2003 bhabani s pradhan wrote :
> >Hi All
> >
> >I am able to connect to my database from a set of different
> >clients from different machines.
> >
> >  From one particular machine i am not able to connect to the
> >DB
> >server machine.
> >
> >ping  works fine
> >but tnsping  gives
> >
> >Bus Error (core dumped)
> >
> >
> >Please help
> >
> >Thanks and Regards
> >
> >___
> >Interior meets Software; Rani Weds Gaurav.
> >Rediff Matchmaker strikes another interesting match
> >Visit http://matchmaker.rediff.com?1
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: bhabani s pradhan
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- 858-538-5051
> >http://www.fatcity.com
> >San Diego, California-- Mailin

Re: RE: Bus Error (Urgent)

[bhabani s pradhan]

While running tnsping and sqlplus i am getting this:

WW_WS> tnsping TRADEDB1
Bus Error (core dumped)
WW_WS> sqlplus rubix/[EMAIL PROTECTED]
Bus Error (core dumped)
WW_WS> /usr/sbin/ping 10.10.8.44
10.10.8.44 is alive
WW_WS> echo $ORACLE_HOME
/export/home/oracle/product/8.1.7
WW_WS> echo $ORACLE_SID
TRADEDB1
WW_WS>

Please help .

Regards



___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  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: Bus Error (Urgent)

[Mladen Gogala]

You cannot start process. You need to increase PROCESSES in
init$ORACLE_SID.ora.
You may have to increase SHMMAX and SEMMNS in /etc/system. 

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of bhabani s pradhan
> Sent: Friday, September 12, 2003 6:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Bus Error (Urgent)
> 
> 
>  From the listener.log I am getting:
> 
> 12-SEP-2003 11:24:20 * 
> (CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trad
> e-host2)(USER=rubix))) 
> * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) * 
> establish * TRADEDB1 * 12500
> TNS-12500: TNS:listener failed to start a dedicated server 
> process
>   TNS-12540: TNS:internal limit restriction exceeded
>TNS-12560: TNS:protocol adapter error
> TNS-00510: Internal limit restriction exceeded
>  Solaris Error: 12: Not enough space
> 
> Regards
> 
> --
> On Sat, 13 Sep 2003 bhabani s pradhan wrote :
> >Hi All
> >
> >I am able to connect to my database from a set of different clients 
> >from different machines.
> >
> >  From one particular machine i am not able to connect to the
> >DB
> >server machine.
> >
> >ping  works fine
> >but tnsping  gives
> >
> >Bus Error (core dumped)
> >
> >
> >Please help
> >
> >Thanks and Regards
> >
> >___
> >Interior meets Software; Rani Weds Gaurav.
> >Rediff Matchmaker strikes another interesting match
> >Visit http://matchmaker.rediff.com?1
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: bhabani s pradhan
> >   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).
> 
> ___
> Interior meets Software; Rani Weds Gaurav.
> Rediff Matchmaker strikes another interesting match
> Visit http://matchmaker.rediff.com?1
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: bhabani s pradhan
>   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).
> 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: Bus Error (Urgent)

[alan . aschenbrenner]

Oddly enough,  I received the same error today on one of our Solaris
servers while trying to start a listener.  I ran 'top' and noticed that all
of the available swap space on the machine was being used.  After the
guilty process was killed, I was able to start the listener.  FYI, the
process was picld, an O/S process that is known to have a memory leak.

Hope that helps...

Alan


Alan Aschenbrenner
Oracle DBA
IHS Group
[EMAIL PROTECTED]



   
 
  "bhabani s   
 
  pradhan"  To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
  <[EMAIL PROTECTED]cc:
 
  ffmail.com>   Subject:  Re: Bus Error (Urgent)   
 
  Sent by: 
 
  [EMAIL PROTECTED]

  com  
 
   
 
   
 
  09/12/2003 04:14 
 
  PM   
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




 From the listener.log I am getting:

12-SEP-2003 11:24:20 *
(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM
=)(HOST=trade-host2)(USER=rubix)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) *
establish * TRADEDB1 * 12500
TNS-12500: TNS:listener failed to start a dedicated server
process
  TNS-12540: TNS:internal limit restriction exceeded
   TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
 Solaris Error: 12: Not enough space

Regards

--
On Sat, 13 Sep 2003 bhabani s pradhan wrote :
>Hi All
>
>I am able to connect to my database from a set of different
>clients from different machines.
>
>  From one particular machine i am not able to connect to the
>DB
>server machine.
>
>ping  works fine
>but tnsping  gives
>
>Bus Error (core dumped)
>
>
>Please help
>
>Thanks and Regards
>
>___
>Interior meets Software; Rani Weds Gaurav.
>Rediff Matchmaker strikes another interesting match
>Visit http://matchmaker.rediff.com?1
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: bhabani s pradhan
>   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).

___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California  

RE: Bus Error (Urgent)

[Stephen Lee]

Maybe find something at http://sunsolve.sun.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  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: Bus Error (Urgent)

[bhabani s pradhan]

 From the listener.log I am getting:

12-SEP-2003 11:24:20 * 
(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trade-host2)(USER=rubix))) 
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) * 
establish * TRADEDB1 * 12500
TNS-12500: TNS:listener failed to start a dedicated server 
process
  TNS-12540: TNS:internal limit restriction exceeded
   TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
 Solaris Error: 12: Not enough space

Regards

--
On Sat, 13 Sep 2003 bhabani s pradhan wrote :
>Hi All
>
>I am able to connect to my database from a set of different
>clients from different machines.
>
>  From one particular machine i am not able to connect to the 
>DB
>server machine.
>
>ping  works fine
>but tnsping  gives
>
>Bus Error (core dumped)
>
>
>Please help
>
>Thanks and Regards
>
>___
>Interior meets Software; Rani Weds Gaurav.
>Rediff Matchmaker strikes another interesting match
>Visit http://matchmaker.rediff.com?1
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: bhabani s pradhan
>   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).

___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  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: RE: Bus Error (Urgent)

[bhabani s pradhan]

both client and server on Sun OS 5.8

ORACLE_HOME and ORACLE_SID in .profile

tnsnames.ora

TRADEDB1 =
   (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT = 
1521))
 )
 (CONNECT_DATA =
   (SERVICE_NAME = TRADEDB1)
 )
   )

INST1_HTTP =
   (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = trade-db)(PORT = 
1521))
 )
 (CONNECT_DATA =
   (SERVER = SHARED)
   (SERVICE_NAME = TRADEDB1)
   (PRESENTATION = http://admin)
 )
   )


sqlnet.ora
--
# SQLNET.ORA Network Configuration File: 
/export/home/oracle/product/8.1.7/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)




now ??

Regards
---



On Sat, 13 Sep 2003 Mladen Gogala wrote :
>Which platform & version, how did you define your ORACLE_HOME 
>and
>ORACLE_SID,
>did you export them, what do your tnsnames.ora and sqlnet.ora 
>look like?
>This way, I can only tell you to wait for another bus.
>
>--
>Mladen Gogala
>Oracle DBA
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
>On
> > Behalf Of bhabani s pradhan
> > Sent: Friday, September 12, 2003 5:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Bus Error (Urgent)
> >
> >
> > Hi All
> >
> > I am able to connect to my database from a set of different
> > clients from different machines.
> >
> >  From one particular machine i am not able to connect to the 
>DB
> > server machine.
> >
> > ping  works fine
> > but tnsping  gives
> >
> > Bus Error (core dumped)
> >
> >
> > Please help
> >
> > Thanks and Regards
> >
> > ___
> > Interior meets Software; Rani Weds Gaurav.
> > Rediff Matchmaker strikes another interesting match
> > Visit http://matchmaker.rediff.com?1
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: bhabani s pradhan
> >   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).
> >
>
>
>
>
>Note:
>This message is for the named person's use only.  It may contain 
>confidential, proprietary or legally privileged information.  No 
>confidentiality or privilege is waived or lost by any 
>mistransmission.  If you receive this message in error, please 
>immediately delete it and all copies of it from your system, 
>destroy any hard copies of it and notify the sender.  You must 
>not, directly or indirectly, use, disclose, distribute, print, or 
>copy any part of this message if you are not the intended 
>recipient. Wang Trading LLC and any of its subsidiaries each 
>reserve the right to monitor all e-mail communications through 
>its networks.
>Any views expressed in this message are those of the individual 
>sender, except where the message states otherwise and the sender 
>is authorized to state them to be the views of any such entity.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Mladen Gogala
>   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).

___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  INET: [E

RE: Bus Error (Urgent)

[Mladen Gogala]

Which platform & version, how did you define your ORACLE_HOME and
ORACLE_SID,
did you export them, what do your tnsnames.ora and sqlnet.ora look like?
This way, I can only tell you to wait for another bus.

--
Mladen Gogala
Oracle DBA 



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of bhabani s pradhan
> Sent: Friday, September 12, 2003 5:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Bus Error (Urgent)
> 
> 
> Hi All
> 
> I am able to connect to my database from a set of different 
> clients from different machines.
> 
>  From one particular machine i am not able to connect to the DB 
> server machine.
> 
> ping  works fine
> but tnsping  gives
> 
> Bus Error (core dumped)
> 
> 
> Please help
> 
> Thanks and Regards
> 
> ___
> Interior meets Software; Rani Weds Gaurav.
> Rediff Matchmaker strikes another interesting match
> Visit http://matchmaker.rediff.com?1
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: bhabani s pradhan
>   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).
> 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

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

Bus Error (Urgent)

[bhabani s pradhan]

Hi All

I am able to connect to my database from a set of different 
clients from different machines.

 From one particular machine i am not able to connect to the DB 
server machine.

ping  works fine
but tnsping  gives

Bus Error (core dumped)


Please help

Thanks and Regards

___
Interior meets Software; Rani Weds Gaurav.
Rediff Matchmaker strikes another interesting match
Visit http://matchmaker.rediff.com?1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: bhabani s pradhan
  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: URGENT REPORTS WONT START

[Paula_Stankus]

Title: RE: URGENT REPORTS WONT START





It was a problem with 2 things:


1-someone had changed the display on me!
2-conf file was corrupted.


Worked it out but can anyone tell me where I can get more robust descriptions of the conf files and how to edit them and each part of them?

Thanks,
Paula


-Original Message-
From: Govindan K [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT REPORTS WONT START



Not sure if this would be of 1% help. I remember getting into similar trouble
when i was working on 9iAS stuff.
- Is there any reference to server name? If so replace it with IP address.
- Do you have original copy of the conf file. If so do a unix diff to see
where all the difference arises. May be some / is missed out while closing the
tag?


Can you mail me the conf file highlighting the changes?


GovindanK



On Thu, 11 Sep 2003 10:59 , [EMAIL PROTECTED] sent:


>
>
>
>
>
>RE: URGENT REPORTS WONT START
>
>
>
>Getting error:
>
>
>REP-50125: Caught exception: java.lang.reflect.InvocationTargetException
>
>
>One note I found on web said to comment out some tags.  Doesn't seem to help.  
>
>
>Any ideas?
>
>
>
>



 Message sent via Zuvio Mail
Get your own FREE email account with SPAM and Antivirus protection!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Govindan K
  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: URGENT REPORTS WONT START

[Govindan K]

Not sure if this would be of 1% help. I remember getting into similar trouble
when i was working on 9iAS stuff.
- Is there any reference to server name? If so replace it with IP address.
- Do you have original copy of the conf file. If so do a unix diff to see
where all the difference arises. May be some / is missed out while closing the
tag?

Can you mail me the conf file highlighting the changes?

GovindanK


On Thu, 11 Sep 2003 10:59 , [EMAIL PROTECTED] sent:

>
>
>
>
>
>RE: URGENT REPORTS WONT START
>
>
>
>Getting error:
>
>
>REP-50125: Caught exception: java.lang.reflect.InvocationTargetException
>
>
>One note I found on web said to comment out some tags.  Doesn't seem to help.  
>
>
>Any ideas?
>
>
>
>


 Message sent via Zuvio Mail
Get your own FREE email account with SPAM and Antivirus protection!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Govindan K
  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: URGENT REPORTS WONT START

[Paula_Stankus]

Title: RE: URGENT REPORTS WONT START





Getting error:


REP-50125: Caught exception: java.lang.reflect.InvocationTargetException


One note I found on web said to comment out some tags.  Doesn't seem to help.  


Any ideas?

Re: Urgent INFO needed. - OFF TOPIC

[Mogens Nørgaard]

 in India one more DBA
is out of work here in the United States.
   -Original Message-
   *From:* Ora DBA [mailto:[EMAIL PROTECTED]
   *Sent:* Wednesday, September 03, 2003 5:30 AM
   *To:* Multiple recipients of list ORACLE-L
   *Subject:* Urgent INFO needed.
   Dear Friends,

   One of my friends has got the offer from CSC india ltd. Please
   respond this mail if any one from CSC india ltd? just to know
   some info , thats it.
   Any info regarding this is appreciated. Please give me your mail
   id and contacts..
   Thanks a lot.

   Regards

   Oracle DBA
   

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Urgent INFO needed. - OFF TOPIC

[VIVEK_SHARMA]

Well-Spoken Indeed

-Original Message-
Sent: Friday, September 05, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L

Yes, in your experience...and maybe most of the other lister's
experience...majority of the time its true...
That's because you people are the best DBAs I've seen...
Your experiences...10...15 years...some of you have a little over 3 years and are
already experts...
Of course a lot of other people are less skilled than you are...
But I am not sure if you represent the rest of the US DBAs...or if I represent the
rest of the 3rd world DBAs...
Again, as I have said...some peopler are just better than others...that's my
opinion...obviously, yours is a lot different than mine...

I don't know you, Joe, well enough to judge you.
So I won't call you names.

Joe Testa wrote:

> Fact of the matter is the majority of the time its true, like it or
> not.  Those of you who know me, know I DON'T do politically correct, I
> call a spade a spade.
>
> Its true at the officer level in a company(and I'm there in the company
> I'm in now), its all about dollars and cents, especially today.   Thats
> why you see it as much as you do.
>
> My example:  I worked for an online training company, they were paying
> me $25/hr to do online tutoring or web based oracle DBA classes., I was
> with them from the beginning just like alot of other tutors from around
> th world.  We were told in early/mid 2002, we've decided to outsource
> all tutoring to India, so if you're interested in teaching your
> replacements, we'll keep you on board for a little extra time.  The end
> was near and someone had asked me how long I'd been doing it, how long I
> was a DBA and how long did I plan on doing it, i gave them the truthful
> answer, about 4 yrs, 10 years as a DBA and not much longer since it was
> all being outsourced to India, got my a$$ fired from the job before my
> time was up.   Basically the concept was: "we can go to India and pay
> $2.50, 10% of what we pay you and we really dont care about the quality
> because they will pick up their English language from previous answers
> you and others have submitted to students throughout the years.".
>
> You tell me I  shouldn't have an attitude, you're as full of garbage as
> them.
>
> Joe
>
> PS: for those who want to know the company, email me direct, i'll be
> glad to share.
>
> Maria Aurora de la Vega wrote:
>
> > Its quite unfair for DBAs to blame their job loss/fear of job loss to
> > DBAs in India or some other countries with cheaper labor.
> > And to say that "you get what you pay for" or insinuating that cheaper
> > labor means less quality...is definitely out of line...
> > some people are just better than others...that's it...it has nothing
> > to do with geography or nationality...
> > some of the best DBAs...or IT professionals in general...are in fact
> > indians...
> > Point is its not the indians' fault jobs just come knocking at their
> > doors...
> > we all want better jobs and better pay...if it comes to me i'll grab
> > it no doubt... would I think about other DBAs who were taken off to
> > accomodate me? of course not. I have nothing to do with their decision
> > to outsource...and even if I stress myself worrying about it...can I
> > do anything about it? no...so, what do I do...I'd take advantage of
> > course...
> > I've come to believe no one is indispensable...even if you've served
> > 5, 10, 15 years in a company...there's always a reason to take you out
> > no matter how good you are...
> > And sometimes companies think...do I really need someone that good and
> > costs a lot more? or can we do with someone quite average but can get
> > the job done and costs a lot less?
> >
> > Tony Johnson wrote:
> >
> >>  All I know about it is that for every new job in India one more DBA
> >> is out of work here in the United States.
> >>
> >> -Original Message-
> >> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
> >> *Sent:* Wednesday, September 03, 2003 5:30 AM
> >> *To:* Multiple recipients of list ORACLE-L
> >> *Subject:* Urgent INFO needed.
> >>
> >> Dear Friends,
> >>
> >> One of my friends has got the offer from CSC india ltd. Please
> >> respond this mail if any one from CSC india ltd? just to know
> >> some info , thats it.
> >>
> >> Any info regarding this is appreciated. Please give me your mail
> >> id and contacts..
> >>
> >> Thanks a lot

RE: Urgent INFO needed.

[DENNIS WILLIAMS]

Maria
   I just wanted to thank you for posting your views on the DBA situation
from your perspective. I always feel better informed when I have an
opportunity to hear opinions from people whose situation is different from
mine. And I agree with you that this is a valuable forum where people with a
staggering amount of expertise are willing to spend a few moments helping
you.

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


-Original Message-
Sent: Friday, September 05, 2003 12:14 AM
To: Multiple recipients of list ORACLE-L


Yes, in your experience...and maybe most of the other lister's
experience...majority of the time its true...
That's because you people are the best DBAs I've seen...
Your experiences...10...15 years...some of you have a little over 3 years
and are
already experts...
Of course a lot of other people are less skilled than you are...
But I am not sure if you represent the rest of the US DBAs...or if I
represent the
rest of the 3rd world DBAs...
Again, as I have said...some peopler are just better than others...that's my
opinion...obviously, yours is a lot different than mine...

I don't know you, Joe, well enough to judge you.
So I won't call you names.

Joe Testa wrote:

> Fact of the matter is the majority of the time its true, like it or
> not.  Those of you who know me, know I DON'T do politically correct, I
> call a spade a spade.
>
> Its true at the officer level in a company(and I'm there in the company
> I'm in now), its all about dollars and cents, especially today.   Thats
> why you see it as much as you do.
>
> My example:  I worked for an online training company, they were paying
> me $25/hr to do online tutoring or web based oracle DBA classes., I was
> with them from the beginning just like alot of other tutors from around
> th world.  We were told in early/mid 2002, we've decided to outsource
> all tutoring to India, so if you're interested in teaching your
> replacements, we'll keep you on board for a little extra time.  The end
> was near and someone had asked me how long I'd been doing it, how long I
> was a DBA and how long did I plan on doing it, i gave them the truthful
> answer, about 4 yrs, 10 years as a DBA and not much longer since it was
> all being outsourced to India, got my a$$ fired from the job before my
> time was up.   Basically the concept was: "we can go to India and pay
> $2.50, 10% of what we pay you and we really dont care about the quality
> because they will pick up their English language from previous answers
> you and others have submitted to students throughout the years.".
>
> You tell me I  shouldn't have an attitude, you're as full of garbage as
> them.
>
> Joe
>
> PS: for those who want to know the company, email me direct, i'll be
> glad to share.
>
> Maria Aurora de la Vega wrote:
>
> > Its quite unfair for DBAs to blame their job loss/fear of job loss to
> > DBAs in India or some other countries with cheaper labor.
> > And to say that "you get what you pay for" or insinuating that cheaper
> > labor means less quality...is definitely out of line...
> > some people are just better than others...that's it...it has nothing
> > to do with geography or nationality...
> > some of the best DBAs...or IT professionals in general...are in fact
> > indians...
> > Point is its not the indians' fault jobs just come knocking at their
> > doors...
> > we all want better jobs and better pay...if it comes to me i'll grab
> > it no doubt... would I think about other DBAs who were taken off to
> > accomodate me? of course not. I have nothing to do with their decision
> > to outsource...and even if I stress myself worrying about it...can I
> > do anything about it? no...so, what do I do...I'd take advantage of
> > course...
> > I've come to believe no one is indispensable...even if you've served
> > 5, 10, 15 years in a company...there's always a reason to take you out
> > no matter how good you are...
> > And sometimes companies think...do I really need someone that good and
> > costs a lot more? or can we do with someone quite average but can get
> > the job done and costs a lot less?
> >
> > Tony Johnson wrote:
> >
> >>  All I know about it is that for every new job in India one more DBA
> >> is out of work here in the United States.
> >>
> >> -Original Message-
> >> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
> >> *Sent:* Wednesday, September 03, 2003 5:30 AM
> >> *To:* Multiple recipien

RE: RE: URGENT : sql*loader performance problem on partionned tab

[NGUYEN Philippe (Cetelem)]

Title: RE: RE: URGENT : sql*loader performance problem on partionned tab





here the trace :
SELECT STATEMENT, GOAL = CHOOSE         2   72  1368    
 FOR UPDATE                     
  FILTER                        
   PARTITION RANGE SINGLE                       
    TABLE ACCESS BY LOCAL INDEX ROWID   FICOM   HREL_FUSION 2   72  1368    
 INDEX RANGE SCAN   FICOM   IDX_HREL_FUSION_P_COD_REL   1   72      
   TABLE ACCESS BY INDEX ROWID  FICOM   PRIMEDI_ENR2_TEMP_FUSION    2   1   32  
    INDEX RANGE SCAN    FICOM   IDX_PRIMCOD_ENR2_TEMP_FUSION    1   1       



TIA


> 
> Philippe Nguyen
> CETELEM - Administration, Architecture Décisionnelle
> Direction Customer Relationship Management
> E-Mail : [EMAIL PROTECTED]
> Tel  : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88
> 



-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Envoyé : 05 September 2003 00:09
À : Multiple recipients of list ORACLE-L
Objet : RE: RE: URGENT : sql*loader performance problem on partionned
tab



Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.


GovindanK



> Here the informations :
> table HREL_FUSION :
>   63 millions rows
>   3 indexes on columns : nodos_or, nodos_or, numcli <--- too much
> indexes ??
> table primedi_enr2_temp_fusion : 133 000 rows
>   I also took snaps with stastpack, can it help you ?
>   this table is recreated and re-analyze each day, but the hanging
> part of the scritp in located here :
>
> **
> SELECT NULL
> FROM hrel_fusion
> WHERE cod_rel = :b1
>   AND dat_rel = :b2
>   AND NOT EXISTS (SELECT NULL
>   FROM primedi_enr2_temp_fusion
>   WHERE primedi_enr2_temp_fusion.nodos_or =
> hrel_fusion.nodos_or
> AND primedi_enr2_temp_fusion.code_logis =
> hrel_fusion.cod_rel
> AND primedi_enr2_temp_fusion.date_logis =
> hrel_fusion.dat_rel)
> FOR UPDATE
> **
>
> The mostly amazing thing is that the same script work in 12 min on
> non-partitionned table.
>
> Here a subset of the script :
> ***
>
> cat <$maj_histo_rel
>
>
> set serveroutput on;
> DECLARE
>
> vt_code_logis   char(4);
> vt_date_logis   number(4);
> n   number;
>
> cursor curs_code_ctlm is
> select code_logis,date_logis from primedi_temp_fusion
> where exists (select null from $TABLE_RETOURS
> where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis
> and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis
> and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom
> )
> ;
>
>
> cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is
> select null from HREL_FUSION
> where cod_rel=vt_code_logis
> and dat_rel=vt_date_logis
> and not exists (select null from primedi_enr2_temp_fusion
> where
> primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or
> and
> primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel
> and
> primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel)
> for update
> ;
>
> BEGIN
> DBMS_OUTPUT.ENABLE(50);
> for curs in curs_code_ctlm
> loop
> n:=0;
>    for enr_histo in curs_histo_ctlm1
> (curs.code_logis,curs.date_logis) loop
>    delete from HREL_FUSION
>    where current of curs_histo_ctlm1;
>    n:=n+1;
>    --if (mod(n,5000) = 0) then
>  --commit;
>    --end if;
>    end loop;
>    --commit;
>    DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) '
> ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION');
>
>
>    -- update $TABLE_RETOURS
>    -- set DATE_MAJ=to_number(to_char(sysdate,'mmdd'))
>    -- where exists (select null from primedi_temp_fusion
> --  where curs.code_logis=$TABLE_RETOURS.code_logis
> --  and curs.date_logis=$TABLE_RETOURS.date_logis
> --  )
> --;
>
> end loop;
> COMMIT;
>
> END;
> /
> exit;
>
> EOD
> ***
>


-- 
Plea

RE: Urgent INFO needed. - OFF TOPIC

[VIVEK_SHARMA]

$2.50 is simply because of the $ to Rupee PARITY RATIO & respective Cost of Living 
here in India.

Labor in India is NOT Cheap . It is Simply this ratio which gives the impression of 
being cheap. 

Also Outsourcers get to pay LESS because of the Current prevailing Work-to-Earnings 
monetary scenario existing in India.

Usually Tech. competence , for most , is at par amongst professionals irrespective of 
nationality .


-Original Message-
Sent: Thursday, September 04, 2003 10:30 PM
To: Multiple recipients of list ORACLE-L

Fact of the matter is the majority of the time its true, like it or 
not.  Those of you who know me, know I DON'T do politically correct, I 
call a spade a spade. 

Its true at the officer level in a company(and I'm there in the company 
I'm in now), its all about dollars and cents, especially today.   Thats 
why you see it as much as you do. 

My example:  I worked for an online training company, they were paying 
me $25/hr to do online tutoring or web based oracle DBA classes., I was 
with them from the beginning just like alot of other tutors from around 
th world.  We were told in early/mid 2002, we've decided to outsource 
all tutoring to India, so if you're interested in teaching your 
replacements, we'll keep you on board for a little extra time.  The end 
was near and someone had asked me how long I'd been doing it, how long I 
was a DBA and how long did I plan on doing it, i gave them the truthful 
answer, about 4 yrs, 10 years as a DBA and not much longer since it was 
all being outsourced to India, got my a$$ fired from the job before my 
time was up.   Basically the concept was: "we can go to India and pay 
$2.50, 10% of what we pay you and we really dont care about the quality 
because they will pick up their English language from previous answers 
you and others have submitted to students throughout the years.".

You tell me I  shouldn't have an attitude, you're as full of garbage as 
them.

Joe

PS: for those who want to know the company, email me direct, i'll be 
glad to share.

Maria Aurora de la Vega wrote:

> Its quite unfair for DBAs to blame their job loss/fear of job loss to 
> DBAs in India or some other countries with cheaper labor.
> And to say that "you get what you pay for" or insinuating that cheaper 
> labor means less quality...is definitely out of line...
> some people are just better than others...that's it...it has nothing 
> to do with geography or nationality...
> some of the best DBAs...or IT professionals in general...are in fact 
> indians...
> Point is its not the indians' fault jobs just come knocking at their 
> doors...
> we all want better jobs and better pay...if it comes to me i'll grab 
> it no doubt... would I think about other DBAs who were taken off to 
> accomodate me? of course not. I have nothing to do with their decision 
> to outsource...and even if I stress myself worrying about it...can I 
> do anything about it? no...so, what do I do...I'd take advantage of 
> course...
> I've come to believe no one is indispensable...even if you've served 
> 5, 10, 15 years in a company...there's always a reason to take you out 
> no matter how good you are...
> And sometimes companies think...do I really need someone that good and 
> costs a lot more? or can we do with someone quite average but can get 
> the job done and costs a lot less?
>
> Tony Johnson wrote:
>
>>  All I know about it is that for every new job in India one more DBA 
>> is out of work here in the United States.
>>
>> -Original Message-
>> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
>> *Sent:* Wednesday, September 03, 2003 5:30 AM
>> *To:* Multiple recipients of list ORACLE-L
>> *Subject:* Urgent INFO needed.
>>  
>> Dear Friends,
>>
>> One of my friends has got the offer from CSC india ltd. Please
>> respond this mail if any one from CSC india ltd? just to know
>> some info , thats it.
>>
>> Any info regarding this is appreciated. Please give me your mail
>> id and contacts..
>>
>> Thanks a lot.
>>
>> Regards
>>
>> Oracle DBA
>>
>> 
>> Do you Yahoo!?
>> Yahoo! SiteBuilder
>> <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>
>> - Free, easy-to-use web site design software
>>

-- 
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: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

Fat City Network 

Re: Urgent INFO needed.

[Maria Aurora de la Vega]

Yes, in your experience...and maybe most of the other lister's
experience...majority of the time its true...
That's because you people are the best DBAs I've seen...
Your experiences...10...15 years...some of you have a little over 3 years and are
already experts...
Of course a lot of other people are less skilled than you are...
But I am not sure if you represent the rest of the US DBAs...or if I represent the
rest of the 3rd world DBAs...
Again, as I have said...some peopler are just better than others...that's my
opinion...obviously, yours is a lot different than mine...

I don't know you, Joe, well enough to judge you.
So I won't call you names.

Joe Testa wrote:

> Fact of the matter is the majority of the time its true, like it or
> not.  Those of you who know me, know I DON'T do politically correct, I
> call a spade a spade.
>
> Its true at the officer level in a company(and I'm there in the company
> I'm in now), its all about dollars and cents, especially today.   Thats
> why you see it as much as you do.
>
> My example:  I worked for an online training company, they were paying
> me $25/hr to do online tutoring or web based oracle DBA classes., I was
> with them from the beginning just like alot of other tutors from around
> th world.  We were told in early/mid 2002, we've decided to outsource
> all tutoring to India, so if you're interested in teaching your
> replacements, we'll keep you on board for a little extra time.  The end
> was near and someone had asked me how long I'd been doing it, how long I
> was a DBA and how long did I plan on doing it, i gave them the truthful
> answer, about 4 yrs, 10 years as a DBA and not much longer since it was
> all being outsourced to India, got my a$$ fired from the job before my
> time was up.   Basically the concept was: "we can go to India and pay
> $2.50, 10% of what we pay you and we really dont care about the quality
> because they will pick up their English language from previous answers
> you and others have submitted to students throughout the years.".
>
> You tell me I  shouldn't have an attitude, you're as full of garbage as
> them.
>
> Joe
>
> PS: for those who want to know the company, email me direct, i'll be
> glad to share.
>
> Maria Aurora de la Vega wrote:
>
> > Its quite unfair for DBAs to blame their job loss/fear of job loss to
> > DBAs in India or some other countries with cheaper labor.
> > And to say that "you get what you pay for" or insinuating that cheaper
> > labor means less quality...is definitely out of line...
> > some people are just better than others...that's it...it has nothing
> > to do with geography or nationality...
> > some of the best DBAs...or IT professionals in general...are in fact
> > indians...
> > Point is its not the indians' fault jobs just come knocking at their
> > doors...
> > we all want better jobs and better pay...if it comes to me i'll grab
> > it no doubt... would I think about other DBAs who were taken off to
> > accomodate me? of course not. I have nothing to do with their decision
> > to outsource...and even if I stress myself worrying about it...can I
> > do anything about it? no...so, what do I do...I'd take advantage of
> > course...
> > I've come to believe no one is indispensable...even if you've served
> > 5, 10, 15 years in a company...there's always a reason to take you out
> > no matter how good you are...
> > And sometimes companies think...do I really need someone that good and
> > costs a lot more? or can we do with someone quite average but can get
> > the job done and costs a lot less?
> >
> > Tony Johnson wrote:
> >
> >>  All I know about it is that for every new job in India one more DBA
> >> is out of work here in the United States.
> >>
> >> -Original Message-
> >> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
> >> *Sent:* Wednesday, September 03, 2003 5:30 AM
> >> *To:* Multiple recipients of list ORACLE-L
> >> *Subject:* Urgent INFO needed.
> >>
> >> Dear Friends,
> >>
> >> One of my friends has got the offer from CSC india ltd. Please
> >> respond this mail if any one from CSC india ltd? just to know
> >> some info , thats it.
> >>
> >> Any info regarding this is appreciated. Please give me your mail
> >> id and contacts..
> >>
> >> Thanks a lot.
> >>
> >> Regards
> >>
> >> Oracle DBA
> >>
> >> -

RE: RE: URGENT : sql*loader performance problem on partionned tab

[cornichepark]

Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.

GovindanK


> Here the informations :
> table HREL_FUSION :
>   63 millions rows
>   3 indexes on columns : nodos_or, nodos_or, numcli <--- too much
> indexes ??
> table primedi_enr2_temp_fusion : 133 000 rows
>   I also took snaps with stastpack, can it help you ?
>   this table is recreated and re-analyze each day, but the hanging
> part of the scritp in located here :
>
> **
> SELECT NULL
> FROM hrel_fusion
> WHERE cod_rel = :b1
>   AND dat_rel = :b2
>   AND NOT EXISTS (SELECT NULL
>   FROM primedi_enr2_temp_fusion
>   WHERE primedi_enr2_temp_fusion.nodos_or =
> hrel_fusion.nodos_or
> AND primedi_enr2_temp_fusion.code_logis =
> hrel_fusion.cod_rel
> AND primedi_enr2_temp_fusion.date_logis =
> hrel_fusion.dat_rel)
> FOR UPDATE
> **
>
> The mostly amazing thing is that the same script work in 12 min on
> non-partitionned table.
>
> Here a subset of the script :
> ***
>
> cat <$maj_histo_rel
>
>
> set serveroutput on;
> DECLARE
>
> vt_code_logis   char(4);
> vt_date_logis   number(4);
> n   number;
>
> cursor curs_code_ctlm is
> select code_logis,date_logis from primedi_temp_fusion
> where exists (select null from $TABLE_RETOURS
> where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis
> and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis
> and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom
> )
> ;
>
>
> cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is
> select null from HREL_FUSION
> where cod_rel=vt_code_logis
> and dat_rel=vt_date_logis
> and not exists (select null from primedi_enr2_temp_fusion
> where
> primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or
> and
> primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel
> and
> primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel)
> for update
> ;
>
> BEGIN
> DBMS_OUTPUT.ENABLE(50);
> for curs in curs_code_ctlm
> loop
> n:=0;
>for enr_histo in curs_histo_ctlm1
> (curs.code_logis,curs.date_logis) loop
>delete from HREL_FUSION
>where current of curs_histo_ctlm1;
>n:=n+1;
>--if (mod(n,5000) = 0) then
>  --commit;
>--end if;
>end loop;
>--commit;
>DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) '
> ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION');
>
>
>-- update $TABLE_RETOURS
>-- set DATE_MAJ=to_number(to_char(sysdate,'mmdd'))
>-- where exists (select null from primedi_temp_fusion
> --  where curs.code_logis=$TABLE_RETOURS.code_logis
> --  and curs.date_logis=$TABLE_RETOURS.date_logis
> --  )
> --;
>
> end loop;
> COMMIT;
>
> END;
> /
> exit;
>
> EOD
> ***
>

-- 
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: Urgent INFO needed.

[Brian Dunbar]

Joe,

It's all about dollars and cents, true.  In your view, can a company look
past the next quarter and see that by outsourcing they might be jumping over
dollars to save pennies?

Example, most of the companies in my region aren't Fortune 500, they're
small manufacturing outfits - it's rare to see a company with more than a
thousand people on the payroll.  By outsourcing, they loose all of their
flexibility as regards what they can do with IT.  This has costs and
consquences beyond the next quarter, sometimes it won't have an impact for
years.

Can the corporate mindset look that far ahead?

~brian

-Original Message-
Sent: Thursday, September 04, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L


Fact of the matter is the majority of the time its true, like it or 
not.  Those of you who know me, know I DON'T do politically correct, I 
call a spade a spade. 

Its true at the officer level in a company(and I'm there in the company 
I'm in now), its all about dollars and cents, especially today.   Thats 
why you see it as much as you do. 

My example:  I worked for an online training company, they were paying 
me $25/hr to do online tutoring or web based oracle DBA classes., I was 
with them from the beginning just like alot of other tutors from around 
th world.  We were told in early/mid 2002, we've decided to outsource 
all tutoring to India, so if you're interested in teaching your 
replacements, we'll keep you on board for a little extra time.  The end 
was near and someone had asked me how long I'd been doing it, how long I 
was a DBA and how long did I plan on doing it, i gave them the truthful 
answer, about 4 yrs, 10 years as a DBA and not much longer since it was 
all being outsourced to India, got my a$$ fired from the job before my 
time was up.   Basically the concept was: "we can go to India and pay 
$2.50, 10% of what we pay you and we really dont care about the quality 
because they will pick up their English language from previous answers 
you and others have submitted to students throughout the years.".

You tell me I  shouldn't have an attitude, you're as full of garbage as 
them.

Joe

PS: for those who want to know the company, email me direct, i'll be 
glad to share.

Maria Aurora de la Vega wrote:

> Its quite unfair for DBAs to blame their job loss/fear of job loss to 
> DBAs in India or some other countries with cheaper labor.
> And to say that "you get what you pay for" or insinuating that cheaper 
> labor means less quality...is definitely out of line...
> some people are just better than others...that's it...it has nothing 
> to do with geography or nationality...
> some of the best DBAs...or IT professionals in general...are in fact 
> indians...
> Point is its not the indians' fault jobs just come knocking at their 
> doors...
> we all want better jobs and better pay...if it comes to me i'll grab 
> it no doubt... would I think about other DBAs who were taken off to 
> accomodate me? of course not. I have nothing to do with their decision 
> to outsource...and even if I stress myself worrying about it...can I 
> do anything about it? no...so, what do I do...I'd take advantage of 
> course...
> I've come to believe no one is indispensable...even if you've served 
> 5, 10, 15 years in a company...there's always a reason to take you out 
> no matter how good you are...
> And sometimes companies think...do I really need someone that good and 
> costs a lot more? or can we do with someone quite average but can get 
> the job done and costs a lot less?
>
> Tony Johnson wrote:
>
>>  All I know about it is that for every new job in India one more DBA 
>> is out of work here in the United States.
>>
>> -Original Message-
>> *From:* Ora DBA [mailto:[EMAIL PROTECTED]
>> *Sent:* Wednesday, September 03, 2003 5:30 AM
>> *To:* Multiple recipients of list ORACLE-L
>> *Subject:* Urgent INFO needed.
>>  
>> Dear Friends,
>>
>> One of my friends has got the offer from CSC india ltd. Please
>> respond this mail if any one from CSC india ltd? just to know
>> some info , thats it.
>>
>> Any info regarding this is appreciated. Please give me your mail
>> id and contacts..
>>
>> Thanks a lot.
>>
>> Regards
>>
>> Oracle DBA
>>
>>

>> Do you Yahoo!?
>> Yahoo! SiteBuilder
>> <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>
>> - Free, easy-to-use web site design software
>>

-- 
Joseph S Testa
Chief Technology Officer
Data Management C

Re: Urgent INFO needed.

[Joe Testa]

Fact of the matter is the majority of the time its true, like it or 
not.  Those of you who know me, know I DON'T do politically correct, I 
call a spade a spade. 

Its true at the officer level in a company(and I'm there in the company 
I'm in now), its all about dollars and cents, especially today.   Thats 
why you see it as much as you do. 

My example:  I worked for an online training company, they were paying 
me $25/hr to do online tutoring or web based oracle DBA classes., I was 
with them from the beginning just like alot of other tutors from around 
th world.  We were told in early/mid 2002, we've decided to outsource 
all tutoring to India, so if you're interested in teaching your 
replacements, we'll keep you on board for a little extra time.  The end 
was near and someone had asked me how long I'd been doing it, how long I 
was a DBA and how long did I plan on doing it, i gave them the truthful 
answer, about 4 yrs, 10 years as a DBA and not much longer since it was 
all being outsourced to India, got my a$$ fired from the job before my 
time was up.   Basically the concept was: "we can go to India and pay 
$2.50, 10% of what we pay you and we really dont care about the quality 
because they will pick up their English language from previous answers 
you and others have submitted to students throughout the years.".

You tell me I  shouldn't have an attitude, you're as full of garbage as 
them.

Joe

PS: for those who want to know the company, email me direct, i'll be 
glad to share.

Maria Aurora de la Vega wrote:

Its quite unfair for DBAs to blame their job loss/fear of job loss to 
DBAs in India or some other countries with cheaper labor.
And to say that "you get what you pay for" or insinuating that cheaper 
labor means less quality...is definitely out of line...
some people are just better than others...that's it...it has nothing 
to do with geography or nationality...
some of the best DBAs...or IT professionals in general...are in fact 
indians...
Point is its not the indians' fault jobs just come knocking at their 
doors...
we all want better jobs and better pay...if it comes to me i'll grab 
it no doubt... would I think about other DBAs who were taken off to 
accomodate me? of course not. I have nothing to do with their decision 
to outsource...and even if I stress myself worrying about it...can I 
do anything about it? no...so, what do I do...I'd take advantage of 
course...
I've come to believe no one is indispensable...even if you've served 
5, 10, 15 years in a company...there's always a reason to take you out 
no matter how good you are...
And sometimes companies think...do I really need someone that good and 
costs a lot more? or can we do with someone quite average but can get 
the job done and costs a lot less?

Tony Johnson wrote:

 All I know about it is that for every new job in India one more DBA 
is out of work here in the United States.

-Original Message-
*From:* Ora DBA [mailto:[EMAIL PROTECTED]
*Sent:* Wednesday, September 03, 2003 5:30 AM
*To:* Multiple recipients of list ORACLE-L
*Subject:* Urgent INFO needed.
 
Dear Friends,

One of my friends has got the offer from CSC india ltd. Please
respond this mail if any one from CSC india ltd? just to know
some info , thats it.
Any info regarding this is appreciated. Please give me your mail
id and contacts..
Thanks a lot.

Regards

Oracle DBA


Do you Yahoo!?
Yahoo! SiteBuilder
<http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>
- Free, easy-to-use web site design software
--
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: Urgent INFO needed.

[Quamrul Polash]

I could not say it in a better way 
/Quamrul
From: Maria Aurora de la Vega <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Urgent INFO needed. 
Date: Wed, 03 Sep 2003 21:19:41 -0800 

Its quite unfair for DBAs to blame their job loss/fear of job loss to 
DBAs in India or some other countries with cheaper labor. 
And to say that "you get what you pay for" or insinuating that cheaper 
labor means less quality...is definitely out of line... 
some people are just better than others...that's it...it has nothing to 
do with geography or nationality... 
some of the best DBAs...or IT professionals in general...are in fact 
indians... 
Point is its not the indians' fault jobs just come knocking at their 
doors... 
we all want better jobs and better pay...if it comes to me i'll grab it 
no doubt... would I think about other DBAs who were taken off to 
accomodate me? of course not. I have nothing to do with their decision 
to outsource...and even if I stress myself worrying about it...can I do 
anything about it? no...so, what do I do...I'd take advantage of 
course... 
I've come to believe no one is indispensable...even if you've served 5, 
10, 15 years in a company...there's always a reason to take you out no 
matter how good you are... 
And sometimes companies think...do I really need someone that good and 
costs a lot more? or can we do with someone quite average but can get 
the job done and costs a lot less? 

Tony Johnson wrote: 

> All I know about it is that for every new job in India one more DBA 
> is out of work here in the United States. 
> 
> -Original Message- 
> From: Ora DBA [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, September 03, 2003 5:30 AM 
> To: Multiple recipients of list ORACLE-L 
> Subject: Urgent INFO needed. 
> 
> Dear Friends, 
> 
> One of my friends has got the offer from CSC india ltd. 
> Please respond this mail if any one from CSC india ltd? just 
> to know some info , thats it. 
> 
> Any info regarding this is appreciated. Please give me your 
> mail id and contacts.. 
> 
> Thanks a lot. 
> 
> Regards 
> 
> Oracle DBA 
> 
> - 
> Do you Yahoo!? 
> Yahoo! SiteBuilder - Free, easy-to-use web site design 
> software 
> 
 Try MSN Messenger 6.0 with integrated webcam functionality! 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Quamrul Polash
  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: RE: URGENT : sql*loader performance problem on partionned tab

[NGUYEN Philippe (Cetelem)]

Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb!





Here the informations :
table HREL_FUSION : 
    63 millions rows
    3 indexes on columns : nodos_or, nodos_or, numcli <--- too much indexes ??
table primedi_enr2_temp_fusion : 133 000 rows
    I also took snaps with stastpack, can it help you ?
    this table is recreated and re-analyze each day, but the hanging part of the scritp in located here :


**
SELECT NULL
    FROM hrel_fusion
    WHERE cod_rel = :b1
  AND dat_rel = :b2
  AND NOT EXISTS (SELECT NULL
  FROM primedi_enr2_temp_fusion
  WHERE primedi_enr2_temp_fusion.nodos_or = 
    hrel_fusion.nodos_or
    AND primedi_enr2_temp_fusion.code_logis = 
    hrel_fusion.cod_rel
    AND primedi_enr2_temp_fusion.date_logis = 
    hrel_fusion.dat_rel)
    FOR UPDATE
**


The mostly amazing thing is that the same script work in 12 min on non-partitionned table.


Here a subset of the script :
***


cat <$maj_histo_rel



set serveroutput on;
DECLARE


vt_code_logis   char(4);
vt_date_logis   number(4);
n   number;


cursor curs_code_ctlm is 
select code_logis,date_logis from primedi_temp_fusion
where exists (select null from $TABLE_RETOURS
    where $TABLE_RETOURS.code_logis=primedi_temp_fusion.code_logis
    and $TABLE_RETOURS.date_logis=primedi_temp_fusion.date_logis
    and $TABLE_RETOURS.code_ficom=primedi_temp_fusion.code_ficom
    )
;



cursor curs_histo_ctlm1 (vt_code_logis char, vt_date_logis number) is
select null from HREL_FUSION
where cod_rel=vt_code_logis
and dat_rel=vt_date_logis
and not exists (select null from primedi_enr2_temp_fusion
    where primedi_enr2_temp_fusion.nodos_or=HREL_FUSION.nodos_or
    and primedi_enr2_temp_fusion.code_logis=HREL_FUSION.cod_rel
    and primedi_enr2_temp_fusion.date_logis=HREL_FUSION.dat_rel)
for update
;


BEGIN
DBMS_OUTPUT.ENABLE(50);
for curs in curs_code_ctlm
loop
    n:=0;
   for enr_histo in curs_histo_ctlm1 (curs.code_logis,curs.date_logis) loop
   delete from HREL_FUSION
   where current of curs_histo_ctlm1;
   n:=n+1;
   --if (mod(n,5000) = 0) then
 --commit;
   --end if;
   end loop;
   --commit;
   DBMS_OUTPUT.PUT_LINE('Supression de ' || n || ' ligne(s) ' ||curs.code_logis || curs.date_logis || ' dans l historique HREL_FUSION');


   -- update $TABLE_RETOURS
   -- set DATE_MAJ=to_number(to_char(sysdate,'mmdd'))
   -- where exists (select null from primedi_temp_fusion
--  where curs.code_logis=$TABLE_RETOURS.code_logis
--  and curs.date_logis=$TABLE_RETOURS.date_logis
--  )
--;


end loop;
COMMIT;
   
END;
/
exit;


EOD
***

Re: Urgent INFO needed.

[Maria Aurora de la Vega]

Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs
in India or some other countries with cheaper labor.
And to say that "you get what you pay for" or insinuating that cheaper
labor means less quality...is definitely out of line...
some people are just better than others...that's it...it has nothing
to do with geography or nationality...
some of the best DBAs...or IT professionals in general...are in fact
indians...
Point is its not the indians' fault jobs just come knocking at their
doors...
we all want better jobs and better pay...if it comes to me i'll grab
it no doubt... would I think about other DBAs who were taken off to accomodate
me? of course not. I have nothing to do with their decision to outsource...and
even if I stress myself worrying about it...can I do anything about it?
no...so, what do I do...I'd take advantage of course...
I've come to believe no one is indispensable...even if you've served
5, 10, 15 years in a company...there's always a reason to take you out
no matter how good you are...
And sometimes companies think...do I really need someone that good
and costs a lot more? or can we do with someone quite average but can get
the job done and costs a lot less?
Tony Johnson wrote:
 All
I know about it is that for every new job in India one more DBA is out
of work here in the United States.

-Original
Message-
From: Ora DBA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September
03, 2003 5:30 AM
To: Multiple recipients of
list ORACLE-L
Subject: Urgent INFO needed.
 
Dear Friends,
One of my friends has got the offer from CSC india ltd. Please respond
this mail if any one from CSC india ltd? just to know some info , thats
it.
Any info regarding this is appreciated. Please give me your mail id
and contacts..
Thanks a lot.
Regards
Oracle DBA

Do you Yahoo!?
Yahoo!
SiteBuilder - Free, easy-to-use web site design software

RE: Urgent INFO needed.

[Orr, Steve]

> part of the problem is that very few people can write decent 
> specs - because in any creative process, and software 
> engineering is one, you only converge towards the result 
> through several iterations

Good point. If folks speaking the same language aren't communicating
well how much more of a challenge is it when there is a language
barrier?! Regarding clear specs, here's one of my keeper links about
what it takes to write perfect software:
http://www.fastcompany.com/online/06/writestuff.html


Steve Orr



-Original Message-
Sent: Wednesday, September 03, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
Importance: High


I disagree about the 'you get what you pay for'. I have been reviewing
in the past weeks code written both in Bangalore and in Paris, and in
both cases I have had to reach for my Prozac box. For what had been
written in France, it is the product of a big (US) consulting firm which
must have been retrospectively happy to change their name a couple of
years ago; note that it is in no way specific of them, I can exhibit
dreadful code from multiple sources. I can assure you that it was both
bad and expensive. Concerning what you pay for, I believe that whatever
you outsource is far from being as cheap as it looks like; part of the
problem is the existence of a contract, part of the problem is indeed
the developers, part of the problem is that very few people can write
decent specs - because in any creative process, and software engineering
is one, you only converge towards the result through several iterations
(just look at famous manuscripts or Old Masters X-ray pictures), and
that interaction with end-users is essential.

Which means that I agree with the conclusion :-). 

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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: Urgent INFO needed.

[Stephane Faroult]

Freeman Robert - IL wrote:
> 
> Actually, I've seen the reverse be true. I've seen the work offshore be so
> poor that more folks are brought in locally to correct the problems, yet the
> offshore remain too because of contractual issues. Happened to me on at
> least two different occations. You get what you pay for. There are some
> great Indian DBA's out there (KG for one is awsome), but just as in America,
> for every great one there are probably 5 that should take up some other
> profession. This will come and go like everything else.
> 
> RF

I disagree about the 'you get what you pay for'. I have been reviewing
in the past weeks code written both in Bangalore and in Paris, and in
both cases I have had to reach for my Prozac box. For what had been
written in France, it is the product of a big (US) consulting firm which
must have been retrospectively happy to change their name a couple of
years ago; note that it is in no way specific of them, I can exhibit
dreadful code from multiple sources. I can assure you that it was both
bad and expensive.
Concerning what you pay for, I believe that whatever you outsource is
far from being as cheap as it looks like; part of the problem is the
existence of a contract, part of the problem is indeed the developers,
part of the problem is that very few people can write decent specs -
because in any creative process, and software engineering is one, you
only converge towards the result through several iterations (just look
at famous manuscripts or Old Masters X-ray pictures), and that
interaction with end-users is essential.

Which means that I agree with the conclusion :-). 

-- 
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: Urgent INFO needed.

[Ryan]

i dont think so. There is too much money in this. Odds are they will refine
their processes 'slowly' improve. Over a period of years they will be
better. Will it always be as good as the US? No, but it doesnt need to be.
Its cheap. This doesnt mean every IT job will dissapear, but there is a
contraction in the market and it is continueing..

Those manufacturing jobs sent to sweat shops never came back due to lack of
quality? No I dont think the IT market will dissapear, however, I think
wages will continue to decline at least for a while. Most of the jobs out
there these days are low paying, short temp jobs.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 5:29 PM


> Actually, I've seen the reverse be true. I've seen the work offshore be so
> poor that more folks are brought in locally to correct the problems, yet
the
> offshore remain too because of contractual issues. Happened to me on at
> least two different occations. You get what you pay for. There are some
> great Indian DBA's out there (KG for one is awsome), but just as in
America,
> for every great one there are probably 5 that should take up some other
> profession. This will come and go like everything else.
>
> RF
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 9/3/2003 3:44 PM
>
> That is call mondialisation...
>
>
>
> Stephane Paquette
>
>
> Administrateur de bases de donnees
>
> Database Administrator
>
> Standard Life
>
> www.standardlife.ca
>
> Tel. (514) 499-7999 7470 and (514) 925-7187
>
> [EMAIL PROTECTED]
> 
>
> -Original Message-
> Tony Johnson
> Sent: Wednesday, September 03, 2003 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> All I know about it is that for every new job in India one more DBA is
> out of work here in the United States.
>
> -Original Message-
> Sent: Wednesday, September 03, 2003 5:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Dear Friends,
>
> One of my friends has got the offer from CSC india ltd. Please respond
> this mail if any one from CSC india ltd? just to know some info , thats
> it.
>
> Any info regarding this is appreciated. Please give me your mail id and
> contacts..
>
> Thanks a lot.
>
> Regards
>
> Oracle DBA
>
>
>
>   _
>
> Do you Yahoo!?
> Yahoo!  
> SiteBuilder - Free, easy-to-use web site design software
>
> --
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  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: Urgent INFO needed.

[Freeman Robert - IL]

Actually, I've seen the reverse be true. I've seen the work offshore be so
poor that more folks are brought in locally to correct the problems, yet the
offshore remain too because of contractual issues. Happened to me on at
least two different occations. You get what you pay for. There are some
great Indian DBA's out there (KG for one is awsome), but just as in America,
for every great one there are probably 5 that should take up some other
profession. This will come and go like everything else.

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/3/2003 3:44 PM

That is call mondialisation...
 
 

Stephane Paquette


Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tel. (514) 499-7999 7470 and (514) 925-7187

[EMAIL PROTECTED]
 

-Original Message-
Tony Johnson
Sent: Wednesday, September 03, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


All I know about it is that for every new job in India one more DBA is
out of work here in the United States.

-Original Message-
Sent: Wednesday, September 03, 2003 5:30 AM
To: Multiple recipients of list ORACLE-L



Dear Friends, 

One of my friends has got the offer from CSC india ltd. Please respond
this mail if any one from CSC india ltd? just to know some info , thats
it. 

Any info regarding this is appreciated. Please give me your mail id and
contacts.. 

Thanks a lot. 

Regards 

Oracle DBA



  _  

Do you Yahoo!?
Yahoo!  
SiteBuilder - Free, easy-to-use web site design software

-- 
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: Urgent INFO needed.

[Stephane Paquette]

That 
is call mondialisation...
 
 



Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Tony JohnsonSent: 
  Wednesday, September 03, 2003 3:05 PMTo: Multiple recipients of 
  list ORACLE-LSubject: RE: Urgent INFO needed.
  All 
  I know about it is that for every new job in India one more DBA is out of work 
  here in the United States.
  
-Original Message-From: Ora DBA 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
5:30 AMTo: Multiple recipients of list 
ORACLE-LSubject: Urgent INFO needed.
Dear Friends, 
One of my friends has got the offer from CSC india ltd. Please respond 
this mail if any one from CSC india ltd? just to know some info , thats it. 

Any info regarding this is appreciated. Please give me your mail id and 
contacts.. 
Thanks a lot. 
Regards 
Oracle DBA



Do you Yahoo!?Yahoo! 
SiteBuilder - Free, easy-to-use web site design 
software

RE: Urgent INFO needed.

[Tony Johnson]

All I 
know about it is that for every new job in India one more DBA is out of work 
here in the United States.

  -Original Message-From: Ora DBA 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
  5:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Urgent INFO needed.
  Dear Friends, 
  One of my friends has got the offer from CSC india ltd. Please respond this 
  mail if any one from CSC india ltd? just to know some info , thats it. 
  Any info regarding this is appreciated. Please give me your mail id and 
  contacts.. 
  Thanks a lot. 
  Regards 
  Oracle DBA
  
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software

Re: RE: URGENT : sql*loader performance problem on partionned table

[rgaffuri]

1. by 'filling' are you doing inserts also? I see a 'FOR UPDATE' statement which 
implies that you are doing updates from with in a cursor. 
2. How many indexes do you have on this table?
3. Is anything else running at the same time? 
4. Are you doing your DML from with in a cursor. This is very slow. Try to do it all 
in SQL. 
5. Consider changing your not exists to 
Where NOT IN (SELECT /*+ hash_aj */ ...)
That can be faster if your sub-query is significantly less costly than your your outer 
query(its the opposite for exists). Wont necessarily help in your case. 
You can also eliminate the join with the 'in'. This can improve performance as well. 

Please post a subset of your batch script. Please format it so its readable. Ill look 
at it. Also please post how many rows are in each table. 

Ill see if I can find anything. I think the two locks on the same object are locks on 
seperate partitions. Not sure. 
> 
> From: "NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
> Date: 2003/09/03 Wed AM 09:59:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: URGENT : sql*loader performance problem on partionned table
> 
> thank U Dennis,
> 
> I use local index, 
> the script is still running (2hours now! instead of 10-20 min) and here is
> the statement  in question (the script who used non-partionned table is
> already ended)
> 
> SELECT NULL
> FROM hrel_fusion
> WHERE cod_rel = :b1
>   AND dat_rel = :b2
>   AND NOT EXISTS (SELECT NULL
>   FROM primedi_enr2_temp_fusion
>   WHERE primedi_enr2_temp_fusion.nodos_or = 
> hrel_fusion.nodos_or
> AND primedi_enr2_temp_fusion.code_logis = 
> hrel_fusion.cod_rel
> AND primedi_enr2_temp_fusion.date_logis = 
> hrel_fusion.dat_rel)
> FOR UPDATE
> 
> 
> The explain plan show that hrel_fusion table is ACCESS BY LOCAL INDEX ROWID
> and primedi table used INDEX too.
> When I looking at lock tables it show me 2 session locked :
> 
> SQL> select session_id, oracle_username, object_name
>   2  from v$locked_object lo, dba_objects o
>   3  where lo.object_id = o.object_id
>   4  ;
> 
> SESSION_ID ORACLE_USERNAMEOBJECT_NAME
> -- --
> 
> 
>  7 FICOM  HREL_FUSION
>  7 FICOM  HREL_FUSION
> 
> -Why are there 2 locks on this table even there only one session ?
> - Yesterday I did gather_statitic on this table and it worked fine (12 min),
> should I do this each day ?
> TIA
> Philippe
> 
> 
> 
> -Message d'origine-
> De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
> Envoyé : 02 September 2003 19:45
> À : Multiple recipients of list ORACLE-L
> Objet : RE: URGENT : sql*loader performance problem on partionned table
> 
> 
> Philippe
>  You aren't providing many details on which to base some guesses.
> However, your statement "brand new disks" implies that you are adding
> additional partitions to an existing table. Then, your statement "should I
> drop indexes" implies that you have indexes on the partitioned table,
> possibly global indexes. If you are continuing to grow a partitioned (or
> non-partitioned) table than has indexes, then the load time will increase
> because Oracle must integrate each new entry into the index, which will take
> more time as the index grows. Take a look at local indexes. If I not
> understood your situation correctly, please clarify your situation further.
> 
> 
> 
> Dennis Williams 
> DBA, 80%OCP, 100% DBA 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Tuesday, September 02, 2003 12:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi gurus, 
> we have two daily loads that one after the other. 
> The first fill up a non partitionned table and the second do the same into a
> partitionned table. 
> First times the second load ran very quickly : 1 min instead of 5 min (non
> partitionnned table). 
> But now since few days, the partitionned table filling take more than 1-2
> hours ! yesterday it took 14 hours  
> Any one has any clue ? 
> - Tablespaces for partitionned table used brand new separate disks 
> - Does it come from indexes ? should I drop them first ? 
> 
> Thankx in advance! 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: 

Urgent INFO needed.

[Ora DBA]

Dear Friends, 
One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. 
Any info regarding this is appreciated. Please give me your mail id and contacts.. 
Thanks a lot. 
Regards 
Oracle DBA

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

RE: URGENT : sql*loader performance problem on partionned table

[NGUYEN Philippe (Cetelem)]

Title: RE: URGENT : sql*loader performance problem on partionned table



thankx for all those 
advbices, actually, the problem does not come from the 
sql*loader but from this particular statement :

  SELECT NULL     FROM 
  hrel_fusion     WHERE cod_rel = 
  :b1   AND dat_rel = 
  :b2   AND NOT EXISTS 
  (SELECT NULL   
  FROM primedi_enr2_temp_fusion   
  WHERE primedi_enr2_temp_fusion.nodos_or =     
  hrel_fusion.nodos_or     
  AND primedi_enr2_temp_fusion.code_logis =     
  hrel_fusion.cod_rel     
  AND primedi_enr2_temp_fusion.date_logis =     
  hrel_fusion.dat_rel)     FOR 
  UPDATE 
  The explain plan show that hrel_fusion table is ACCESS BY 
  LOCAL INDEX ROWID and primedi table used INDEX too. When I looking at lock tables it show me 2 session locked : 
  SQL> select session_id, oracle_username, object_name 
    2  from v$locked_object lo, dba_objects o 
    3  where lo.object_id = o.object_id 
    4  ; 
  SESSION_ID 
  ORACLE_USERNAME    
  OBJECT_NAME -- -- 
  
   7 
  FICOM  
  HREL_FUSION  7 
  FICOM  
  HREL_FUSION 
  -Why are there 2 locks on this table even there only one 
  session ? - Yesterday I did gather_statitic on this 
  table and it worked fine (12 min), should I do this each day ? 
  TIA Philippe 
  -Message d'origine- De : 
  DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  Envoyé : 02 September 2003 19:45 À : 
  Multiple recipients of list ORACLE-L Objet : RE: 
  URGENT : sql*loader performance problem on partionned table 
  Philippe  You 
  aren't providing many details on which to base some guesses. However, your statement "brand new disks" implies that you are 
  adding additional partitions to an existing table. 
  Then, your statement "should I drop indexes" implies 
  that you have indexes on the partitioned table, possibly global indexes. If you are continuing to grow a partitioned 
  (or non-partitioned) table than has indexes, then the 
  load time will increase because Oracle must integrate 
  each new entry into the index, which will take more 
  time as the index grows. Take a look at local indexes. If I not 
  understood your situation correctly, please clarify your 
  situation further. 
  Dennis Williams DBA, 80%OCP, 100% DBA 
  Lifetouch, Inc. [EMAIL PROTECTED] 
  -Original Message- Sent: 
  Tuesday, September 02, 2003 12:14 PM To: Multiple 
  recipients of list ORACLE-L 
  Hi gurus, we have two daily loads that 
  one after the other. The first fill up a non 
  partitionned table and the second do the same into a partitionned table. First times the second load 
  ran very quickly : 1 min instead of 5 min (non partitionnned table). But now since few days, 
  the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours  Any one 
  has any clue ? - Tablespaces for partitionned table 
  used brand new separate disks - Does it come from 
  indexes ? should I drop them first ? 
  Thankx in advance! 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: DENNIS WILLIAMS   
  INET: [EMAIL PROTECTED] 

Re: URGENT : sql*loader performance problem on partionned table

[cornichepark]

Hello

Did you check alert.log for any unusual messages? May be it is using lot of
rollback / archiving.

You can use unrecoverable option to load. You have not mentioned whether
you are using direct load or not.

Check if too many extents are getting allocated at runtime. That is
going to slow down the load.

Presorting data on indexed columns is another method to speeden up load.
This is likely to minimise the use of temp segment.

HTH

GovindanK

> Hi gurus,
> we have two daily loads that one after the other.
> The first fill up a non partitionned table and the second do the same into
> a
> partitionned table.
> First times the second load ran very quickly : 1 min instead of 5 min (non
> partitionnned table).
> But now since few days, the partitionned table filling take more than 1-2
> hours ! yesterday it took 14 hours 
> Any one has any clue ?
> - Tablespaces for partitionned table used brand new separate disks
> - Does it come from indexes ? should I drop them first ?
>
> Thankx in advance!
>
>
>

-- 
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: URGENT : sql*loader performance problem on partionned table

[cornichepark]

Yesterday i posted a reply on this .. but did not reach.
Check if too much logging taking place. Avoid this with loading as
UNRECOVERABLE; Or else Presort the data on the index key to minimise
the use of Temp segment. As of now i am able to think of only these two.

HTH
GovindanK


> Hi gurus,
> we have two daily loads that one after the other.
> The first fill up a non partitionned table and the second do the same into
> a
> partitionned table.
> First times the second load ran very quickly : 1 min instead of 5 min (non
> partitionnned table).
> But now since few days, the partitionned table filling take more than 1-2
> hours ! yesterday it took 14 hours 
> Any one has any clue ?
> - Tablespaces for partitionned table used brand new separate disks
> - Does it come from indexes ? should I drop them first ?
>
> Thankx in advance!
>
>
>

-- 
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: URGENT : sql*loader performance problem on partionned table

[NGUYEN Philippe (Cetelem)]

Title: RE: URGENT : sql*loader performance problem on partionned table





thank U Dennis,


I use local index, 
the script is still running (2hours now! instead of 10-20 min) and here is the statement  in question (the script who used non-partionned table is already ended)

SELECT NULL
    FROM hrel_fusion
    WHERE cod_rel = :b1
  AND dat_rel = :b2
  AND NOT EXISTS (SELECT NULL
  FROM primedi_enr2_temp_fusion
  WHERE primedi_enr2_temp_fusion.nodos_or = 
    hrel_fusion.nodos_or
    AND primedi_enr2_temp_fusion.code_logis = 
    hrel_fusion.cod_rel
    AND primedi_enr2_temp_fusion.date_logis = 
    hrel_fusion.dat_rel)
    FOR UPDATE



The explain plan show that hrel_fusion table is ACCESS BY LOCAL INDEX ROWID and primedi table used INDEX too.
When I looking at lock tables it show me 2 session locked :


SQL> select session_id, oracle_username, object_name
  2  from v$locked_object lo, dba_objects o
  3  where lo.object_id = o.object_id
  4  ;


SESSION_ID ORACLE_USERNAME    OBJECT_NAME
-- -- 

 7 FICOM  HREL_FUSION
 7 FICOM  HREL_FUSION


-Why are there 2 locks on this table even there only one session ?
- Yesterday I did gather_statitic on this table and it worked fine (12 min), should I do this each day ?
TIA
Philippe




-Message d'origine-
De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Envoyé : 02 September 2003 19:45
À : Multiple recipients of list ORACLE-L
Objet : RE: URGENT : sql*loader performance problem on partionned table



Philippe
 You aren't providing many details on which to base some guesses.
However, your statement "brand new disks" implies that you are adding
additional partitions to an existing table. Then, your statement "should I
drop indexes" implies that you have indexes on the partitioned table,
possibly global indexes. If you are continuing to grow a partitioned (or
non-partitioned) table than has indexes, then the load time will increase
because Oracle must integrate each new entry into the index, which will take
more time as the index grows. Take a look at local indexes. If I not
understood your situation correctly, please clarify your situation further.




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


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




Hi gurus, 
we have two daily loads that one after the other. 
The first fill up a non partitionned table and the second do the same into a
partitionned table. 
First times the second load ran very quickly : 1 min instead of 5 min (non
partitionnned table). 
But now since few days, the partitionned table filling take more than 1-2
hours ! yesterday it took 14 hours  
Any one has any clue ? 
- Tablespaces for partitionned table used brand new separate disks 
- Does it come from indexes ? should I drop them first ? 


Thankx in advance! 



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

RE: URGENT : sql*loader performance problem on partionned table

[NGUYEN Philippe (Cetelem)]

Title: RE: URGENT : sql*loader performance problem on partionned table





precision : Oracle 8.1.7.3 (64 bits) in Solaris 8 


-Message d'origine-
De : NGUYEN Philippe (Cetelem) 
Envoyé : 02 September 2003 18:14
À : '[EMAIL PROTECTED]'
Objet : URGENT : sql*loader performance problem on partionned table



Hi gurus,
we have two daily loads that one after the other.
The first fill up a non partitionned table and the second do the same into a partitionned table.
First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table).
But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours 
Any one has any clue ?
- Tablespaces for partitionned table used brand new separate disks
- Does it come from indexes ? should I drop them first ?


Thankx in advance!

RE: URGENT : sql*loader performance problem on partionned table

[DENNIS WILLIAMS]

Philippe
 You aren't providing many details on which to base some guesses.
However, your statement "brand new disks" implies that you are adding
additional partitions to an existing table. Then, your statement "should I
drop indexes" implies that you have indexes on the partitioned table,
possibly global indexes. If you are continuing to grow a partitioned (or
non-partitioned) table than has indexes, then the load time will increase
because Oracle must integrate each new entry into the index, which will take
more time as the index grows. Take a look at local indexes. If I not
understood your situation correctly, please clarify your situation further.



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

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



Hi gurus, 
we have two daily loads that one after the other. 
The first fill up a non partitionned table and the second do the same into a
partitionned table. 
First times the second load ran very quickly : 1 min instead of 5 min (non
partitionnned table). 
But now since few days, the partitionned table filling take more than 1-2
hours ! yesterday it took 14 hours  
Any one has any clue ? 
- Tablespaces for partitionned table used brand new separate disks 
- Does it come from indexes ? should I drop them first ? 

Thankx in advance! 


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

URGENT : sql*loader performance problem on partionned table

[NGUYEN Philippe (Cetelem)]

Title: URGENT : sql*loader performance problem on partionned table





Hi gurus,
we have two daily loads that one after the other.
The first fill up a non partitionned table and the second do the same into a partitionned table.
First times the second load ran very quickly : 1 min instead of 5 min (non partitionnned table).
But now since few days, the partitionned table filling take more than 1-2 hours ! yesterday it took 14 hours 
Any one has any clue ?
- Tablespaces for partitionned table used brand new separate disks
- Does it come from indexes ? should I drop them first ?


Thankx in advance!

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Mladen Gogala]

$ su  - root
Password:
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]#
[EMAIL PROTECTED] root]# sync
[EMAIL PROTECTED] root]#
On 2003.08.22 00:34, Tim Gorman wrote:
I think the reasoning falls somewhere between the utterly rational and the
insanely superstitious...
I¹ve known people who would keep repeating ³sync² until their fingers
started tripping over one another, so I tend to see three ³sync²s as the
minimum.  At least, that¹s how it was explained to me 20 years ago:  ³by the
time you type it in for the third time, the first one has done the job²...
Go ahead, type in ³sync² just once.  I dare ya...



on 8/21/03 9:04 AM, Tanel Poder at [EMAIL PROTECTED] wrote:

> Hi!
>
> I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3*
> syncs everything has been written to disk? Or it more like that after that
> number of syncs, most of the changes should be on disk? (sounds stupid)
>
> Tanel.
>> - Original Message -
>> From: Tim Gorman <mailto:[EMAIL PROTECTED]>
>> To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]>
>> Sent: Thursday, August 21, 2003 12:04 AM
>> Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
>>
>> I’d suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior
to
>> the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to
make
>> me feel better)...
>>
>> Does anyone remember the UNIX mantra of entering “sync; sync; sync” before
>> “halt”?  :-)
>>
>>
>>
>> on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:
>>
>>> We have started waiting 90 min then do shutdown abort, startup, shutdown
>>> immediate
>>>
>>> April Wells
>>> Oracle DBA/Oracle Apps DBA
>>> Corporate Systems
>>> Amarillo Texas
>>>
>>> Few people really enjoy the simple pleasure of flying a kite
>>> Adam Wells age 11
>>>>
>>>> -Original Message-
>>>> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
>>>> Sent: Wednesday, August 20, 2003 12:54 PM
>>>> To: Multiple recipients of list ORACLE-L
>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons
>>>>
>>>> Which brings up that thread of - if they are hard to shutdown and
possibly
>>>> going to crash anyway then . why not just wait some period of time
and
>>>> do the old shutdown abort.
>>>>> -Original Message-
>>>>> From: April Wells [mailto:[EMAIL PROTECTED]
>>>>> Sent: Wednesday, August 20, 2003 1:00 PM
>>>>> To: Multiple recipients of list ORACLE-L
>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons
>>>>>
>>>>> We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting
them
>>>>> to shutdown elegantly... and they sometimes crash
>>>>>
>>>>> April Wells
>>>>> Oracle DBA/Oracle Apps DBA
>>>>> Corporate Systems
>>>>> Amarillo Texas
>>>>>
>>>>> Few people really enjoy the simple pleasure of flying a kite
>>>>> Adam Wells age 11
>>>>>>
>>>>>> -Original Message-
>>>>>> From: [EMAIL PROTECTED]
>>>>>> [mailto:[EMAIL PROTECTED]
>>>>>> Sent: Wednesday, August 20, 2003 11:50 AM
>>>>>> To: Multiple recipients of list ORACLE-L
>>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons
>>>>>>
>>>>>> BTW, nothing happening in terms of processes that would hang-up the
>>>>>> system.  Also, I have check alert and trace files and there are no
>>>>>> obvious errors.
>>>>>>> -Original Message-
>>>>>>> From: [EMAIL PROTECTED]
>>>>>>> [mailto:[EMAIL PROTECTED]
>>>>>>> Sent: Wednesday, August 20, 2003 12:25 PM
>>>>>>> To: Multiple recipients of list ORACLE-L
>>>>>>> Subject: RE: URGENT!!! My 9i databases are not shutting down
>>>>>>> cleanly/cons
>>>>>>>
>>>>>>>
>>>>>>> There seems to be a problem with consistent shutdowns in 9i
>>>>>>>
>>>>>>> Oracle 9i 64bit
>>>>>>>
>>>>>>> 9.0.1.3.0 - infrastructure database that comes with the application
>>>>>>>

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Tim Gorman]

Title: Re: URGENT!!!  My 9i databases are not shutting down cleanly/cons



I think the reasoning falls somewhere between the utterly rational and the insanely superstitious...

I’ve known people who would keep repeating “sync” until their fingers started tripping over one another, so I tend to see three “sync”s as the minimum.  At least, that’s how it was explained to me 20 years ago:  “by the time you type it in for the third time, the first one has done the job”...

Go ahead, type in “sync” just once.  I dare ya...



on 8/21/03 9:04 AM, Tanel Poder at [EMAIL PROTECTED] wrote:

Hi!
 
I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid)
 
Tanel.
- Original Message - 
From: Tim Gorman   
To: Multiple recipients of list ORACLE-L   
Sent: Thursday, August 21, 2003 12:04 AM
Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

I’d suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...

Does anyone remember the UNIX mantra of entering “sync; sync; sync” before “halt”?  :-)



on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:

We have started waiting 90 min then do shutdown abort, startup, shutdown immediate

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort.  
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

BTW, nothing happening in terms of processes that would hang-up the system.  Also, I have check alert and trace files and there are no obvious errors.  
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons


There seems to be a problem with consistent shutdowns in 9i 

Oracle 9i 64bit 

9.0.1.3.0 - infrastructure database that comes with the application server 
9.2.0.1.0 - that is the version of RDBMS we are running. 

Does anyone have problems shutting down their databases consistently with 9i? 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.
The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Paul Baumgartel]

Wow--that one sent me scrambling to Google.  Nice riposte!


--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Paul Baumgartel wrote:
> > 
> > A couple of corrections are in order here.  First, some Christians
> > might object to your characterizing the Holy Trinity, et. al. as
> > "mythology". 
> 
> I don't believe Andrei Rublev to be on this list.
> 
> -- 
> 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).
> 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  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: URGENT!!! My 9i databases are not shutting down

[Nelson, Allan]

Oh, we're used to it.  It's the predominant mythos of the current
society.  Everybody gets their own opinion unitl either death or
judgment.

Allan

-Original Message-
Sent: Thursday, August 21, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
cleanly/cons


Paul Baumgartel wrote:
> 
> A couple of corrections are in order here.  First, some Christians 
> might object to your characterizing the Holy Trinity, et. al. as 
> "mythology".

I don't believe Andrei Rublev to be on this list.

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



__
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 error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  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: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Stephane Faroult]

Paul Baumgartel wrote:
> 
> A couple of corrections are in order here.  First, some Christians
> might object to your characterizing the Holy Trinity, et. al. as
> "mythology". 

I don't believe Andrei Rublev to be on this list.

-- 
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: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Paul Baumgartel]

A couple of corrections are in order here.  First, some Christians
might object to your characterizing the Holy Trinity, et. al. as
"mythology".  Second, I thought we became food for worms, not ants.


--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> It's a superstition.  Whole christian mithology is based on the
> number 3. We
> have Holy Trinity, we have 3 places to go when we transcend 
> into food  for ants (paradise,purgatory, and the place with great
> demos) ,
> we have 3 layers of personality, according to Freud (libido, ego,
> super-ego),
> to make the whole story short, number 3 is sort of a mystical number
> in
> christian mithology. Now, please send me $3,333,333.33
>  
>  
> --
> Mladen Gogala
> Oracle DBA 
> 
> 
> -Original Message-
> Tanel Poder
> Sent: Thursday, August 21, 2003 12:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi!
>  
> I've always wondered why 3 syncs. Is it quaranteed, that after
> *exactly 3*
> syncs everything has been written to disk? Or it more like that after
> that
> number of syncs, most of the changes should be on disk? (sounds
> stupid)
>  
> Tanel.
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L
>   
> Sent: Thursday, August 21, 2003 12:04 AM
> 
> 
> I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just
> prior to
> the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just
> to
> make me feel better)...
> 
> Does anyone remember the UNIX mantra of entering "sync; sync; sync"
> before
> "halt"?  :-)
> 
> 
> 
> on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:
> 
> 
> 
> We have started waiting 90 min then do shutdown abort, startup,
> shutdown
> immediate
> 
> April Wells 
> Oracle DBA/Oracle Apps DBA 
> Corporate Systems 
> Amarillo Texas 
> 
> Few people really enjoy the simple pleasure of flying a kite 
> Adam Wells age 11 
> 
> 
> 
> -Original Message-
> ]
> Sent: Wednesday, August 20, 2003 12:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Which brings up that thread of - if they are hard to shutdown and
> possibly
> going to crash anyway then . why not just wait some period of
> time and
> do the old shutdown abort.  
> 
> 
> -Original Message-
> Sent: Wednesday, August 20, 2003 1:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting
> them to
> shutdown elegantly... and they sometimes crash
> 
> April Wells 
> Oracle DBA/Oracle Apps DBA 
> Corporate Systems 
> Amarillo Texas 
> 
> Few people really enjoy the simple pleasure of flying a kite 
> Adam Wells age 11 
> 
> 
> 
> -Original Message-
> ]
> Sent: Wednesday, August 20, 2003 11:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> BTW, nothing happening in terms of processes that would hang-up the
> system.
> Also, I have check alert and trace files and there are no obvious
> errors.  
> 
> 
> -Original Message-
> ]
> Sent: Wednesday, August 20, 2003 12:25 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> There seems to be a problem with consistent shutdowns in 9i 
> 
> Oracle 9i 64bit 
> 
> 9.0.1.3.0 - infrastructure database that comes with the application
> server 
> 9.2.0.1.0 - that is the version of RDBMS we are running. 
> 
> Does anyone have problems shutting down their databases consistently
> with
> 9i? 
> 
> 
> 
> The information contained in this communication, including
> attachments, is
> strictly 
> confidential and for the intended use of the addressee only; it may
> also
> contain 
> proprietary, price sensitive, or legally privileged information.
> Notice is
> hereby given that 
> any disclosure, distribution, dissemination, use, or copying of the
> information by anyone 
> other than the intended recipient is strictly prohibited and may be
> illegal.
> If you have 
> received this communication in error, please notify the sender
> immediately
> by reply e-mail, 
> delete this communication, and destroy all copies.
>  
> 
> Corporate Systems, Inc. has taken reasonable precautions to ensure
> that any
> attachment to 
> this e-mail has been swept for viruses. We specifically disclaim all
> liability and will 
> accept no responsibility for any damage sustained as a result of
> software
> viruses and advise 
> you to carry out your own virus checks before opening any attachment.
> 
> 
> The information contained in this communication, including
> attachments, is
> strictly 
> confidential and for the intended use of the addressee only; it may
> also
> contain 
> proprietary, price sensitive, or legally privileged information.
> Notice is
> hereby given that 
> any disclosure, distribution, dissemination, use, or copying of the
> information by anyone 
> other than the intended recipient is strictly prohibited and may be
> illegal.
> If you have 
> received this communication in error, please notify the sender
> immediately
> by reply e-mail, 
> dele

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Thater, William]

 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  4:04 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  Um, yeah. [Shrek] 
  sync
  sync
  sync
   
  move 
  thread to [EMAIL PROTECTED]
   
  --
  Bill 
  "Shrek" Thater ORACLE 
  DBA  BAARF Party member #25
      
  [EMAIL PROTECTED]
  
  A 
  good intention but fixed and resolute - bent on high and holy ends, we shall 
  find means to them on every side and at every moment; and even obstacles and 
  opposition will but make us "like the fabled spectre-ships," which sail the 
  fastest in the very teeth of the wind. - Ralph Waldo 
  Emerson
   

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Mladen Gogala]

Title: Message



Yes 
they did, despite the fact that Croatia had communism while I was growing 
up.
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/consUm, 
  yeah. 
  


  
  "Mercadante, Thomas F" 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 08/21/2003 12:39 PM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        RE: URGENT!!!  My 9i 
databases are not shutting down 
  cleanly/cons"Did the nuns hit your knuckles with a ruler as 
  well?"   three times for the father, son and holy 
  ghost!     PS - Jared, is this enough??? -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consThanks for 
  all the wonderful and interesting responses - esp. Tim Gorman.  I think 
  that is what I needed.  Sorry to resurface that old issue again. 
   Mladen, you too?  Did the nuns hit your knuckles with a ruler as 
  well?     -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
  August 21, 2003 2:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consHey Tom, 
  You can send me $111 3 times and 
  I'll be happy!  ;o)   -Scott 
  Stefick -Original 
  Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 
  1:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: URGENT!!! My 9i databases are not shutting down 
  cleanly/conshow about if I 
  send you $1,111,111.11   3 times.   -Original 
  Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down 
  cleanly/consIt's a 
  superstition.  Whole christian mithology is based on the number 3. We 
  have Holy Trinity, we have 3 places to go when we transcend into food  for ants (paradise,purgatory, and 
  the place with great demos) , we have 3 layers of personality, according to 
  Freud (libido, ego, super-ego), to make the whole story short, number 3 is sort of a mystical number in 
  christian mithology. Now, please send me $3,333,333.33     --Mladen 
  GogalaOracle DBA -Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: 
  Thursday, August 21, 2003 12:05 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not shutting 
  down cleanly/consHi!   I've 
  always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs 
  everything has been written to disk? Or it more like that after that number of 
  syncs, most of the changes should be on disk? (sounds stupid)   Tanel. - Original 
  Message - From: 
  Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 12:04 AM Subject: Re: URGENT!!! My 9i databases 
  are not shutting down cleanly/cons I'd 
  suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the 
  SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me 
  feel better)...Does anyone remember the UNIX mantra of entering "sync; 
  sync; sync" before "halt"?  :-)on 8/20/03 11:09 AM, April 
  Wells at [EMAIL PROTECTED] 
  wrote:We have 
  started waiting 90 min then do shutdown abort, startup, shutdown 
  immediateApril Wells Oracle DBA/Oracle Apps DBA Corporate 
  Systems Amarillo Texas Few people really enjoy the simple pleasure of 
  flying a kite Adam Wells age 11 -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 12:54 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/consWhich 
  brings up that thread of - if they are hard to shutdown and possibly going to 
  crash anyway then . why not just wait some period of time and do the old 
  shutdown abort.   -Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 2003 1:00 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT!!! My 9i databases are not shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 
  9.2.0.2 we have trouble getting them to shutdown elegantly... and they 
  sometimes crashApril

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Jared . Still]

Um, yeah.








"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/21/2003 12:39 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: URGENT!!!  My 9i databases are not shutting down cleanly/cons


"Did the nuns hit your knuckles with a ruler as well?"
 
three times for the father, son and holy ghost!
 
 
PS - Jared, is this enough???
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Thanks for all the wonderful and interesting responses - esp. Tim Gorman.  I think that is what I needed.  Sorry to resurface that old issue again.  Mladen, you too?  Did the nuns hit your knuckles with a ruler as well?
 
 
-Original Message-
From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Hey Tom, 
You can send me $111 3 times and I'll be happy!  ;o)
 
-Scott Stefick
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 21, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

how about if I send you $1,111,111.11   3 times.
 
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

It's a superstition.  Whole christian mithology is based on the number 3. We have Holy Trinity, we have 3 places to go when we transcend 
into food  for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of personality, according to Freud (libido, ego, super-ego),
to make the whole story short, number 3 is sort of a mystical number in christian mithology. Now, please send me $3,333,333.33
 
 
--
Mladen Gogala
Oracle DBA 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder
Sent: Thursday, August 21, 2003 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

Hi!
 
I've always wondered why 3 syncs. Is it quaranteed, that after *exactly 3* syncs everything has been written to disk? Or it more like that after that number of syncs, most of the changes should be on disk? (sounds stupid)
 
Tanel.
- Original Message - 
From: Tim Gorman 
To: Multiple recipients of list ORACLE-L 
Sent: Thursday, August 21, 2003 12:04 AM
Subject: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

I'd suggest throwing a couple ALTER SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help speed up the subsequent STARTUP (and just to make me feel better)...

Does anyone remember the UNIX mantra of entering "sync; sync; sync" before "halt"?  :-)



on 8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] wrote:

We have started waiting 90 min then do shutdown abort, startup, shutdown immediate

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

Which brings up that thread of - if they are hard to shutdown and possibly going to crash anyway then . why not just wait some period of time and do the old shutdown abort.  
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

We do, Paula... both in 9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown elegantly... and they sometimes crash

April Wells 
Oracle DBA/Oracle Apps DBA 
Corporate Systems 
Amarillo Texas 

Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

BTW, nothing happening in terms of processes that would hang-up the system.  Also, I have check alert and trace files and there are no obvious errors.  
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 20

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Mercadante, Thomas F]

Title: Message



"Did 
the nuns hit your knuckles with a ruler as well?"
 
three 
times for the father, son and holy ghost!
 
 
PS - 
Jared, is this enough???

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Thanks for all the wonderful and interesting responses - esp. Tim 
  Gorman.  I think that is what I needed.  Sorry to resurface that old 
  issue again.  Mladen, you too?  Did the nuns hit your knuckles with 
  a ruler as well?
   
   
  
-Original Message-From: Stefick Ronald S Contr 
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
August 21, 2003 2:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
Hey Tom, 
You can send me $111 3 times and I'll be happy!  
;o)
 
-Scott Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  August 21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how about if I send you $1,111,111.11   3 
  times.
   
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
2003 2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/cons
It's a superstition.  Whole christian mithology is based on 
the number 3. We have Holy Trinity, we have 3 places to go when we 
transcend 
into food  for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of 
personality, according to Freud (libido, ego, 
super-ego),
to make the whole story short, number 3 is sort of a mystical 
number in christian mithology. Now, please send me 
$3,333,333.33
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: URGENT!!! My 9i databases are not 
  shutting down cleanly/cons
  Hi!
   
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written 
  to disk? Or it more like that after that number of syncs, most of the 
  changes should be on disk? (sounds stupid)
   
  Tanel.
  
- Original Message - 
From: 
Tim 
Gorman 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
12:04 AM
    Subject: Re: URGENT!!! My 9i 
databases are not shutting down cleanly/cons
I'd suggest throwing a couple ALTER 
SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
speed up the subsequent STARTUP (and just to make me feel 
better)...Does anyone remember the UNIX mantra of entering 
"sync; sync; sync" before "halt"?  :-)on 
8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
We have started waiting 90 min then do 
  shutdown abort, startup, shutdown 
  immediateApril Wells 
  Oracle 
  DBA/Oracle Apps DBA 
  Corporate 
  Systems Amarillo 
  Texas Few people really enjoy the 
  simple pleasure of flying a kite 
  Adam Wells age 
  11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 12:54 PMTo: Multiple 
    recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consWhich brings up that thread of - if they are hard to 
shutdown and possibly going to crash anyway then . why not 
just wait some period of time and do the old shutdown abort. 
 
-Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 
  20, 2003 1:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are 
  not shutting down cleanly/consWe do, Paula... both 
  i

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Jamadagni, Rajendra]

Title: Message



One thing I like about 'sync' is it will fail silently. i.e.., if 
you don't have privs, it will not complain but pretend that it completed 
successfully, which is correct, it completed successfully but didn't do 
anything.
 
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, August 21, 
  2003 3:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Thanks for all the wonderful and interesting responses - esp. Tim 
  Gorman.  I think that is what I needed.  Sorry to resurface that old 
  issue again.  Mladen, you too?  Did the nuns hit your knuckles with 
  a ruler as well?
   
   
  
-Original Message-From: Stefick Ronald S Contr 
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
August 21, 2003 2:49 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
Hey Tom, 
You can send me $111 3 times and I'll be happy!  
;o)
 
-Scott Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  August 21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how about if I send you $1,111,111.11   3 
  times.
   
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 
2003 2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/cons
It's a superstition.  Whole christian mithology is based on 
the number 3. We have Holy Trinity, we have 3 places to go when we 
transcend 
into food  for ants (paradise,purgatory, and the place with great demos) , we have 3 layers of 
personality, according to Freud (libido, ego, 
super-ego),
to make the whole story short, number 3 is sort of a mystical 
number in christian mithology. Now, please send me 
$3,333,333.33
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list 
      ORACLE-LSubject: Re: URGENT!!! My 9i databases are not 
  shutting down cleanly/cons
  Hi!
   
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written 
  to disk? Or it more like that after that number of syncs, most of the 
  changes should be on disk? (sounds stupid)
   
  Tanel.
  
- Original Message - 
From: 
Tim 
Gorman 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
    12:04 AM
Subject: Re: URGENT!!! My 9i 
databases are not shutting down cleanly/cons
I'd suggest throwing a couple ALTER 
SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
speed up the subsequent STARTUP (and just to make me feel 
better)...Does anyone remember the UNIX mantra of entering 
"sync; sync; sync" before "halt"?  :-)on 
8/20/03 11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
We have started waiting 90 min then do 
  shutdown abort, startup, shutdown 
  immediateApril Wells 
  Oracle 
  DBA/Oracle Apps DBA 
  Corporate 
  Systems Amarillo 
  Texas Few people really enjoy the 
  simple pleasure of flying a kite 
  Adam Wells age 
  11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 12:54 PMTo: Multiple 
    recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consWhich brings up that thread of - if they are hard to 
shutdown and possibly going to crash anyway then . why not 
just wait some period of time and do the old shutdown abort. 
 
--

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Paula_Stankus]

Title: Message



Thanks 
for all the wonderful and interesting responses - esp. Tim Gorman.  I think 
that is what I needed.  Sorry to resurface that old issue again.  
Mladen, you too?  Did the nuns hit your knuckles with a ruler as 
well?
 
 

  -Original Message-From: Stefick Ronald S Contr 
  ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, 
  August 21, 2003 2:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  Hey 
  Tom, 
  You 
  can send me $111 3 times and I'll be happy!  ;o)
   
  -Scott Stefick
  

-Original Message-From: Mercadante, 
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 
21, 2003 1:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
how about if I send you $1,111,111.11   3 
times.
 

  -Original Message-From: Mladen Gogala 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
  2:04 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  It's a superstition.  Whole christian mithology is based on 
  the number 3. We have Holy Trinity, we have 3 places to go when we 
  transcend 
  into food  for ants (paradise,purgatory, 
  and the place with great demos) , we have 3 layers of personality, 
  according to Freud (libido, ego, super-ego),
  to make the whole story short, number 3 is sort of a mystical 
  number in christian mithology. Now, please send me 
  $3,333,333.33
   
   
  --Mladen GogalaOracle DBA 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
Tanel PoderSent: Thursday, August 21, 2003 12:05 
PMTo: Multiple recipients of list ORACLE-LSubject: 
    Re: URGENT!!! My 9i databases are not shutting down 
cleanly/cons
Hi!
 
I've always wondered why 3 syncs. Is it 
quaranteed, that after *exactly 3* syncs everything has been written to 
disk? Or it more like that after that number of syncs, most of the 
changes should be on disk? (sounds stupid)
 
Tanel.

  - Original Message - 
  From: 
  Tim 
  Gorman 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, August 21, 2003 
  12:04 AM
  Subject: Re: URGENT!!! My 9i 
  databases are not shutting down cleanly/cons
  I'd suggest throwing a couple ALTER 
  SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
  speed up the subsequent STARTUP (and just to make me feel 
  better)...Does anyone remember the UNIX mantra of entering 
  "sync; sync; sync" before "halt"?  :-)on 8/20/03 
  11:09 AM, April Wells at [EMAIL PROTECTED] 
  wrote:
  We have started waiting 90 min then do shutdown 
abort, startup, shutdown immediateApril 
Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
Few people 
really enjoy the simple pleasure of flying a kite Adam 
Wells age 11 
-Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, 
  August 20, 2003 12:54 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWhich brings up that thread of - if they are hard to 
  shutdown and possibly going to crash anyway then . why not 
  just wait some period of time and do the old shutdown abort. 
   
  -Original 
Message-From: April Wells 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
2003 1:00 PMTo: Multiple recipients of list 
    ORACLE-LSubject: RE: URGENT!!! My 9i databases are 
not shutting down cleanly/consWe do, Paula... both in 
9.0.1.3 and 9.2.0.2 we have trouble getting them to shutdown 
elegantly... and they sometimes 
crashApril Wells Oracle DBA/Oracle Apps 
DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure 
of flying a kite Adam Wells age 
11 
-Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: 
  Wednesday, August 20, 2003 11:50 AMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: URGENT!!! 
  My 9i databases are not shutting down 
  cleanl

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Mladen Gogala]

I will not object to anything. You can send me $1 and I'll gladly take it

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

[Stefick Ronald S Contr ESC/HRIDD]

Title: Message



Hey 
Tom, 
You 
can send me $111 3 times and I'll be happy!  ;o)
 
-Scott 
Stefick

  
  -Original Message-From: Mercadante, 
  Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 
  21, 2003 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
  down cleanly/cons
  how 
  about if I send you $1,111,111.11   3 times.
   
  
-Original Message-From: Mladen Gogala 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 
2:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not shutting 
down cleanly/cons
It's a superstition.  Whole christian mithology is based on the 
number 3. We have Holy Trinity, we have 3 places to go when we transcend 

into food  for ants (paradise,purgatory, 
and the place with great demos) , we have 3 layers of personality, according 
to Freud (libido, ego, super-ego),
to 
make the whole story short, number 3 is sort of a mystical number in 
christian mithology. Now, please send me $3,333,333.33
 
 
--Mladen GogalaOracle DBA 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Tanel PoderSent: Thursday, August 21, 2003 12:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: URGENT!!! My 9i databases are not shutting down 
  cleanly/cons
  Hi!
   
  I've always wondered why 3 syncs. Is it 
  quaranteed, that after *exactly 3* syncs everything has been written to 
  disk? Or it more like that after that number of syncs, most of the changes 
  should be on disk? (sounds stupid)
   
  Tanel.
  
- Original Message - 
From: 
Tim 
Gorman 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, August 21, 2003 
12:04 AM
    Subject: Re: URGENT!!! My 9i 
databases are not shutting down cleanly/cons
I'd suggest throwing a couple ALTER 
SYSTEM CHECKPOINT commands just prior to the SHUTDOWN ABORT, to help 
speed up the subsequent STARTUP (and just to make me feel 
better)...Does anyone remember the UNIX mantra of entering 
"sync; sync; sync" before "halt"?  :-)on 8/20/03 
11:09 AM, April Wells at [EMAIL PROTECTED] 
wrote:
We have started waiting 90 min then do shutdown 
  abort, startup, shutdown immediateApril 
  Wells Oracle DBA/Oracle Apps DBA Corporate Systems 
  Amarillo 
  Texas Few people really enjoy the simple pleasure of 
  flying a kite Adam Wells age 11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, 
August 20, 2003 12:54 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
shutting down cleanly/consWhich brings up that thread of - if they are hard to 
shutdown and possibly going to crash anyway then . why not just 
wait some period of time and do the old shutdown abort. 
 
-Original 
  Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 20, 
  2003 1:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: URGENT!!! My 9i databases are not 
  shutting down cleanly/consWe do, Paula... both in 9.0.1.3 and 9.2.0.2 
  we have trouble getting them to shutdown elegantly... and they 
  sometimes crashApril Wells 
  Oracle 
  DBA/Oracle Apps DBA 
  Corporate 
  Systems Amarillo 
  Texas Few people really enjoy the 
  simple pleasure of flying a kite 
  Adam Wells age 
  11 
  -Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, August 20, 2003 11:50 AMTo: Multiple 
recipients of list ORACLE-LSubject: RE: URGENT!!! My 
9i databases are not shutting down 
cleanly/consBTW, nothing happening in terms of processes that 
would hang-up the system.  Also, I have check alert and 
trace files and there are no obvious errors. 
 
-Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: 
  Wednesday, August 20, 2003 12:25 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: URGENT!!! 
  My 9i databases are not shutting down 
  cleanly/consThere seems to be a problem with consistent shutdowns