What is the difference between Cost Based Optimizer and Rule Based Optimizer?(CBO is the default optimizer)
Latest Answer: In brief the rule-based method means that when executing a query the database must follow certain predefined rules and matter what data is stored in affected database tables. The cost-based method means the database must decide which query execution plan ...
Latest Answer: Failover: Primary fails and standby is made primary.Switchover: Primary and secondary interchanges the role.Effectively, in both cases, standby becomes primary, main difference is, when failover happens, it means there is something wrong at primary site, ...
While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time?
Latest Answer: .bash_profile has to set at OS level before connecting to oracle database. ...
What is the difference between Cloning and Standby databases?
Latest Answer: Cloning is nothing but the copy of your database which can be open in read write mode. The standby database is also a copy of your database which is in standby mode and which is made in sink with production database by applying the redo log generated ...
How to assign an index tablespace for a database permanently, so that whatever indexes we are creating in the database, should automatically goes to that tablespace i.e. we neednot supply the tablespace
Latest Answer: There is no such provision in oracle to have default index tablespace. Workaround is- you can have a job which will scan for indexes in other tablespaces and rebuild into desired one. ...
Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations
Latest Answer: Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such. ...
What is the most important action a DBA must perform after changing the database from NOARCHIVELOG TO ARCHIVELOG ?
Latest Answer: It depends on your requirement, if you want no of users around 300 then you can still achieve that by keeping PGA parameters low. If you are looking for number of users 1000 or even more, you need to go for shared server mode. ...
Latest Answer: run this query in the sql promptsql> select tablespace_name,file_name from dba_data_files; ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
