RE: Was 8.1.6 certified on Solaris 8?

ttp://www.orafaq.net -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself fr

RE: #of blocks in extent

OTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Was 8.1.6 certified on Solaris 8?

s that 8.1.6 is desupported and therefore doesn't list any certified OS versions for it. Did anyone run 8.1.6 on Solaris 8 or remember if it was ever certified? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat C

RE: Hotsos Clinic

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: ALTER TABLE MOVE command causes table to grow

ther change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: New course for 9i - Dumps/Crashes from Oracle University

c. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ

RE: Backup DB files to the Tape

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

Installing Pro*C for 9.2?

turned up tons of irrelevant references. I'm sure the answer is there somewhere... Thanks! Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com S

RE: ORA-1653: unable to extend table - Resolved?

pdate each row with something like (update set column-1=column-1) Good luck! Barb "Miller, Jay" <[EMAIL PROTECTED]> wrote: But will this solve my problem in the near term? My understanding is that simply changing the PCT USED won't move the problematic blocks o

RE: ORA-1653: unable to extend table - Why?

this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in the new datafile). > > > > Why isn't it making use of the exist

RE: ORA-1653: unable to extend table - Why?

o: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 offi

RE: ORA-1653: unable to extend table - Why?

e message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EM

RE: ORA-1653: unable to extend table - Why?

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 O

RE: ORA-1653: unable to extend table - Why?

lso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: ORA-1653: unable to extend table - Why?

t; > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile

RE: ORA-1653: unable to extend table - Why?

3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in the new datafile). >

RE: ORA-1653: unable to extend table - Why?

ng > > 30,000. > > > > After reanalyzing the table I saw the following stats in > DBA_TABLES: > > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > f

RE: ORA-1653: unable to extend table - Why?

> > > > > > > Okay, I can't figure this one out. Earlier this week I got an > > > ORA-1653: > > > unable to extend table on a really big table. However this was > > just >

RE: ORA-1653: unable to extend table - Why?

all since he just >>>>deleted >>>>2 million rows so there are plenty of space within the segment >>>>itself. >>>>Those free blocks should be used, unless he is doing a direct path >>>>insert >>>>which will only use space abo

RE: ORA-1653: unable to extend table - Why?

ce_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in the

RE: ORA-1653: unable to extend table - Why?

pace_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of s

RE: ORA-1653: unable to extend table - Why?

ce_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in

RE: ORA-1653: unable to extend table - Why?

pace_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of s

RE: ORA-1653: unable to extend table - Why?

following stats in > DBA_TABLES: > > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and g

RE: ORA-1653: unable to extend table - Why?

ES: > > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so

RE: ORA-1653: unable to extend table - Why?

? If so the insert inserts after the highwater mark. The highwater mark is not reinitialized after deletes. So maybe that's why the insert failed. --- "Miller, Jay" <[EMAIL PROTECTED]> a écrit : > Okay, I can't figure this one out. Earlier this > week I got

RE: ORA-1653: unable to extend table - Why?

Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

ORA-1653: unable to extend table - Why?

y isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Do user processes apply against shmmax limit?

