Database performance can make or break your application's user experience. When your SQL queries are running slowly, users feel it immediately through sluggish page loads and unres…
https://www.youtube.com/watch?v=b2F-DItXtZs
SQL> select resource_name,limit from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME'; RESOURCE_NAME LIMIT -------------------------------- ----------…
EC_TO_TIME() returns a TIME, is constrained to the range of the TIME data type, and a warning occurs for arguments resulting in values outside of that range 1. Solution DROP FUNC…
1.1) DBA Group ~~~~~~~~~~~~~~ The 'DBA' group is chosen at installation time and is usually the group 'dba' by default. The DBA group is compiled into the 'oracle' executable and s…
0. /etc/sysctl.conf fs.suid_dumpable = 1 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 # semaphores: semmsl,…
SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'; Init File Type -------------------------------- SPFILE &n…
MyISAM table fix CHECK TABLE test_table; #CHECK TABLE test_table FAST QUICK; REPAIR TABLE table_name; Don't undervalue the backup of the to be repair table.
Oracle License SQL Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>…
shell> mysql -u username -p mysql> PURGE BINARY LOGS TO 'mysql-bin.000015'; Alternatively, you can remove the binary older than a specific date. shell> mysql -u username -…