How would you best determine why your MVIEW couldn't FAST
REFRESH?
No Answer is Posted For this Question
Be the First to Post Answer
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
How do you open a cluster administrator? : sql server DBA
How will u copy the objects of one schema to another schema in datapump & export/import?
You're getting high "busy buffer waits" - how can you find what's causing it?
what are the performance views in an oracle rac environment?
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
Why would you call update statistics? : sql server DBA
Explain the difference between a data block, an extent and a segment.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What type of index should you use on a fact table?
which background process will run @ the time of creation of catalog database
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.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)