RE: Bind variables v. cursor_sharing = FORCE

[Steve Adams]

Hi Greg and list,

I'm not convinced of John's conclusion that 'cursor_sharing' = FORCE outperforms bind 
variables. Some months ago I tried
to reproduce John's results and was not able to, despite trying several different 
variations on the tests. Tom Kyte
claims that 'cursor_sharing' is about 10% more expensive. My results were between 10% 
and 30%.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all


-Original Message-
Sent: Saturday, 20 October 2001 7:21
To: Multiple recipients of list ORACLE-L


An excerpt from

PIRANHAS IN THE POOL,
SQL PERFORMANCE KILLERS
Investigating the effects of literal SQL on Oracle performance

John Beresniewicz
Precise Software Solutio

--
Effect of CURSOR_SHARING
A primary purpose of the 8.1.6 testing was to assess the impact the new CURSOR_SHARING 
system parameter and its
potential for helping DBAs manage ill-behaved applications with high parse rates of 
literal SQL.  Comparing Test 1 to
Test 3 and also Test 0 to Test 4 serves this goal.
Comparing these Test results, CURSOR_SHARING exhibits advantages similar to those 
obtained using bind variables in Test
2:
-- Reduced library cache impact.
-- Negligible shared pool activity.
-- Reduced CPU demands.
In fact, Test 3 produced the best elapsed time of all tests in spite of the fact that 
all the SQL was literal.  Thus, it
is clear that CURSOR_SHARING can be used to greatly enhance performance of 
applications that produce high volume literal
SQL and thus is a great advantage for the DBA saddled with such applications.
CURSOR_SHARING vs. Bind Variables
Comparing Test 2 and Test 3 reveals that CURSOR_SHARING = FORCE showed significantly 
better performance than bind
variables in both elapsed time and reduced library cache latching impact.  This 
surprising result deserves further
investigation to produce an adequate explanation.  Library cache latch impact was 
significantly reduced as well as
shared pool pins and releases. Parsing CPU time increased some but overall CPU was 
reduced. Perhaps the additional
parsing involved in forced cursor sharing also enables increased sharing of shared 
pool memory heaps.

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

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

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

RE: ORA 235

[Steve Adams]

Hi Sinardy,

Further to that, if you've looked at 'recover.bsq' you'll have seen that it attempts 
up to 5 retries in the event of
ORA-235 errors. If you want to write similarly robust code and use event 10327 to test 
it, then you might want to use
the seldom used LIFETIME qualifier of the event syntax instead of the FOREVER 
qualifier that I suggested before.  For
example, you could simulate getting the error twice and then succeeding on the third 
attempt using the qualifier
LIFETIME 2.

There is also an AFTER n TIMES qualifier available that can be used to delay the 
raising of the error. The thing to
watch here is that queries against the controlfile based V$ views may need to read 
more than one block from the
controlfile. So although a query against V$THREAD can get away with just one 
controlfile read, my full scan of V$LOGHIST
actually did 19 controlfile reads, so I would need to specify AFTER 19 TIMES to get 
the query to succeed once before
failing. The AFTER n TIMES qualifier can be combined with the LIFETIME qualifier using 
a comma to get both effects as
follows.

SQL> alter session set events '10327 trace name context after 19 times, 
lifetime 2';

Session altered.

SQL> select count(*) from v$loghist;

  COUNT(*)
--
   823

SQL> /
select count(*) from v$loghist
*
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update


SQL> /
select count(*) from v$loghist
*
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update


SQL> /

  COUNT(*)
--
   823

SQL>

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all


-Original Message-
Sent: Friday, 19 October 2001 19:05
To: Sinard Xing; Multiple recipients of list ORACLE-L


Hi Sinardy,

Sure, the following should illustrate how you might use it for testing ...

SQL> alter session set events '10327 trace name context forever';

Session altered.

SQL> select count(*) from v$loghist;
select count(*) from v$loghist
 *
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update


SQL>

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all


-Original Message-
Sent: Friday, 19 October 2001 19:20
To: Multiple recipients of list ORACLE-L


Hi Steve,

Can you please give some hint, what is event 10327 ?


Regards,

Sinardy


-Original Message-
Sent: Friday, 19 October 2001 3:38 PM
To: Sinard Xing; Multiple recipients of list ORACLE-L


Hi Sinardy,

It probably means that a log switch was in progress at the same time as the
query. However, the error can be simulated
by setting event 10327. So if someone's been setting events and has messed
up, that could also explain it. You can use
that event for testing if you want to write robust code that handles the
error. A good example of such code can be seen
in '$ORACLE_HOME/rdbms/admin/recover.bsq'.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/   -  For all


-Original Message-


Can someone tell me what is the cause of this error

FROM sys.v_$loghist lh1, sys.v_$loghist lh2
 *
ERROR at line 6:
ORA-00235: controlfile fixed table inconsistent due to concurrent update

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

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

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

RE:

[Jared . Still]

I can't, he's from Montana.

Jared




   
 
"Mohan, Ross"  
 

SMI.com> cc:   
 
Sent by: Subject: RE:  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
10/19/01 12:07 
 
PM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Jared,

throw this individual off. He is a big, fat meanie.

Waa Waa Waa

- Ross "nowaltiamnotasheep" Mohan

-Original Message-
Sent: Friday, October 19, 2001 1:39 PM
To: Multiple recipients of list ORACLE-L


Are you an idiot?

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, October 19, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L


HELP

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

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

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




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

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

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

Re: Bind Variables

[Jared . Still]

Danny,

Bind variables are nearly always better than literals in your SQL.

The one exception I can think of is if you are making using of histograms,
but those aren't often used in OLTP type apps.

Without sitting down and analyzing what was taking place, all anyone
can do is guess.  If you have a test box to do this on, then you can
analyze the before and after SQL, check v$systemevent, etc.

If you don't have a test box, you have a good reason to get one.

If your queries are returning in 2 second while parsing SQL, it should
be able to go significantly faster with bind variables, particularly
under load.

Literal SQL doesn't scale very well.

Jared




   
 
"Danny 
 
Hughes<[EMAIL PROTECTED]   To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>
>" 2 minutes to load.  The db server was pegged at 100% from 8-5 every
=
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,
=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.

There are so many confusing documents regarding the use of bind variables.
=
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"


--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I have a question about using bind variables.  It is my understanding that
=
bind variables are to be used to keep the same SQL from being reparsed and
=
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While
=
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly
=
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com


--KMQGUMGTJRAMPYVFBAEF--

--HALPYZPZYFFYCGAKLKOY--

--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature

MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4w

ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQI

EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD

VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNB

IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlRo

YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20w

XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCwJ

P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHVn

aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxSe

oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK+

2GR13ldRWLfoDphFJyvBXuI0x2AhPpC+KY04jBojgtKmwX//BoKquodT89CzcDrZaU4FRU5OG7cM

Hc4q/c8wggMpMIICkqADAgECAgEMMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMG

A1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjA

RE: Bind Variables

[Kimberly Smith]

I have heard of it.  Its a concern.  However, with hints you can
solve some of your problems.  And then you could use Stored Outlines
and get it stable.  And then life will be groovy.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L





Danny,

It sounds like when you "...moved to bind variables..." you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.

I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so --  the CBO vs. RBO is irrelevant
in this case).

Thus the question: did you collect the statistics on all your application
tables prior to switching to CBO?

If you did not have any statistics collected or had some tables that did
not have statistics collected then Oracle may had been choosing wrong
execution path.

Thanks,
Val Gamerman.




[EMAIL PROTECTED] on 10/19/2001 03:07:56 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Val Gamerman/Victoria Financial)






Danny,
Were you using histograms?   Histograms do not work on bind variables,
they only work on literals.
I'm sure others will have more to say on the topic but that is one tidbit
that
I do have experience with on bind variables.
Cherie Machler
Oracle DBA
Gelco Information Network


"Danny
Hughes<[EMAIL PROTECTED]   To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>" 2 minutes to load.  The db server was pegged at 100% from 8-5 every
=
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,
=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.
There are so many confusing documents regarding the use of bind variables.
=
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.
TIA
Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com
--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"

--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
I have a question about using bind variables.  It is my understanding that
=
bind variables are to be used to keep the same SQL from being reparsed and
=
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While
=
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly
=
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--KMQGUMGTJRAMPYVFBAEF--
--HALPYZPZYFFYCGAKLKOY--
--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature
MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4
w
ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQ
I
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwY
D
VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlN
B
IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlR
o
YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb2

Re: Bind Variables

[Val_Gamerman/Victoria_Financial . VICTORIA_FINANCIAL]

Danny,

It sounds like when you "...moved to bind variables..." you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.

I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so --  the CBO vs. RBO is irrelevant
in this case).

Thus the question: did you collect the statistics on all your application
tables prior to switching to CBO?

If you did not have any statistics collected or had some tables that did
not have statistics collected then Oracle may had been choosing wrong
execution path.

Thanks,
Val Gamerman.




[EMAIL PROTECTED] on 10/19/2001 03:07:56 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Val Gamerman/Victoria Financial)






Danny,
Were you using histograms?   Histograms do not work on bind variables,
they only work on literals.
I'm sure others will have more to say on the topic but that is one tidbit
that
I do have experience with on bind variables.
Cherie Machler
Oracle DBA
Gelco Information Network


"Danny
Hughes<[EMAIL PROTECTED]   To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>" 2 minutes to load.  The db server was pegged at 100% from 8-5 every
=
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,
=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.
There are so many confusing documents regarding the use of bind variables.
=
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.
TIA
Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com
--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"

--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
I have a question about using bind variables.  It is my understanding that
=
bind variables are to be used to keep the same SQL from being reparsed and
=
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While
=
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly
=
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--KMQGUMGTJRAMPYVFBAEF--
--HALPYZPZYFFYCGAKLKOY--
--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature
MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4
w
ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQ
I
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwY
D
VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlN
B
IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlR
o
YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20
w
XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCw
J
P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHV
n
aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxS
e
oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK
+
2GR13

Re: Bind Variables

[Val_Gamerman/Victoria_Financial . VICTORIA_FINANCIAL]

Danny,

It sounds like when you "...moved to bind variables..." you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.

I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so --  the CBO vs. RBO is irrelevant
in this case).

Thus the question: did you collect the statistics on all your application
tables prior to switching to CBO?

If you did not have any statistics collected or had some tables that did
not have statistics collected then Oracle may had been choosing wrong
execution path.

Thanks,
Val Gamerman.




[EMAIL PROTECTED] on 10/19/2001 03:07:56 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Val Gamerman/Victoria Financial)






Danny,
Were you using histograms?   Histograms do not work on bind variables,
they only work on literals.
I'm sure others will have more to say on the topic but that is one tidbit
that
I do have experience with on bind variables.
Cherie Machler
Oracle DBA
Gelco Information Network


"Danny
Hughes<[EMAIL PROTECTED]   To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>" 2 minutes to load.  The db server was pegged at 100% from 8-5 every
=
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,
=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.
There are so many confusing documents regarding the use of bind variables.
=
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.
TIA
Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com
--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"

--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
I have a question about using bind variables.  It is my understanding that
=
bind variables are to be used to keep the same SQL from being reparsed and
=
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While
=
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly
=
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--KMQGUMGTJRAMPYVFBAEF--
--HALPYZPZYFFYCGAKLKOY--
--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature
MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4
w
ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQ
I
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwY
D
VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlN
B
IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlR
o
YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20
w
XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCw
J
P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHV
n
aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxS
e
oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK
+
2GR13

Re: Bind Variables

[Val_Gamerman/Victoria_Financial . VICTORIA_FINANCIAL]

Danny,

It sounds like when you "...moved to bind variables..." you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.

I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so --  the CBO vs. RBO is irrelevant
in this case).

Thus the question: did you collect the statistics on all your application
tables prior to switching to CBO?

If you did not have any statistics collected or had some tables that did
not have statistics collected then Oracle may had been choosing wrong
execution path.

Thanks,
Val Gamerman.



[EMAIL PROTECTED] on 10/19/2001 03:07:56 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Val Gamerman/Victoria Financial)






Danny,
Were you using histograms?   Histograms do not work on bind variables,
they only work on literals.
I'm sure others will have more to say on the topic but that is one tidbit
that
I do have experience with on bind variables.
Cherie Machler
Oracle DBA
Gelco Information Network


"Danny
Hughes<[EMAIL PROTECTED]   To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>" 2 minutes to load.  The db server was pegged at 100% from 8-5 every
=
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,
=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.
There are so many confusing documents regarding the use of bind variables.
=
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.
TIA
Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com
--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"

--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
I have a question about using bind variables.  It is my understanding that
=
bind variables are to be used to keep the same SQL from being reparsed and
=
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While
=
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly
=
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--KMQGUMGTJRAMPYVFBAEF--
--HALPYZPZYFFYCGAKLKOY--
--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature
MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4
w
ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQ
I
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwY
D
VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlN
B
IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlR
o
YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20
w
XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCw
J
P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHV
n
aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxS
e
oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK
+
2GR13l

RE: schema documentation

[Maser, Donna (SEA)]

Marin,
The new "Q-Designer" from Quest has saved me on this one.  
I used to HATE writing documentation, but not now!
You can write really good (comprehensive and comprehendible!) html docs.
Modification is easy, but the vanilla docs are quite good.

- Donna


-Original Message-
Sent: Thursday, October 18, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L



Hi,

is anyone aware of a tool that will reverse engineer a database and generate
appropriate documentation for it (i.e. tables, columns, column types, type
definitions, package procedures,parameters, etc, etc) in fancy HTML (or
something similar)

OraSnap performs something like this (in the Database Objects section) but
the output is not detailed enough (since this is not the goal of OraSnap)

thanx,

Marin



"When someone is seeking, it happens quite easily that he only sees
the thing that he is seeking; that he is unable to find anything, unable to
absorb anything, because he is only thinking of the thing he is seeking,
because he is obsessed with his goal. Seeking means: to have a goal;
but finding means: to be free, to be receptive, to have no goal. ..."


Herman Hesse, "Siddhartha"






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

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

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


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maser, Donna  (SEA)
  INET: [EMAIL PROTECTED]

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

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

RE: Errormessage

[Jacques Kilchoer]

Title: RE: Errormessage





