Re: Database down

2001-12-11 Thread Jeff Wiegard

Well, I think the issue is two-fold.

1. They have been tinkering with user sessions, and the trace file
output below is discussed on Steve Adams' website.

PMON unable to acquire latch 80002060
modify parameter values
possible holder pid = 58 ospid=29937
2001.12.09.15.27.43.000

I'm reviewing the settings in /etc/system. It is my belief that
the additional application server pushed Oracle over some threshhold
set in /etc/system.
We are not running multi-threaded server, and we now have three
application servers.

2. The issue with the patch has to do with my inability to restart
the damn server due to an 'ORA-27123: unable to attach to shared
memory segment'. I've   asked our UNIX admin to verify we have the
following patch:
  PATCH 105181-07 

 We are running 8.0.6 on Solaris 2.6. There are some issues
with the sgadef.dbf file upon shutdown. This is only supposed to
occur on a shutdown abort, but I've seen it occur on a shutdown
immediate. I do not know if this patch specifically addresses the
lingering sgadef.dbf file.

Jeff


 [EMAIL PROTECTED] 12/11/01 12:10AM 
Jeff,

I had a similar situation last week. I would like to know what
patch are
talking about and what's your version of Oracle?

Regards,
Ed




 I discovered the trace file after restarting Oracle - so that
 process ID is no longer out there. I've also discovered that
there
 is a specific patch for this problem, which appears not to have
been
 applied. I will move forward with this, but would like to
provide
 management with an explanation as to why we had problems now,
after
 so many days of uptime.

 Thanks for your help.

 Jeff

  [EMAIL PROTECTED] 12/10/01 03:35PM 
 I don't suppose you've run ps -ef | grep 29937 yet, just
 out of curiousity, have you?

 -Original Message-

 Just to follow up. I have the database backup. I am afraid
 however,
 that the problem is still floating around.

 Briefly, here is what occured:

 I restarted Oracle because our application was unable to
connect.
 I
 could connect through svrmgrl, but a 'select sysdate from dual'
 just
 hung. So I brought the database down, and recieved the memory
 segment error.

 So we were having problems while the database was up. Here is a
 trace file dump that may be linked to the problem:

   PMON unable to acquire latch 80002060 modify parameter values
 possible holder pid = 58 ospid=29937
   *** 2001.12.09.15.27.43.000


 We added a third application server last week. Could that
somehow
 be the source of these problems? This application has been
running
 problem free for over 100 days.

 Thanks for your input

 Jeff







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

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


 To REMOVE yourself from this mailing list, send an E-Mail
message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Wiegard
  INET: [EMAIL PROTECTED]

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

Database down

2001-12-10 Thread Jeff Wiegard

 ORA-27123: unable to attach to shared memory segment
SVR4 Error: 12: Not enough space

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 down

2001-12-10 Thread Jeff Wiegard

Just to follow up. I have the database backup. I am afraid however,
that the problem is still floating around. 

Briefly, here is what occured:

I restarted Oracle because our application was unable to connect. I
could connect through svrmgrl, but a 'select sysdate from dual' just
hung. So I brought the database down, and recieved the memory
segment error. 

So we were having problems while the database was up. Here is a
trace file dump that may be linked to the problem:

  PMON unable to acquire latch 80002060 modify parameter values
possible holder pid = 58 ospid=29937
  *** 2001.12.09.15.27.43.000


We added a third application server last week. Could that somehow
be the source of these problems? This application has been running
problem free for over 100 days.

Thanks for your input

Jeff


 [EMAIL PROTECTED] 12/10/01 02:27PM 
Hi Jeff,

1. the previous killed instance that still holds a shared memory
segment ?
2. unappropriatedly large parameters of shared_pool and/or
db_block_buffers ?

Regards,
Ed

 ORA-27123: unable to attach to shared memory segment
 SVR4 Error: 12: Not enough space
 
 Any ideas?


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 down

2001-12-10 Thread Jeff Wiegard

I discovered the trace file after restarting Oracle - so that
process ID is no longer out there. I've also discovered that there
is a specific patch for this problem, which appears not to have been
applied. I will move forward with this, but would like to provide
management with an explanation as to why we had problems now, after
so many days of uptime.

Thanks for your help.

Jeff

 [EMAIL PROTECTED] 12/10/01 03:35PM 
I don't suppose you've run ps -ef | grep 29937 yet, just
out of curiousity, have you?

-Original Message-

Just to follow up. I have the database backup. I am afraid
however,
that the problem is still floating around. 

Briefly, here is what occured:

I restarted Oracle because our application was unable to connect.
I
could connect through svrmgrl, but a 'select sysdate from dual'
just
hung. So I brought the database down, and recieved the memory
segment error. 

So we were having problems while the database was up. Here is a
trace file dump that may be linked to the problem:

  PMON unable to acquire latch 80002060 modify parameter values
possible holder pid = 58 ospid=29937
  *** 2001.12.09.15.27.43.000


