Latest Answer: In Unix: ps -ef | grep pmon In Windows: You can check the database service is runnig or not. ...
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: The WRAP utility 'wraps', or hashes, the PL/SQL source code, but will not 'unwrap' it to restore the plain text starting point. Oracle can decipher this 'translation' internally, however to edit the code one must retain the ...
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: In dictionary managed tablespace the user can know aboout what is happening with tablespace because in this tablespace the extent management is manual. and user need to give the extent sizes. ...
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 Five Mandatory Background Processes in Oracle Architecture are as Follows:1.Database Writer(DBWR)2.Log Writer(LGWR)3.Check Point(CKPT)4.System Monitor(SMON)5.Processes Monitor(PMON) ...
Latest Answer: Other than the way they implemented, one of the functional difference is Bitmap index can index null values where as BTREE index cannot. ...
View page [1] 2 3 4 5 6 7 8 Next >>

Go Top