As an organisation, Doyensys believes in pushing the boundaries and setting examples for others to follow. Our team of hard-working and talented Doyens is always willing to accept new challenges.…
Read MoreThe AUD$ table growth will impact the performance of database so we want to purge it regularly by using the DBMS_AUDIT_MGMT package Check AUD$ table is not in SYSTEM table tablespace.…
Read MoreSteps to move the Audit table from SYSTEM tablespace to newly created tablespace. • Audit trail tables called SYS.aud$ and SYS.fga_log$ keeps all Audit records in the Oracle database and…
Read MoreEXTERNAL USER CREATION External users and their authentication are managed by external services such as operating system or a network service. If our OS environment is secured, we can enable…
Read MoreCURSORS A cursor is a temporary work area created in the system memory when a SQL statement is executed. It can hold more than one row but can process only…
Read MoreWe can connect to another user without knowing the password, with grant connect through privilege In this case a user TEST1 wants to connect to TEST2 user and create a…
Read MoreCREATE PASSWORD FILE IN ASM DISK GROUP FOR ORACLE 12C ONLY ASMCMD> pwcreate –dbuniquename {db_unique_name} {file_path} {sys_password} ASMCMD> pwcreate –dbuniquename PRDPRE +DATA/PWDFILE/pwdPRDPREoracle FOR ALL VERSION orapwd file=’+DATA/orapwPRODPRE’ ENTRIES=10 DBUNIQUENAME=’PRODPRE’
Read MoreLIST ASM USERS ASMCMD> lspwusr Username sysdba sysoper sysasm SYS TRUE TRUE TRUE CRSUSER__ASM_001 TRUE FALSE TRUE ASMSNMP TRUE FALSE FALSE MODIFY USER PASSWORD ASMCMD> orapwusr –modify asmsnmp Enter password:…
Read MoreASM file can be copied to remote asm instance(diskgroup) using asmcmd command. SYNTAX asmcmd> cp – -port asm_port file_name remote_asm_user/remote_asm_pwd@remote_host:Instancce_name:TARGET ASM_PATH ASMCMD> cp –port 1521 s_srv_new21.dbf sys/oracle@172.20.17.69.+ASM1:+ARCL/s_srv_new21.dbf
Read Moreselect sql_id,object_owner,object_name from V$SQL_PLAN where operation=’TABLE ACCESS’ and options=’FULL’ and object_owner not in (‘SYS’,’SYSTEM’,’DBSNMP’);
Read More