Hi Mans,
Thanks again for the response.
My concern is again performance. All of my locally managed tablespaces are created with auto option. I am trying to see if there are possible advantages of switching to manual. I am looking for documentation on cons and pros of both options
Thanks,
Milana
-----Original Message-----
From: Mans Axell [mailto:oracledba-ezmlmshield-x24884875.[Email address protected]
Sent: Saturday, February 24, 2007 6:56 AM
To: LazyDBA Discussion
Subject: RE: locally managed tablespaces
Hi Milana ... me again :-)
Do you refer to segment space management?
If yes, when using segment spage management auto you don't need to tune
pctfree and freelists which you might need when set to manual. You can see
this if the ITL waits are high or you suffer from very high cache_buffer_chains event.
Regards
Mċns Axell
Consultant
Infrastructure Managed Services
Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg (Zürich)
Phone +41-44-808 70 20
Fax +41-44-808 70 21
Mobile +41-79-457 97 85
mans.[Email address protected]
www.trivadis.com <http://www.trivadis.com/>
________________________________
From: Krupetsky Milana [mailto:oracledba-ezmlmshield-x33667209.[Email address protected]
Sent: Fri 2/23/2007 21:46
To: LazyDBA Discussion
Subject: locally managed tablespaces
DBAs,
Does any one have a reference to documentation that compares cases where
auto is preferred over manual(or another way around) in locally managed
tablespaces for 10G?
Thanks,
Mila
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page