-
How to do the scheduled task/jobs in Unix platform
Nandu
- Aug 11th, 2011
By using the command
crontabmatabrez
- Jan 15th, 2011
Using crontab we can schedule task/jobs to run at particular time, date, day basis. steps. 1. Login to unix 2. At $prompt 'crontab -l' use this command to check what jobs are already schedule...
-
Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why
rajesh_bu2001
- Aug 24th, 2009
Dual is a single row table in the system tablespace accessible to all the schema users. Selecting from the DUAL table is useful for computing a constant expression with the SELECT statement. Because D...
P.Sathe
- Jul 19th, 2006
You can issue "sysdate" from any table, but the result will be as many rows as your table , that you used.The whole idea behind using "DUAL" table is to meet the the criteria as defined by RDBMS , that you have to use "Select.. from" syntax to get the values from column.
-
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan
Kedar_Risbud
- Jun 23rd, 2009
Usually, whenever MORE THAN 2 to 4 % of rows in a table are going to be returned by a query, a full table scan is preferred over an indexed scan. So in this case, as 35% of rows of the table are accessed by the application, a full table scan will be used.
Surya Peri
- Feb 18th, 2007
Hi,15% of 100 million rows is still a lot of rows and would take lot of time if there is a full table scan.
-
-
Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
Sharath
- Jul 27th, 2011
You just validate it.. by using validate procedure and validate package commands.. ok don't worry
vaddapalli
- May 2nd, 2009
we can use the @?/rdbms/admin/utlrp.sqlThe below listed are the scripts that were executed to valid the DBMS_STAT on particular databses.@?/rdbms/admin/dbmsstat.sql@?/rdbms/admin/prvtstas.plb@?/rdbms/admin/prvtstat.plb
-
-
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B
Real time Oracle Interview Questions
Ans