Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 6524 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kumarayyalusamy
We will tune that query
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you process messages in order asynchronously?
what is a user-defined lock?
what are the types of connection load-balancing?
what is the diffrence between core dba and apps dba?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what are the performance views in an oracle rac environment?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
