How do you increase the OS limitation for open files (LINUX
and/or Solaris)?
Answer Posted / braj123
changing the value
$cat /proc/sys/fs/file_max
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you trace the traffic hitting a sql server? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What happens on checkpoint? : sql server DBA
how can you process messages in order asynchronously?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how to restore files with rman?