how to find indexes on a table in oracle

Last updated on July 10th, 2019 at 04:11 amIt is very common that you want to Find indexes status and assigned columns for a oracle table And also you sometime want to know the columns which are assigned to the indexes. Following views would be helpful in these cases and to find indexes on a table in oracle dba_ind_columns all_ind_columns Query to Find the indexes … Continue reading how to find indexes on a table in oracle »

How to resolve ORA-29913 with external tables

Last updated on July 10th, 2019 at 05:22 amORA-29913 is one of the common error when working with external tables in Oracle database. We would be looking at various ways the error can be produced and what can be done to resolve the error External File not found or permission incorrect SQL> select * from Scott.example_external_table; select * from example_external_table * ERROR at line 1: … Continue reading How to resolve ORA-29913 with external tables »

Top 30 Most Useful Concurrent Manager Queries

Last updated on August 6th, 2019 at 04:06 am What are Concurrent Managers Concurrent Managers are the controllers of background processing for Oracle Applications. The main function of Concurrent Managers is to regulate and control process requests based upon a set of rules. It is a technique used to execute non interactive, data-dependent programs simultaneously in the background. Oracle Applications comes with predefined managers, including … Continue reading Top 30 Most Useful Concurrent Manager Queries »

Alert log file in Oracle And command to check for ORA error and startup time

What is alert log file in Oracle The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions. Oracle will automatically create a new alert … Continue reading Alert log file in Oracle And command to check for ORA error and startup time »

Performance Lesson :What is a Bind Variable

Last updated on July 1st, 2019 at 04:36 amWhat is a Bind Variable? -It is a placeholder for a value .It is replaced by actual value when the SQL statement is executed -In PL/SQL it is called a local or global variable. DECLARE l_empl_id DEPT.emp_id%TYPE; BEGIN select first_name  from DEPT  where id = l_empl_id; END; -in SQL*Plus it is a variable variable a number BEGIN :a … Continue reading Performance Lesson :What is a Bind Variable »

How to use grep command in Unix and Linux with examples

grep command Means – globally search regular expression. It is very useful while searching for strings in Unix  and Linux operating system. Here we would be taking  a look on grep command in Unix with examples,Linux grep examples,grep command options,egrep command in Unix How to use grep command in Unix The grep utility searches text file.txt for a pattern and prints all lines that contain … Continue reading How to use grep command in Unix and Linux with examples »

Python Tutor Help: Get Excellent Quality of Any Technical Task

Python is a general purpose programming language. It is also a high level programming language, which allows a wide range of applications. Python is good for desktop GUI applications, websites, and other online applications. Python is very easy to learn. After a few lessons, beginners can write functional code.  In fact, many experts recommend learning Python as a first programming language. Python offers the best … Continue reading Python Tutor Help: Get Excellent Quality of Any Technical Task »

How to resolve ORA-00904: invalid identifier

Last updated on July 10th, 2019 at 05:22 amORA-00904: invalid identifier is one of the common error seen. You might get creating tables, selecting from tables and many more. It most happens because of the syntax issue. We have to be very careful with the syntax. The key is to remember syntax and write the code  correctly. You might want to check the Sql tutorials … Continue reading How to resolve ORA-00904: invalid identifier »

How to check if Port pool is free in Oracle applications R12

Last updated on June 28th, 2019 at 03:02 amWhat is Port Pool? Oracle Applications 11i/R12.0/R12.1/R12.2 uses the concept of a port pool. A port pool is a preconfigured set of unique port assignments for every E-Business Suite technology stack component that requires network connectivity. So multiple Release 12 environments can coexists on the same machine,provided  you have  configured each of them to use a different … Continue reading How to check if Port pool is free in Oracle applications R12 »

Top 40 Oracle Interview questions : Basics , Oracle SQL

Last updated on July 18th, 2019 at 04:00 amThis article contains Top 40 Oracle Interview questions : Basics , Oracle SQL asked in various interview. I hope it should help in interviews Question 1.  What is a table Cluster ? Answer: Table Cluster is a group of related tables that share common columns are store related data in the same block. Question 2. What is exists … Continue reading Top 40 Oracle Interview questions : Basics , Oracle SQL »

How to find table where statistics are locked

Last updated on June 16th, 2019 at 07:39 pmStatistics played in key role for Oracle performance tuning. Optimizer creates the execution plan based on the statistics of the oracle table involved in the Sql queries. You may want to lock statistics in a oracle table in some cases, for example a)   you don’t want a table to be analyzed by schedule  statistics job but want … Continue reading How to find table where statistics are locked »