- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 7.3.4 Tablespace Creation Time
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
тАО06-26-2000 08:26 PM
тАО06-26-2000 08:26 PM
Oracle 7.3.4 Tablespace Creation Time
under vxfs takes about 8-9 hours at a rate of 10 minutes per GB. Disks are on an EMC array. Is this about right or can this process be sped up?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2000 11:41 PM
тАО06-26-2000 11:41 PM
Re: Oracle 7.3.4 Tablespace Creation Time
You can speed up the system by increasing the memory, number of cpu's and swap space. For the interim, adjust the following kernel parameters:
allocate_fs_swapmap=0
maxdsize=1gb
shmmax=1gb
swapmem_on=1
I hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2000 11:43 PM
тАО06-26-2000 11:43 PM
Re: Oracle 7.3.4 Tablespace Creation Time
You can speed up the system by increasing the memory, number of cpu's and swap space. For the interim, adjust the following kernel parameters:
allocate_fs_swapmap=0
maxdsize=1gb
shmax=1gb
swapmem_on=1
I hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2000 05:34 AM
тАО06-27-2000 05:34 AM
Re: Oracle 7.3.4 Tablespace Creation Time
I'm using a N4000 with a HPArray with 11.0. I don't have databases as large as you but creating a datafile of 1 GB takes about 15 min. For me that's normal, i think it depents on how frequently you are creating such datafiles before changing kernelsettings or adding memory/CPU's.
Hope it helps,
Wim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2000 07:48 AM
тАО06-27-2000 07:48 AM
Re: Oracle 7.3.4 Tablespace Creation Time
I would stay away from adjusting kernel parameters. It doesn't make sense to me. I think you run a higher risk of negatively affecting performance somewhere else.
As far as more memory, don't see the need. You're not really working on a data set. Your writing nulls to a logical volume.
More CPUs. Again, don't see how it will help. You're not processing data.
How did you create the logical volumes? Is the slow performance when you are creating the logical volumes or when adding the table spaces in Oracle? My guess is it has more to do with how these logical volumes were created or are being created. Are they spread across controllers and LUNs? Did you do any type of stripping?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-27-2000 09:05 AM
тАО06-27-2000 09:05 AM
Re: Oracle 7.3.4 Tablespace Creation Time
First things first, tune the kernel with the above parameters, if you have fast wide controllers change them to a HSC for improved performance. With 50gb of database, you sure need higher CPU, memory and swap space.