see answer below


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> what does this errormessage mean. I get  it when i try to do  
> this select statement.
> If I dont include the last two lines in the statement it 
> works fine. What does this depend on? and which action shallI 
> do to make it work?
> 
> SELECT RIK2.VARE.EAN_NR,
> RIK2.VARE.LEVNR,
> RIK2.ART_HIERARKI_CALC.VGR,
> RIK2.VARE.SORTIMENT,
> RIK2.VARE.VARENAVN
> FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC
> WHERE RIK2.VARE.SELSKAP='11' AND
>    RIK2.VARE.VARE_SNR=10
>    AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR
> ORDER BY VGR
> 
> 
> ORA-03232: unable to allocate an extent of 62 blocks from tablespace 3


My personal guess would be that tablespace 3 is the temporary tablespace for the user issuing the query, and the "order by" is causing a sort that will use up space in your temporary tablespace. Removal of the "order by" eliminates the sort, which is why the statement is successful with removal of the "order by".

RE: INSERT ROWS

[Guidry, Chris]

Hi,
You can use UTL_FILE or SQL*Loader utilities.

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 01:15 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  INSERT ROWS
> 
> 
> I AM LEARNING ORACLE. 
> 
> I CREATED A TABLE JUNK AS BELOW, 
> 
> SQL> CREATE TABLE JUNK 
>   2  (NAME VARCHAR2(10), 
>   3   EMPID NUMBER(5)  , 
>   4  SALARY NUMBER(5,3) ) ; 
> 
> Table created. 
> 
> I NEED TO INSERT " C:|JUNK.SQL " ( I SAVED IN  NOTEPAD ) WHICH LOOKS AS
> FOLLOWS : 
> HOW SHOULD I DO THAT ? 
> 
> 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99 
> ABCDEFGHIJ 12345 999.99
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

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

Re: SP Non-Parse CPU Calculation IS Incorrect

[Ed Bittel]

I don't know if anyone else uses Statspack, but I
couldn't help but notice the incorrect '% Non Parse
CPU' result in the instance efficiency section of the
report.  

Non-Parse CPU % calculation taken from STATSPACK
8.1.7: STATSREP.SQL: 
round(100*1-(:prscpu/:tcpu),2). 

It should be: 
round(100*(1-(:prscpu/:tcpu),2)).

Here's an example using actual statspack values for
'CPU used by this session' and 'parse time cpu'.

select round(100*1-(23255/234162),2) pctval
from dual;

PCTVAL 
-- 
  99.9 

select round(100*(1-(23255/234162)),2) pctval
from dual;  


PCTVAL 
-- 
 90.07 

So instead of .10% of CPU being used to parse as
reported by Statspack, the database is actually using
10% of CPU to parse.  Using the statspack calculation,
my database could be using 50% of CPU to parse and the
report would still report a high non-parse CPU %.

I guess it pays to remember "My Dear Aunt Sally".


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Bittel
  INET: [EMAIL PROTECTED]

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

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

RE: Little Brother Larry not really ON topic

[Bellows, Bambi]

Sorry... I was raised by
attorneys.  Lots of them.  Thankfully, through some weird twist of
genetics, I was blessed with a well defined geek gene.

 

-Original Message-
From: Jim Conboy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 19, 2001
3:50 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Little Brother Larry
not really ON topic

 



Y'know, Bambi is such a gentle name,
but you're scaring me with this in-depth knowledge. :-)





 





JIm

>>> [EMAIL PROTECTED] 10/19/01 03:59PM >>>



Yes, well, I
think that they thought that was a pretty snazzy way not to pay 
on life insurance.  In practice, though, if you've had your policy more
than 
two years, most companies will pay anyway.  It's hard to get a definitive 
yes or no out of them at the time you buy your policy, so it's rather the 
luck of the draw, um, as it were... 

-Original Message- 
Sent: Friday, October 19, 2001 2:42 PM 
To: Multiple recipients of list ORACLE-L 

And you they won't pay your life insuranc to your
beneficiaries because you 
died in the commission of a crime..Catch 22 eh? 
Ruth 
- Original Message - 
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
Sent: Friday, October 19, 2001 3:07 PM 

 

> Suicide is illegal, but, oddly commission of
that crime lands you in a 
> mental institution because you are mentally unfit to stand trial, and, 
> except in the case of extraordinary extenuating circumstances, is proof of

> at least temporary insanity.  This is the mechanism that is used to 
> institutionalize people who attempt, but fail, to commit suicide. 
This is 
> also used by some insurance companies who will not pay claims for 
sufferings 
> incurred in the commission of a crime. 
> 
> Extraordinary extenuating circumstances include (but are not limited to): 
> Extreme political protest (e.g., the autoimolation of those monks); 
> extraordinary pain and suffering (it's still illegal, but won't land you 
in 
> a mental institution); suicide attempts immediately prior to capital 
> punishment (they really don't like that because they can't execute you 
until 
> you're mentally competent to appreciate the punishment you are about to 
> endure and prisoners, instead, are placed on suicide watch) 
> 
> HTH, 
> Bambi. 
> 
> -Original Message- 
> Sent: Friday, October 19, 2001 1:15 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> Are you sure its not illegal to 'attempt' suicide?  Granted 
> that still does not make a whole lot of sense but it gives 
> them a way to get back at you for the medical bills and what 
> not of a failed attempt I believe.  So if you do want to do 
> it take the extra time and plan well (not that I think anyone 
> should do it). 
> 
> -Original Message- 
> Sent: Friday, October 19, 2001 10:55 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> No, man, they through your corpse into a cell until you learn better. 
Duh! 
> 
> -Original Message- 
> Sent: Friday, October 19, 2001 4:25 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> 
> Sent: Friday, October 19, 2001 00:50 
> 
> 
> > My favorite law is that it is illegal to commit suicide. 
> > 
> > Love that! 
> 
> 
> and what happens if u successfully commit one? 
> 
> will they sue u? 
> 
> 
> Marin 
> 
> 
>  
> "...what you brought from your past, is of no use in your present.
When 
> you must choose a new path, do not bring old experiences with you. 
> Those who strike out afresh, but who attempt to retain a little of the 
> old life, end up torn apart by their own memories. " 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com

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

> -- 
> Author: Bellows, Bambi 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
(858) 538-5051 
> San Diego, California    -- Public
Internet access / Mailing Lists 
>  
> To REMOVE yourself from this mailing list, send an E-Mail message 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L 
> (or the name of mailing list you want to be removed f

RE: Books or Websites that discuss RMAN?

[Kathy Duret]

Rama's backup book has a nice explanation and some good examples, also look at:

/rdbms/product/8.1.6/rdbms/demo

AND go through this list's archives search for RMAN.  There have been alot of good
examples and discussions regarding this topic that I have benefitted GREATELY from.

Kathy

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


AFAIK there are no books (other than the upcoming RMAN pocket reference
from  Oreilly). Oracle Documentation is comprehensive and Rama's backup
& Recovery handbook also has some good details abt RMAN.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, October 19, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L

Does anyone know of a good site/book, other than Oracle Docs, that gives a
good explanation of RMAN?

Thanks,

Rick Stephenson


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

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

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


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

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

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

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

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

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

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

RE: Which RAID level do you use?

[Christopher Spence]

For 1TB and only having 20 spindles, I doubt many people would chose 100Gb
drives for an Oracle database unless it was just huge.


$20,000 isn't much for 1Tb solution, but you haven't taken in account your
enclosure, any enclosure that would handle 20 drives, hot swap and most
likely multiple connections for multiple controllers would probably be
$5-$10k.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Friday, October 19, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L

oh yea, 20K plus cabinet and cablingthat IS 
too much for a TERABYTE of storage. 

What was i thinking?



-Original Message-
Sent: Friday, October 19, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L


Then mirror it for an additional 10K

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 18, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L

"RAID 1 is fine if you have infinite storage (read: Infinite Budget).
Try buying an extra TB of disk just for the fun of it and see what
your budget committee does to you :-)"


Kind of agree.Get an IBM Deskstar model...close to 100 GBbuy
ten at maybe, what? a grand each..and VOILA a terabyte for about
10K. 

Not exactly "infinite budget"!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

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

Re: Books or Websites that discuss RMAN?

[Greg Moore]

> Does anyone know of a good site/book that
> gives a good explanation of RMAN?

A paper on Tim Gorman's site:

http://www.evdbt.com/library.htm

"Is RMAN Really Worth The Trouble?" (Adobe Acrobat white paper - 32Kb,
MS-PowerPoint97 slide show - 135Kb, WinZip archive with both paper and
presentation - 54Kb) ) This paper and presentation was presented at the
Eastern Caribbean Oracle Users Group in Trinidad on 14 March 2001 and at the
Rocky Mtn Oracle Users Group (RMOUG) "Training Days 2000" on 10 February,
2000 in Denver. It explains the three important features of Oracle8 Recovery
Manager that absolutely no other backup/recovery solution is capable of
matching, and why these features might be crucial to help fulfill your
requirements and expectations. If you do not have these requirements or
expectations, then RMAN may not be worth the trouble to install and
configure. But if you do have these requirements, then RMAN may be the only
viable solution for you.

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

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

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

Re: Books or Websites that discuss RMAN?

[Thater, William]

[EMAIL PROTECTED] wrote:

>Does anyone know of a good site/book, other than Oracle Docs, that gives a
>good explanation of RMAN?
>
>Thanks,
>
>Rick Stephenson
>
>
Oracle8 backup and recovery handbook fro Oracle press

-- 
--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Save energy:  Drive a smaller shell.




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

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

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

Re: distribution of the sleeps on the library cache latches

[Greg Moore]

An excerpt from
 
PIRANHAS IN THE POOL,SQL PERFORMANCE 
KILLERSInvestigating the effects of literal SQL on Oracle 
performance
 
John BeresniewiczPrecise Software 
Solutio
--
Effect of CURSOR_SHARINGA primary purpose of 
the 8.1.6 testing was to assess the impact the new CURSOR_SHARING system 
parameter and its potential for helping DBAs manage ill-behaved applications 
with high parse rates of literal SQL.  Comparing Test 1 to Test 3 and also 
Test 0 to Test 4 serves this goal.Comparing these Test results, 
CURSOR_SHARING exhibits advantages similar to those obtained using bind 
variables in Test 2:-- Reduced library cache impact.-- Negligible shared 
pool activity.-- Reduced CPU demands.In fact, Test 3 produced the best 
elapsed time of all tests in spite of the fact that all the SQL was 
literal.  Thus, it is clear that CURSOR_SHARING can be used to greatly 
enhance performance of applications that produce high volume literal SQL and 
thus is a great advantage for the DBA saddled with such 
applications.CURSOR_SHARING vs. Bind VariablesComparing Test 2 and Test 
3 reveals that CURSOR_SHARING = FORCE showed significantly better 
performance than bind variables in both elapsed time and reduced 
library cache latching impact.  This surprising result deserves further 
investigation to produce an adequate explanation.  Library cache latch 
impact was significantly reduced as well as shared pool pins and releases. 
Parsing CPU time increased some but overall CPU was reduced. Perhaps the 
additional parsing involved in forced cursor sharing also enables increased 
sharing of shared pool memory heaps.

Re:

[Scott Shafer]

I thought it was:

Ross "nowaltiambilingualtheresadifference" Mohan

--S


"Mohan, Ross" wrote:
> 
> Jared,
> 
> throw this individual off. He is a big, fat meanie.
> 
> Waa Waa Waa
> 
> - Ross "nowaltiamnotasheep" Mohan
> 
> -Original Message-
> Sent: Friday, October 19, 2001 1:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> Are you an idiot?
> 
> --Walt Weaver
>   Bozeman, Montana
> 
> -Original Message-
> Sent: Friday, October 19, 2001 11:05 AM
> To: Multiple recipients of list ORACLE-L
> 
> HELP

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

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

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

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

RE: Books or Websites that discuss RMAN?

[K Gopalakrishnan]

AFAIK there are no books (other than the upcoming RMAN pocket reference
from  Oreilly). Oracle Documentation is comprehensive and Rama's backup
& Recovery handbook also has some good details abt RMAN.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-Original Message-
[EMAIL PROTECTED]
Sent: Friday, October 19, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L

Does anyone know of a good site/book, other than Oracle Docs, that gives a
good explanation of RMAN?

Thanks,

Rick Stephenson


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

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

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


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

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

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

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

RE: Little Brother Larry not really ON topic

[Jim Conboy]

Y'know, Bambi is such a gentle name, but you're scaring me with this 
in-depth knowledge. :-)
 
JIm>>> [EMAIL PROTECTED] 10/19/01 03:59PM 
>>>
Yes, well, I think that they thought that was a pretty snazzy 
way not to pay on life insurance.  In practice, 
though, if you've had your policy more than two years, 
most companies will pay anyway.  It's hard to get a definitive 
yes or no out of them at the time you buy your policy, so it's 
rather the luck of the draw, um, as it were... 

-Original Message- Sent: Friday, 
October 19, 2001 2:42 PM To: Multiple recipients of list 
ORACLE-L 
And you they won't pay your life insuranc to your beneficiaries 
because you died in the commission of a crime..Catch 22 
eh? Ruth - Original Message 
- To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]> Sent: Friday, October 19, 
2001 3:07 PM 
> Suicide is illegal, but, oddly commission of that crime 
lands you in a > mental institution because you are 
mentally unfit to stand trial, and, > except in the 
case of extraordinary extenuating circumstances, is proof of > at least temporary insanity.  This is the mechanism that is 
used to > institutionalize people who attempt, but 
fail, to commit suicide.  This is > also used by 
some insurance companies who will not pay claims for sufferings > incurred in the commission of a 
crime. > > Extraordinary 
extenuating circumstances include (but are not limited to): > Extreme political protest (e.g., the autoimolation of those 
monks); > extraordinary pain and suffering (it's 
still illegal, but won't land you in > a mental institution); suicide attempts immediately prior to 
capital > punishment (they really don't like that 
because they can't execute you until > you're mentally competent to appreciate the punishment you are about 
to > endure and prisoners, instead, are placed on 
suicide watch) > > 
HTH, > Bambi. > 
> -Original Message- > 
Sent: Friday, October 19, 2001 1:15 PM > To: Multiple 
recipients of list ORACLE-L > > Are you sure its not illegal to 'attempt' suicide?  
Granted > that still does not make a whole lot of 
sense but it gives > them a way to get back at you 
for the medical bills and what > not of a failed 
attempt I believe.  So if you do want to do > it 
take the extra time and plan well (not that I think anyone > should do it). > > -Original Message- > Sent: 
Friday, October 19, 2001 10:55 AM > To: Multiple 
recipients of list ORACLE-L > > > No, man, they through your corpse into 
a cell until you learn better. Duh! > > -Original Message- 
> Sent: Friday, October 19, 2001 4:25 AM > To: Multiple recipients of list ORACLE-L > > - Original Message - 
> To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]> > Sent: Friday, October 
19, 2001 00:50 > > 
> > My favorite law is that it is illegal to commit 
suicide. > > > > 
Love that! > > 
> and what happens if u successfully commit one? 
> > will they sue u? 
> > > Marin > 
> >  > "...what you brought from your past, is of no use in your present. 
When > you must choose a new path, do not bring old 
experiences with you. > Those who strike out afresh, 
but who attempt to retain a little of the > old life, 
end up torn apart by their own memories. " > 
> > > 
-- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Marin Dimitrov 
>   INET: [EMAIL PROTECTED] > > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, 
California    -- Public Internet access / 
Mailing Lists > 
 
