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 to restore files with rman?
how can you create a user-defined lock?
How do you trace the traffic hitting a sql server? : sql server DBA
what are the differences of where and if in SAS?
What is the default port no on which sql server listens? : sql server DBA
Can you redefine a table online?
internal architecture
What types of replication are supported in sql server? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
how can you find out if a table can be redefined?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you connect from 10g user to 11g user??
What authentication modes does sql server support? : sql server DBA
