Forum Stats

  • 3,728,034 Users
  • 2,245,522 Discussions
  • 7,853,255 Comments

Discussions

query to check tablespace size and freespace

547581
547581 Member Posts: 48
hi experts
i am using oracle 9i .
want ot check freespace and size of tablespace could u plz tell me the query

thanks
varun
KenforceHarish VijayakumartjconsultPrabhakar Yantrosweetritz2681663icharlto -Oracle FMw SOA-Oracle2710549HectorEnriquezSanjayPatel2702980102666327769721062268DDGuptaTannuMedier_luoNishi KantSreenivasa SumanDear DBA FrankTrevorWJNorthSaraODan.A-Oracle92c2cc14-8d80-49f0-8478-cbc70d1a26dfcicaUser775647-Oracle28758632726274Sergey Klimov傅淼麟_ML1563666Bablu MondalWisam HuiziSantoshkumar Muddada-OraclemahfoozalamÜmit VarolRigoberto30129043014313frazlibrab51cb1ef-2a3a-482e-977c-b59fd4c070331b23ce78-ab0b-4702-a1fd-706be7ed70bePavan Kumar Goud NamuriMd. Budrul Hasan BhiuyangkayaSherpaSimonKalpataruThembaniPanagiotis S-OracleHolgerHCristinaM-Oracle3146298xeain33848271352489Nilesh GaurMd_Arshad_AliEvandro Lima-OracleJasdeep Kaurdba_since_7.23515652amadis

Comments

  • Nicolas Gasparotto
    Nicolas Gasparotto Member Posts: 25,514 Silver Crown
    Good point, but who does matter the free space of temp tbs ?

    Nicolas.
    cica3012904
  • 44863
    44863 Member Posts: 312
    It is about the size of DB.
    cica3012904
  • ViragSharma
    ViragSharma Member Posts: 2,325 Green Ribbon
    Thanks Nicolas,

    I use this script for monitoring purpose ( tablespace usage should not cross 90%)
    I never thought of this possibility/case, that tablespace can exists without any segments.

    Thanks once again

    Cheer,
    Virag
    cica
This discussion has been closed.