> To REMOVE yourself from this mailing list, send an E-Mail 
message > to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in > the message BODY, 
include a line containing: UNSUB ORACLE-L > (or the 
name of mailing list you want to be removed from).  You may 
> also send the HELP command for other information (like 
subscribing). > -- > 
Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bellows, Bambi 
>   INET: [EMAIL PROTECTED] > > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, 
California    -- Public Internet access / 
Mailing Lists > 
 
> To REMOVE yourself from this mailing list, send an E-Mail 
message > to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in > the message BODY, 
include a line containing: UNSUB ORACLE-L > (or the 
name of mailing list you want to be removed from).  You may 
> also send the HELP command for other information (like 
subscribing). > -- > 
Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith 
>   INET: [EMAIL PROTECTED] 
> > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, 
California    -- Public Internet access / 
Mailing Lists > 
---

Books or Websites that discuss RMAN?

[rick_stephenson]

Does anyone know of a good site/book, other than Oracle Docs, that gives a
good explanation of RMAN?

Thanks,

Rick Stephenson


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

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

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

RE: sys.obj$, type# desc

[Jacques Kilchoer]

Title: RE: sys.obj$, type# desc





>-Original Message-
>From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
>
> ...
>Where i can check to know the desc for all the type#?. (N.B. from sys.obj$)


Look at the source code for the dba_objects view. In SQL*Plus:
set long 5000
set pagesize 0
select text
from dba_views
where owner = 'SYS'
and view_name = 'DBA_OBJECTS' ;



Have a look at the source code for some other dba_ views while you're at it (e.g. DBA_TABLES, DBA_INDEXES, DBA_SEGMENTS), it can be very instructive.

RE: QUERY PROBLEM

[Jacques Kilchoer]

Title: RE: QUERY PROBLEM





> -Original Message-
> From: Harvinder Singh [mailto:[EMAIL PROTECTED]]
> 
> We need to write a query like this:
> 
> declare
> dd number;
> begin
> select * from t_acc where id_acc=dd;
> end;
> /


Get the result back to where? What kind of client application? Is the query returning only one row or multiple rows?


Here are two ways of doing it in SQL*Plus:


SQL> define def_var = "X"
SQL> select * from dual where dummy = '&def_var' ;
ancien   1 : select * from dual where dummy = '&def_var'
nouveau   1 : select * from dual where dummy = 'X'


D
-
X


SQL> variable bind_var varchar2 (1)
SQL> execute :bind_var := 'X'


Procédure PL/SQL terminée avec succès.


SQL> select * from dual where dummy = :bind_var ;


D
-
X

RE: Free space puzzle

[Jacques Kilchoer]

Title: RE: Free space puzzle





> -Original Message-
> From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]
> 
> TS is showing 100% used in DBA Studio.  DBA_DATA_FILES is 
> showing MAXBLOCKS,
> MAXBYTES values corresponding to filesize of 2000M which was 
> what tablespace
> was originally created with.  Subsequently altered to 4000M with ALTER
> DATABASE DATAFILE '' AUTOEXTEND ON MAXSIZE 4000M.  
> I'm puzzled as
> to why the DBA views do not reflect the 4000M.  Can anyone 
> explain what I'm
> overlooking please?



What dba_ view are you looking at? This will probably be of little consolation to you, but for me, dba_data_files immediately reflected the change in maxsize on a datafile in my test database (8.1.7 on Windows 2000).

SQL> select file_name, maxbytes
  2  from dba_data_files
  3  where file_name = 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF' ;


FILE_NAME

  MAXBYTES
--
D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF
 115344384



SQL> alter database datafile 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF'
  2  autoextend on maxsize 300 M ;


Base de données modifiée.


SQL> select file_name, maxbytes
  2  from dba_data_files
  3  where file_name = 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF' ;


FILE_NAME

  MAXBYTES
--
D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF
 314572800

ERWin - Reversing Commands

[Ken Janusz]

I am using ERWin 4.0.  I would like to know if there is a way to reverse
drawing commands.  Such as deleting or moving an object?

I cannot find any references to this in the documentation.

Thanks,
Kenneth C. Janusz, CPIM 
Database Conversion Lead 
Sufficient System, Inc.  
Minneapolis, MN 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ken Janusz
  INET: [EMAIL PROTECTED]

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

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

RE: Little Brother Larry sorta ON topic

[Bellows, Bambi]

Yes, well, I think that they thought that was a pretty snazzy way not to pay
on life insurance.  In practice, though, if you've had your policy more than
two years, most companies will pay anyway.  It's hard to get a definitive
yes or no out of them at the time you buy your policy, so it's rather the
luck of the draw, um, as it were...

-Original Message-
Sent: Friday, October 19, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L

And you they won't pay your life insuranc to your beneficiaries because you
died in the commission of a crime..Catch 22 eh?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 3:07 PM


> Suicide is illegal, but, oddly commission of that crime lands you in a
> mental institution because you are mentally unfit to stand trial, and,
> except in the case of extraordinary extenuating circumstances, is proof of
> at least temporary insanity.  This is the mechanism that is used to
> institutionalize people who attempt, but fail, to commit suicide.  This is
> also used by some insurance companies who will not pay claims for
sufferings
> incurred in the commission of a crime.
>
> Extraordinary extenuating circumstances include (but are not limited to):
> Extreme political protest (e.g., the autoimolation of those monks);
> extraordinary pain and suffering (it's still illegal, but won't land you
in
> a mental institution); suicide attempts immediately prior to capital
> punishment (they really don't like that because they can't execute you
until
> you're mentally competent to appreciate the punishment you are about to
> endure and prisoners, instead, are placed on suicide watch)
>
> HTH,
> Bambi.
>
> -Original Message-
> Sent: Friday, October 19, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> Are you sure its not illegal to 'attempt' suicide?  Granted
> that still does not make a whole lot of sense but it gives
> them a way to get back at you for the medical bills and what
> not of a failed attempt I believe.  So if you do want to do
> it take the extra time and plan well (not that I think anyone
> should do it).
>
> -Original Message-
> Sent: Friday, October 19, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> No, man, they through your corpse into a cell until you learn better.
Duh!
>
> -Original Message-
> Sent: Friday, October 19, 2001 4:25 AM
> To: Multiple recipients of list ORACLE-L
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, October 19, 2001 00:50
>
>
> > My favorite law is that it is illegal to commit suicide.
> >
> > Love that!
>
>
> and what happens if u successfully commit one?
>
> will they sue u?
>
>
> Marin
>
>
> 
> "...what you brought from your past, is of no use in your present. When
> you must choose a new path, do not bring old experiences with you.
> Those who strike out afresh, but who attempt to retain a little of the
> old life, end up torn apart by their own memories. "
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marin Dimitrov
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bellows, Bambi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name o

Re: Little Brother Larry sorta ON topic

[Ruth Gramolini]

And you they won't pay your life insuranc to your beneficiaries because you
died in the commission of a crime..Catch 22 eh?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 3:07 PM


> Suicide is illegal, but, oddly commission of that crime lands you in a
> mental institution because you are mentally unfit to stand trial, and,
> except in the case of extraordinary extenuating circumstances, is proof of
> at least temporary insanity.  This is the mechanism that is used to
> institutionalize people who attempt, but fail, to commit suicide.  This is
> also used by some insurance companies who will not pay claims for
sufferings
> incurred in the commission of a crime.
>
> Extraordinary extenuating circumstances include (but are not limited to):
> Extreme political protest (e.g., the autoimolation of those monks);
> extraordinary pain and suffering (it's still illegal, but won't land you
in
> a mental institution); suicide attempts immediately prior to capital
> punishment (they really don't like that because they can't execute you
until
> you're mentally competent to appreciate the punishment you are about to
> endure and prisoners, instead, are placed on suicide watch)
>
> HTH,
> Bambi.
>
> -Original Message-
> Sent: Friday, October 19, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> Are you sure its not illegal to 'attempt' suicide?  Granted
> that still does not make a whole lot of sense but it gives
> them a way to get back at you for the medical bills and what
> not of a failed attempt I believe.  So if you do want to do
> it take the extra time and plan well (not that I think anyone
> should do it).
>
> -Original Message-
> Sent: Friday, October 19, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> No, man, they through your corpse into a cell until you learn better.
Duh!
>
> -Original Message-
> Sent: Friday, October 19, 2001 4:25 AM
> To: Multiple recipients of list ORACLE-L
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, October 19, 2001 00:50
>
>
> > My favorite law is that it is illegal to commit suicide.
> >
> > Love that!
>
>
> and what happens if u successfully commit one?
>
> will they sue u?
>
>
> Marin
>
>
> 
> "...what you brought from your past, is of no use in your present. When
> you must choose a new path, do not bring old experiences with you.
> Those who strike out afresh, but who attempt to retain a little of the
> old life, end up torn apart by their own memories. "
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marin Dimitrov
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bellows, Bambi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bellows, Bambi
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --

Re: INSERT ROWS

[Thater, William]

[EMAIL PROTECTED] wrote:

>
> I AM LEARNING ORACLE.
>
> I CREATED A TABLE JUNK AS BELOW,
>
> SQL> CREATE TABLE JUNK
>   2  (NAME VARCHAR2(10),
>   3   EMPID NUMBER(5)  ,
>   4  SALARY NUMBER(5,3) ) ;
>
> Table created.
>
> I NEED TO INSERT " C:|JUNK.SQL " ( I SAVED IN  NOTEPAD ) WHICH LOOKS 
> AS FOLLOWS :
> HOW SHOULD I DO THAT ?

carefully.  or you could read the documentation on sql*loader.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Save energy:  Drive a smaller shell.




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

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

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

Re:RE: Tools

[dgoulet]

Eric,

MANY years ago, before the advent of Cool-Tools UK I do believe (back in V6
days) I was seriously impeded by a similar situation to you.  Namely I really
hated being told that something in the DB was wrong before I could get my hat,
never mind the coat, off.  A few days of those 2x4's aside the head as I arrived
provided the fuel to Mother Invention.  The results of that, called OraCheck by
us, is still here & running happily.  Now I don't know about Mark's tools and
'Norad' in general as developing something in-house is always looked upon
favorably here since it has a much lower cost of acquisition & ownership (also
you have complete freedom to customize to the n'th degree).  For that reason I
have not publicly revealed what it is internally, but if your a C programmer
with knowledge of Pro*C, I can zip it up for you & you can have it for nothing. 
Note that is source code only, not the executables and there are a few other
things you may well need, like the SEE4C libraries from Marshall Soft so that
the SMTP mail capabilities work.

Dick Goulet

Reply Separator
Author: "Wong; Bing" <[EMAIL PROTECTED]>
Date:   10/19/2001 10:02 AM

you are ready to pay big $ for BMC, Quest and CA tools.

-Original Message-
Sent: Friday, October 19, 2001 10:39 AM
To: Multiple recipients of list ORACLE-L


Does anybody know of any good monitoring tools for Oracle. We are using OEM 
and are not very happy.
We need something to monitor the DB and alert us, and something to run 
"jobs" on a schedule or repair basis.
This could save me months of research and surfing.

What works for you?


TIA!!

Eric.

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

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

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

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

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

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

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

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

RE:

[Weaver, Walt]

> Ross "nowaltiamnotasheep" Mohan

Damn.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, October 19, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


Jared, 

throw this individual off. He is a big, fat meanie. 

Waa Waa Waa

- Ross "nowaltiamnotasheep" Mohan

-Original Message-
Sent: Friday, October 19, 2001 1:39 PM
To: Multiple recipients of list ORACLE-L


Are you an idiot?

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, October 19, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L


HELP

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

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

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

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

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

OAS Mailing list?

[Paul Vallee]

Hello all,
Is there a mailing list where Oracle Application Server issues are
discussed?
Thanks,
Paul

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

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

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

Re: QUERY PROBLEM

[Shishir]

Sorry to ask u . DO u want ot to get recordset in ur application 

Shishir Kumar Mishra
Email :[EMAIL PROTECTED]
--



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, October 20, 2001 12:05 AM


> we want query to retun result set back to application...
> 
> -Original Message-
> Sent: Friday, October 19, 2001 2:03 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It depends on what you want to do with this.  You need to have an into
> clause, so declare a variable and put one in.  If you want to see the
> output, then use the dbms_ouput package to display it.
> 
> Harvinder Singh wrote:
> > 
> > Hi,
> > 
> > We need to write a query like this:
> > 
> > declare
> > dd number;
> > begin
> > select * from t_acc where id_acc=dd;
> > end;
> > /
> > 
> > we r getting obvious error that INTO clause is missing
> > but we only need to run the query and get the result back.
> > How can we accomplish this.
> > 
> > Thanks
> > -Harvinder
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Harvinder Singh
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> 
> -- 
> Scott Canaan ([EMAIL PROTECTED])
> (716) 475-7886
> "Life is like a sewer, what you get out of it depends on what you put
> into it" - Tom Lehrer
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Scott Canaan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Harvinder Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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

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

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

Re: Errormessage

[Ruth Gramolini]

It means you need to allocate more space to Tablespace 3.  You can either
increase the size of the current  datafile(s)  or add another datafile.

Regards.,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 12:00 PM



Hallo,

what does this errormessage mean. I get  it when i try to do  this select
statement.
If I dont include the last two lines in the statement it works fine. What
does this depend on? and which action shallI do to make it work?


SELECT RIK2.VARE.EAN_NR,
RIK2.VARE.LEVNR,
RIK2.ART_HIERARKI_CALC.VGR,
RIK2.VARE.SORTIMENT,
RIK2.VARE.VARENAVN
FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC
WHERE RIK2.VARE.SELSKAP='11' AND
   RIK2.VARE.VARE_SNR=10
   AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR
ORDER BY VGR


ORA-03232: unable to allocate an extent of 62 blocks from tablespace 3




sincerely

Roland Sköldblom

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

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

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

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

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

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

RE: Little Brother Larry sorta ON topic

[Henry Poras]

I thought the punishment was a stiff fine.

Henry

-Original Message-
Sent: Friday, October 19, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L


No, man, they through your corpse into a cell until you learn better.  Duh!

-Original Message-
Sent: Friday, October 19, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 00:50


> My favorite law is that it is illegal to commit suicide. 
> 
> Love that!


and what happens if u successfully commit one?

will they sue u?


Marin



"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "



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

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

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

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

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

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

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

INSERT ROWS

[gspatel]

I AM LEARNING ORACLE.

I CREATED A TABLE JUNK AS BELOW,

SQL> CREATE TABLE JUNK
  2  (NAME VARCHAR2(10),
  3   EMPID NUMBER(5)  ,
  4  SALARY NUMBER(5,3) ) ;

Table created.

I NEED TO INSERT " C:|JUNK.SQL " ( I SAVED IN  NOTEPAD ) WHICH LOOKS AS FOLLOWS :
HOW SHOULD I DO THAT ?


ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99
ABCDEFGHIJ 12345 999.99

RE:

[Mohan, Ross]

Jared, 

throw this individual off. He is a big, fat meanie. 

Waa Waa Waa

- Ross "nowaltiamnotasheep" Mohan

-Original Message-
Sent: Friday, October 19, 2001 1:39 PM
To: Multiple recipients of list ORACLE-L


Are you an idiot?

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, October 19, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L


HELP

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

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

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

Re: Bind Variables

[Cherie_Machler]

Danny,

Were you using histograms?   Histograms do not work on bind variables,
they only work on literals.

I'm sure others will have more to say on the topic but that is one tidbit
that
I do have experience with on bind variables.

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
"Danny 
  
Hughes<[EMAIL PROTECTED]   To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]> 
>" 2 minutes to load.  The db server was pegged at 100% from 8-5 every
=
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,
=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.

