What 90s song has a really high pitched woman singing?

The song you are referring to is "Dreams" by The Cranberries. The lead singer, Dolores O'Riordan, has a distinct and powerful high-pitched voice that is a prominent feature of the song. "Dreams" was released in 1993 and became a global hit, reaching number one in several countries and becoming one of the most successful songs of the 1990s.