Skip to content

Instantly share code, notes, and snippets.

@amitzilblog

amitzilblog/find_segment.sql Secret

Created April 13, 2016 03:26
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save amitzilblog/7ad209d6cf51aeef872a57823b35b3fd to your computer and use it in GitHub Desktop.
Save amitzilblog/7ad209d6cf51aeef872a57823b35b3fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
find_segment.sql
select owner,segment_type,segment_name
from dba_extents
where file_id=&file_number
and &block_number between block_id and block_id+blocks-1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment