Recursively check ownership of all files

find files in a folder and their user permission other than oracle

find <<Starting search location>> -not -user oracle -printf "%p %u\n"

find files in a folder and thier group permission other than oinstall

find <<Starting search location>>  -not -user oinstall -printf "%p %u\n" 

Display Sender Name in oracle apex mail

You can display send name using oracle apex_email

 apex_mail.send(
                p_from => "Sender Display Name"<fromemailaddress>

don't enter space after the sender display name double quotes(") and from email address less than symbol (<)

List users with DBA privilege

Which users having dba provilege assigned, query dba_role_privs in the SYS schema

SQL>  select * from dba_role_privs where granted_role='DBA';

Rebuild UNUSABLE Partition Indexes

Validate and generate rebuild script for partition indexes

Select 'ALTER INDEX '||INDEX_OWNER||'.'||index_name ||' rebuild partition ' || PARTITION_NAME ||';'  from DBA_IND_PARTITIONS Where  status = 'UNUSABLE'

How to disable CC Direct Manager functionality in Expenses Workflow

1. Open the wft file and double click on 'IS_MANAGER_IN_THE_APPR_PROCESS'.
2. Click on the Node Attributes and here we have an attribute named 'CC Direct Manager Notification'.
3. Please update the value to No, save the workflow file to the database.
4. Bounce the workflow listeners as well as apache.