Download pdf for Oracle/Weblogic/Unix

This page consists of Downloads for Oracle,weblogic and Unix

Oracle Downloads

1. Autoconfig R12
2. Useful Scripts For APPS DBA.
3. What Is Enqueue And Locks
4. Oracle Table Guide
5. Oracle Views Guide
6. Oracle Tablespace Guide
7. Backup And Recovery
8. Oracle 12c Features
9. Oracle DBA queries
10. RMAN cheatsheet
11. Oracle DBA interview questions
12. Oracle Sql developer tool Guide

Oracle Script download

Oracle Apps

Concurrent Manager

• Check-all-cm-details.sql
• Check-cm-site-profiles.sql
• Check-enable-cm-detail.sql
• Check ICM Settings
• Check All Concurrent manager Specialization rules
• Find Concurrent Request SID
• Find Concurrent request Trace
• Find pending Concurrent requests
• Find Concurrent request details
• Find running Concurrent requests
• Find the Concurrent manager running the concurrent request
• Find the SID of all the conncurent request running on Database instance

Audit

• How to check EBS audit settings
• EBS Object Auditing
• Login Session Responsibilites
• Detail Session Flow for a user id
• Profile Who Column Example
• V$sesssion Sid for Fnd User
• Last Sql executed by FND user

Workflow mailer

• Workflow agent status
• Workflow mailer logfile location
• Workflow mailer configuration settings
• Workflow mailer start through sqlplus
• Workflow mailer stop through plsql

Oracle Whitepaper downloads

1. Partitioning with Oracle Database 12c
2. SQL Plan Management in 12c (Oracle White Paper)
3. Best Practices For Gathering Optimizer Statistics in 12c
4. Understanding Optimizer Statistics With Oracle 12c
5. Parallel Execution Fundamentals With Oracle Database 12c
6. Upgrading to Oracle Database 12.1.0.2 (Oracle White Paper)
7. Oracle Database 12c Global Data Services (Oracle White Paper)
8. Plug Into Cloud With Oracle Database 12c (Oracle White Paper)
9. Oracle Multitenant (Oracle White Paper)
10. Oracle Database In-Memory (Oracle White Paper)
11. Optimizer In Oracle Database 12c
12. Oracle’s Approach to Performance Tuning Part-I by Darrick Addison
13. Oracle’s Approach to Performance Tuning Part-II by Darrick Addison
14. Adaptive Cursors And SQL Plan Management (Arup Nanda)
15. Oracle Database Parallel Execution Fundamentals (Oracle White Paper)
16. Understanding Parallel Execution Part-I (Randolf Geist)
17. Understanding Parallel Execution Part-II (Randolf Geist)
18. The Oracle Optimizer – Explain The Explain Plan
19. Oracle Active Data Guard Far Sync (Oracle White Paper)
20. Oracle Active Data Guard 12c (Oracle White Paper)
21. Oracle Active Data Guard 11g (Oracle White Paper)
22. Oracle Single Client Access Name (SCAN)(12c) (Oracle White Paper)
23. Oracle 12c RAC (Oracle White paper)
24. Oracle Clusterware 12c (Oracle White Paper)
25. Maximize Availability with Oracle 12c (Oracle White Paper)

Linux download

• Basic Unix commands
• vi editor cheatsheet

R12.2 download(white Paper)

• Best Practices for Minimizing E-Business Suite R12.2.n Upgrade Downtime
• Migrating the customization in R12.2
• Online Patching in R12.2
• EBS R12.2 Maintainance Guide
• Best Practice for EBS upgrade
• EBS R12.2 Upgrade Sizing and Best Practices
• Express_Diagnosis_of EBS R12 Upgrade Performance Issues

Oracle Cloud Infrastructure(White Paper and Links )

• EBS deployment on Oracle Cloud infrastructure
• Best Practice for Deploying HA Architecture on Oracle Cloud infrastructure
• Oracle Cloud infrastructure Study Guide
• OCI User Guide
• OCI Security Guide
• OCI Database FAQ
• OCI Networking FAQ
• How to deploy Custom images in OCI
• Object Storage FAQ
• Block Volume FAQ
• File storage FAQ
• Oracle OCI Practice Exam