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?
2746Assuming 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.
2220How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
1 4873In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
2786Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
1964An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
1 5360What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
1 4600Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
2095Post New DB Administration Questions
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is a crs resource?
what is logical system in sap basis
what are the differences of where and if in SAS?
when does an alert gets signaled?
How can you control the amount of free space in your index pages? : sql server DBA
how can you initialize log miner?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
what are the benefits of flashback feature?
What authentication modes does sql server support? : sql server DBA
What is replication? : sql server DBA
what is the use of recording information about current session?
How to start SQL Server in minimal configuration mode?
What are the operating modes in which database mirroring runs? : sql server DBA