ft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: Miller, Jay [mailto:[EMAIL P

Do user processes apply against shmmax limit?

minfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Data specs of columns

'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: M

10046 Level 8 Trace file disappeared

s to what might have happened to my file? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: System Tablespace and Autoextend

, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat Cit

RE: Destination address unreachable

e and stupidity all in the same package. How efficient of you.   -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web ho

RE: Data Purging Strategy

TECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

e to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 OR

RE: Can any one tell me how can i read parameter info from RDF(Re

Can any one tell me how can i read parameter info from RDF(Reports definition file) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Calif

RE: Data Purging Strategy

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

RE: System Tablespace and Autoextend

ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMO

CLOB inserts

0 0.4 db file parallel write170 0 0 0 0.3 control file parallel write 161 0 0 0 0.3 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat

RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB

containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL

RE: LOCALLY MANAGED TABLESPACE

experience what gain after changing to locally managed tablespace? Thx -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cal

RE: Defragmentation of tablespace

ved 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Ca

RE: Database design, replacing null by a default value

XACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.ora

RE: Help in Training on DBA

d in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INE

Auditing grant and revoke privileges

t restarted the database since changing the init.ora parameter (untrue). Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Data guard

nformation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: Adhoc queries and limiting the amount of records queried...

erver, so SQL Server ideas would also be appreciated. Many thanks!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE:

re specifically multiple tables from a user in 1 go. I need to delete 50+ tables/objects without deleting them 1 by 1. Thanks Clint -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Creating new user

ru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller

RE:

icial ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To R

RE: admin_restrictions_listener

vious job. He copied the listener.ora file to another server, then ran 'lsnrctl stop' before modifying the file for the new server. Guess what happened? Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/17/2002 11:29 AM Please respond to ORACLE-L

RE: admin_restrictions_listener

: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Advice needed on move to Sun 15K (losing spindles)

ru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, J

RE: Advice needed on move to Sun 15K (losing spindles)

ems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning t

RE: Advice needed on move to Sun 15K (losing spindles)

to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L

RE: Advice needed on move to Sun 15K (losing spindles)

ases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionali

RE: Advice needed on move to Sun 15K (losing spindles)

thing else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM

RE: Advice needed on move to Sun 15K (losing spindles)

lity to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L

Advice needed on move to Sun 15K (losing spindles)

ne can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

RE: help!! smon

ke subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web ho

A really stupid question

How can I access the Oracle-L archives? There's something I remember reading a few months ago that I want to look up. Embarassedly yours, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Ser

RE: Backups

rom this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send th

RE: DBA work load

UB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-5

RE: 8.1.6 to 8.1.7 upgrade

E-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yoursel

RE: DBA work load

Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED]

RE: ALTER TABLE DROP COLUMNS CONTINUE - how far has it gotten

> COLUMNS CONTINUE > > Is there any way to determine how far it has gotten? There is no entry in > V$SESSION_LONGOPS. > > Thanks. > > Jay Miller > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAI

ALTER TABLE DROP COLUMNS CONTINUE - how far has it gotten

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Backup Strategy - Informal Survey

e 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Consulting Position Available-Oracle DBA/Developer/NYC

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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: Recreating database from hot backup but only 1 tablespace - U

ions are welcome. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: ALTER TABLE MOVE command causes table to grow

f 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: ALTER TABLE MOVE command causes table to grow

afaq.com <http://www.orafaq.com> -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Recreating database from hot backup but only 1 tablespace - U

I'm still searching the Velpuri book. Any other suggestions are welcome. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San D

Recreating database from hot backup but only 1 tablespace - Urgen

E-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE y

RE: ALTER TABLE MOVE command causes table to grow

LE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

RE: ALTER TABLE MOVE command causes table to grow

change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Jay INET: [EMAIL P

RE: ALTER TABLE MOVE command causes table to grow

ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> < http://www.orafaq.com <http://www.orafaq.com> > -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: ALTER TABLE MOVE command causes table to grow

r change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: ALTER TABLE MOVE command causes table to grow

ce and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Miller, Ja

RE: PCTUSED - when is block added to freelist?

t the head of the chain. Rick "Miller, Jay" house.com> cc: Sent by:

ALTER TABLE MOVE command causes table to grow

meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: automatic segment space management

a line containing: UNSUB ORACLE-L (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

RE: PCTUSED - when is block added to freelist?

"what action or actions trigger Oracle to put a block back on the freelist after changing PCTUSED to a higher value?" Is that correct Jay? Jared On Tuesday 03 September 2002 15:38, Miller, Jay wrote: > I have one huge table (takes up about 30% of the total database storage) > which has

PCTUSED - when is block added to freelist?

to a block. Anyway, why would a lower PCTUSED reduce processing costs during a DELETE but a higher PCTUSED wouldn't increase processing costs during a DELETE. That makes no sense. I'm befuddled. TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4

oved 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: ONLINE index creation in 8.1.7.2

in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAI

RE: OEM changes

) and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET

RE: Recompiling blocked package - locating blocking session

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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (85

RE: Bind Variables in VB

'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- Auth

RE: How to notify the password expiration in oracle using email?

other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RE: Had to get this off my chest

include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat

RE: How to notify the password expiration in oracle using email?

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Rant-Rant

, I'd make a good nun (Robert, did you see my test results?) --- "Miller, Jay" <[EMAIL PROTECTED]> wrote: > FYI: SJs make up about 40% of the population (app. 10% for each > sub-division). > > Jay Miller > infp (yeah, I know, what's an infp doing in a

Had to get this off my chest

ny please. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Rant-Rant

Message- Sent: Monday, July 22, 2002 5:25 PM To: Multiple recipients of list ORACLE-L How about an ENTJ as a DBA and System Admin... I'm loads of fun with a bunch of touchy feely type SP's here at the college I work for ;-) Joe On Mon, 22 Jul 2002, Miller, Jay wrote: > FYI: S

Recompiling blocked package - locating blocking session

that will save the random searching next time? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: Rant-Rant

http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: STATSPACK space requirement feature on 8i (FYI)

or other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

RE: How to change VB code to use bind variables?

itten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask

  1   2   3   >