Stephane,
I don't understand what you mean when you say you can
select on t1 before any commit.
I just tried this on an 8.1.7 database, and there was
a signicant reduction in redo. There was only 668
bytes of redo generated vs. 2320 (see below). I think
some redo will still be generated as you allocate
extents (my tablespace is dictionary managed).
Rob Pegram
Oracle Certified DBA
SQL create table t as select * from dba_users;
Table created.
SQL alter table t nologging;
Table altered.
SQL delete from t;
15 rows deleted.
SQL commit;
Commit complete.
SQL select value
from v$mystat, v$statname
where v$mystat.statistic# = v$statname.statistic#
and v$statname.name = 'redo size'
VALUE
--
117720
SQL insert /*+ append */ into t as select * from
dba_users;
insert /*+ append */ into t as select * from dba_users
*
ERROR at line 1:
ORA-00926: missing VALUES keyword
SQL insert /*+ append */ into t select * from
dba_users;
15 rows created.
SQL commit;
Commit complete.
SQL select value
from v$mystat, v$statname
where v$mystat.statistic# = v$statname.statistic#
and v$statname.name = 'redo size'
VALUE
--
118388
SQL delete from t;
15 rows deleted.
SQL
SQL commit;
Commit complete.
SQL select value
from v$mystat, v$statname
where v$mystat.statistic# = v$statname.statistic#
and v$statname.name = 'redo size'
VALUE
--
123856
SQL insert into t select * from dba_users;
15 rows created.
SQL commit;
Commit complete.
SQL select value
from v$mystat, v$statname
where v$mystat.statistic# = v$statname.statistic#
and v$statname.name = 'redo size'
VALUE
--
126176
--- paquette stephane [EMAIL PROTECTED]
wrote:
Hi,
I'm trying the following insert /*+ append */ into
t1
as select * from t2;
t1 is created with nologging attribute.
The insert is not using the hint at all.
I can select on t1 (before any commit) which I
should
not be able to do if the append hint was used.
Any ways to get the hing used ?
(Oracle 817/NT)
TIA
=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et
en français !
Yahoo! Mail : http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
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!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Pegram
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).