- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: A question for DBAs: What's your opinion
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 09:44 PM
тАО11-02-2003 09:44 PM
A question for DBAs: What's your opinion
We are evaluating a product from Quest Software called LiveReorg. (For Oracle databases). The product helps perform a database reorg without shutdown or taking the table/tablespace offline. This significantly improves performance and reduces wastes blocks in a tablespace. The number of extents drops down to 1,2,3,4 or the number you choose. instead of those 100s on one tablespace. We had a chance to do it live on a test server and looks great. Although it was difficult to reorg a whole tablespace since it needs twice the size (in the same location)!! But the work around is to reorg on another location or file system then drop the old one.
What do you think? What should watch out for?
(Env. SAP R/3 on Oracle 8.1.7.4 and HP-UX 11.0)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 10:17 PM
тАО11-02-2003 10:17 PM
Re: A question for DBAs: What's your opinion
I've read the doc on LiveReorg some time ago. It seems to be a damn nice toy, but rather expensive.
But you can also find documents on the net "stop reorganizing and start living". Oracle 8i and above can handle 10000 extents per segment without performance loss if you use reasonable extents (> 1MB).
regards,
Thierry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 10:34 PM
тАО11-02-2003 10:34 PM
Re: A question for DBAs: What's your opinion
"lots of extents for a table is bad for performance"
and its false.
Anyway Quest tools were always good,do you have the test sheet and result found fine ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2003 10:43 PM
тАО11-02-2003 10:43 PM
Re: A question for DBAs: What's your opinion
Please drop me an email to latif_IT2000@yahoo.com I need to talk to you.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 04:51 AM
тАО11-03-2003 04:51 AM
Re: A question for DBAs: What's your opinion
I would suggest you to use locally mananged tablespaces LMTs and forget reorgs with respect to shrinking number of extents and start living! Besides, oracle 9i has online data reorg and redefinition package, where you can move things online without any downtime. why would anyone want to buy a feature that is available on the next release. If you think you would be doing reorg too often, then this could justify for your migration to 9i.
-
hth,
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 05:01 AM
тАО11-03-2003 05:01 AM
Re: A question for DBAs: What's your opinion
I would suggest extensive testing on a sandbox system to make sure it doesn't mess anything up.
Then reorg during maintenance windows right after cold backups until its proven istelf.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 05:21 AM
тАО11-03-2003 05:21 AM
Re: A question for DBAs: What's your opinion
We have an identical environment to yours and we have LiveReorg. I am strictly the HPUX admin, but the two Oracle/SAP guys are very very happy with LiveReorg. We are a very very conservative shop since we support our worldwide operations, so they probably do not use the product to it's full potential. We have had it installed now for probably about a year and they have performed quite a few reorgs on our productioin system. I beleive they installed and tested the product on our test systems for about six months before even considering it for our production boxes.
Hope this helps!
-Bryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 06:25 AM
тАО11-03-2003 06:25 AM
Re: A question for DBAs: What's your opinion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2003 06:23 PM
тАО11-03-2003 06:23 PM
Re: A question for DBAs: What's your opinion
Thanks for the replies.
Thierry: I did read the document. When I joined the team here the system was in a different state. The document was supposed to be considered during the implementation├в ┬ж
Hari: No I didn├в t get any test sheets but we manually chose some tables to work on. We tried small tables such as 2MB to large such 2 GB and 3 GB. Results are great.
Stan: in an SAP environment, we stick to what SAP recommends.
Steven: Good idea. The first re-orgs will be during weekends and after backups are done.
Bryan: We had about 4 months now evaluating this product. May it├в s time to go Live now!!
Clay: Good idea also, having LiveReorg run frequently reduces fragmentation and keeps performance up to expectations.
Thanks for the suggestions guys. More are we