Results 1 to 3 of 3

Thread: Exponential

  1. #1
    Join Date
    Jan 2011
    Posts
    32

    Talking Unanswered: Exponential

    Dear ALL

    hostname:XYZadm 1% ls -rlt /oracle/XYZ/cntrl1/cntrlXYZ.dbf
    -rw-r----- 1 oraXYZ dba 233914368 Jul 21 12:33 /oracle/XYZ/cntrl1/cntrlXYZ.dbf
    hostname:XYZadm 2% ls -rlt /oracle/XYZ/cntrl2/cntrlXYZ.dbf
    -rw-r----- 1 oraXYZ dba 150945792 Jul 21 12:33 /oracle/XYZ/cntrl2/cntrlXYZ.dbf
    hostname:XYZadm 3% ls -rlt /oracle/XYZ/cntrl3/cntrlXYZ.dbf
    -rw-r----- 1 oraXYZ dba 150945792 Jul 21 12:33 /oracle/XYZ/cntrl3/cntrlXYZ.dbf


    In our system , if you look at First location of control file which Grew more , compared to other locations .

    How to go about this ...Please Suggest

    Thanks in advance

  2. #2
    Join Date
    Jan 2011
    Posts
    32
    why only in first location , it grew ?

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Those are the wrong size for control files. I think that these are data files. Run the following select as a dba user to get the location of your control files

    SELECT NAME FROM SYS.V_$CONTROLFILE;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •