Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbx not working in Linux

user8356813Jan 19 2015 — edited Feb 4 2015

I am using RedHat 6.5 Linux

Linux version 2.6.32-431.el6.x86_64

I am using Oracle SolarisStudio12.3 to build my application and run in Linux machine.

Binaries are built as 32 bit which are deployed in 64 bit Linux OS.

I am getting the following error while using dbx on my binary:

[dncs@dncs dncs]$ /opt/oracle/solarisstudio12.3/bin/dbx -xexec32 bin/myapp

For information about new features see `help changes'

To remove this message, put `dbxenv suppress_startup_message 7.9' in your .dbxrc

Reading myapp

Reading ld-linux.so.2

dbx: fetch at 0xef40 failed -- Input/output error

dbx: warning: could not put in breakpoint

dbx: warning: internal handler (-80) made defunct -- could not enable event BPT

dbx: warning: internal handler (-86) made defunct -- could not enable event BPT

Let me know if you need more information on this issue.

Comments

Frank Kulash
Answer

Hi,
Whenever you have a question, please post a little sample data in a usable form (such as CREATE TABLE and INSERT statements), so the people who want to help you car re-create the problem and test their ideas. Also post the exact results you want from the given data, and an explanation (in general terms) of you get those results from that data. Always say which version of Oracle you're using (e.g. 12.2.0.1.0).
See: https://community.oracle.com/tech/apps-infra/kb/articles/4-how-to-ask-questions-in-developer-community-spaces
If col1, col2, col3, ... are NUMBER columns (or any kind of NUMBER expressions) you can find how many of them that are positive numbers like this:

CASE WHEN col1 > 0 THEN 1 ELSE 0 END +
CASE WHEN col2 > 0 THEN 1 ELSE 0 END +
CASE WHEN col3 > 0 THEN 1 ELSE 0 END ...

If all the expressions are 0 or greater (i.e. no NULLs or negative values) then you can use:

SIGN (col1) +
SIGN (col2) +
SIGN (col3) ...

You can reduce the amount of code by unpivoting the columns, but that will make the query slower. Which is more important in this case: concise code or performance?

Marked as Answer by Sainaa · Jan 27 2021
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 4 2015
Added on Jan 19 2015
3 comments
1,358 views