Question : When I install MySQL via Yum, it automatically creates the mysql operating system user and group. Then mysqld […]
Tag: unix
Unlock user shell script for Oracle
Question : We have so many user ID locks from the front-end users. We need to provide a shell script […]
how can I divide log files for specific DB queries?
Question : Currently my db has a couple of triggers for some (not all) tables that get executed when a […]
How to get readonly access to mysql files via g+w permission 750 or 640?
Question : The data-dir itself has permissions 700 thereby limiting access to the mysql user. I want other folks who […]
Oracle’s UTL_FILE when connected locally or through listener has different behaviour
Question : We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4) […]
What limits the number of connections?
Question : As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server “Generally, PostgreSQL on good hardware can support […]
How to check if Oracle DB process is running in Unix and where Oracle DB is installed
Question : I am new to Unix and trying to find out a command that checks if Oracle DB is […]
which process has created a load spike on my server last week?
Question : O.S.:Linux MYSQL server we got a load spike last week. how can I find the process that has […]
How do you find home information for Oracle RAC on Unix?
Question : Need help finding Oracle home path corresponding to a database instance in RAC environment. I am aware of […]
Fetching wrong results on comparing a variable with 0 in unix
Question : I have the following code in unix #!/bin/bash user=$1 username=$user’%’ DB_name=$2 userpwd=$4 export PGPASSWORD=$3 psql -h localhost -U […]