6 responses

  1. Kent Graziano
    April 14, 2014

    But wait Jeff, I get an error when I try to look at the tablespaces…

    Oh yea, my user access does not have DBA privileges (probably a good thing).

    No doubt this question will come up – what exact privileges does one need to even see the tablespace definitions?

    • thatjeffsmith
      thatjeffsmith
      April 14, 2014

      At minimum you need access to the dba_ views like dba_data_files and dba_tablespaces.

      We assume if you’re in the DBA panel, that you are indeed a DBA (with the DBA role)

  2. Danilo Piazzalunga
    April 15, 2014

    Excellent! Tools support for DBA features is great for learning.

    • thatjeffsmith
      thatjeffsmith
      April 15, 2014

      I’m glad you like it, thanks for sharing your experience here!

  3. Sam
    April 17, 2014

    Hi Jeff, I love your posts. I posted this on the sqldeveloper forum also, but when I click on the chart tab I get a “The data is zero” message. I’m in as a dba and there is definitely data in the tablespaces. sqldeveloper is 4.0.1 and the databases are 10g and 11g.
    Thanks in advance
    Sam

    • thatjeffsmith
      thatjeffsmith
      April 21, 2014

      What do you get when you run this?

      SELECT tablespace_name,
        owner,
        ROUND(SUM(bytes/1024/1024),3)
      FROM dba_extents
      WHERE tablespace_name = :OBJECT_NAME
      GROUP BY tablespace_name,
        owner
      

Leave a Reply

 

 

 

Back to top
mobile desktop