I once dated a flight attendant who had a very low tolerance to alcohol. One evening, while we were watching DVD's and eating Chinese food at her sister's house, she vanished. I couldn't find her anywhere. Eventually, I heard splashing from the bathtub in a dark bathroom. I entered and switched on the light.
"Oh, no! You have to turn out the sun," she slurred.
I flicked off the light and asked what she was doing?
She ignored the question.
"Trace. I'm glad you're a lifeguard."
"Why?" I asked.
"Because you won't let me drown. You won't let me drown, will you, Trace?"
That was after she drank half a glass of wine with dinner! I drank half the bottle and could still safely use a knife, operate the DVD player, and take care of her.
Now, hearing about that experience, someone might believe that wine is truly dangerous and should never be consumed. However, because we grow up surrounded by alcohol we know that most people can enjoy wine, beer, and other alcoholic beverages responsibly. Impairment begins with the first drink and in diving impairment begins as we descend.
The attitude a diver has toward narcosis will definitely affect how frightened or not the diver is of any intoxicated feeling. The tech diving community has pretty much decided that the "safe" range for open water narcotic impairment is between 130 feet and 180 feet on air from the Advanced Nitrox to the Extended Range certification levels. In cave diving 130 feet is considered the maximum acceptable narcotic depth due to the risks and complexities of the activity. There are also many factors that effect narcosis. I was diving without a hood in November in the St. Lawrence and got whacked by narcosis while on Nitrox 32 because of the cold on my unprotected noggin at 112 feet. A couple months ago, I dove air at 130 - 140 and could maintain vigilance for student safety in an advanced nitrox class in FL. Organizations like GUE and UTD manage narcosis by teaching their divers to use helium even inside "recreational" depths. I've had that training, but I've also had training in deep air diving from other agencies such as NACD, TDI, PDIC and PSAI.
The best way to "manage narcosis" is through knowledge, education and experience.
Here are four links to check out.
The first is a post I made regarding some perspective on attitude as it pertains to deep diving and narcosis and the Mount-Milner survey conducted by Tom Mount of IANTD and a psychologist, Dr. Milner in 1965:
http://www.scubaboard.com/forums/5198399-post196.html
The second is a 2003 post discussing the same thing by DA Aquamaster:
http://www.scubaboard.com/forums/355882-post10.html
Next, my friend Andy provides a link to a Brett Gilliam (founder of TDI) article about deep diving and narcosis:
http://www.scubaboard.com/forums/5774058-post38.html
Finally, this DAN article about anxiety while diving is really worth the read and again discusses attitude as it pertains to deep diving and narcosis:
DAN Divers Alert Network : Anxiety: Is It A Contraindication to Diving?