What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
2679Assuming 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.
2152How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
1 4788In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
2717Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
1905An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
1 5254What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
1 4516Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
2041Post New DB Administration Questions
What are the different ways you can create databases in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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?
how can you initialize log miner?
how can a session indicate its interest in receiving alerts?
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
Where do you find the default index fill factor and how to change it? : sql server DBA
what are the benefits of flashback feature?
How do you open a cluster administrator? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what is ora 24313?what is the procedure to exclude that error?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Explain materialized views and how they are used.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
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.