In Oracle9i the sort_area_size is an old parameter which has been
superseded by pga_agregate_target which sizes a large PGA buffer area.
Likewise db_block_buffers has been superseded by db_cache_size.
I suggest that you set the db_cache_size high ( >640M) and the
pga_aggregate_target to a similar value.
Also set undo_retention time greater than the 15 mins (900seconds) to
ensure that you have a large undo segment area for processing the data.
Lloyd
-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x42125668.[Email address protected]
Sent: 06 July 2005 16:06
To: LazyDBA Discussion
Subject: RE: Replication of a large table
CTAS when expanded means CREATE TABLE newtablename AS select * from
oldtablename. You could control the storage parameters in the new table
if you want or let oracle use the defaults and you could also control
what you want get from the old table by appending a where clause after
the oldtablename. I will definitely suggest you using larger initial and
next extents because you are going to move millions of rows and that you
leave the maxextents to unlimited initially.
Another important thing I want to suggest you is that you alter your
session for bumping up the sort_area_size parameter to something like 10
MB. This will help you move data even faster.
Gurmohan
www.freemath.info
-----Original Message-----
From: Qi cheng [mailto:[Email address protected]
Sent: Wednesday, July 06, 2005 10:56 AM
To: Shergill, Gurmohan
Subject: Re: Replication of a large table
Thanks,
Have not idea what CTAS is, Can you give any link?
Qi
On 7/6/2005 10:50 AM, Shergill Gurmohan <[Email address protected]
wrote:
>**A LazyDBA.com subscriber has responded to your lazydba.com post**
>**LazyDBA.com mail shield has forwarded you this email,
>**and removed any attachments, and kept your email address secret
>**from this person, and any viruses/trojans.
>**If you reply to this email, the person will see your email address
>as normal
>**Anything below this line is the original email text
>
>
>If you are attempting to recreate the table elsewhere then try using
>CTAS. This could be the fastest way of replicating. If your definition
>of replicating is something like as we use in materialized views
>then please disregard my suggestion.
>
>Gurmohan
>www.freemath.info
>
>
>
>-----Original Message-----
>From: Qi cheng
>[Email address protected]
>Sent: Wednesday, July 06, 2005 10:13 AM
>To: LazyDBA Discussion
>Subject: Replication of a large table
>
>
>Any one has the nice way to replicate over 60M rows of table to report
>database ? export and import is too time consuming, plus rebuild
>index will take for ever. Any one using material view against big
>table?
>Thanks.
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page