Oracle internals tips, tricks, and techniques for DBAs
If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Boca Raton, Florida :
Auerbach Publications
[2017]
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627834506719 |
Tabla de Contenidos:
- Book Cover; Half-Title; Series-Title; Title; Copyright; Contributors; Contents; Introduction; Part I Oracle applications development techniques; 1 A practical example of data conversion; 2 Using wizards in an Oracle developer 6i form; 3 Using Oracle's developer 6i to create a record directory; 4 Using Hierarchical Tree items in Oracle's developer 6i; 5 Populating Oracle form hierarchies incrementally at runtime; 6 Oracle designer 2.1.2.API: Enforcing column naming standards; Part II Oracle web development; 7 Buliding a .com from the ground up; 8 Rapid web deployment with webdb
- 9 Introduction to iAS for the OAS administrator10 Viewing performance data with OAS; 11 Top DBA scripts for web developers; 12 Web-based testing and capacity planning; 13 HTTP listeners; 14 Introduction to UTL_HTTP; 15 Portal 3.0: Moving folders across content areas with its API; 16 Not webDB 3.3, Not iPortal, but Oracle Portal; Part III Java and Oracle; 17 The fast track to Java with Oracle; 18 Building a Java Applet for monitoring Oracle; Part IV Oracle and Unix; 19 UNIX scripts for Oracle administration; 20 UNIX tips and tricks for the Oracle DBA
- 21 FIle exchange solutions: SQL*Loader, PL/SQL, and Pro*C22 Cauging how Linux May change the DBMS Market; Part V Oracle backup and recovery; 23 Strategies for an archives management program; 24 Scripting Oracle backups with RMAN and EBU; 25 Alert mechanisms for RMAN backups; 26 Tips and scripts fpr implenting RMAN; 27 Paging people with Oracle8i Out of the box; Part VI Sql Tuning; 28 Cost-based Optimization: Whys and Hows; 29 Analytic Functions; 30 Piranhas in the pool: Investigations into literal Sql and Oracle shared pool performance; 31 Managing database objects in sets; 32 Oracle's joins
- 33 To_FormatPart VII Oracle disk management; 34 Exploring disk size and Oracle disk I/O performance; 35 Adaptive strategies for disk performance in Oracle; 36 Raid and Oracle; 37 Visualizing the I/O Signature; Part VIII Distributed Oracle systems; 38 Automating distribution of Oracle client software; 39 Sql*Net diagnostics abd performance tuning; Part IX Oracle buffer and SGA management; 40 Pinning packages in the SGA; 41 Investigating the multiple buffer pool feature of Oracle8; 42 Diving into the shared pool; 43 Managing multple buffer pools in Oracle8
- 44 Oracle8i Buffer cache: New featuresPart X Oracle table management; 45 How I reorganized a large database; 46 Partition and conquer; 47 Eliminating space reorganizations in Oracle8i; 48 Determining the table rebuild ratio for Oracle tables; 49 Oracle parallel query; 50 Managing Oracle table freelists; Part XI Oracle security; 51 Using roles in Oracle securtiy; 52 Managing row-level security in Oracle8i; 53 Auditing Oracle; Part XII Oracle data warehousing; 54 What's wrong with my data?; 55 Oracle express development in the enterprise; 56 An approach to load analysis and stess testing
- 57 Undocumented express
