Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4630 Views
- I also Faced
- E-Mail Answers
Answer Posted / sushant
It is just to check whether the query which we provide is
quiet simple n takes less time to compile as compared to
other querys !!!
Mostly its a DBA part !!
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between hot backup vs. Cold backup?
What are the varoius components of physical database structure of oracle database?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Is there any function in oracle similar like group_concat of mysql?
What is the usage of synonyms?
Explain a segment?
Why do we use bulk collect in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How can I get column names from a table in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to increment dates by 1 in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Give the various rollback segment states.
