Latest Answer: In UNIX u can use ps -ef|grep pmon or u can check oratab or listener file listner.oraIn Windows u can check servises for Oracle ...
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: The main advantage of using dictionary managed tablespaces is that in this we can give the size of the extents according to our need. We can modify extent size but in locally managed tablespace extents are of uniform size. ...
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: Bitmap index:------------A type of index that uses a string of bits to quickly locate rows in a table. Bitmap indexes are normally used to index low cardinality columns in a warehouse environment.Btree index:------------A type of index that ...
View page [1] 2 3 4 5 6 7 8 Next >>
Go Top
