Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / balu
exec dbms_stats.gather_table_stats('ownername','tablename')
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldn't FAST REFRESH?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
. 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?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What types of replication are supported in sql server? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is a system database and what is a user database? : sql server DBA
what is asm?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Why would you use sql agent? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
how can you enable flashback feature?
