Unlike older releases, Oracle11g sets password expiry by DEFAULT. Get rid of these with:
SQL> alter profile default limit
failed_login_attempts unlimited
password_life_time unlimited;
20 June 2011
6 June 2011
PostgreSQL - Calculating DB size
SQL> select pg_size_pretty(pg_database_size(current_database())) as dbsize
Subscribe to:
Comments (Atom)
Wordpress - Local installation in Vmware
If you're interested in exploring website design with WordPress, this guide will help you set up a WordPress instance on your local mach...
-
[Tested On] CentOS Linux release 7.4.1708 (Core) # wget https://ftp.postgresql.org/pub/source/v9.6.6/postgresql-9.6.6.tar.gz # tar xvzf post...
-
To print single column from a text file #awk -F: '{print $1}' /etc/passwd To print multiple columns from a text file # awk -F: '...
-
# enq -sAW # ps -eaf | grep {queue name} # kill -9 {queue name} # cd /var/spool/lpd/qdir # remove all queues # cd /var/spool/lpd/stat # remo...