What kind of backup you take Physical / Logical? Which one is better and Why?
Latest Answer: Logical backup means backing up the individual database objects such as tables, views , indexes.. using the utility called EXPORT, provided by Oracle. The objects exported in this way can be imported into either same database or into any other database. ...
What is your datafile size? How long it can go? What is the max limit to which you can extend?
Latest Answer: v$datafile data dictionary view will tell us the size of a datafile.to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.you can also resize the datafile ...
You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?
Latest Answer: COMPRESSION =(METADATA_ONLY | NONE) - This parameter applies from Oracle 10.2. It specifies whether to compress metadata before writing to the dump file set. Compression reduces the amount of disk space consumed by dump files.To convert from 2 GB to 1 ...
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
Latest Answer: Is the meomory that is allocated to each connection to Oracle, this memory is not recliamed even if the session is inactiveit is recliamed if the session is disconnected onlyto see it:D:appadminproduct11.1.0db11gBINorastack oracle.exe to change it to ...
Can we create as many tablespace as we require. What is the limit? What is the default size of tablespace? (System and User tablespace). Mention name of some tablespace.
Latest Answer: Default size for tablespace: 51276 kb ...
How you spend a day as a DBA. Explain DBA activities in detail.
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 ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
