What is a shared pool?
Answer / nishi
Memory area of oracle which consists of Library cache (recently executed sql and pl/sql statements) and Data Dictionary cache(recently used tables and indexes).
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the restrictions in a oracle read only transaction?
What happens to the current transaction if a ddl statement is executed?
How does the on-delete-cascade statement work?
Give the Types of modules in a form?
After using set unused can we enable the column again to use? Please give me some answers....
Can a Tablespace hold objects from different Schemes ?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to export your own schema?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to start an oracle instance?
What are the various types of snapshots ?
How can you merge two tables in oracle?