Latest Answer: Unix does provide the command nice [increment] command to lower a priority of a process.
As system administrator you can use the renice command to change the priority of a process, all processes of a user, or all processes belong to a group of users. ...
Latest Answer: Type the following command in the shell promptTo force killkill -9 for normal killkill ...
What is stored in Oratab file
Latest Answer: This file is used by ORACLE utilities. It is created by root.sh and updated by the Database Configuration Assistant when creating a database.A colon, ':', is used as the field terminator. A new line terminates the entry. Lines ...
how do you remove memory segments
Latest Answer: To see the Oracle memory segments from UNIX write ipcsthen look at the status column, the one with status is empty and owner is oraclewrite down the shmid, ex: 2 find 2 shmid 123 and 456 in order to startup the database without having to reboot the ...
How do you see how many memory segments are acquired by Oracle Instance.
Latest Answer: For shared memory segmets in UNIX or LINUX:-->In HOST1_LINUX has one instance $ ipcs -m oracle@HOST1_LINUX:$ ipcs -m------ Shared Memory Segments --------key shmid ...
How do you see how many memory segments are acquired by Oracle Instance.
Latest Answer: Check on x$bh it show you what objects are in the buffer.Try this query;SELECT /*+ ordered use_hash(o) use_hash(bh) */ bp.NAME BUFFER_POOL, u.NAME owner, so.object_type segment_type, ...
What is OERR Utility
Latest Answer: OERR Utility is an Oracle error lookup utility in UNIX environment. ...
How many max datafiles can there be in an Oracle Database.
Latest Answer: Look, A single Oracle database can have max of 1022 of datafile in case of small file tablespace, and only one datafile in case of Bfile tablespace. ...
How do you control No. of Datafiles one can have in an Oracle Database.
Latest Answer: At creation time you can set up the maximun numer of datafiles.CREATE DATABASE .....MAXDATAFILES 500If you want to check it:select * from V$CONTROLFILE_RECORD_SECTION where type ='DATAFILE';If you want to increase it, you have to recreate ...
How to write script for export backup in shell.
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
