What are wait events. Describe the wait event tables.
Answer / surya
Many of these wait events are tied to the internal implementation of Oracle and therefore are subject to change or deletion without notice. Application developers should be aware of this and write their code to tolerate missing or extra wait events.
The following SQL statement displays an alphabetical list of all Oracle wait events and the wait class to which they belong:
SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;
|Is This Answer Correct ?||1 Yes||0 No|
What is the difference between anonymous block and named blocks?
please explain database architecture..
display null value rows with out using null function?
in procedure how to return a value
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
Can we write create command in the plsql block?if possible how?
how can create data base link for tow servers (scott schema) give examples plz
With out using count() function. How to the find total number of rows in a table?
when normalization is required
why not null constraint showing its constraint type as 'c'
What is the difference between the Primary and Foreign key?