Question ::A user selects from a sequence and gets back two values, his select is: SELECT pk_seq.nextval FROM dual; What is the problem?

:: Home :: Add Questions

Question :: A user selects from a sequence and gets back two values, his select is: SELECT pk_seq.nextval FROM dual; What is the problem?

Post Answer

Tags

Answers to ""

: Run the ANALYZE INDEX command on the index to validate its structure and then calculate the ratio of LF_BLK_LEN/LF_BLK_LEN+BR_BLK_LEN and if it isn?t near 1.0 (i.e. greater than 0.7 or so) then the index should be rebuilt. Or if the ratio BR_BLK_LEN/ LF_BLK_LEN+BR_BLK_LEN is nearing 0.3.

Related Questions