We added a third application server last week. Could that somehow
be the source of these problems? This application has been running
problem free for over 100 days.

Thanks for your input

Jeff







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

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

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



Snapshot Problems

2001-11-29 Thread Jeff Wiegard

Good Day.

I have a problem with recreating some snapshots. I would like to
add to the current set of snapshots. They were created in the
following manner:

create snapshot snap_test as select * from test@test_DB;

They are executed nightly in the following manner:

execute DBMS_SNAPSHOT.REFRESH('SCOTT.TEST','?');


However, when I try and create them, I get an ORA-01406 error, due
to truncation of the varchar2(4000) . According to Oracle, this is a
bug. Does someone know of a work-around?  

Jeff

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Altering Indexes

2001-11-27 Thread Jeff Wiegard

Ken,

Try executing the following:

select 'I am rebuilding my index '||index_name||' and putting it in
another tablespace;'
from user_indexes
/

and of course, spool the sucker, set heading off, set pagesize.

Merry Spooling and Happy Selecting 

 [EMAIL PROTECTED] 11/27/01 08:25AM 
I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design).  Is there a way I can move all
of the
indexes to a separate tablespace en-mass?  I know I can move them
one at a
time with the alter index command, but that would be rather time
consuming.

Thanks,
Ken 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Wiegard
  INET: [EMAIL PROTECTED]

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

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



Solaris - db_file_multiblock_read_count

2001-11-19 Thread Jeff Wiegard

Hi.

I was hoping for some confirmation here.

I'm running 8.0.5 on Solaris 2.7, with block size set to 8192.
There is no 'maxphys' parameter in /etc/system.

After some testing, I've decided to set the
db_file_multiblock_read_count = 24, based on the following:

1.   SQL alter session set db_file_multiblock_read_count = 1000;

2.   select value from v$parameter where name =
'db_file_multiblock_read_count';

  This gave me a value = 128

3.   alter session set events '10046 trace name context forever,
level 8';

4.   select /*+ FULL(t) */ count(*) from sys.source$ t;

The trace file gave me the following:

WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=660 p3=25
WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1167 p3=25
WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1207 p3=25
WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1272 p3=25
WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1312 p3=25

So then setting db_file_multiblock_read_count to 24 would be about
right ... right?

Thanks,

Jeff


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: W2000 Unix Command Equivalent

2001-11-13 Thread Jeff Wiegard

Install Cygwin, and you have access to a full set of UNIX commands -
even a BASH environment. If you add the Cygwin/bin directory to your
path, you can sit at the DOS prompt, and run most UNIX commands. You
can also execute Windows commands from the BASH shell. I have Oracle
8i and 9i running on W2K, and I've modified some backup scripts to
utilize the UNIX commands. You even get the 'man' pages.

Jeff

 [EMAIL PROTECTED] 11/12/01 03:10PM 
Does anyone know where I can find a list of the W2000 equivalent
commands
for Unix.  Such as show, set, etc.

Thanks,
Ken 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Wiegard
  INET: [EMAIL PROTECTED]

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

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



Oracle Label Security

2001-11-02 Thread Jeff Wiegard

Hi. I've been asked to look into this component for 8i, and I wasn't
aware this even existed. Couldn't you just create views, or am I
being naive?

Thanks,

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

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

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



Oracle Data Guard

2001-11-01 Thread Jeff Wiegard

Hi. I'm looking into implementing a read-only stand-by database. I'd
like to have it read-only for periodic reporting during the day. Is
this possible under 8.1.7, or 9i? 

Are there any drawbacks to having the stand-by database opened for
read-only? I would have two goals in mind: 1. A stand-by, read-only
reporting db. 2. Easy switch-over to the stand-by. Are these two
goals compatible? I can't find any documention on Data Guard for
8.1.7, as the links on Technet are broken.

Thanks

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

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

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



Messy Messy SQL

2001-10-31 Thread Jeff Wiegard

I've been asked to review some troublesome SQL queries, and since I
don't know what to do with this one, I thought I'd see what you all
can come up with.

They are doing the following:

select A.value 1, C.value2, A.value3
from  Table A, Table B, Table C
where  A.id = B.id
and B.id = C.id
and (A.ZIPS like ('%54016%') 
or A.ZIPS like ( '%54021%') 
or A.ZIPS like ( '%54351%') 
or A.ZIPS like ( '%54025%') 
or A.ZIPS like ( '%54246%') 
or A.ZIPS like ( '%54071%') 
or A.ZIPS like ( '%54023%') 
or A.ZIPS like ( '%54029%') 
or A.ZIPS like ( '%54078%') 
or A.ZIPS like ( '%54651%') 
or A.ZIPS like ( '%54901%') 
or A.ZIPS like ( '%55514%'))

The only problem is that the actual data in the ZIPS field could be
in the format of one of the following 3 samples:

55306:50

55358:100 56601:100

56301:25 56304:25 56379:25

