Database Administration (MOSC)

MOSC Banner

lsof shows files still open by checkpoint process after delete

edited Apr 27, 2016 5:04AM in Database Administration (MOSC) 10 commentsAnswered

Oracle 12.1.0.1.0. Linux x86-64.  In some cases when a PDB is dropped including datafiles the space is not released back to the system. lsof shows file as deleted and the checkpoint process still has the files allocated.

ora_ckpt_ 33992   dbpediw  515u      REG           199,2003     183508992      1960 /db/p/ediw/v4/system/EDIWP1/PPCNIN1507_system_01.dbf (deleted)

ora_ckpt_ 33992   dbpediw  516u      REG           199,2003     160964608      1979 /db/p/ediw/v4/system/EDIWP1/PPCNIN1507_sysaux_01.dbf (deleted)

ora_ckpt_ 33992   dbpediw  519u      REG           199,2003     786440192      1980 /db/p/ediw/v4/table/EDIWP1/PPCNIN1507_reference_ts_01.dbf (deleted)

ora_ckpt_ 33992   dbpediw  520u      REG           199,2003   18519236608      1984 /db/p/ediw/v4/table/EDIWP1/PPCNIN1507_cent_in_table_ts_1.dbf (deleted)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center