93 reputation
6
bio website
location Glasgow, United Kingdom
age
visits member for 3 years, 10 months
seen Sep 30 at 13:48

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