From where does PMON gets the informance about failure? How is the user process terminited?
Latest Answer: When user process is terminated abruptly due to power cut or any other factors then oracle database instance goes down then PMON mandatory background process is activated i.e it will then writes the commited data into respective datafiles which we can ...
Latest Answer: select name as "DB Name" from v$database;select global_name from global_name;select ora_database_name from dual; ...
How will you identify database size when you create a database first time?
Latest Answer: in Addition you can also use:select sum(bytes/1024/1024/1024) from dba_extents;Reg,Vikash ...
what is remote login user and local user in database?And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..What does it mean ?
Latest Answer: When you have distributed environment,you may access one database from other.This is normally done via db link.So lets say you have flight database and customer dabatabase.Now from customer database you intend to access flight database then you ...
Here i'm sending all of you the error which occurred frequently during database connection.While creating a data block in Oracle Forms, the error which encountered frequently is "ORA-12560: TNS
Latest Answer: dude ur databse is not running...right click on my compiuter>manage>services& applictaions(on right side)>services>oracle_databse_name(the datasbe that ur trying to start) --> restart the service...will ...
Latest Answer: DBMS_OBFUSCATION_TOOLKIT package is a simple API for data encryption ...
Latest Answer: The server process modifies the db buffer cache. DBWn only writes the data from DBBC to datafiles. It does not modify the database buffer cache. ...
Latest Answer: All Extent info is maintained in Dictionary which is infact a dis-advantage, Also in case of a huge insert operation undo is generated. ...
Latest Answer: Just in simple words.....Ora01555 error occurs when a transation fails when it cannot able to find read consistence image in rollback segment. To solve this problem: Increse the Undo_RetentionCheers :) ...
Latest Answer: The background process in the Oracle which will dump the system and sysaux data files in to their respective directories before going to start the database. There are mandatory and optional backgroung process are presented in the oracle 10g. The mandatory ...
View page [1] 2 3 4 5 6 7 8 Next >>
Go Top
