Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Difference between Count(1) Vs count(*)

538849Jan 29 2008 — edited Jan 29 2008
Hello,

Can Someone help me by letting me know that what is the difference between Count(*) and Count(1). I am quite confused with this.

Gursimran

Message was edited by:
Gursimran Singh

Comments

user8609728
Answer

Hi, I've hit the same problem, see

https://access.redhat.com/security/vulnerabilities/stackguard?sc_cid=70160000000gzltAAA&

To fix I changed the commonenv file found in middleware/bin to hash out this line

    #ulimit -S -s $EM_THREAD_STACK_SIZE

Marked as Answer by Praveen Alluri · Sep 27 2020
2 people found this helpful
Praveen Alluri

Than you very much.. This fixed my issue.

Appreciate your help on this,

Regards,

Praveen

user6707569

Ideed this is correct.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 26 2008
Added on Jan 29 2008
11 comments
21,866 views