There are so many confusing documents regarding the use of bind variables.
=
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"


--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I have a question about using bind variables.  It is my understanding that
=
bind variables are to be used to keep the same SQL from being reparsed and
=
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While
=
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly
=
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com


--KMQGUMGTJRAMPYVFBAEF--

--HALPYZPZYFFYCGAKLKOY--

--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature

MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4w

ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQI

EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD

VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNB

IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlRo

YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20w

XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCwJ

P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHVn

aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxSe

oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK+

2GR13ldRWLfoDphFJyvBXuI0x2AhPpC+KY04jBojgtKmwX//BoKquodT89CzcDrZaU4FRU5OG7cM

Hc4q/c8wggMpMIICkqADAgECAgEMMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMG

A1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBD

b25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYD

VQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFs

LWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDAwODMwMDAwMDAwWhcNMDIwODI5MjM1OTU5WjCBkjEL

MAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8w

DQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlc

RE: Little Brother Larry sorta ON topic

[Bellows, Bambi]

Suicide is illegal, but, oddly commission of that crime lands you in a
mental institution because you are mentally unfit to stand trial, and,
except in the case of extraordinary extenuating circumstances, is proof of
at least temporary insanity.  This is the mechanism that is used to
institutionalize people who attempt, but fail, to commit suicide.  This is
also used by some insurance companies who will not pay claims for sufferings
incurred in the commission of a crime.

Extraordinary extenuating circumstances include (but are not limited to):
Extreme political protest (e.g., the autoimolation of those monks);
extraordinary pain and suffering (it's still illegal, but won't land you in
a mental institution); suicide attempts immediately prior to capital
punishment (they really don't like that because they can't execute you until
you're mentally competent to appreciate the punishment you are about to
endure and prisoners, instead, are placed on suicide watch)

HTH,
Bambi.

-Original Message-
Sent: Friday, October 19, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L

Are you sure its not illegal to 'attempt' suicide?  Granted
that still does not make a whole lot of sense but it gives
them a way to get back at you for the medical bills and what
not of a failed attempt I believe.  So if you do want to do
it take the extra time and plan well (not that I think anyone
should do it).

-Original Message-
Sent: Friday, October 19, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


No, man, they through your corpse into a cell until you learn better.  Duh!

-Original Message-
Sent: Friday, October 19, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 00:50


> My favorite law is that it is illegal to commit suicide. 
> 
> Love that!


and what happens if u successfully commit one?

will they sue u?


Marin



"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "



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

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

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

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

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

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

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

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

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

AIX Print Queue Setup

[raldridg]

Hello,

Can someone who is running Oracle Apps in an AIX environment tell me the
proper setup for the AIX queue to work as an Applications printer? Should
the AIX queue be setup as a print file type of PCL or pass-through, etc.

Thanks,
Randy Aldridge

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

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

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

RE: Tools

[Mark Leith]

We provide a tool that can do all of this for you:

http://www.cool-tools.co.uk/Products/surveillance.html

At significantly less cost than those mentioned below.



Mark

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

-Original Message-
Sent: Friday, October 19, 2001 19:03
To: Multiple recipients of list ORACLE-L


you are ready to pay big $ for BMC, Quest and CA tools.

-Original Message-
Sent: Friday, October 19, 2001 10:39 AM
To: Multiple recipients of list ORACLE-L


Does anybody know of any good monitoring tools for Oracle. We are using OEM
and are not very happy.
We need something to monitor the DB and alert us, and something to run
"jobs" on a schedule or repair basis.
This could save me months of research and surfing.

What works for you?


TIA!!

Eric.

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

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

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

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

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

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

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

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

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

RE: QUERY PROBLEM

[Harvinder Singh]

we want query to retun result set back to application...

-Original Message-
Sent: Friday, October 19, 2001 2:03 PM
To: Multiple recipients of list ORACLE-L


It depends on what you want to do with this.  You need to have an into
clause, so declare a variable and put one in.  If you want to see the
output, then use the dbms_ouput package to display it.

Harvinder Singh wrote:
> 
> Hi,
> 
> We need to write a query like this:
> 
> declare
> dd number;
> begin
> select * from t_acc where id_acc=dd;
> end;
> /
> 
> we r getting obvious error that INTO clause is missing
> but we only need to run the query and get the result back.
> How can we accomplish this.
> 
> Thanks
> -Harvinder
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Free space puzzle

[Deepak Thapliyal]

try adding more data .. basically forcing the df to
extend .. see if this gets reflected in dba_datafile 
if it does then you have your answer. if not then 
maybe my common sense is not that really:)

Deepak

--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> TS is showing 100% used in DBA Studio. 
> DBA_DATA_FILES is showing MAXBLOCKS,
> MAXBYTES values corresponding to filesize of 2000M
> which was what tablespace
> was originally created with.  Subsequently altered
> to 4000M with ALTER
> DATABASE DATAFILE '' AUTOEXTEND ON MAXSIZE
> 4000M.  I'm puzzled as
> to why the DBA views do not reflect the 4000M.  Can
> anyone explain what I'm
> overlooking please?
> 
> -
> Sean O' Neill
> Organon (Ireland) Ltd.
> [subscribed: digest mode] 
> Oracle 8.1.7 - W2K 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: Tools

[Richard Ji]

With CA you pay big bucks but you ain't getting anything with their Oracle agent.

>>> [EMAIL PROTECTED] 10/19/01 02:02PM >>>
you are ready to pay big $ for BMC, Quest and CA tools.

-Original Message-
Sent: Friday, October 19, 2001 10:39 AM
To: Multiple recipients of list ORACLE-L


Does anybody know of any good monitoring tools for Oracle. We are using OEM 
and are not very happy.
We need something to monitor the DB and alert us, and something to run 
"jobs" on a schedule or repair basis.
This could save me months of research and surfing.

What works for you?


TIA!!

Eric.

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

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

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

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

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

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

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

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

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

Re: Ora-000036 error

[Deepak Thapliyal]

you've reqached a hardcoded limit not configurable in
7/8 .. more details in -->
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=48793.1

deepak

--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> I have "ORA-00036: maximum number of recursive SQL
> levels (50) exceeded" 
> error.Let me know which parameter is related I can
> change.I am running 
> oracle8.1.7 on solaris platform
> Thanks
> -Seema
> 
>
_
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: QUERY PROBLEM

[Harvinder Singh]

Actullay it sql server u can do like this inside the block:

declare @@dd int
select * from t_acc where id_acc=@@dd

AND now developer wants something similar in Oracle...



-Original Message-
Sent: Friday, October 19, 2001 2:03 PM
To: Multiple recipients of list ORACLE-L


It depends on what you want to do with this.  You need to have an into
clause, so declare a variable and put one in.  If you want to see the
output, then use the dbms_ouput package to display it.

Harvinder Singh wrote:
> 
> Hi,
> 
> We need to write a query like this:
> 
> declare
> dd number;
> begin
> select * from t_acc where id_acc=dd;
> end;
> /
> 
> we r getting obvious error that INTO clause is missing
> but we only need to run the query and get the result back.
> How can we accomplish this.
> 
> Thanks
> -Harvinder
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: [EMAIL PROTECTED]

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

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

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

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

Bind Variables

[Danny Hughes<[EMAIL PROTECTED]>]

--CIVUFTDKZVQDOGJWYCGU
Content-Type: multipart/alternative; boundary="HALPYZPZYFFYCGAKLKOY"


--HALPYZPZYFFYCGAKLKOY
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I have a question about using bind variables.  It is my understanding that =
bind variables are to be used to keep the same SQL from being reparsed and =
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of the =
same sql, and hundreds of different sql, we decided to look into converting=
 certain web pages to bind variables.  After we converted to using bind =
variables, the pages that once took < 5 seconds to load all of the sudden =
took > 2 minutes to load.  The db server was pegged at 100% from 8-5 every =
day while this application was being used.  We have converted back to =
literals and the pages are loading quickly again.  While on bind variables,=
 we used every possible hint except RULE and had no luck.  We didn't want =
to resort to using the RULE hint because oracle claims not to use the RBO =
(because of no further enhancements and possibly phasing it out), and to =
start using the CBO for everything.

There are so many confusing documents regarding the use of bind variables. =
 I wanted to see what the oracle community is doing in regards to using =
bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com

--HALPYZPZYFFYCGAKLKOY
Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF"


--KMQGUMGTJRAMPYVFBAEF
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I have a question about using bind variables.  It is my understanding that =
bind variables are to be used to keep the same SQL from being reparsed and =
keeping multiple copies in the SGA, thus *speeding* things up.  I also =
understand that by using bind variables that the CBO will not be able to =
optimally use the statistics to determine the most effective path to =
retrieve data.  Some documentation states to use hints when you are using =
bind variables to tell the CBO which path to take.  Other documentation =
states that bind variables don't like the CBO and to use the RBO.

After we looked at the library cache and saw thousands of copies of =
the same sql, and hundreds of different sql, we decided to look into =
converting certain web pages to bind variables.  After we converted to =
using bind variables, the pages that once took < 5 seconds to load all =
of the sudden took > 2 minutes to load.  The db server was pegged at =
100% from 8-5 every day while this application was being used.  We have =
converted back to literals and the pages are loading quickly again.  While =
on bind variables, we used every possible hint except RULE and had no =
luck.  We didn't want to resort to using the RULE hint because oracle =
claims not to use the RBO (because of no further enhancements and possibly =
phasing it out), and to start using the CBO for everything.

There are so many confusing documents regarding the use of bind =
variables.  I wanted to see what the oracle community is doing in regards =
to using bind variables and what their experiences are.

TIA

Danny Hughes
DBA
Knobias.com
[EMAIL PROTECTED]
www.knobias.com


--KMQGUMGTJRAMPYVFBAEF--

--HALPYZPZYFFYCGAKLKOY--

--CIVUFTDKZVQDOGJWYCGU
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
CONTENT-DESCRIPTION: S/MIME Cryptographic Signature

MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4w
ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQI
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD
VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNB
IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlRo
YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20w
XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCwJ
P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHVn
aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxSe
oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK+
2GR13ldRWLfoDphFJyvBXuI0x2AhPpC+KY04jBojgtKmwX//BoKquodT89CzcDrZaU4FRU5OG7cM
Hc4q/c8wggMpMIICkqADAgECAgEMMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMG
A1UECBMMV2VzdG

RE: Separate tablespaces for indexes on same table?

[Koivu, Lisa]

Title: RE: Separate tablespaces for indexes on same table?





Hi Cherie, 


Whatever happened to the thought over there that I/O contention just didn't happen on a Symmetrix?  (I never believed it)

Personally I'd opt for two tablespaces on truly separate disks, though this is difficult to determine on the symmetrix.  Just my bias.

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



-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, October 19, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject:    Separate tablespaces for indexes on same table?



I am rebuilding some indexes for a 20-Gig table.   I am following the
recommendations in the paper How to Stop Defragmenting and Start Living...


There are six indexes on this table.   According to the paper, I should
create a separate tablespace for these indexes.   My question is:  Should I
put all of the indexes in a single tablespace or should I make two
tablespaces and separate them.   In some queries, the indexes may be used
together but in most they will not.   If I put them in a single tablespace,
will that cause I/O contention.


This is on 8.0.4  Sun E10K Solaris 2.6 with Veritas Quick I/O.


Thanks,


Cherie Machler
Gelco Information Network


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


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

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

RE: Errormessage

[Deepak Thapliyal]

ronald .. like mohan has identified .. u need 2 wakeup
smon or use that fancy "alter session set events .."
that scott or someone sent for forcing smon to start
doing his stuff...