The joins are on 400,000 row tables, and it's doing a full table
scan on all three tables because of the first % wildcard in the like
clause. It would be easy to get the values if they were all like the
first format, because I could use 'substr(A.zips,1,5) = '55514'',
but I don't know what to do with the second two samples, where there
is more than one zipcode in the field.

I would like to be able to find the ':' character and subtract 5 to
get the zipcode, but there could be 3 ':' characters corresponding
to 3 zips in one field. Any ideas? 

Thanks,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Messy Messy SQL

2001-10-31 Thread Jeff Wiegard

Thanks - I was thinking about breaking it out as well, but thought
there might be some trick out there from SQL For Smarties or
something.

 [EMAIL PROTECTED] 10/31/01 11:37AM 
Jeff,

That's a pretty silly way to store zip codes. Could you create a
zipcode-id table, where you break out each zip and its id? Then
search that table and join back to table a?

Or, if you're at 8i, and if you only get up to a really small
number
(like the 3 you display) of zips in a combined zip field, you
could
create the first index on the zip field, and two additional
function-
based indexes on the second and third zip codes. Then instead of
using like '%9%', you could use the function with which you
created the index, like where substr(instr(zip_field, ' ')+1) like
'9%'.

Some thoughts, hope they help.

God bless America.

Yosi


Jeff Wiegard wrote:

 I've been asked to review some troublesome SQL queries, and since
I
 don't know what to do with this one, I thought I'd see what you
all
 can come up with.

 They are doing the following:

 select A.value 1, C.value2, A.value3
 from  Table A, Table B, Table C
 where  A.id = B.id
 and B.id = C.id
 and (A.ZIPS like ('%54016%')
 or A.ZIPS like ( '%54021%')
 or A.ZIPS like ( '%54351%')
 or A.ZIPS like ( '%54025%')
 or A.ZIPS like ( '%54246%')
 or A.ZIPS like ( '%54071%')
 or A.ZIPS like ( '%54023%')
 or A.ZIPS like ( '%54029%')
 or A.ZIPS like ( '%54078%')
 or A.ZIPS like ( '%54651%')
 or A.ZIPS like ( '%54901%')
 or A.ZIPS like ( '%55514%'))

 The only problem is that the actual data in the ZIPS field could
be
 in the format of one of the following 3 samples:

 55306:50

 55358:100 56601:100

 56301:25 56304:25 56379:25

 The joins are on 400,000 row tables, and it's doing a full table
 scan on all three tables because of the first % wildcard in the
like
 clause. It would be easy to get the values if they were all like
the
 first format, because I could use 'substr(A.zips,1,5) =
'55514'',
 but I don't know what to do with the second two samples, where
there
 is more than one zipcode in the field.

 I would like to be able to find the ':' character and subtract 5
to
 get the zipcode, but there could be 3 ':' characters
corresponding
 to 3 zips in one field. Any ideas?

 Thanks,

 Jeff

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

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

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



Consistent Gets

2001-10-30 Thread Jeff Wiegard

Hi. What exactly does Consistent Gets mean?

Thanks

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Java in the database

2001-10-25 Thread Jeff Wiegard

Yes, I'd be interested to hear about peoples experience too. We developed a web portal 
for WWWRRR Inc. It was a Servlet framework. We found more success avoiding Oracle's 
Java technologies, as you're stuck with outdated Java classes, and/or Oracle-specific 
Java classes. Try getting the OCI drivers to work. It is an effort of a scale similar 
to the hunt for Osama ...

 [EMAIL PROTECTED] 10/25/01 12:16PM 
Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Jeff Wiegard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Reallocate Table Storage

2001-10-04 Thread Jeff Wiegard

Thanks. Leaves are at their peak, but it's about to get COLD! Temp
in the upper 20's when we wake up Saturday morning.

 Koivu, Lisa [EMAIL PROTECTED] 10/04/01 02:00PM 
Hi Jeff, 

Well if you have the time, export/import and reset your storage
parms either
in the dump file or with LMT's

Or you can alter table move ... set new storage 

Or you could create table as as select new table name, drop
initial table
and rename new table.  These are just a few options.

How's beautiful Minnesota?  I read that the leaves peaked last
week.  

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


 -Original Message-
 From: Jeff Wiegard [SMTP:[EMAIL PROTECTED]]

 Sent: Thursday, October 04, 2001 2:55 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Reallocate Table Storage
 
 good day ...
 
 I'm looking at a production, test, development environment tight
on
 space. I've noticed there are a slew of tables that aren't used
at
 all, or are improperly sized. In fact, I could recapture perhaps
20
 percent of the used space, which measures in the gigabyte
range. I
 have an idea of how I want to do this, but thought I'd post for
how
 others have accomplished this.
 
 thanks,
 
 Jeff
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Jeff Wiegard
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
 San Diego, California-- Public Internet access / Mailing
Lists


 To REMOVE yourself from this mailing list, send an E-Mail
message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Jeff Wiegard
  INET: [EMAIL PROTECTED]

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

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