skip to main | skip to sidebar

PeopleSoft Helper

Reference codes used in PeopleSoft Projects

Saturday, May 24, 2014

Query to identify a table size in Oracle

SELECT segment_name,segment_type,bytes/1024/1024 MB
 FROM dba_segments
 WHERE segment_type='TABLE' AND segment_name='PS_BI_EXTRCT_LINE';
Posted by Arvin at 8:47 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Aravind's Blogs

  • ▼  2014 (12)
    • ▼  May (12)
      • Script for updating the vendor short name sequence...
      • Tree denoralization script for PeopleSoft trees --...
      • SQL to list out the records and fields in a People...
      • Multibyte characters related to peoplesoft in orac...
      • Oracle long running operations /sql in the database
      • Script to list out long running operations or sq...
      • Oracle PL/SQL script for reading a Long data colum...
      • PeopleSoft IB message transaction table names, /*...
      • Script to ask email ids in PeopleSoft FSCM financi...
      • Query to identify a table size in Oracle SELECT s...
      • -->provides navigation path of a componentSELECT a...
      • --provides PIA navigation path of a Component/fold...
  • ►  2013 (9)
    • ►  April (6)
    • ►  March (1)
    • ►  February (2)
  • ►  2012 (7)
    • ►  May (1)
    • ►  March (6)
  • ►  2011 (5)
    • ►  August (3)
    • ►  July (2)
  • ►  2008 (1)
    • ►  June (1)