- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Any feedback for init.ora parameter discrete_t...
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
тАО05-03-2005 12:30 AM
тАО05-03-2005 12:30 AM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
When issuing dd with different block sizes, and monitoring with glance, I can see that transfered size divided by IO count is equal to dd's bs, while bs inferior to 256KB. If bs is larger than 256KB, IOs seems broken and are always 256KB large.
I never managed to find a parameter to increase that size. scsi_maxphys default value is set to 1MB as a default, so it may not be the blocking factor.
Note that my tests were only for reads.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2005 09:29 PM
тАО05-03-2005 09:29 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
From what I understood scsi_maxphys is the overall limit (must not be changed) but there is a hardware limit, depending on the device and its associated drivers.
To you use a different value than the default 1 (for 1 CPU) for spin_count?
Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2005 09:47 PM
тАО05-03-2005 09:47 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
Here's a script which tells you a lot about tunable parameters. Also physical reads and writes. Read it carefully, execute it several times at the same time of the day and try to change the parameters positively.
you can always use Oracle Enterprise Manager to view things graphically.
Cheers,
Renarios
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2005 09:57 PM
тАО05-03-2005 09:57 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
You missed the script...
Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2005 10:06 PM
тАО05-03-2005 10:06 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
What is spin_count ?
Renarios,
Oracle version is 8.0.5. OEM of such old versions (DBA studio) is rather buggy and less complete than nowadays. If he uses last OEM version, I doubt that parameters descriptions are accurate.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2005 10:33 PM
тАО05-03-2005 10:33 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
spin_count is "Amount to spin waiting for a latch". But I think it is only usefull to be set with a different value than de default (1) for multiprocessor systems...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2005 10:49 PM
тАО05-03-2005 10:49 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
Here's take two:
Cheers,
Renarios
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2005 12:35 AM
тАО05-04-2005 12:35 AM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2005 07:58 PM
тАО05-04-2005 07:58 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
Fred,
yes I've readed it. I'm reviewing all init.ora parameters that are not derived...
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2005 10:40 PM
тАО05-04-2005 10:40 PM
Re: Any feedback for init.ora parameter discrete_transaction_enabled?
Thanks to all!
- « Previous
-
- 1
- 2
- Next »