It is a two's complement overflow, and I use this SQL snippet to get valid values. I get the value, a MB value and the real number in case there is some confusion.
CASE
WHEN to_number(t.data_byte_count) < 0 THEN
power(2, 32) + to_number(t.data_byte_count) + 1
ELSE
to_number(t.data_byte_count)
END data_byte_count,
CASE
WHEN t.data_byte_count < 0 THEN
round((power(2, 32) + t.data_byte_count + 1) / power(1024, 2), 4)
ELSE
round(t.data_byte_count / power(1024, 2), 4)
END data_byte_count_mb,
t.data_byte_count AS data_byte_count_neg,
Thanks,
Ed Lipson
Director
BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217
Information Lifecycle Management
T 718.315.4763 | F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com
The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.
Please refer to
https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of
www.bnymellon.com.