Dicas ORACLE DBA

 DECLARE    stat   BOOLEAN; BEGIN    DBMS_OUTPUT.DISABLE;    DBMS_OUTPUT.ENABLE (100000);    stat := fnd_profile.SAVE ('SITENAME', 'VALOR DESEJADO', 'SITE');    IF stat    THEN       DBMS_OUTPUT.put_line ('Stat = TRUE - profile updated');    ELSE       DBMS_OUTPUT.put_line ('Stat = FALSE - profile NOT updated');    END IF;    COMMIT; END;

Script: import os import weblogic.security.internal.SerializedSystemIni import weblogic.security.internal.encryption.ClearOrEncryptedService   def decryptString(domainPath, encryptedString):     es = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domainPath)     ces = weblogic.security.internal.encryption.ClearOrEncryptedService(es)     decryptedString = ces.decrypt(encryptedString)     print "=" * 40     print " " * 10 +"Decrypted Password:" + decryptedString     print "=" * 40   try:     os.system('clear')     if len(sys.argv) == 3:         decryptString(sys.argv[1], sys.argv[2])     else:         print "=" * 40         print "INVALID ARGUMENTS"         print "Usage: java weblogic.WLST %s <ABSOLUTE DOMAIN_HOME PATH> <ENCRYPTED_PASSWORD>" %sys.argv[0]       ...

  DECLARE   l_sql_tune_task_id  VARCHAR2(100); BEGIN   l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (                           sql_id      => '6x2xfudxngmmj',                           scope       => DBMS_SQLTUNE.scope_comprehensive,                           time_limit  => 1200,                           task_name   => '6x2xfudxngmmj_AWR_tuning_task',                           description => 'Tuning task for query 6x2xfudxngmmj in AWR.');   DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); END; / begin  DBMS_SQLTUNE.execute_tuning_task(task_name ...

Sometimes, we need to know wich users or groups is in a files structures on linux. It´s a simple hint, but for me is very useful for migrations, mainly in aplications migrations. To show owners (users): find . -printf '%u\n' | sort -t: -u To show group owners: find . -printf '%g\n' | sort -t: -u

Oracle Database 20c preview version available for virtual machine DB systems Services :  Database Release Date : Feb. 14, 2020 You can now provision a virtual machine DB system with Oracle 20c preview version software to do development and application testing. Preview version software is limited to virtual machine systems using the Fast Provisioning option (which uses Logical Volume Manager for storage management). For more information, see  Oracle Database Preview Version Availability . You must use Logical Volume Manage to show the 20c version option:

Caution: This command destroy ALL images and Containers. Recovery only possible if you have backed up properly. - Delete all containers docker rm $(docker ps -a -q) - Delete all images docker rmi $(docker images -q)

Oracle Data Modeler and Oracle SQL Developer does not allow to change the user interface language in “Options” or somewhere else in the GUI. This applies to the versions: Oracle SQL Developer Data Modeler - Version All and later (18.2.0 in my case) Oracle SQL Developer - Version 3.2 and later However, it’s possible switch to other language, changing datamodeler\ide\bin\ide.conf configuration file. The following lines should be added to the file for support English: AddVMOption -Duser.language=en AddVMOption -Duser.country=US Restart application! SQL Developer and Data Modeler supports the following languages: French(fr), German(de), Italian(it), Spanish(es), Brazilian Portuguese(pt BR), Japanese(ja), Korean(ko), Simplified Chinese(zh CN), Traditional Chinese(zh TW).