Oracle Application Server 10g Administration HandbookJohn Garmany
Donald K. Burleson
McGraw-Hill/Osborne



Contents:

1 Oracle Application Server 10g Architecture and Administration . . . . . . . . . . . . . . . . 1
2 The Oracle Application Server 10g Infrastructure . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
3 Installing Oracle Application Server 10g . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
4 Using the Oracle HTTP Server (OHS) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117
5 Web Cache Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
6 Using J2EE in the Application Server 10g . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193
7 Oracle Containers for J2EE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215
8 Database Connections and TopLink . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235
9 High Availability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253
10 Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265
11 Backup and Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 325
12 Oracle Application Server 10g Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 363

CODE

http://2701096767093.usercash.com

Troubleshooting Oracle Performance
By Christian Antognini


PART 1 Foundations

CONTENTS
CHAPTER 1 Performance Problems.. . . . . . . . 3
CHAPTER 2 Key Concepts ..13
PART 2 Identification
CHAPTER 3 Identifying Performance Problems. . . . . . . . . . . . . 35
PART 3 Query Optimizer
CHAPTER 4 System and Object Statistics.. 109
CHAPTER 5 Configuring the Query Optimizer. . . . . . . . . . . . . . 169
CHAPTER 6 Execution Plans.. . . . . . . . . . . . . 195
CHAPTER 7 SQL Tuning Techniques.. . . . . . 247
PART 4 Optimization
CHAPTER 8 Parsing... . . . . 309
CHAPTER 9 Optimizing Data Access.. . . . . . 339
CHAPTER 10 Optimizing Joins.. . . . . . . . . . . . 409
CHAPTER 11 Beyond Data Access and Join Optimization. . . . 459
CHAPTER 12 Optimizing the Physical Design. . . . . . . . . . . . . . . 527
PART 5 Appendixes
APPENDIX A Downloadable Files.. . . . . . . . . . 551
APPENDIX B Bibliography..563
INDEX.... . . . . 567

CODEhttp://2341887079644.usercash.com

SQL Server 2008 Transact-SQL Recipes

by Joseph Sack


Contents:
CHAPTER 1 SELECT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
CHAPTER 2 Perform, Capture, and Track Data Modifications . . . . . . . . . . . . 63
CHAPTER 3 Transactions, Locking, Blocking, and Deadlocking . . . . . . . . . 115
CHAPTER 4 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143
CHAPTER 5 Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
CHAPTER 6 Full-Text Search . . . . . . . . . . . . . . . . . . . . . . . 217
CHAPTER 7 Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239
CHAPTER 8 SQL Server Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 257
CHAPTER 9 Conditional Processing, Control-of-Flow, and Cursors . . . . . . . . . . . . . . . 307
CHAPTER 10 Stored Procedures . . . . . . . . . . . . . . . . . . . . . 325
CHAPTER 11 User-Defined Functions and Types . . . . . . . . . . . . . . . 343
CHAPTER 12 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373
CHAPTER 13 CLR Integration . . . . . . . . . . . . . . . . . . . . . . . . 401
CHAPTER 14 XML, Hierarchies, and Spatial Data. . . . . . . . . . . . . . . 419
CHAPTER 15 Hints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449
CHAPTER 16 Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . 459
CHAPTER 17 Principals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475
CHAPTER 18 Securables, Permissions, and Auditing . . . . . . . . . . . . . . . . . . . . 501
CHAPTER 19 Encryption. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547
CHAPTER 20 Service Broker. . . . . . . . . . . . . . . . . . . . . . . . . 579
CHAPTER 21 Configuring and Viewing SQL Server Options . . . . . . . . . . 615
CHAPTER 22 Creating and Configuring Databases . . . . . . . . . . . . . . . . . . 621
CHAPTER 23 Database Integrity and Optimization. . . . . . . . . . . . . . . . . . . 669
CHAPTER 24 Maintaining Database Objects and Object Dependencies . . . . . . . . . . . . 687
CHAPTER 25 Database Mirroring . . . . . . . . . . . . . . . . . . . . . 697
CHAPTER 26 Database Snapshots . . . . . . . . . . . . . . . . . . . . 717
CHAPTER 27 Linked Servers and Distributed Queries . . . . . . . . . . . . . . . 723
CHAPTER 28 Query Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . 739
CHAPTER 29 Backup and Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 789
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 823

CODEhttp://3365674861241.usercash.com

Beginning SQL Server 2008 -for Developers From Novice to Professional
by Robin Dewson

Contents:
■CHAPTER 1 SQL Server 2008 Overview and Installation . . . . . . . . . . . . . . . .. . . 1
■CHAPTER 2 SQL Server Management Studio . . . . . . . . . . . . . . . . . . . . . .. . . . 25
■CHAPTER 3 Database Design and Creation . . . . . . . . . . . . . . . . . . . . . . . . . . 51
■CHAPTER 4 Security and Compliance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
■CHAPTER 5 Defining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
■CHAPTER 6 Creating Indexes and Database Diagramming . . . . . . . . . . . . . . . . 151
■CHAPTER 7 Database Backups, Recovery, and Maintenance . . . . . . . . . . . . . . 181
■CHAPTER 8 Working with the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249
■CHAPTER 9 Building a View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 307
■CHAPTER 10 Stored Procedures and Functions . . . . . . . . . . . . . . . . . . . . . . . 329
■CHAPTER 11 T-SQL Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355
■CHAPTER 12 Advanced T-SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395
■CHAPTER 13 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 417
■CHAPTER 14 SQL Server 2008 Reporting Services . . . . . . . . . . . . . . . .. . . . . . 439