if you get the error even after coalescing then you
might need to increae your temp tablespace

deepak

--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> Let me guess that tablespace 3 is your temporary
> tablespace?
> 
> 
> 
> -Original Message-
> Sent: Friday, October 19, 2001 12:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hallo,
> 
> what does this errormessage mean. I get  it when i
> try to do  this select
> statement.
> If I dont include the last two lines in the
> statement it works fine. What
> does this depend on? and which action shallI do to
> make it work?
> 
> 
> SELECT RIK2.VARE.EAN_NR,
> RIK2.VARE.LEVNR,
> RIK2.ART_HIERARKI_CALC.VGR,
> RIK2.VARE.SORTIMENT,
> RIK2.VARE.VARENAVN
> FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC
> WHERE RIK2.VARE.SELSKAP='11' AND
>RIK2.VARE.VARE_SNR=10
>AND
> RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR
> ORDER BY VGR
> 
> 
> ORA-03232: unable to allocate an extent of 62 blocks
> from tablespace 3
> 
> 
> 
> 
> sincerely
> 
> Roland Sköldblom
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re: distribution of the sleeps on the library cache latches

[Deepak Thapliyal]

are you using broadvision by any chance .. we have
similar issues with one of our main customer
databases..
--- Edward Shevtsov <[EMAIL PROTECTED]> wrote:
> Hi Steve,
> 
> yes, you're absolutely right. I've inhereted that
> system. The
> shared_pool_size = 750M. I believe it's HUGE and
> oversized. The application
> code is mostly based on literal SQL. The miss rate
> on the shared pool is
> normally about 15%-20% with periodical peaks up to
> 50%. But the previous DBA
> insist that we shouldn't decrease the size of shared
> pool as the miss rate
> will be much higher. He also setup periodical
> flushing every 3 hours (I
> assume he did it in order to prevent ORA-4031).
> If I undestand the things right, deacresing of
> shared_pool_size will
> decrease load on shared pool latch _but_ contention
> on the library latches
> will be higher because of higher parse rate. Is it
> correct and what's your
> advice in my case?
> 
> Thanks in advance,
> Ed
> 
> 
> > Hi Ed,
> >
> > I would agree with the _kgl_latch_count change,
> but the _kgl_bucket_count
> change seems unwarranted and extreme. Rather I
> > suspect that the size of your library cache hash
> table rather reflects an
> oversized shared pool, probably with some use
> > of literal SQL.
> >
> > @   Regards,
> > @   Steve Adams
> > @   http://www.ixora.com.au/  -  For
> DBAs
> > @   http://www.secularislam.org/call.htm  -  For
> Muslims
> > @   http://www.christianity.net.au/   -  For
> all
> >
> >
> > -Original Message-
> > From: Edward Shevtsov [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, 19 October 2001 18:02
> > To: [EMAIL PROTECTED]
> > Cc: Steve Adams
> > Subject: Re: distribution of the sleeps on the
> library cache latches
> >
> >
> > Hi Steve,
> >
> > thanks for your reply. I'm thinking about twice
> increasing  number of
> > library latches ( _kgl_latch_count = 23 ) in order
> to mitigate loading on
> > them.
> > Also I would like to set _kgl_bucket_count = 8
> according to output of your
> > script. Do you think it's a good idea in my case.
> >
> > NAME  IMPACT SLEEP_RATE   
> HOLDING LEVEL#
> > - -- --
> -- --
> > library cache  60333579.3  0.32% 
> 1729452385
> > shared pool19313269.2  1.40%  
>   8265405 7
> > cache buffers chains1950080.11  0.00% 
>  629411 1
> > row cache objects   738401.912 0.04%   
> 3369329  4
> > session allocation 70758.0784 0.01%   
>   144008  5
> > cache buffer handles56104.  0.01% 
>  71913  3
> > redo allocation33494.1227  0.02%  
>   215582   6
> > cache buffers lru chain 12784.3859  0.00%   
> 198869   3
> > checkpoint queue latch10980.4325  0.00% 
> 52259   7
> > latch wait list   9976.33016 
> 0.04%  24412   9
> > redo writing  4846.5256  0.01%
>  75484 5
> >
> > Regards,
> > Ed
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Edward Shevtsov
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re: QUERY PROBLEM

[Deepak Thapliyal]

i think he wants to query based on a varaible in the
where clause and probably needs top know how that is
done is sql*plus (and not pl/sql)

i gues there is a accept/define commands whihc you
could use .. 

hth
Deepak

PS;i am lame myself in sql*plus...


--- Scott Canaan <[EMAIL PROTECTED]> wrote:
> It depends on what you want to do with this.  You
> need to have an into
> clause, so declare a variable and put one in.  If
> you want to see the
> output, then use the dbms_ouput package to display
> it.
> 
> Harvinder Singh wrote:
> > 
> > Hi,
> > 
> > We need to write a query like this:
> > 
> > declare
> > dd number;
> > begin
> > select * from t_acc where id_acc=dd;
> > end;
> > /
> > 
> > we r getting obvious error that INTO clause is
> missing
> > but we only need to run the query and get the
> result back.
> > How can we accomplish this.
> > 
> > Thanks
> > -Harvinder
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Harvinder Singh
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re: Separate tablespaces for indexes on same table?

[Deepak Thapliyal]

Hi cherie,

In an ideal world i would like to use separate
tablespaces for indexes. 

however first check what lun configuration was used to
design your mount points. 

might not buy you much if you have a set of index
tablespaces under same mount point in terms of
performance at least. 

might also not buy you much if you have a set of index
tablespaces under differnet mount point (assuming
lousy lun configuration)

but under both above worst cases .. it atleast avoids
some maintainance haggles .. so to cut to the chase ..
diff indexes on diff tblspcs makes sense

makes even more sense to also have a tete-tete with
the sysadmin and understand your how many mount points
you have and how they have been configured.

I generally go by the 101 perf book by gaja and kirti
which uses the principle of having 3
categories(tablespaces) like small/medium/large or
something like that.

so once you have these tablespace, just start dumping
the indexes in them based on the sizes of the indexes.

hth
deepak
--- [EMAIL PROTECTED] wrote:
> 
> I am rebuilding some indexes for a 20-Gig table.   I
> am following the
> recommendations in the paper How to Stop
> Defragmenting and Start Living...
> 
> There are six indexes on this table.   According to
> the paper, I should
> create a separate tablespace for these indexes.   My
> question is:  Should I
> put all of the indexes in a single tablespace or
> should I make two
> tablespaces and separate them.   In some queries,
> the indexes may be used
> together but in most they will not.   If I put them
> in a single tablespace,
> will that cause I/O contention.
> 
> This is on 8.0.4  Sun E10K Solaris 2.6 with Veritas
> Quick I/O.
> 
> Thanks,
> 
> Cherie Machler
> Gelco Information Network
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Client install from hell

[Farnsworth, Dave]

I am having a problem on a couple of client installs.  I have Oracle 8.1.7
to be installed on NT 4.0 SP6.  The install starts out fine, I select a
Orahome and then it starts to install.  When it gets to 90% all of a sudden
the install wizard screen just disappears without any error messages.  I can
see that it created a new directory and copied a bunch of files to the hard
drive.  I can even double click on the SQLPlus icon and it launches asking
me for a username, password, and database.
Then if I put the client CD back in and click on the "show installed
components", it tells me that there are no Oracle components installed.  I
look in the registry and a registry for Oracle has been created.  I have
done this about twenty times and get the exact same results.  I even tried a
different CD but that does not change things.
During the install Oracle will write to a log but this log tells me nothing
except what it installed, without one stinking clue as to what is causing
this to puke.
I get this just on two PC's with identical results.  Has anyone seen this
before?  I can go to other PC's and install without a hitch.  These PC's do
work and have plenty of disk space.
Any ideas, ,,,anything?

Thanks,

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

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

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

Re: Separate tablespaces for indexes on same table?

[Connor McDonald]

What really matter is avoiding IO overload on a single
device - and that depends on usage.  The ol' tale
about separating tables and indexes is just a special
case of that (and probably obsolete).

You need to have an idea of 
- how often each index is used
- if they are used together
- if they are used with the table (counts etc can be
done with just the index and not the table at all).

Based on this, you come up with the IO separation you
would required.  This could be 1 index on an 8 disk
stripe (because its hammered), and all the rest
somewhere else.  It could be each index on separate
stripes - because they are all hammered at the same
time.  It could be all on a single stripe - because
typically only 1 get used at a time.

You just need to be able to model what and when is
going to run (monitoring v$filestat is a very good
means for this) and planning (adjusting) accordingly.

hth
connor


 --- [EMAIL PROTECTED] wrote: > 
> I am rebuilding some indexes for a 20-Gig table.   I
> am following the
> recommendations in the paper How to Stop
> Defragmenting and Start Living...
> 
> There are six indexes on this table.   According to
> the paper, I should
> create a separate tablespace for these indexes.   My
> question is:  Should I
> put all of the indexes in a single tablespace or
> should I make two
> tablespaces and separate them.   In some queries,
> the indexes may be used
> together but in most they will not.   If I put them
> in a single tablespace,
> will that cause I/O contention.
> 
> This is on 8.0.4  Sun E10K Solaris 2.6 with Veritas
> Quick I/O.
> 
> Thanks,
> 
> Cherie Machler
> Gelco Information Network
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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


Nokia Game is on again. 
Go to http://uk.yahoo.com/nokiagame/ and join the new
all media adventure before November 3rd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE:

[Deepak Thapliyal]

no data found .. 

its friday .. .. lol

--- "Behar, Rivaldi"
<[EMAIL PROTECTED]> wrote:
> exp scott/tiger tables=idiot
> 
> About to export specified tables via Conventional
> Path ...
> . . exporting tableIDIOT
> 1000 rows
> exported
> 
> 
> -Original Message-
> Sent: Friday, October 19, 2001 12:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Are you an idiot?
> 
> --Walt Weaver
>   Bozeman, Montana
> 
> -Original Message-
> Sent: Friday, October 19, 2001 11:05 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> HELP
> 
> -Original Message-
> Sent: Friday, October 19, 2001 12:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> ORA-600 No info. Please contact your oracle support
> representative. Do not
> despair.
> 
> -Original Message-
> Sent: Friday, October 19, 2001 11:40 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> INFO ORACLE-L
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

816 desupport

[Deepak Thapliyal]

got this from one of the analysts looking at one of
the tars my colleugues had filed for a bug we were
hiting that is fixed in 817 .. the reason he said for
denial of backport to 8163 was: "8.1.6 is desupported
as of October 31st of this year"

looks like oracle wants everyone to jump 2 817 (.. if
not 9i)

deepak


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: Little Brother Larry sorta ON topic

[Kimberly Smith]

Are you sure its not illegal to 'attempt' suicide?  Granted
that still does not make a whole lot of sense but it gives
them a way to get back at you for the medical bills and what
not of a failed attempt I believe.  So if you do want to do
it take the extra time and plan well (not that I think anyone
should do it).

-Original Message-
Sent: Friday, October 19, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L


No, man, they through your corpse into a cell until you learn better.  Duh!

-Original Message-
Sent: Friday, October 19, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 00:50


> My favorite law is that it is illegal to commit suicide. 
> 
> Love that!


and what happens if u successfully commit one?

will they sue u?


Marin



"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "



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

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

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

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

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

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

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

Re: event= to capture deadlock debug info

[Deepak Thapliyal]

Hi James,

setting an event at init/session level would basically
dump the error state into an trc file. ora-60 or
deadlock by defualt writes a message in alert file and
also dumps a large trace in udump.

so why do you want to explicitly set this event? The
default behaviour mimicks the same anyways.

hth
Deepak

--- James Howerton <[EMAIL PROTECTED]> wrote:
> DBA's
> 
> Does anyone know of an event= to set to capture a
> deadlock condition? 
> 
> On two occasions now a user's session has locked up
> due to a network problem or three finger salute or
> who knows what(???) blocking other users from adding
> records to the system. I have to get it fixed
> quickly to get them working again so I don't have
> time to study everything in the locked state before
> killing the offending users session. It has only
> happened twice, once at night and once on a
> holliday. I don't have all of my toys at home to get
> a quick look.
> 
> TIA
> 
> ...JIM... 
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: James Howerton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

RE: Tools

[Wong, Bing]

you are ready to pay big $ for BMC, Quest and CA tools.

-Original Message-
Sent: Friday, October 19, 2001 10:39 AM
To: Multiple recipients of list ORACLE-L


Does anybody know of any good monitoring tools for Oracle. We are using OEM 
and are not very happy.
We need something to monitor the DB and alert us, and something to run 
"jobs" on a schedule or repair basis.
This could save me months of research and surfing.

What works for you?


TIA!!

Eric.

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

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

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

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

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

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

RE:

[Behar, Rivaldi]

Title: RE: 





exp scott/tiger tables=idiot


About to export specified tables via Conventional Path ...
. . exporting table    IDIOT 1000 rows exported



-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: 



Are you an idiot?


--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Friday, October 19, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L



HELP


-Original Message-
Sent: Friday, October 19, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L



ORA-600 No info. Please contact your oracle support representative. Do not
despair.


-Original Message-
Sent: Friday, October 19, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L



INFO ORACLE-L


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


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

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


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

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


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

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

Re: QUERY PROBLEM

[Scott Canaan]

It depends on what you want to do with this.  You need to have an into
clause, so declare a variable and put one in.  If you want to see the
output, then use the dbms_ouput package to display it.

Harvinder Singh wrote:
> 
> Hi,
> 
> We need to write a query like this:
> 
> declare
> dd number;
> begin
> select * from t_acc where id_acc=dd;
> end;
> /
> 
> we r getting obvious error that INTO clause is missing
> but we only need to run the query and get the result back.
> How can we accomplish this.
> 
> Thanks
> -Harvinder
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: [EMAIL PROTECTED]

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

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

RE: Little Brother Larry sorta ON topic

[Bellows, Bambi]

No, man, they through your corpse into a cell until you learn better.  Duh!

-Original Message-
Sent: Friday, October 19, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 00:50


> My favorite law is that it is illegal to commit suicide. 
> 
> Love that!


and what happens if u successfully commit one?

will they sue u?


Marin



"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "



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

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

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

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

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

Separate tablespaces for indexes on same table?

[Cherie_Machler]

I am rebuilding some indexes for a 20-Gig table.   I am following the
recommendations in the paper How to Stop Defragmenting and Start Living...

There are six indexes on this table.   According to the paper, I should
create a separate tablespace for these indexes.   My question is:  Should I
put all of the indexes in a single tablespace or should I make two
tablespaces and separate them.   In some queries, the indexes may be used
together but in most they will not.   If I put them in a single tablespace,
will that cause I/O contention.

This is on 8.0.4  Sun E10K Solaris 2.6 with Veritas Quick I/O.

Thanks,

Cherie Machler
Gelco Information Network

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

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

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

RE: Design question DW

[Aponte, Tony]

Title: RE: Design question DW






I consider the skillset I acquired as an extension of the OLTP ones I already had.  Some lessons I learned: 

think big (lots of data, parallelize queries and object creation/maintenance), 

move to SAFE tablespace layouts (famous paper 711) to reduce object sizing and defrag work,

bone up on partitioning features and caveats,

ditto for locally-managed tablespaces,

denormalize tables to speed query response times,

don't denormalize to make it easier for developing SQL,

live without database-enforced constraints that slow down DML (enforce it on the load programs)

don't run in archivelog mode,

replace traditional cold backups with transportable tablespaces (will keep your DW in read-only mode while backup executes)

wide-striping performed better that manual object/datafile/device I/O balancing,

and I can't emphasize this enough, get design help from the professionals.  Our 1st through 4th attempt at deploying a DW were driven by OLTP programmers.  In the words of an independent audit (read $$$) conducted on our DW "It's an OLTP programmer's view of a DW.  Keep the named of the DW and trash the rest."  Heads rolled, money was misspent and I lost some more hair.

If you haven't already done so I suggest reading almost everything in http://www.billinmon.com/  http://www.ralphkimball.com/ to get up to speed on DW concepts.  I'm not totally sure but I think your case is referred to a multi-values source system fields and has been addressed in one of the two sites.  I learned that for starters the approach I would take is to gather typical questions that are asked of the OLTP system (i.e.. foreign cars that used p240 tires, foreign cars that take 2 or more tire sizes, all cars that use p250 and p200).  Each one of these implies that the multi-values column should be parsed out into separate tables (one dimension table for cars, one for tire sizes, and another helper table for car/tire size rows).  You'll find many of these terms in the two websites.  The 3 tables could answer the examples as follows (excuse my syntax errors):

Foreign cars that used p240 tires:


Select 

  car,count(*)

from 

  car_table, car_tire_table

where 

  car_table.domestic=false

and   

  car_table.car = car_tire_table.car

and   

  car_tire_table.tire_size = 'p240';


Foreign cars that take 2 or more tire sizes:


Select 

  car,count(*)

from 

  car_table, car_tire_table

where 

  car_table.domestic=false

and   

  car_table.car = car_tire_table.car

group by 

  car

having 

  count(*) > 1;



All cars that use p250 and p200 tires


Select

  car

from

  car_tire_table

where

  car_tire_table.tire_size in ('p250','p200');



My point here is to show that gathering few common questions coupled with a little knowledge of DW concepts can jumpstart your thinking in DW design terms (or scare you enough to seek out people that do it for a living).

HTH

Tony Aponte



-Original Message-

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

Sent: Friday, October 19, 2001 10:35 AM

To: Multiple recipients of list ORACLE-L

Subject: Design question DW



Hello List,


 I have a design question for a datawarehouse

application.  I have done OLTP design, but no DW

design before.  The issue is that this warehouse is

being fed from an existing system that allows

multi-values.  What I mean by multi-values is a

column that has comma delimited values in it.  So for

example, if there is a car table with a column that

says tire_size, if the car can handle tire sizes of

p200, p240, and p250 then for a select on the one row

with that car in it, under the tire column you would

have p200,p240,p250.  

I would never even think about letting this thru in

an OLTP system, and if I didn't have access to the

list I wouldn't allow it in a data warehouse either. 

But, since I have the advantage of your expertise, I

thought I might as well use it.  There are about 40

of these columns in 5 tables in the proposed design

by the developer.  The developer is trying to say

that they won't use these columns in the where

clauses on most of them and that they are just

detailed data for display.  I have been around long

enough to know how fast that changes, and all of a

sudden the database is a dog and everyone is blaming

the DBA.  

 So my question is, am I just an OLTP DBA in new

territory, or the same principles apply, and

multi-values are still one of the biggest relational

design disasters regardless of OLTP or DW.


Any help is appreciated,

Mike




You too can have your own email address from Eurosport.

http://www.eurosport.com






-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: 

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists

---

RE:

[Weaver, Walt]

Are you an idiot?

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, October 19, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L


HELP

-Original Message-
Sent: Friday, October 19, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L


ORA-600 No info. Please contact your oracle support representative. Do not
despair.

-Original Message-
Sent: Friday, October 19, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


INFO ORACLE-L

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

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

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

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

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

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

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

Tools

[Eric Swain]

Does anybody know of any good monitoring tools for Oracle. We are using OEM 
and are not very happy.
We need something to monitor the DB and alert us, and something to run 
"jobs" on a schedule or repair basis.
This could save me months of research and surfing.

What works for you?


TIA!!

Eric.

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

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

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

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

Data Auditing

[Bill Buchan]

Does anyone have any recommendations on auditing data changes on several 
tables?  I want to keep before and after data along with username/timestamp.

I'm thinking of a DML trigger on each table and each with its own audit 
table?  Or what about a single audit table (using TO_CHAR to convert all 
non-character data into the BEFORE and AFTER columns; only CHAR, VARCHAR2, 
DATE and NUMBER datatypes are used).  That should be slightly more generic.

Either way it seems a bit messy.  Anybody got a better idea?  (This audit 
trail has to be readily visible to the users - ie. a table - Log Miner 
isn't really practical).

Many thanks for any suggestions.
- Bill.


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

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

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

QUERY PROBLEM

[Harvinder Singh]

Hi,

We need to write a query like this:

declare
dd number;
begin
select * from t_acc where id_acc=dd;
end;
/

we r getting obvious error that INTO clause is missing
but we only need to run the query and get the result back.
How can we accomplish this.

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

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

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

Re: sys.obj$, type# desc

[Richard Ji]

1 INDEX
2 TABLE
3 CLUSTER
4 VIEW
5 SYNONYM
6 SEQUENCE
7 PROCEDURE
8 FUNCTION
9 PACKAGE
10 NON-EXISTENT
11 PACKAGE BODY
12 TRIGGER
13 TYPE
14 TYPE BODY
19 TABLE PARTITION
20 INDEX PARTITION
21 LOB
22 LIBRARY
23 DIRECTORY
24 QUEUE
25 IOT
26 REPLICATION OBJECT GROUP
27 REPLICATION PROPAGATOR
28 JAVA SOURCE
29 JAVA CLASS
30 JAVA RESOURCE
31 JAVA JAR
32 INDEXTYPE
33 OPERATOR
34 TABLE SUBPARTITION
35 INDEX SUBPARTITION

Richard Ji

>>> [EMAIL PROTECTED] 10/19/01 12:10PM >>>
hI gurus'

[EMAIL PROTECTED]>;
  1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and
rownum < 4
[EMAIL PROTECTED]> /

 OBJ# NAME   TYPE#
- -- -
 1149 DBA_ROLES  4
 1150 DBA_ROLES  5
 1151 DBA_PROFILES   4

[EMAIL PROTECTED]> 

Hope that type# 4, refers 'SYNONYMS'. what is the object whic are refered by
type# 5?.(Is't view?)

Where i can check to know the desc for all the type#?.


Regards, 
Nirmal.

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

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

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

RE:

[Mohan, Ross]

HELP

-Original Message-
Sent: Friday, October 19, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L


ORA-600 No info. Please contact your oracle support representative. Do not
despair.

-Original Message-
Sent: Friday, October 19, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


INFO ORACLE-L

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

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

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

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

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

event= to capture deadlock debug info

[James Howerton]

DBA's

Does anyone know of an event= to set to capture a deadlock condition? 

On two occasions now a user's session has locked up due to a network problem or three 
finger salute or who knows what(???) blocking other users from adding records to the 
system. I have to get it fixed quickly to get them working again so I don't have time 
to study everything in the locked state before killing the offending users session. It 
has only happened twice, once at night and once on a holliday. I don't have all of my 
toys at home to get a quick look.

TIA

...JIM... 

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

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

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

RE: providing 24*7 database ---

[Nick Wagner]

Title: RE: providing 24*7 database ---





Here is a link http://www.quest.com/whitepapers/ you can use to check out a couple of white papers on 24x7 shops and HA environments with Oracle.   One very good one, that will help address your needs is this one... http://www.quest.com/whitepapers/Building_WP.pdf written by Eyal Aronoff.   


Nick


-Original Message-
Sent: Thursday, October 18, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: providing 24*7 database ---



hi  gurus,


Our shop ( GIS oracle spatials ) attempting to provide a production database
(7x 24 hours) , currently we have to offline database for users while
loading of data.
we donot what users to access data while loading. 
We are thinking of provide 24* 7 services to customers with out going
offline. 
What are the best  possible solutions ? I had few but I donot know its right
direction .


Possible Solutions


Replication - 
*   not possible until Oracle 9i spatial  (because of the restriction on
replicating objects).  
*   Even then expense of additional licensing/machinery may be too great


Duplicate instances - have 2 instances and users switch from one to other
after production load.-- how to implement ?


Duplicate schema within current database.  Have 3 schemas inside a single
TIPSPROD instance.  The schema with the current data remains in production
until the second schema is loaded with the new data.  This is can only work
if we introduce a third schema that holds the views.  At certain time, we
redefine all the views in the DATAVIEWS schema. --- its kind of duplication
--- certainly not my option


Can some body direct me where to look or any ideas ?
TIA
> narender.akula
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Narender Akula
  INET: [EMAIL PROTECTED]


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

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

RE: sys.obj$, type# desc

[Deshpande, Kirti]

Nirmal,
Type#  4 is a view 

Type#  5 is a synonym. 

Look in sql.bsq file for more info... 

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Nirmal Kumar  Muthu Kumaran [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 11:10 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  sys.obj$, type# desc
> 
> hI gurus' 
> 
> [EMAIL PROTECTED]>; 
>   1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and
> rownum < 4 
> [EMAIL PROTECTED]> / 
> 
>  OBJ# NAME   TYPE# 
> - -- - 
>  1149 DBA_ROLES  4 
>  1150 DBA_ROLES  5 
>  1151 DBA_PROFILES   4 
> 
> [EMAIL PROTECTED]> 
> 
> Hope that type# 4, refers 'SYNONYMS'. what is the object whic are refered
> by type# 5?.(Is't view?) 
> 
> Where i can check to know the desc for all the type#?. 
> 
> 
> Regards, 
> Nirmal. 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: Ora-000036 error

[Mohan, Ross]

the parameter is

developer_coding_standards = auto_increase

-Original Message-
Sent: Friday, October 19, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L


Hi
I have "ORA-00036: maximum number of recursive SQL levels (50) exceeded" 
error.Let me know which parameter is related I can change.I am running 
oracle8.1.7 on solaris platform
Thanks
-Seema

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

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

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

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

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

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

Re: Question about temporary segments

[Yosi Greenfield]

Mike,

When it creates an index, Oracle doesn't make it visible as it's being built. So

basically, Oracle creates the index as a temporary segment in the location it
will belong when it's done being created. When Oracle finishes creating the
index, Oracle then makes the index 'un-temporary', gives it its specified
index name, and leaves it where it is.

The alternative would be to create the index in TEMP and then take the
extra step of moving the index to its final destination. Oracle doesn't do that.

Note that these are different temp segments than the ones Oracle uses to sort
the data in order to build the index. Those are, as you noted, stored in TEMP.

HTH,

Yosi


"Petrus, Mike (CAP, GEFA)" wrote:

> Greetings All;
> I am confused and hope someone can straighten me out.
>
> My confusion surrounds temporary segments and where they are created.  I had
> assumed that temporary segments were created in a user's, assigned temporary
> tablespace.  However when I have a creation failure, for example, if I am
> attempting to rebuild an index that is currently in tablespace aww_index1, I
> received the following error: (ORA-1652: unable to extend temp segment by
> 1280 in tablespace AWW_INDEX1), this is telling me that the temp segment is
> being created in the tablespace that the permanent object exists in.  Is
> this always the case?  Is the only purpose of the user's, assigned
> "TEMPORARY" table space for sorting.  Can I tell Oracle to redirect the
> creation of the temp segment to a different tablespace?  If so how is that
> accomplished?
>
> Thanks in advance.
>
> Michael L. Petrus
> GE Auto Warranty Services
> 7125 W. Jefferson Av. #200
> Lakewood, CO 80235
>
> Database Administrator
>
> Phone: (303) 987 4129
> Fax: (303) 987 4298
> Email:   [EMAIL PROTECTED]


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

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

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

RE:

[Gogala, Mladen]

ORA-600 No info. Please contact your oracle support representative. Do not
despair.

-Original Message-
Sent: Friday, October 19, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L


INFO ORACLE-L

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

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

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

RE: Errormessage

[Mohan, Ross]

Let me guess that tablespace 3 is your temporary tablespace?



-Original Message-
Sent: Friday, October 19, 2001 12:00 PM
To: Multiple recipients of list ORACLE-L



Hallo,

what does this errormessage mean. I get  it when i try to do  this select
statement.
If I dont include the last two lines in the statement it works fine. What
does this depend on? and which action shallI do to make it work?


SELECT RIK2.VARE.EAN_NR,
RIK2.VARE.LEVNR,
RIK2.ART_HIERARKI_CALC.VGR,
RIK2.VARE.SORTIMENT,
RIK2.VARE.VARENAVN
FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC
WHERE RIK2.VARE.SELSKAP='11' AND
   RIK2.VARE.VARE_SNR=10
   AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR
ORDER BY VGR


ORA-03232: unable to allocate an extent of 62 blocks from tablespace 3




sincerely

Roland Sköldblom

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

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

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

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

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

Rep:RE: providing 24*7 database ---

[adba]

 If the only time the data is updated is through
a batch process then you could have 2 databases, and
just run the batch updates at different times.  The
databases would always be in sync except during the
load process.
 On the other hand, if you have OLTP type
updating, you need to think about something similiar
to what Guy Hammond said.


-Message d'origine-
De: "Guy Hammond" <[EMAIL PROTECTED]>
A: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Date: 19/10/01
Objet: RE: providing 24*7 database ---

The thing that immediately springs to mind would be
to use two
databases, one for queries, one for loading. Then,
when the data was
ready, use a transportable tablespace to plug it in.
There might be some
post processing or redefining of views necessary.
This is better than
using two schemas to do it, because you can have two
instances on two
different machines, each instance tuned for exactly
what you want to do
with it, and the loading and the queries won't need
to share I/O and
CPU. Altho' I guess you could use resource consumer
groups and spread
the I/O across controllers. That way you could have
one big machine and
all its CPU would be available while loads weren't
running. Hmmm.

g




-Original Message-
Sent: Thursday, October 18, 2001 10:30 PM
To: Multiple recipients of list ORACLE-L


hi  gurus,

Our shop ( GIS oracle spatials ) attempting to
provide a production
database
(7x 24 hours) , currently we have to offline database
for users while
loading of data.
we donot what users to access data while loading. 
We are thinking of provide 24* 7 services to
customers with out going
offline. 
What are the best  possible solutions ? I had few but
I donot know its
right
direction .

Possible Solutions

Replication - 
* not possible until Oracle 9i spatial  (because of
the
restriction on
replicating objects).  
* Even then expense of additional licensing/machinery
may be too
great

Duplicate instances - have 2 instances and users
switch from one to
other
after production load.-- how to implement ?

Duplicate schema within current database.  Have 3
schemas inside a
single
TIPSPROD instance.  The schema with the current data
remains in
production
until the second schema is loaded with the new data. 
This is can only
work
if we introduce a third schema that holds the views. 
At certain time,
we
redefine all the views in the DATAVIEWS schema. ---
its kind of
duplication
--- certainly not my option

Can some body direct me where to look or any ideas ?
TIA
> narender.akula
> 
-
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

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


You too can have your own email address from Eurosport.
http://www.eurosport.com





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

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

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

RE: slightly OT: visual c++ and null values

[Norrell, Brian]

Pro*C has indicator variables.
MFC's ODBC classes have IsNull functions.

Both methods add an extra step to the code to check for null, so it is a
pain to implement (and a major pain if all the columns are nullable), but it
is doable.

Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600


-Original Message-
Sent: Friday, October 19, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L


hello!

our developers here are requesting that I put defaults (' ' for
chars/varchars, 0 for numbers, etc) in place instead of nulls in all
columns that would supposedly allow null values...
they are using visual c++ and they say that they cannot make visual c++
retreive null values...
i am very hesitant in implementing this...
i have no knowledge whatsoever of visual c++ and don't know if this is
true...

i'd like to know if anyone had encountered this same problem before?
or maybe someone can tell me if there is any truth to what our
developers are saying...


oracle817 on solaris7

thanks =)

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

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

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

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

Ora-000036 error

[Seema Singh]

Hi
I have "ORA-00036: maximum number of recursive SQL levels (50) exceeded" 
error.Let me know which parameter is related I can change.I am running 
oracle8.1.7 on solaris platform
Thanks
-Seema

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

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

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

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

sys.obj$, type# desc

[Nirmal Kumar Muthu Kumaran]

Title: sys.obj$, type# desc





hI gurus'


[EMAIL PROTECTED]>;
  1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and rownum < 4
[EMAIL PROTECTED]> /


 OBJ# NAME   TYPE#
- -- -
 1149 DBA_ROLES  4
 1150 DBA_ROLES  5
 1151 DBA_PROFILES   4


[EMAIL PROTECTED]> 


Hope that type# 4, refers 'SYNONYMS'. what is the object whic are refered by type# 5?.(Is't view?)


Where i can check to know the desc for all the type#?.



Regards, 
Nirmal.

Datafile header info needed

[Tracy Rahmlow]

Background:

We have 2 databases (7.3.4.5) on aix 4.3.3.  When executing the strings command
(strings system.dbf | pg) on a datafile one returns the database and the
oracle_home location.  For example:

prdr:/optc/oracle/rdbms/7.3.4

The other database does not display this information.  What controls whether or
not this is written to the header?  This came up as an issue because we
currently use Sql BackTrack and during a restore process(logical extraction) it
restores needed datafiles and attempts to create a temporary database so that
it can extract out data.  In the process it fails to create the control files
because I believe it is using this information in the datafile to locate the
sqadef.dbf file within the oracle_home/dbs directory to verify whether or
not the instance is currently running.  One database works because it can not
find the sgadef file and it also does not have the oracle_home info in the
header.  The other database fails with an ora-09782 sfifi: another instance has
the same database mounted.  (this database has the oracle_home in the header).
Anyone run across this issue before?  Does this sound correct? And what
controls whether or not the info is written to the header?  Why do we have
mixed results? Why, why, why?  Thanks and at least its friday.


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

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

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

RE: providing 24*7 database ---

[Rachel Carmichael]

Having been through (and still going through this)...

we use one for queries, one for loading, when the loads are done, we do
a backup then we switch the app to the "loading" database (coded so
that as long as someone is connected the app doesn't switch over).

once the app has switched, we down the "queries" database and rebuild
it from the backup.  then switch everyone back to that one.

guy -- transportable has problems, and if the tablespace names are the
same as existing ones, you can't do the transport.

Rachel
--- Guy Hammond <[EMAIL PROTECTED]> wrote:
> The thing that immediately springs to mind would be to use two
> databases, one for queries, one for loading. Then, when the data was
> ready, use a transportable tablespace to plug it in. There might be
> some
> post processing or redefining of views necessary. This is better than
> using two schemas to do it, because you can have two instances on two
> different machines, each instance tuned for exactly what you want to
> do
> with it, and the loading and the queries won't need to share I/O and
> CPU. Altho' I guess you could use resource consumer groups and spread
> the I/O across controllers. That way you could have one big machine
> and
> all its CPU would be available while loads weren't running. Hmmm.
> 
> g
> 
> 
> 
> 
> -Original Message-
> Sent: Thursday, October 18, 2001 10:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> hi  gurus,
> 
> Our shop ( GIS oracle spatials ) attempting to provide a production
> database
> (7x 24 hours) , currently we have to offline database for users while
> loading of data.
> we donot what users to access data while loading. 
> We are thinking of provide 24* 7 services to customers with out going
> offline. 
> What are the best  possible solutions ? I had few but I donot know
> its
> right
> direction .
> 
> Possible Solutions
> 
> Replication - 
> * not possible until Oracle 9i spatial  (because of the
> restriction on
> replicating objects).  
> * Even then expense of additional licensing/machinery may be too
> great
> 
> Duplicate instances - have 2 instances and users switch from one to
> other
> after production load.-- how to implement ?
> 
> Duplicate schema within current database.  Have 3 schemas inside a
> single
> TIPSPROD instance.  The schema with the current data remains in
> production
> until the second schema is loaded with the new data.  This is can
> only
> work
> if we introduce a third schema that holds the views.  At certain
> time,
> we
> redefine all the views in the DATAVIEWS schema. --- its kind of
> duplication
> --- certainly not my option
> 
> Can some body direct me where to look or any ideas ?
> TIA
> > narender.akula
> > 
> -
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Guy Hammond
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: slightly OT: visual c++ and null values

[Guidry, Chris]

Hi,
>From the book:

EXEC SQL BEGIN DECLARE SECTION; 
intemp_number; 
float  salary, commission; 
short comm_ind;  /* indicator variable  */
EXEC SQL END DECLARE SECTION;
char temp[16];
float  pay;  /* not used in a SQL statement */
...
printf("Employee number? "); 
gets(temp);
emp_number = atof(temp);
EXEC SQL SELECT SAL, COMM 
INTO :salary, :commission:ind_comm 
FROM EMP 
WHERE EMPNO = :emp_number; 
if(ind_comm == -1)/* commission is null */
pay = salary; 
else
pay = salary + commission; 


--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 09:25 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: slightly OT: visual c++ and null values
> 
> Stefan,
> 
> OK.  can you help with a solution?  sounds like you have experience...
> :)
> 
> How about some coding examples?
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> Sent: Friday, October 19, 2001 10:05 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> sorry for the strong language, but the statement that VC++ isn't able to
> retrieve NULL values is plain bullshit.
> 
>  
> | Regards,   |
> | Stefan Jahnke  |
> | BOV AG |
> | @:D2 Vodafone, Abt.: FBOM  |
> | Tel.: 0211/533-4893|
>  
> 
> Maria Aurora VT de la Vega schrieb:
> > 
> > hello!
> > 
> > our developers here are requesting that I put defaults (' ' for
> > chars/varchars, 0 for numbers, etc) in place instead of nulls in all
> > columns that would supposedly allow null values...
> > they are using visual c++ and they say that they cannot make visual c++
> > retreive null values...
> > i am very hesitant in implementing this...
> > i have no knowledge whatsoever of visual c++ and don't know if this is
> > true...
> > 
> > i'd like to know if anyone had encountered this same problem before?
> > or maybe someone can tell me if there is any truth to what our
> > developers are saying...
> > 
> > oracle817 on solaris7
> > 
> > thanks =)
> > 
> > --
> > Maria Aurora VT de la Vega (OCP)
> > Database Specialist
> > Philippine Stock Exchange, Inc.
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Maria Aurora VT de la Vega
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> > -
> > This Mail has been checked for Viruses
> > Attention: Encrypted mails can NOT be checked!
> > 
> > **
> > 
> > Diese Mail wurde auf Viren geprueft
> > Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
> > -
> 
> --
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Se

No Subject

[Paula Wachtmeister]

INFO ORACLE-L

Errormessage

[Roland . Skoldblom]

Hallo,

what does this errormessage mean. I get  it when i try to do  this select statement.
If I dont include the last two lines in the statement it works fine. What does this 
depend on? and which action shallI do to make it work?


SELECT RIK2.VARE.EAN_NR,
RIK2.VARE.LEVNR,
RIK2.ART_HIERARKI_CALC.VGR,
RIK2.VARE.SORTIMENT,
RIK2.VARE.VARENAVN
FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC
WHERE RIK2.VARE.SELSKAP='11' AND
   RIK2.VARE.VARE_SNR=10
   AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR
ORDER BY VGR


ORA-03232: unable to allocate an extent of 62 blocks from tablespace 3




sincerely

Roland Sköldblom

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

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

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

RE: database degrade ???

[Deshpande, Kirti]

Create a clone of 8.1.7 database (using cold backup or hot backup). 
Connect to the clone under 8.1.7 environment.
Review and run Oracle's downgrade script
$ORACLE_HOME/rdbms/admin/d080150.sql.
Shutdown the clone. 
Create appropriate init.ora for the clone's 8.1.5 incarnation.. 
Setup env for 8.1.5 for clone. Adjust oratab, listener.ora etc.  Startup the
clone under 8.1.5. 
You may want to re-run catalog, catproc scripts..  

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Leslie Lu [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 6:21 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  database degrade ???
> 
> Hi all, 
> 
> We installed 815, 817 on Sun 5.6.  There is an 817
> database, and developers requested to build an exactly
> same database but at 815 level.  
> 
> I don't think I can copy 817's backup files and create
> a 815 db, since the backup already has 817
> characteristics.  Is there a way to do degrade?
> 
> If I create an 815 db, and do an export/import, how do
> I make sure the dmp from 817 only have 815
> characteristics.  Full db export won't work, is it? 
> And does schema export has nothing to do with Oracle
> version, if so, I can use schema dmp file.
> 
> Thank you!
> 
> Leslie
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: WINNT-L Digest - 18 Oct 2001 - Special issue (#2001-762)

[Mohan, Ross]

*excellent*

Pour that man a globalized alcohol beverage!

-Original Message-
Sent: Thursday, October 18, 2001 8:10 PM
To: Multiple recipients of list ORACLE-L


Also (look under "scripting"?):

http://www.ultratech-llc.com/KB/?File=~MoreInfo.TXT


> For the Ross-tafarian:
> 
> http://peach.ease.lsoft.com/archives/winnt-l.html

...

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

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

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

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

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

Re[2]: slightly OT: visual c++ and null values

[dgoulet]

Stefan,

I'll disagree.  VC++ can handle null values, it's a question of whether or
not the developer can handle them.  I'll make the assumption that they are using
PRO*C vs. OCI and during execution you do get an Oracle error stating that there
is a null value if you do not handle it correctly.  Many a developer and
duhveloper is under the assumption that this is a language problem since Version
6 and early 7 handled this situation for you.  Today you need the indicator
value, but for the most part you can ignore the indicator's value since the
.len parameter of a VARCHAR will be 0.  Indicator variables really
come into their own when your dialing with numeric data as that's the only way
to handle retrieving or inserting nulls.  Basically if the indicator is < 0
there is a null.  PeopleSoft is rampant with this placing a single space in a
character column to indicate a null.

Dick Goulet
Oracle certified 8i DBA
& Pro*C Evangelist

Reply Separator
Author: Stefan Jahnke <[EMAIL PROTECTED]>
Date:   10/19/01 6:05 AM

Hi,

sorry for the strong language, but the statement that VC++ isn't able to
retrieve NULL values is plain bullshit.

 
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893|
 

Maria Aurora VT de la Vega schrieb:
> 
> hello!
> 
> our developers here are requesting that I put defaults (' ' for
> chars/varchars, 0 for numbers, etc) in place instead of nulls in all
> columns that would supposedly allow null values...
> they are using visual c++ and they say that they cannot make visual c++
> retreive null values...
> i am very hesitant in implementing this...
> i have no knowledge whatsoever of visual c++ and don't know if this is
> true...
> 
> i'd like to know if anyone had encountered this same problem before?
> or maybe someone can tell me if there is any truth to what our
> developers are saying...
> 
> oracle817 on solaris7
> 
> thanks =)
> 
> --
> Maria Aurora VT de la Vega (OCP)
> Database Specialist
> Philippine Stock Exchange, Inc.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Maria Aurora VT de la Vega
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
> 
> **
> 
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
> -

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

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

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

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

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

Free space puzzle

[O'Neill, Sean]

TS is showing 100% used in DBA Studio.  DBA_DATA_FILES is showing MAXBLOCKS,
MAXBYTES values corresponding to filesize of 2000M which was what tablespace
was originally created with.  Subsequently altered to 4000M with ALTER
DATABASE DATAFILE '' AUTOEXTEND ON MAXSIZE 4000M.  I'm puzzled as
to why the DBA views do not reflect the 4000M.  Can anyone explain what I'm
overlooking please?

-
Sean O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 
Oracle 8.1.7 - W2K 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

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

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

RE: Which RAID level do you use?

[Mohan, Ross]

oh yea, 20K plus cabinet and cablingthat IS 
too much for a TERABYTE of storage. 

What was i thinking?



-Original Message-
Sent: Friday, October 19, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L


Then mirror it for an additional 10K

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 18, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L

"RAID 1 is fine if you have infinite storage (read: Infinite Budget).
Try buying an extra TB of disk just for the fun of it and see what
your budget committee does to you :-)"


Kind of agree.Get an IBM Deskstar model...close to 100 GBbuy
ten at maybe, what? a grand each..and VOILA a terabyte for about
10K. 

Not exactly "infinite budget"!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: slightly OT: visual c++ and null values

[Mercadante, Thomas F]

Stefan,

OK.  can you help with a solution?  sounds like you have experience...   :)

How about some coding examples?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, October 19, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


Hi,

sorry for the strong language, but the statement that VC++ isn't able to
retrieve NULL values is plain bullshit.

 
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893|
 

Maria Aurora VT de la Vega schrieb:
> 
> hello!
> 
> our developers here are requesting that I put defaults (' ' for
> chars/varchars, 0 for numbers, etc) in place instead of nulls in all
> columns that would supposedly allow null values...
> they are using visual c++ and they say that they cannot make visual c++
> retreive null values...
> i am very hesitant in implementing this...
> i have no knowledge whatsoever of visual c++ and don't know if this is
> true...
> 
> i'd like to know if anyone had encountered this same problem before?
> or maybe someone can tell me if there is any truth to what our
> developers are saying...
> 
> oracle817 on solaris7
> 
> thanks =)
> 
> --
> Maria Aurora VT de la Vega (OCP)
> Database Specialist
> Philippine Stock Exchange, Inc.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Maria Aurora VT de la Vega
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
> 
> **
> 
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
> -

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

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

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

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

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

