Open my eyes so I may see 2 Kings 6:15-17 (KJV)
  15 And when the servant of the man of God was risen early, and gone forth, behold, an host compassed the city both with horses and chariots. And his servant said unto him, Alas, my master! how shall we do?
  16 And he answered, Fear not: for they that be with us are more than they that be with them.
  17 And Elisha prayed, and said, LORD, I pray thee, open his eyes, that he may see. And the LORD opened the eyes of the young man; and he saw: and, behold, the mountain was full of horses and chariots of fire round about Elisha.


Is this the result of the power of Elisha's prayer and/or is it possible that while on this earth, I will ever be able to see like this?
Two common metaphors used throughout scripture are that we are "blind" and that we are "dead." In both metaphors, the idea is that there are entire worlds and goings-on of which we are unaware.  Paul even combines both metaphors when he describes the Gospel as "veiled to those who are perishing."

Certainly, then, the normal course of events is that we are unaware of this.

That said, the power of the Gospel can be compared to "a blind man receiving back his sight."  This typically doesn't happen until the end, however, for as 1 Cor 13:12 says, "For now we see only a reflection as in a mirror [ed or "as in a glass, darkly"]; then we shall see face to face. Now I know in part; then I shall know fully, even as I am fully known..."

The point is that the supernatural part of Elijah's prayer wasn't that Elisha would see - but rather that he would see NOW as opposed to later.