From where does PMON gets the informance about failure? How is the user process terminited?
Latest Answer: When a user process fails or when it is killed, it then cleans up the cache and frees resources that the process used. PMON checks server processes and restarts them if they have failed. ...
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: Background process performs I/O operations in Oracle,they are used as medium between logical files and physical files ...
View page [1] 2 3 4 5 6 7 8 Next >>
Go Top
