Frank's Oracle Blog

aus der Doku: Quelle: http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/memory.htm#PFGRF94351 7.5 PGA Memory Management For complex queries (for example, decision support queries), a big portion of the run-time area is dedicated to work areas allocated by memory intensive operators, such as the following: * Sort-based operators, such as ORDER BY, GROUP BY, ROLLUP, and window functions * Hash-join * Bitmap merge * Bitmap create * Write buffers used by bulk load operations Sizing: A) Ideally, the size of a work area is big enough that it can accommodate the input data and auxiliary memory structures allocated by its associated SQL operator. This is known as the optimal size of a work area. B) When the size of the work area is smaller than optimal, the response time increases, because an extra pass is performed over part of the input data. This is known as the one-pass size of the work area. C) Under the one-pass threshold, when the size of a work area is far too small compar...

Exporting Multiple Pages or the Entire Space * Berechtigungen To export to PDF, you will need 'Export Space' permission which is assigned by a space administrator from the Space Administration screens. See Space Permissions or contact a space administrator for more information. * Vorgehen Go to the 'Advanced' view for the space. To do this: Go to a page in the space, open the 'Browse' menu and select 'Advanced'. The 'Advanced' view will open. Click 'PDF Export' in the left-hand panel

Klingt komisch, ist aber u.U. hilfreich: Abschalten von CPU's (Kernen) auf Mehrkernmaschinen! Warum kann das sinnvoll sein? Weil gewisse SW-Anbieter Ihre CPU-Lizenzierung nach der Anzahl der Kerne im System berechnen und Virtualisierung nicht immer möglich/gewünscht ist (bzw. nur ein bestimmtes Virtualisierungsprodukt akzeptiert ist). [Ich nenne mal keinen Firmennamen.] *** ungetestet *** Linux bietet die Möglichkeit per Kernelparameter maxcpus die Zahl der CPU's zu begrenzen. (Erweitern geht wohl leider nicht ;-)) Beispiel für GRUB: Edit your grub.conf file: # vi grub.conf Append parameter maxcpus at the end of Kernel line. A the end it should read as follows: kernel /boot/vmlinuz-2.6.13-Ora10g root=/dev/sda1 ro maxcpus=2 Save and close the file. Reboot system: # reboot Quelle: http://www.cyberciti.biz/tips/linux-limiting-or-restricting-smp-cpu-activation-in-smp-mode.html

Both EA and ITIL are emerging disciplines that are growing in importance and impact. Here are their basic definitions: EA synthesizes business and technical information and develops information products and governance services to enable better decision making. ITIL (Information Technology Infrastructure Library) "provides a comprehensive, consistent set of best practices focused on the management of IT services processes. It promotes a quality approach to achieving business effectiveness and efficiency in the use of information systems. ITIL is focused on IT Service Management, which is "concerned with delivering and supporting IT services that are appropriate to the business requirements of the organization." (ITIL IT Service Management Essentials, Pink Elephant) To me, EA and ITIL are mutually supportive. Here's how: EA is a decision framework that provides for planning and governance. EA answers the question, what IT investment will we make? ITIL i...

Gefunden in der Computerwoche: Ein interessanter Artikel zur (möglichen) Zukunft von Oracle und SUN. Mit sicherlich recht reisserischen Thesen ("Sun wird verschwinden"), insgesamt aber sehr interessant: http://www.computerwoche.de/software/bi-ecm/2495358/

Die OOW auf YouTube: http://www.youtube.com/Oracle?src=7308729&Act=98&pcode=WWMK11042185MPP039 Meine Highlight aus Larry's Rede: a) PARALLEL - offensichtlich wird die Welt nach der Wolke parallel. Er hat vermutlich über 100x Parallele Verarbeitung als Lösung aller Probleme genannt. und b) The SUN Also Rises! Ein Hemmingway-Zitat - ich denke das beruhigt. SUN geht also nicht nur unter, sondern auch wieder auf. Ob das die Anwender von SUN beruhigt? Meine OOW-Highlight soweit:http://www.blogger.com/img/blank.gif Exalytics http://www.oracle.com/us/solutiohttp://www.blogger.com/img/blank.gifns/ent-performance-bi/business-intelligence/exalytics-bi-machine/overview/index.html database appliance http://www.oracle.com/us/products/database/database-appliance/index.html

u.a. hier: http://st-curriculum.oracle.com/obe/fmw/bi/bip/bip11g/gettingstarted/gettingstarted.htm