Jump to content

madhusmita

Members
  • Content count

    8
  • Joined

  • Last visited

Community Reputation

0 Neutral

About madhusmita

  • Rank
    Newbie
  1. Can somebody please help to provide the steps for adding DB in 13c oem where the DB is present in WIndows server and 13cOEM in linux
  2. madhusmita

    Oracle Connection

    Any idea How data stage jobs get connected to the a ORACLE db/server through many other intermediate nodes? Which connection method used here? How the underlying configuration is? Any suggestion
  3. madhusmita

    Listener & database Services

    What is Listener & DB services in oracle 11.2.0.4, How it Behave as one node RAC? HOW the managed by oracle restart ? How to create them?
  4. madhusmita

    rollback session

    SELECT s.username, s.sid, s.serial#, t.used_ublk, t.used_urec, rs.segment_name, r.rssize, r.status FROM v$transaction t, v$session s, v$rollstat r, dba_rollback_segs rs WHERE s.saddr = t.ses_addr AND t.xidusn = r.usn AND rs.segment_id = t.xidusn ORDER BY t.used_ublk DESC / We can monitor the count of above underlined columns after killing the transaction...
  5. madhusmita

    rollback session

    found this script very helpful for the same SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 COLUMN username FORMAT A20 COLUMN sid FORMAT 9999 COLUMN serial# FORMAT 99999 SELECT s.username, s.sid, s.serial#, t.used_ublk, t.used_urec, rs.segment_name, r.rssize, r.status FROM v$transaction t, v$session s, v$rollstat r, dba_rollback_segs rs WHERE s.saddr = t.ses_addr AND t.xidusn = r.usn AND rs.segment_id = t.xidusn ORDER BY t.used_ublk DESC / if used undo_blk & used undo_record count is going down after killing the session that means it is doing roll back else if it is going up then the transaction is still active please do write if any other suggestion / also confirm if this is the correct way
  6. madhusmita

    Temp usage

    Hi All, today one of the user came back to us for the below issue : While he was trying to run a User query he got ora:06152 unable to extend temp segment *Checked current temp as usage as usual it shows current usage as 0MB is there any way to check " TEMP usage during the time user ran his query /which session was consuming how much temp space during that time"
  7. madhusmita

    rollback session

    How to find out if a session(UPDATE QUERY) is doing rollback after killing it with "ALTER SYSTEM SESSION KILL IMMEDIATE" command , which was causing lock on almost 35 other session ? Also how much rollback the session has to do? Any script for this?
  8. madhusmita

    Tivoli Configuration

    All our local server backups are sheduled from ADSM(Backup Server) & stored as tape backup. Can somebody help me to understand how the actual configuration is for Taking backup through TIVOLI? How can I check mount points to & storage capacity of backup server assigned to my local server?
×