Free Space in Tempory Tablespace

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Connected as apps


SQL>
SQL> SELECT T.TABLESPACE_NAME,
2 NVL(ROUND(((SUM(U.BLOCKS) * P.VALUE) / 1024 / 1024), 2), 0) USED_MB,
3 T.TOT_MB,
4 NVL(ROUND(SUM(U.BLOCKS) * P.VALUE / 1024 / 1024 / T.TOT_MB * 100, 2),
5 0) "USED %"
6 FROM GV$SORT_USAGE U,
7 GV$PARAMETER P,
8 (SELECT TABLESPACE_NAME, SUM(BYTES) / 1024 / 1024 TOT_MB
9 FROM DBA_TEMP_FILES
10 GROUP BY TABLESPACE_NAME) T
11 WHERE P.NAME = 'db_block_size' AND U.TABLESPACE(+) = T.TABLESPACE_NAME
12 GROUP BY T.TABLESPACE_NAME, P.VALUE, T.TOT_MB
13 ORDER BY 1, 2;

TABLESPACE_NAME USED_MB TOT_MB USED %
------------------------------ ---------- ------ ----------
TEMP2 160 6000 2.67

SQL>

Important Tables for Oracle Apps DBA

oncurrent Manager
FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

FND

FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES

AD / Patches

AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS

Oracle apps Reports 6i FAQ

1. What are the various types of reports?
2. What is the difference between Master - Detail Report and report created by breaks?
3. What are Anchors?
4. What are the various types of anchors in Reports?
5. What are the various report triggers? What is their order of firing?
6. What are Placeholder Columns?
7. What are the various Module Types in Reports?
8. What are Physical and Logical pages in Reports?
9. What are the various page layout sections in Oracle Reports?
10. What are various types of parameters?
10. How do you reference parameters and columns in reports?
12. What are Bind Referencing and Lexical Referencing?
13. Can you create a group without any break columns?
14. Types of Matrix report?
15. In Reports, how can you print one record per page in the output?
16. How do you print a Report 2.5 report in character mode?
17. What are widow lines?
18. What are widow records?
19. What is 'page protect' property for objects?
20. What is the 'Print Condition Type' property?
21. What are the various values of the 'Print Condition Type' property in Reports?
22. What is the 'Print Condition Object' property?
23. What are the various values of the 'Print Condition Object' property in Reports?
24. What is the horizontal of vertical sizing property of objects?
25. What are the various values of the horizontal of vertical sizing property?
26. How do you display a message in reports?
27. What are the various values of 'Print Panel Order' property of report?
28. What is the 'Print Direction' Property of Repeating frames?
29. What are the various values of the 'Print Direction' Property of Repeating frames?
30. What is the 'Keep with Anchoring Object' object property?
31. What is 'Page Break Before' object property?
32. What is 'Page Break After' object property?
33. What is the 'Break Order' property of columns?
34. What are the various types of links?
35. Name some of the procedures in the SRW package?
36. What are the various report layout regions?
37. What is more efficient: Maximum rows or Group Filter?

Which Has The Better Apps Strategy: Oracle Or SAP?

A key decision criterion for enterprise applications is how compelling and clear the vendor's vision for the future is. Oracle's vision for the future of its apps business is now clearer and more compelling than that of archrival SAP. But Oracle's biggest test is yet to come ? it must deliver the Oracle Fusion Applications system with its associated promises of better flexibility and lower cost of ownership and do it within the next two years to keep the upper hand in apps innovation. SAP offers a gradual and potentially less disruptive path for enterprise customers, evolving its current release piece by piece; it has also taken its innovative SAP Business ByDesign product off the table as its next-generation suite. Each vendor now offers more (and more complex) paths for customers to consider, but it is unlikely that mass defections will take place in either direction. Despite the size and influence of Oracle and SAP, customers should challenge the vendors to prove the value of their migration and upgrade strategies, including assessing whether either vendor offers better front-office or vertical solutions than best-of-breed suppliers or emerging cloud-based solutions.

Try the following Link
http://www.forrester.com/Research/Document/Excerpt/0,7211,41885,00.html

Imporatant Metalink Notes

Note: 362135.1 - Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management
Note: 312731.1 - Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM
Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note: 279956.1 - Oracle E-Business Suite Release 11i with 9i RAC: Installation and Configuration using AutoConfig
Note: 294932.1 - Recommendations to Install Oracle Applications 11i
Note: 403339.1 - Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
Note: 455398.1 - Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i
Note: 402311.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft Windows
Note: 405565.1 - Oracle Applications Release 12 Installation Guidelines

AD Utilities

