Soban.dba

On Running a huge database backup we often need to know the status of backup. 1) How much backup is taken. 2) How much is remain. 3) Estimate time to complete the backup. After lot of search i find out this amazing query below. col dbsize_mbytes for 99,999,990.00 justify right head "DBSIZE_MB" col input_mbytes for 99,999,990.00 justify right head "READ_MB" col output_mbytes for 99,999,990.00 justify right head "WRITTEN_MB" col output_device_type for a10 justify left head "DEVICE" col complete for 990.00 justify right head "COMPLETE %" col compression for 990.00 justify right head "COMPRESS|% ORIG" col est_complete for a20 head "ESTIMATED COMPLETION" col recid for 9999999 head "ID" select recid , output_device_type , dbsize_mbytes , input_bytes/1024/1024 input_mbytes , output_bytes/1024/1...

Finding Package running behind a concurrent request SystemAdministrator>concurrent>Program>define>Search Search for the concurrent request Ok Copy Executable name Systemadministrator>concurrnet>Program>Executable Enter <F11> Paste in executable field Enter <Ctrl+F11> Executable File Name is the name of Package Regards Soban Ali

What is the SQL Tuning Health-Check Script (SQLHC)? The SQL Tuning Health-Check Script is a tool developed by the Oracle Server Technologies Center of Expertise. The tool, also known as SQLHC, is used to check the environment in which a single SQL Statement runs, checking Cost-based Optimizer (CBO) statistics, schema object metadata, configuration parameters and other elements that may influence the performance of the one SQL being analyzed. INSTRUCTIONS Login to the database server and set the environment used by the Database Instance Download the "sqlhc.zip" archive file  and extract the contents to a suitable directory/folder Connect into SQL*Plus as SYS, a DBA account, or a user with access to Data Dictionary views and simply execute the "sqlhc.sql" script. It will request to enter two parameters: Oracle Pack License ( T uning,  D iagnostics or  N one) [T|D|N] (required) If site has both Tuning and Diagnostics licenses then specify  T  (Or...

Option 1: Configure From Front end: The Override Address is set after the clone is completed as it will be set in OAM. Oracle Workflow sends the Notification Mailer Override Address Verification message when an administrator sets an override address where the notification mailer should send all outgoing e-mail notifications for testing purposes. It can be set as follows: 1. To setup Test Override please do the following: a. Please log in to OAM. b. Select Workflow Manager from "Navigate to" LOV and click "GO". c. Click "Notification Mailers". d. Click "View Details". e. Click "Set Override Address". f. Populate "New Override Address" with a Test address and click "Submit". g. Populate the verification code that appears in the email notification that was sent to the 'Override Address' and click "APPLY". Example: Verification Code: 896424928 h. Conformation of the change will be prov...

Hi, To apply the solution, simply log in to application Tier and run the enviroment and change in below file Edit file  $ORACLE_HOME/guicommon/tk/admin/uifont.ali  After line  [ PDF ]  Add line--  Symbol = Arial  Regards Soban Ali

1) Enable Trace of a concurrent request: Please enable trace on the concurrent program using the following steps:   Go to Sysadmin > Concurrent > Program > Define   Query the concurrent program   Check the trace box to enable trace   2) Fatching the trace file location: The following query helps to identify the Trace file path location for a particular Concurrent Request Pass the request id as parameter   SQL Code: SELECT     req . request_id       , req . logfile_node_name node       , req . oracle_Process_id       , req . enable_trace       , dest . VALUE || '/' || LOWER ( dbnm . VALUE ) || '_ora_' || oracle_process_id || '.trc'   trace_filename       , prog . user_concurrent_program_name       , execname . execution_file_name       , execname . subroutine_name       , phase_code       , statu...