Intermedia application

[SARKAR, Samir]

Hi there,

An application running the Intermedia process ctxhx is seen to b consuming
an unusually high CPU 
time thus preventing other applications from running.

Being very new to Intermedia I do not why this is happening. Can somebody
help me on how to
diagnose the problem of high CPU usage by ctxhx and correct it ??

Any help will be greatly appreciated.

Thanks.

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



___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

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

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

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

RE: providing 24*7 database ---

[Guy Hammond]

The thing that immediately springs to mind would be to use two
databases, one for queries, one for loading. Then, when the data was
ready, use a transportable tablespace to plug it in. There might be some
post processing or redefining of views necessary. This is better than
using two schemas to do it, because you can have two instances on two
different machines, each instance tuned for exactly what you want to do
with it, and the loading and the queries won't need to share I/O and
CPU. Altho' I guess you could use resource consumer groups and spread
the I/O across controllers. That way you could have one big machine and
all its CPU would be available while loads weren't running. Hmmm.

g




-Original Message-
Sent: Thursday, October 18, 2001 10:30 PM
To: Multiple recipients of list ORACLE-L


hi  gurus,

Our shop ( GIS oracle spatials ) attempting to provide a production
database
(7x 24 hours) , currently we have to offline database for users while
loading of data.
we donot what users to access data while loading. 
We are thinking of provide 24* 7 services to customers with out going
offline. 
What are the best  possible solutions ? I had few but I donot know its
right
direction .

