Predavanje

OPOMBA: časi in dvorane predavanj so le informativni in se lahko do pričetka prireditve še spremenijo. Prireditev SIOUG 2009 (začetek: 20.09.2009, trajanje: 4 dni) Avtor Randolf Geist Soavtorji - Podjetje Freelance Consultant Naslov CBO fundamentals: Understanding the different modes of System Statistics Opis Predavanje bo izvedeno v angleškem jeziku. Glej angleški opis. Naslov (ENG) CBO fundamentals: Understanding the different modes of System Statistics Opis (ENG) Understanding the different modes of System statistics aka. CPU costing and the effects of multiple blocksizes: One of the most important components of the Oracle database is still the optimizer, since everything the database does is SQL. This presentation explains what System Statistics mean to the cost based optimizer. It covers in-depth the different available System Statistics modes along with explanations and samples about the formulas and arithmetics used. Finally the effects of multiple non-standard block sizes are shown and why it is a bad idea in general to use them for "tuning" purposes. Target audience are DBAs and developers who are looking for a deeper understanding how the cost-based optimizer works. Jezik English Področje 1. Tehnologija in tehnološke rešitve Zahtevnost 2: Basic Začetek predavanja 21.09.2009 14:25 Konec predavanja 21.09.2009 15:05 Dvorana Emerald 2