Note: 178722.1 - How to Generate a Specific Form Through AD utility ADADMIN
Note: 109667.1 - What is AD Administration on APPS 11.0.x ?
Note: 112327.1 - How Does ADADMIN Know Which Forms Files To Regenerate?
Note: 136342.1 - How To Apply a Patch in a Multi-Server Environment
Note: 109666.1 - Release 10.7 to 11.0.3 : What is adpatch ?
Note: 152306.1 - How to Restart Failed AutoInstall Job
Note: 356878.1 - How to relink an Applications Installation of Release 11i and Release 12
Note: 218089.1 - Autoconfig FAQ
Note: 125922.1 - How To Find Oracle Application File Versions

Cloning

Note: 419475.1 - Removing Credentials from a Cloned EBS Production Database
Note: 398619.1 - Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
Note: 230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone
Note: 406982.1 - Cloning Oracle Applications Release 12 with Rapid Clone
Note: 364565.1 - Troubleshooting RapidClone issues with Oracle Applications 11i
Note: 603104.1 - Troubleshooting RapidClone issues with Oracle Applications R12
Note: 435550.1 - R12 Login issue on target after cloning
Note: 559518.1 - Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
Note: 216664.1 - FAQ: Cloning Oracle Applications Release 11i

Patching

Note: 225165.1 - Patching Best Practices and Reducing Downtime
Note: 62418.1 - PATCHING/PATCHSET FREQUENTLY ASKED QUESTIONS
Note: 181665.1 - Release 11i Adpatch Basics
Note: 443761.1 - How to check if a certain Patch was applied to Oracle Applications instance?
Note: 231701.1 - How to Find Patching History (10.7, 11.0, 11i)
Note: 60766.1 - 11.0.x : Patch Installation Frequently Asked Questions
Note: 459156.1 - Oracle Applications Patching FAQ for Release 12
Note: 130608.1 - AdPatch Basics
Note::60766.1 - Patch Installation FAQ (Part 1)

Upgrade

Note: 461709.1 - Oracle E-Business Suite Upgrade Guide ? Plan
Note: 293166.1 - Previous Versions of e-Business 11i Upgrade Assistant FAQ
Note: 224875.1 - Installation, Patching & Upgrade Frequently Asked Questions (FAQ?s)
Note: 224814.1 - Installation, Patching & Upgrade Current Issues
Note: 225088.1 - Installation, Patching & Upgrade Patches Guide
Note: 225813.1 - Installation, Patching & Upgrade Setup and Usage Guide
Note: 224816.1 - Installation, Patching & Upgrade Troubleshooting Guide
Note: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note: 362203.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note: 423056.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.2)
Note: 726982.1 - Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.3)
Note: 452783.1 - Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
Note: 406652.1 - Upgrading Oracle Applications 11i DB to DB 10gR2 with Physical Standby in Place
Note: 316365.1 - Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions
Note: 418161.1 - Best Practices for Upgrading Oracle E-Business Suite

Printer

Note: 297522.1 - How to investigate printing issues and work towards its resolution ?
Note: 110406.1 - Check Printing Frequently Asked Questions
Note: 264118.1 - Pasta Pasta Printing Setup Test
Note: 200359.1 - Oracle Application Object Library Printer Setup Test
Note: 234606.1 - Oracle Application Object Library Printer Initialization String Setup Test
Note: 1014599.102 - Subject: How to Test Printer Initialization Strings in Unix

Performance

Note: 390137.1 - FAQ for Collections Performance
Note: 216205.1 - Database Initialization Parameters for Oracle Applications Release 11i
Note: 169935.1 - Troubleshooting Oracle Applications Performance Issues
Note: 171647.1 - Tracing Oracle Applications using Event 10046
Note: 153507.1 - Oracle Applications and StatsPack
Note: 356501.1 - How to Setup Pasta Quickly and Effectively
Note: 333504.1 - How To Print Concurrent Requests in PDF Format
Note: 356972.1 - 11i How to troubleshoot issues with printers

Others

Note: 189367.1 - Best Practices for Securing the E-Business Suite
Note: 403537.1 - Best Practices For Securing Oracle E-Business Suite Release 12
Note: 454616.1 - Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2
Note: 394692.1 - Oracle Applications Documentation Resources, Release 12
Note: 370274.1 - New Features in Oracle Application 11i
Note: 130183.1 - How to Get Log Files from Various Programs for Oracle Applications
Note: 285267.1 - Oracle E-Business Suite 11i and Database FAQ
Note: 453137.1 - Oracle Workflow Best Practices Release 12 and Release 11i
Note: 398942.1 - FNDCPASS Utility New Feature ALLORACLE
Note: 187735.1 - Workflow FAQ ? All Versions

ORA-00001

ORA-00001 unique constraint (string.string) violated
Oracle version: 10g

Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.

Action: Either remove the unique restriction or do not insert the key

ORA-12203: TNS:unable to connect to destination

ORA-12203: TNS:unable to connect to destination


Solution:

Do you have an entry in your tnsnames.ora file that describes the destination?
Does tnsping SERVER tell you anything?