Oracle Database Discussions

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!

tune x$dual statement

LEARNING_ORACLEDec 16 2006 — edited Jul 13 2007

Hi,

In top 5 sql statement of my database.This statement is there not sure how to tune this statuement.

SELECT to_char (sysdate, 'YYYY', 'NLS_CALENDAR=Gregorian'),
to_char (sysdate, 'MM', 'NLS_CALENDAR=Gregorian'),
to_char (sysdate, 'DD', 'NLS_CALENDAR=Gregorian')
FROM x$dual

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2007

Added on Dec 16 2006

#general-database-discussions

7 comments

661 views