View Single Post
  #1 (permalink)  
Old 09-18-2007, 12:35 PM
FED's Avatar
FED FED is offline
--:: Administrator ::--
 
Join Date: Apr 2007
Location: Free-Ebook-Download.net
Age: 21
Posts: 8,033
Points: 142,970, Level: 53
Points: 142,970, Level: 53 Points: 142,970, Level: 53 Points: 142,970, Level: 53
Level up: 99%, 80 Points needed
Level up: 99% Level up: 99% Level up: 99%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
Default Oracle Performance Tuning for 10gR2, Second Edition


Tuning of SQL code is generally cheaper than changing the data model.
Physical and configuration tuning involves a search for bottlenecks that
often points to SQL code or data model issues. Building an appropriate
data model and writing properly performing SQL code can give 100%+
performance improvement. Physical and configuration tuning often gives
at most a 25% performance increase. Gavin Powell shows that the central
theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data
models to fit applications; tune SQL code according to both the data
model and the application in relation to scalability; create a
well-proportioned physical architecture at the time of initial Oracle
installation; and most important, mix skill sets to obtain the best
results.

* Fully updated for version 10gR2 and provides all necessary transition
material from version 9i
* Includes all three aspects of Oracle database tuning: data model
tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
* Contains experienced guidance and real-world examples using large
datasets Emphasizes development as opposed to operating system
perspective
[url]http://rapidshare.com/files/45315203/Digital.Press.Oracle.Performance.Tuning.for.10gR2. 2nd.Edition.Sep.2006.rar[/url]
or
[url]http://www.megaupload.com/?d=K8QDO7X5[/url]
Reply With Quote
 

Search Engine Optimization by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227