Possible Solutions

Replication - 
*   not possible until Oracle 9i spatial  (because of the
restriction on
replicating objects).  
*   Even then expense of additional licensing/machinery may be too
great

Duplicate instances - have 2 instances and users switch from one to
other
after production load.-- how to implement ?

Duplicate schema within current database.  Have 3 schemas inside a
single
TIPSPROD instance.  The schema with the current data remains in
production
until the second schema is loaded with the new data.  This is can only
work
if we introduce a third schema that holds the views.  At certain time,
we
redefine all the views in the DATAVIEWS schema. --- its kind of
duplication
--- certainly not my option

Can some body direct me where to look or any ideas ?
TIA
> narender.akula
> 
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
  INET: [EMAIL PROTECTED]

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

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

Re: Data Cleansing.

[Dale Edgar]

Hi Yuval
 
Can you tell us a bit about what you would like the 
product to do (a wish list)
 
> We are 
currently looking into a tool that will help us validate data (. Can you 
recommend any tool or product that will do it in an Oracle 
environment.
 

Thanks
Dale 
--DataBee - Oracle DataBase SubsetsCreate 
small training and development databases the easy way. http://www.databee.com

RE: slightly OT: visual c++ and null values

[Mercadante, Thomas F]

"I forget the values for the indicator variables, but that is in the PRO*C
manual."


I think the values are 0 & 1 (false & true).  At least they are in Cobol.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, October 19, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L


Maria:

The developers need to read the PRO*C manual. What the developers need to do
is to use indicator variable. These are varaiables that indicate whether the
variable is NULL (or if the value was truncated when selected into).

Here is a short example.
char   v_first_name[18];
short v_first_name_ind;

SELECT first_name
INTO   v_first_name:v_first_name_ind
FROM  emp
WHERE emplid = :v_emplid:v_emplid_ind;

I forget the values for the indicator variables, but that is in the PRO*C
manual.

HTH
Kevin

-Original Message-
Sent: Friday, October 19, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L


hello!

our developers here are requesting that I put defaults (' ' for
chars/varchars, 0 for numbers, etc) in place instead of nulls in all
columns that would supposedly allow null values...
they are using visual c++ and they say that they cannot make visual c++
retreive null values...
i am very hesitant in implementing this...
i have no knowledge whatsoever of visual c++ and don't know if this is
true...

i'd like to know if anyone had encountered this same problem before?
or maybe someone can tell me if there is any truth to what our
developers are saying...


oracle817 on solaris7

thanks =)

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: Oracle 7 documentation

