meta user
network profile
| bio | website | |
|---|---|---|
| location | Glasgow, United Kingdom | |
| age | ||
| visits | member for | 2 years, 4 months |
| seen | Dec 13 '12 at 7:37 | |
| stats | profile views | 1 |
|
Mar 12 |
awarded | Popular Question |
|
Nov 23 |
comment |
SSDs with Oracle We ended up adding SSDs for indexes and tablespaces and striping the two across them. We didn't get the big speed jump we were hoping for. More like 10-15% faster for our migration runs, but in the absence of any other options that was a good timesaver (our Oracle tuning expert had already been let loose on the DB). Thanks for all the comments. We went with Crucial SSDs which offered pretty good performance for a good price and still haven't had any problems. We also accepted they'd wear out and are keeping an eye on them (and copious backups)! Thanks for all the comments. Stuart. |
|
Nov 23 |
awarded | Supporter |
|
Nov 23 |
awarded | Scholar |
|
Nov 23 |
comment |
SSDs with Oracle +1 for good info, makes sense to keep the redo's off the SSD, thanks for pointing that out. |
|
Nov 23 |
comment |
SSDs with Oracle Chosen as accepted answer as it gives me the most information on SSDs. Thanks! |
|
Nov 23 |
accepted | SSDs with Oracle |
|
Jul 6 |
awarded | Nice Question |
|
Feb 10 |
awarded | Teacher |
|
Feb 2 |
comment |
SSDs with Oracle Thanks, I hadn't read the linux.com article linked to on it (I'd read the Anand article). Very interesting. Still really looking for people with real word experience though. +1 anyway. |
|
Jan 27 |
answered | What kind of hardware/software config should I look at for a MySQL database with 10,000 plus tables |
|
Jan 19 |
comment |
SSDs with Oracle We use 10,000rpm SCSI drives in our main server (Centos and Itanium 2) and I think 7200rpm SATA drives in the Dell (Centos and Xeons) but I haven't had it open. When I say "consumer" I meant the cheaper SSDs from crucial.com rather than the expensive Intel ones. Buying directly from Dell in particular is very expensive. I'm sure there are other shops out there with a restricted hardware budget! |
|
Jan 13 |
comment |
SSDs with Oracle @Gary, thanks I'll look into that too. Sounds like I should be running Statspack. |
|
Jan 12 |
comment |
SSDs with Oracle I haven't tested, but it has been tested! I'm just investigating other options so I can look good in a meeting chuckle. I'm pretty sure the load has been balanced and tuned. |
|
Jan 12 |
comment |
SSDs with Oracle I'll be honest, I've not been involved in the performance tuning. I was wondering if SSD(s) could be used as a blunt "make it faster" tool. I figured putting the redo logs, data and indexes on seperate SSDs might make things significantly faster at a reasonable cost with consumer units but wondered about what issues we might have. |
|
Jan 12 |
awarded | Student |
|
Jan 12 |
asked | SSDs with Oracle |