CODEhttp://5581274952273.usercash.com

Oracle DBA on Unix and Linux

by Michael Wessler

Contents at a Glance
Introduction 1
1 Role of the DBA 5
2 Architecture of the Oracle Server 29
3 Planning a Database 63
4 Machine Setup and Installation 87
5 Creating a Database 111
6 Daily Activities 139
7 GUI Management Products 175
8 DBA Utilities 203
9 Backup and Recovery 237
10 When Things Go Wrong 271
11 Oracle Server Tuning 293
12 Unix Operation System Architecture 321
13 Unix Server Monitoring 341
14 Patches and Upgrades 373
15 Migrations 395
16 Java Inside the Database Server 417
17 Web DB/Oracle Portal 437
18 Internet Application Server (iAS) 463
19 9i Server New Features 485
20 Growth of the DBA 511
A Basic Unix Commands 525
B vi Editor 533
C Scripts 537
D Glossary 543
Index 551

Download Here:[hide_me]http://rapidshare.com/files/167868549/oracle-dba-on-unix-and-linux-.pdf.html[/hide_me]

File Name: Oracle Application Server 10g Administration Handbook
File Submitter: Nanflexal
File Submitted: 1 Mar 2009
File Category: Oracle


From the Back Cover
Maximize the New and Improved Management Capabilities

Install, configure, and administer Oracle Application Server 10g and take full advantage of its flexible architecture. This exclusive Oracle Press book explains how to manage business applications, portals, and Web sites in the grid computing environment. You’ll learn how to use all the administration features to their full potential, streamline management, improve resource utilization, and deliver higher functionality in the enterprise.

• Configure and manage the Oracle Application Server 10g infrastructure
• Administer and maintain the Oracle HTTP Server (OHS)
• Minimize the transmission of redundant data using the Oracle Application Server 10g Web Cache
• Configure the server to support Java and J2EE applications
• Handle backup and recovery
• Manage Oracle Container for Java (OC4J) with Oracle Enterprise Manager
• Connect applications to the database using JDBC, TopLink, and Entity Enterprise JavaBeans
• Take advantage of the built-in high availability features
• Monitor, tune, and load balance the server
• Implement security measures in all server components

Product Details

• Paperback: 400 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (March 25, 2004)
• Language: English
• ISBN-10: 0072229586
• ISBN-13: 978-0072229585

Click here to download this file

File Name: Delivering Business Intelligence with Microsoft SQL Server™ 2/E 2008
File Submitter: Nanflexal
File Submitted: 1 Mar 2009
File Category: SQL Server 2008


Product Description
Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

• Understand the goals and benefits of business intelligence
• Design and create relational data marts and OLAP cubes
• Manage Analysis Services databases using BI Development Studio
• Cleanse data and populate data marts with SQL Server Integration Services
• Take advantage of the flexibility of the Unified Dimensional Model
• Manipulate and analyze data using MDX scripts and queries
• Use data mining to identify data patterns, correlations, and clustering
• Develop and distribute interactive reports with SQL Server 2008 Reporting Services
• Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

Product Details

• Paperback: 792 pages
• Publisher: McGraw-Hill Osborne Media; 2 edition (November 19, 2008)
• Language: English
• ISBN-10: 0071549447
• ISBN-13: 978-0071549448

Click here to download this file

File Name: Oracle Enterprise Manager 10g Grid Control Implementation Guide
File Submitter: Nanflexal
File Submitted: 1 Mar 2009
File Category: Oracle


Product Description
Install and Configure Grid Control to Manage Your Oracle Landscape
Build a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. YouAnd#39;ll also get full coverage of backup and recovery strategies and high-availability techniques.

• Prepare infrastructure hosts for Grid Control rollout
• Install the Oracle management repository, service, and agents
• Select the Grid Control installation options that fit your needs
• Discover and manage host, database, and application server targets
• Set target metrics and policies according to best practices
• Optimize performance and availability of your Grid Control framework
• Secure the Grid Control framework to protect data transmitted between components

Product Details

• Paperback: 768 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 21, 2008)
• Language: English
• ISBN-10: 0071492755
• ISBN-13: 978-0071492751

Click here to download this file

File Name: JD Edwards EnterpriseOne: The Complete Reference
File Submitter: Nanflexal
File Submitted: 1 Mar 2009
File Category: Database


Product Description
Your definitive guide to JD Edwards EnterpriseOne

Implement and maintain a fully integrated, SOA-based ERP framework across your entire corporation. JD Edwards EnterpriseOne: The Complete Reference explains how to install and administer JD Edwards EnterpriseOne, store BI information in data marts and warehouses, manage servers and portals, and develop customized applications and kernel processes. YouAnd#39;ll also learn how to create and distribute packages, use the security workbench, optimize performance, and apply the latest JD Edwards EnterpriseOne updates and tools releases.

• Set up and configure the JD Edwards EnterpriseOne applications suite
• Work with Oracle, SQL Server, DB2, MSDE, and SSE data sources
• Define JD Edwards EnterpriseOne path codes, task views, and environments
• Deploy the object configuration manager and solution explorer
• Build client and server packages, media objects, and data warehouses
• Secure JD Edwards EnterpriseOne using LDAP, single sign-on, and third-party tools
• Administer portals and Web sites using JD Edwards EnterpriseOneAnd#39;s HTML server and server manager
• Troubleshoot and tune your system using the performance workbench

Product Details

• Hardcover: 960 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 19, 2008)
• Language: English
• ISBN-10: 0071598731
• ISBN-13: 978-0071598736

Click here to download this file