[Deshpande, Kirti]

It is hiding at http://technet.oracle.com/doc/server734.htm

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 3:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Oracle 7 documentation
> 
> > -Original Message- 
> > From: Scott Shafer [ ] 
> > 
> > Does anyone know if technet is still hiding v7 docs somewhere? 
> 
> As far as I can tell, technet removed all Oracle 7 documentation a few
> weeks ago. You can find the Oracle 7.3 documentation on Metalink.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: slightly OT: visual c++ and null values

[Shari Dishop]

Maria,
  They need to use indicator variables.  This is documented in the Pro*C 
documentation.  The application that I wrote is two years old but is still 
operational against a 8.1.x database.  I tried to find a small snippet of code 
to include but since I haven't worked on the application in about two years 
couldn't find anything quickly.  

The gist of it is though that you define short integer variables in addition to 
your variable to hold your column value.  The column is then referenced in the 
select/update statement as a concatenation of the two variables.  
:column_name:indicatorthen if the indicator is <0 the column variable has 
undefined value (NULL).  For inserts/updates the user sets the indicator to -1 
and Pro*C interpretes the value as a NULL.

I admit that my version of Visual C++ is old 5.0 and my version of Pro*C is 
8.0.5 but this does work against a 8.1.x database (on Compaq) but I haven't seen 
anything to indicate that they were getting away from indicator variables.

Shari Dishop
SAP ABAP Development - Project Systems Team
Northrop Grumman Information Technology
Baltimore, MD



>hello!
>
>our developers here are requesting that I put defaults (' ' for
>chars/varchars, 0 for numbers, etc) in place instead of nulls in all
>columns that would supposedly allow null values...
>they are using visual c++ and they say that they cannot make visual c++
>retreive null values...
>i am very hesitant in implementing this...
>i have no knowledge whatsoever of visual c++ and don't know if this is
>true...
>
>i'd like to know if anyone had encountered this same problem before?
>or maybe someone can tell me if there is any truth to what our
>developers are saying...
>
>
>oracle817 on solaris7
>
>thanks =)
>
>--
>Maria Aurora VT de la Vega (OCP)
>Database Specialist
>Philippine Stock Exchange, Inc.

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

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

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

Design question DW

[adba]

Hello List,

 I have a design question for a datawarehouse
application.  I have done OLTP design, but no DW
design before.  The issue is that this warehouse is
being fed from an existing system that allows
multi-values.  What I mean by multi-values is a
column that has comma delimited values in it.  So for
example, if there is a car table with a column that
says tire_size, if the car can handle tire sizes of
p200, p240, and p250 then for a select on the one row
with that car in it, under the tire column you would
have p200,p240,p250.  
I would never even think about letting this thru in
an OLTP system, and if I didn't have access to the
list I wouldn't allow it in a data warehouse either. 
But, since I have the advantage of your expertise, I
thought I might as well use it.  There are about 40
of these columns in 5 tables in the proposed design
by the developer.  The developer is trying to say
that they won't use these columns in the where
clauses on most of them and that they are just
detailed data for display.  I have been around long
enough to know how fast that changes, and all of a
sudden the database is a dog and everyone is blaming
the DBA.  
 So my question is, am I just an OLTP DBA in new
territory, or the same principles apply, and
multi-values are still one of the biggest relational
design disasters regardless of OLTP or DW.

Any help is appreciated,
Mike


You too can have your own email address from Eurosport.
http://www.eurosport.com





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

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

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

RE: Extrange behavior

[Ramon Estevez]

Title: RE: Extrange behavior



The 
application has more than 1 year working properly, this happen 
when
I migrated 
from 8.0.5 to 8.1.7.0.0 a month ago, repeat, the users can 
insert
data, make 
reports, etc, but cant make update of the data.
 
This is 
another IOT table.
In this one 
I can make an update, this is the detail table of the previous one, 
ACT
 
 
SQL> 
EDWrote file afiedt.buf
 
  
1  select tablespace_name, IOT_NAME, iot_type  2  from 
user_tables  3  where  4* table_name = 
'DAT_ACTS'SQL> /
 
TABLESPACE_NAME    
IOT_NAME    
IOT_TYPE-- -- 
   
  IOT
This is the 
error thru the forms, it is a master/detail form and I am 
trying
to modify a 
field on the master record
 
ORA-02292: integrity constraint 
(RAMON.DAT_ACT_ACTIVOS_FK) violated - child record found
 

In SqlPlus 
the session hangs.
 
 
And I dont 
see any errors in the trace file.
 
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121

  -Mensaje original-De: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]En nombre de Amar Kumar PadhiEnviado 
  el: Thursday, 18 October, 2001 11:46 AMPara: Multiple 
  recipients of list ORACLE-LAsunto: RE: Extrange 
  behavior
  Check if any policy is defined against the table. 
  rgds amar 
  -Original Message- From: Ramon 
  Estevez [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, October 18, 2001 8:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Extrange behavior 
  Hi Rachel, 
  This is the user owner of the object and has DBA 
  privilege. 
  I made the select and this is the result 
  OWNER  
  OBJECT_NAME    
  OBJECT_TYPE -- 
  -- --  PUBLIC 
  ACT    
  SYNONYM RAMON  
  ACT    
  TABLE 
  SQL> ED Wrote file 
  afiedt.buf 
    1  select Segment_name, tablespace_name from 
  dba_segments   2* where segment_name 
  ='ACTS' SQL> / 
  no rows selected 
  The users can see data, make reports of it, but cant update 
  it.  I am logged as the user owner of the table 
  and either can't make the update, the session hangs. 
  Is an IOT table. 
  Thanks, 
  Ramon E. Estevez [EMAIL PROTECTED]  
  809-565-3121 
  -Mensaje original- De: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de 
  Rachel Carmichael Enviado el: 
  Thursday, 18 October, 2001 10:22 AM Para: Multiple 
  recipients of list ORACLE-L Asunto: RE: Extrange 
  behavior 
  Log in as SYSTEM (or any other DBA account you have) 
  
  and do 
  select owner, object_name, object_type from dba_objects 
  where object_name = 'ACTS'; 
  it's possible that the user you log into is looking at a 
  synonym, and has not been granted update by the true 
  owner. 
  Also, under a DBA account, you should be able to tell what 
  tablespace it's in. 
  select segment_owner, segment_name, tablespace_name from 
  dba_segments where segment_name ='ACTS'; 
  --- Ramon Estevez <[EMAIL PROTECTED]> 
  wrote: > Hi List, > > I have a strange problem, I have a 
  table and I can see the data of > it, but 
  > can't update the records of it. > > In forms it gives me an error and in 
  SQL plus the process hang, the > table is 
  > IOT, and either can't see in what tablespace the table 
  is. > > SQL> SELECT 
  COUNT(*) FROM ACTS; > >  COUNT(*) > - 
  >  3320 > > SELECT IOT_TYPE, IOT_NAME, 
  TABLESPACE_NAME > FROM USER_TABLES > WHERE > TABLE_NAME = 'ACTS' 
  > > > SQL> / > > IOT_TYPE 
  IOT_NAME   
  TABLESPACE_NAME >  
  -- > 
  -- > IOT 
  > > > *-* It hangs > UPDATE ACTS 
  >   SET SERIE = SERIE||'---' > WHERE >   GR = 01 AND 
  >   CO = 01 AND >   CAT = 10 AND >   
  LOC = 01 AND >   ACT= 01 > *-* It hangs > > > select index_name, INDEX_TYPE, 
  TABLESPACE_NAME from user_indexes > where 
  > table_name = 'ACTS' > 
  > 
  INDEX_NAME 
  INDEX_TYPE  
  TABLESPACE_NAME > - 
  --- > 
   > 
  ACTS_PK  
  IOT - 
  TOP   
  CONT > > 
  > I can see all the records, insert records, but cant 
  update. > > Scenario 
  8.1.7 Windows 2000 > > 
  Any suggestions will be apreciated > 
  > Thanks > > Ramon E. Estevez > 
  [EMAIL PROTECTED] > Dominican 
  Republic > 809-565-3121 > > > 
  
  __ 
  Do You Yahoo!? Make a great 
  connection at Yahoo! Personals. http://personals.yahoo.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- Author: Rachel Carmichael 
    INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858)