Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ehtesham malik
Alter index index_name REBUILD COPMUTE STATISTICS
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you go about verifying the network name that the local_listener is currently using?
what is a crs resource?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the commands used in dcl? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how to restore files with rman?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a system database and what is a user database? : sql server DBA
