https://www.zutshigroup.com/ Thu, 04 Jun 2026 17:46:26 +0000 FeedCreator 1.8 https://www.zutshigroup.com/_media/wiki/dokuwiki.svg https://www.zutshigroup.com/ https://www.zutshigroup.com/tech/rdbms/main?rev=1718985844&do=diff RDBMS rdbms index anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000 https://www.zutshigroup.com/tech/rdbms/mysql_hints?rev=1718985844&do=diff Quick mysql primer mysql connection test os> mysql -u root -p Password: <PASSWORD> mysql>use mysql mysql>show tables; mysql>select * from user mysql>exit Backup a database mysqldump --user=root --password=<PASSWORD> --database <DBNAME> > /backup/path/<DBNAME>.bkp anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000 https://www.zutshigroup.com/tech/rdbms/ora_dblinks?rev=1718985844&do=diff Oracle Database Links Create db link: create public database link <LINK_NAME> connect to <USER> identified by <PASS> using '<HOST>:<PORT>/<SID>'; Example: create public database link STAGE connect to STAGE identified by STAGE using 'aos.su.local:1521/AOS' anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000 https://www.zutshigroup.com/tech/rdbms/ora_invalid_objects?rev=1718985844&do=diff Oracle Invalid Objects Note: Run SQL below as SYS (connect as sysdba) Are there any invalid objects? select owner,object_type,object_name from dba_objects where status != 'VALID' order by owner, object_type; Rebuild all invalid PACKAGE/PACKAGE BODY etc. anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000 https://www.zutshigroup.com/tech/rdbms/ora_password_lifetime_unlimited?rev=1718985844&do=diff Set Oracle Profile PASSWORD_LIFE_TIME to "UNLIMITED" The SQL below is for the DEFAULT profile. Set PASSWORD_LIFE_TIME to UNLIMITED for Profile DEFAULT alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED; See all properties for profile select * from DBA_PROFILES where PROFILE = 'DEFAULT' anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000 https://www.zutshigroup.com/tech/rdbms/ora_stats?rev=1718985844&do=diff Oracle STATS (schema,table) Stats for a complete schema e.g. SYSADM BEGIN DBMS_STATS.GATHER_SCHEMA_STATS( OWNNAME => 'SYSADM', ESTIMATE_PERCENT => NULL, BLOCK_SAMPLE => FALSE, DEGREE => 32, GRANULARITY => 'ALL', CASCADE => TRUE ); END; / Stats for a table e.g. PS_R_PER507 anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000 https://www.zutshigroup.com/tech/rdbms/sp_change_users_login?rev=1718985844&do=diff SQL Server - "Managing database users and logins" In Microsoft SQL Server there are two forms of “User ID's”: * There is a SQL Server “Login” which aloows the user to connect to the SQL Server. This data is usually found under the “Security anonymous@undisclosed.example.com (Anonymous) Fri, 21 Jun 2024 16:04:04 +0000