Home / Database Scripts / How to Find Database Object and it’s Corresponding Datafiles

How to Find Database Object and it’s Corresponding Datafiles

How to Find Database Object and it’s Corresponding Datafiles

SELECT DISTINCT t.ts#,
t.name                AS Tablespace_name,
d.name                AS DATAFILE,
s.owner,
s.segment_name,
s.segment_type,
s.bytes / 1024 / 1024 AS “MB”
FROM   v$tablespace t,
v$datafile d,
dba_segments s
WHERE  t.ts# = d.ts#
AND t.name = s.tablespace_name
AND s.owner = ‘APPS’;

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Application Report Queries

QUERY TO CHECK LIST OF RUNNING REQUEST

Leave a Reply