Tablespace Thresholds and Alerts
How to set tablespace thresholds?If you have very less no. of targets and you are using dbcontrol for each database, then use DBMS_SERVER_ALERT package to set. If you have OEM…
Read MoreOracle Online Redefinition
Oracle Online Redefinition When a table records fragmented, the select statement takes more I/O. Its causes a performance issue. Defragmentation help to increase the performance of…
Read MoreFind DBID in NOMOUNT Stage
How To Find DBID in NOMOUNT Stage Oracle database identifier in short DBID is an internal,unique identifier for an oracle database. Database administrator must note down the DBID…
Read MoreHow to Cancel a Concurrent Request Stuck in the Queue
Some times we get a Request from customers that they are not able to cancel their request because of the following error. “The concurrent manager process that was running this…
Read MoreHow to change Date & time in AIX.
smitty date # smitty date Change / Show Day and Time Type or select values in entry fields. Press Enter AFTER making all desired changes. …
Read MoreOracle License Calculations
To calculate/compare the user license according to application/responsibility. –In Details which user using which responsibility. SELECT fu.employee_id, fu.user_name, application_name, t.responsibility_name, wur.START_DATE responsibility_start_date, wur.EXPIRATION_DATE responsibility_end_date FROM…
Read More