Oracle PL/SQL Questions
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how to improve the performance of a query. 5. %type vs %rowtype. 6. regression testing. 7. deleting the duplicate records without using rowid in oracle. 8. Row chaining. 9. types of cursors. 2021-02-10, 7278👍, 1💬
Oracle ASM questions
Please help to answer below Oracle ASM questions: Where you will free disk details in ASM? What status would be for Free disks? What is Rebalance operations? How you will check rebalance operations progress? how to increase performance of Rebalance operations? Mandatory BG process in ASM How will ch... 2019-01-20, 1558👍, 0💬
How Many Types of Tables Supported by Oracle
How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Oracle supports 4 types of tables based on how data is organized in storage: Ordinary (heap-organized) table - This is the basic, general purpose type of table. Its data is stored as an unordered collect... 2016-11-18, 9858👍, 1💬
How To Export Your Connection Information to a File
How To Export Your Connection Information to a File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer SQL Developer allows you to export your connection information into an XML file. Here is how to do this: Right-click on Connections Select Export Connection... Enter File Name as: \temp\conne... 2016-07-11, 31215👍, 1💬
How To Increment Dates by 1
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you want to increment it by 1. You can do this by adding the date with a date interval. You can also do this by adding the number 1 directly on the date. The tutorial example below shows you how to addin... 2016-07-06, 30628👍, 1💬
What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - Oracle DBA FAQ - Understanding SQL Basics Both CHAR and NCHAR are fixed length character data types. But they have the following differences: CHAR's size is specified in bytes by default. NCHAR's size is specified in characters by default. A charact... 2016-06-25, 5897👍, 0💬
Can you use both ADPATCH and OPATCH in application ?
Can you use both ADPATCH and OPATCH in application ? Yes you have to use both in application , for application patches you will use ADPATCH UTILITY and for applying database patch in application you will use opatch UTILITY. 2011-12-29, 3564👍, 0💬
What is difference between ADPATCH and OPATCH ?
What is difference between ADPATCH and OPATCH ? # ADPATCH is utility to apply ORACLE application Patches whereas # OPATCH is utility to apply database patches 2011-12-29, 6887👍, 0💬
How to compile JSP in Oracle Applications ?
How to compile JSP in Oracle Applications ? You can use ojspCompile.pl perl script shipped with Oracle Applications to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is perl ojspCompile.pl --compile --quiet 2011-12-28, 3443👍, 0💬
How to compile Invalid Objects in database ?
How to compile Invalid Objects in database ? You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects. 2011-12-28, 3313👍, 0💬
How will you find Invalid Objects in database ?
How will you find Invalid Objects in database ? using query SQLPLUS> select count(*) from dba_objects where status like 'INVALID'; 2011-12-27, 3192👍, 0💬
What is Web Listener ?
What is Web Listener ? Web Listener is Web Server listener which is listening for web Services(HTTP) request. This listener is started by adapcctl.sh and defined by directive (Listen, Port) in httpd.conf for Web Server. When you initially type request like http://becomeappsdba.blogspot. com:80to acc... 2011-12-27, 3283👍, 0💬
How to confirm if Apps Listener is Up and Running ?
How to confirm if Apps Listener is Up and Running ? execute below command lsnrctl status APPS_$SID (replcae SID with your Instance Name) so If your SID is VISION then use lsnrctl status APPS_VISION out put should be like Services Summary... FNDFS has 1 service handler(s) FNDSM has 1 service handler(... 2011-12-26, 3049👍, 0💬
How to start Applications listener ?
How to start Applications listener ? In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name) 2011-12-26, 3147👍, 0💬
What is use of Applications listener ?
What is use of Applications listener ? Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS and FNDSM. 2011-12-23, 3017👍, 0💬
What is difference between Rename and Alias?
What is difference between Rename and Alias? Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object. Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not... 2011-12-22, 4284👍, 0💬
What is difference between UNIQUE and PRIMARY KEY constraints?
What is difference between UNIQUE and PRIMARY KEY constraints? An UNIQUE key can have NULL whereas PRIMARY key is always not NOT NULL. Both bears unique values. 2011-12-22, 2911👍, 0💬
What is difference between SQL and SQL*PLUS?
What is difference between SQL and SQL*PLUS? SQL is the query language to manipulate the data from the database. SQL*PLUS is the tool that lets to use SQL to fetch and display the data. 2011-12-20, 3047👍, 0💬
What is difference between SUBSTR and INSTR?
What is difference between SUBSTR and INSTR? INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_le... 2011-12-19, 4079👍, 0💬
What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
What is difference between ICM, Standard Managers and CRM in Concurrent Manager ? # ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and try to restart them. You can say it as administrator to other concurrent managers. It has othe... 2011-12-19, 3100👍, 0💬
How to confirm if Report Server is Up and Running ?
How to confirm if Report Server is Up and Running ? Report Server is started by executable rwmts60 on concurrent manager Node and this file is under $ORACLE_HOME/bin .execute command on your server like ps -ef | grep rwmts60 You should get output like applmgr ....... rwmts60 name=REP60_VISION 2011-12-16, 2864👍, 0💬
Output and Logfiles for requests executed on source Instance not working on cloned Instance
Output and Logfiles for requests executed on source Instance not working on cloned Instance Here is exact problem description - You cloned an Oracle Apps Instance from PRODBOX to another box with Instance name say CLONEBOX on 1st of August. You can any CM logs/output files after 1st of August only b... 2011-12-16, 3150👍, 0💬
How to reduce the final size of an executable file? Size of the final execuatable can be reduced usi...
Assuming that the structure of a table shows two columns like this: --------+------------+-- ----+---...
What metrics will you look at in order to see the project is moving successfully? Most metric sets d...
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
How can we suppress a finalize method? GC.SuppressFinalize ()