| Redo geneated high in temp table [message #612545] |
Mon, 21 April 2014 13:00  |
 |
sachin99
Messages: 7
Registered: December 2012
|
Junior Member |
|
|
Hi,
As we know that, GTT is generated more redo logs at some scenario but i need some information about temp table and indexes.
Step 1:
temp table is created with no logging option but its index is created with logging option.
select TABLE_NAME,LOGGING
from dba_tables
where temporary ='Y'
AND table_name like '%GTT_REDO_LOG%';
GTT_REDO_LOG NO
Step 2:
select index_name,logging
from dba_indexes
where table_name in (select TABLE_NAME
from dba_tables
where temporary ='Y'
AND table_name like '%GTT_REDO_LOG%');
GTT_REDO_LOGIDX1 YES
Does it leads problem for redo log size.
How to alter GTT table index for nologging option. i tried and i got unimplement future error.
Is any other way to reduce redo log size in Oracle 11g Exadata?
|
|
|
|
|
|
| Re: Redo geneated high in temp table [message #612547 is a reply to message #612545] |
Mon, 21 April 2014 13:09  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Redo is never generated for global temporary tables or their indexes, but undo is geneated. The redo you see is protecting the changes to the undo segments. When you upgrade to release 12.x, you can enable temporary undo segments and then there will be no redo generated at all.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
