Error: ORA-00018 Maximum number of sessions exceeded

nolaegghead

 

Cause: All session state objects are in use.

Action: Increase the value of the SESSIONS initialization parameter.

nolaegghead

 

nolaegghead

 

nolaegghead

 

nolaegghead

 

Sardonicus

Sometimes, I miss smoking that stuff.

nolaegghead

Somehow, I ended up reading this tonight

http://eggheadforum.com/discussion/1191882/hear-ye-mortals-incredible-scientific-discovery-on-gravitational-waves-massively-weigh-in-here/p1

where @bhedges1987 totally fabricated a quote from Niel deGrasse Tyson and got busted, but denied it through not acknowledging his fraudulence (in his mind).  I think there were more troll/dislike/off-topic flags than the united nations.

Good times 

Why can't we just get along like them good ole days again?

nolaegghead

Source of thread subject, been working late developing stuff in Oracle.  I do process automation and efficiency development, which is a job killer.

SGH

nolaegghead said:
 which is a job killer. 

Sounds like Obingo 

nolaegghead

SGH said:

nolaegghead said:
 which is a job killer. 

Sounds like Obingo 

http://money.cnn.com/2016/12/02/news/economy/trump-obama-economy/

Get nekkid and dance!

RRP

Nola...when do you sleep and how much sleep do you get on the average night?

nolaegghead

not enough.  no sleep for the wicked.

5-6 hours weeknights, 8 plus weekends

RRP

5 to 6 recharge your battery enough to function during the day at work?

nolaegghead

Seems that too much sleep makes me lethargic.  And too little.  I'm a little weird.  There are sacrifices and trade-offs that I realize I don't fully appreciate.

But if I might ask, seems like you're a night owl, Ron.  How much sleep do you get?

Legume

I guess no answer tonight, maybe that's the answer.

Legume

Oops, forgot this    !

Eoin

nolaegghead said:

Source of thread subject, been working late developing stuff in Oracle.  I do process automation and efficiency development, which is a job killer.

Who said Americans don't get irony?

Sea2Ski

nolaegghead said:  I do process automation and efficiency development, which is a job killer. 

@nolaegghead is that what you really do? Can't tell with the vast diversity of things you are into. I know you know tech from other posts you have made, but am sincerely interested to know if that job is your primary occupation beyond surfing this forum.  

thetrim

nolaegghead said:

not enough.  no sleep for the wicked.

5-6 hours weeknights, 8 plus weekends

More than that at Brisket Camp

pgprescott

nolaegghead said:

SGH said:

nolaegghead said:
 which is a job killer. 

Sounds like Obingo 

http://money.cnn.com/2016/12/02/news/economy/trump-obama-economy/

Get nekkid and dance!

I don't expect the writer to know this, or ask simple grade school questions, but I expect you to know. 

Population on growth is @ 12 million net over 8 years. New jobs are below population growth. 
Nearly 93 million not working now. High water mark. Some are baby boomers, I know, you don't need to say. 

P.S. You being one of the smart guys around here, I am trying do some research and find the ideal temperature for the entire planet Earth as measured over the whole Earth throughout an individual year. Can you help as you are well read in this area?

JohnInCarolina

nolaegghead said:

Somehow, I ended up reading this tonight

http://eggheadforum.com/discussion/1191882/hear-ye-mortals-incredible-scientific-discovery-on-gravitational-waves-massively-weigh-in-here/p1

where @bhedges1987 totally fabricated a quote from Niel deGrasse Tyson and got busted, but denied it through not acknowledging his fraudulence (in his mind).  I think there were more troll/dislike/off-topic flags than the united nations.

Good times 

Why can't we just get along like them good ole days again?

That is a pretty epic thread.  In @bhedges1987 defense, I think he just got NdG Tyson confused with the guy who sells a metric ton of chicken every year.  Easy mistake to make, really.

JohnInCarolina

pgprescott said:

P.S. You being one of the smart guys around here, I am trying do some research and find the ideal temperature for the entire planet Earth as measured over the whole Earth throughout an individual year. Can you help as you are well read in this area?

To be clear, you're looking for an ideal mean surface temperature, right?  How are you quantifying "ideal" ?  I'm not sure your question is particularly well posed TBH.

nolaegghead

Sea2Ski said:

nolaegghead said:  I do process automation and efficiency development, which is a job killer. 

@nolaegghead is that what you really do? Can't tell with the vast diversity of things you are into. I know you know tech from other posts you have made, but am sincerely interested to know if that job is your primary occupation beyond surfing this forum.  

@Sea2Ski My only occupation.  Secondary unpaid is forum troll.  I'm a chemist that defected to IT about 20 years ago.  Me and a co-worker wrote a LIMS (laboratory information management system) long ago.  Currently I work for corporate IT as a database engineer/developer specializing in data warehouse operations, automation, lims and I write stuff in pl/sql for Oracle dbs.  I know the data, chemistry and math well (started off as a bench chemist).  Been working with the same group of people for 26 years.

RRP

nolaegghead said:

But if I might ask, seems like you're a night owl, Ron.  How much sleep do you get?

no - I'm not a night owl. I am a type 2 diabetic and plagued from time to time with neuropathy in my toes that wakes me and drives me nuts for hours. Last night I went to bed fine at 11:30, but was awaken at 1:00 with my toes throbbing like crazy. I laid there for nearly an hour trying to overcome it but no  luck so at 2:00 I got up. I got on the net here and then did some reading and finally went back to bed at 4:30. I had my alarm set for 9AM as my Westie needs a pill at that time. Though I got some sleep I'm sure from 4:30 to 9:00 I know I tossed and turned as my back is hurting as it dragged my tired butt out of bed. Some nights are better than others.

onedbguru

Sometimes people attempt too many connections causing this error. You can look at v$resource_limit to see what your current + max sessions/processes are. 

just curious, but what version of O?
(I don't use onedbguru as a handle for nothing...)

nolaegghead

onedbguru said:

Sometimes people attempt too many connections causing this error. You can look at v$resource_limit to see what your current + max sessions/processes are. 

just curious, but what version of O?
(I don't use onedbguru as a handle for nothing...)

I figured it meant one db guru long ago.

As far as Oracle dbs go, most of ours are 10g Release 10.2.0.5.0 - 64bit Production or 11g Release 11.2.0.3.0 - 64bit Production.  Some legacy archives are older, some devel/test are newer.  We probably have 40 Oracle systems.  Less than half are production.

DBA?  (I'm not a DBA).

pgprescott

JohnInCarolina said:

pgprescott said:

P.S. You being one of the smart guys around here, I am trying do some research and find the ideal temperature for the entire planet Earth as measured over the whole Earth throughout an individual year. Can you help as you are well read in this area?

To be clear, you're looking for an ideal mean surface temperature, right?  How are you quantifying "ideal" ?  I'm not sure your question is particularly well posed TBH.

Exactly. Now you are on to something. 

onedbguru

nolaegghead said:

onedbguru said:

Sometimes people attempt too many connections causing this error. You can look at v$resource_limit to see what your current + max sessions/processes are. 

just curious, but what version of O?
(I don't use onedbguru as a handle for nothing...)

I figured it meant one db guru long ago.

As far as Oracle dbs go, most of ours are 10g Release 10.2.0.5.0 - 64bit Production or 11g Release 11.2.0.3.0 - 64bit Production.  Some legacy archives are older, some devel/test are newer.  We probably have 40 Oracle systems.  Less than half are production.

DBA?  (I'm not a DBA).

Yes.  DBA/DBEngineer Principal Level Consultant (my company gets really big bucks for my services).   Sometimes tuning the queries can make a Uuuge difference in performance. 

I had to tune one query where they initially wanted it to execute once every hour. The query they put together would take > 2-3hrs to complete. I made a minor change to the table order and it now executes in < 2 minutes. It started out 10g (when I tuned it) -> 11g and now 12c. 

JohnInCarolina

pgprescott said:

JohnInCarolina said:

pgprescott said:

P.S. You being one of the smart guys around here, I am trying do some research and find the ideal temperature for the entire planet Earth as measured over the whole Earth throughout an individual year. Can you help as you are well read in this area?

To be clear, you're looking for an ideal mean surface temperature, right?  How are you quantifying "ideal" ?  I'm not sure your question is particularly well posed TBH.

Exactly. Now you are on to something. 

OK. Well, I'm not sure what you've been doing for research, but you might want to check out this text:

https://www.amazon.com/Global-Warming-Understanding-David-Archer/dp/1405140399

We use it in our introductory EOS courses here because it's accessible to a fairly broad audience.  I also personally like that it is written by one of my colleagues in computational science.  

nolaegghead

onedbguru said:

nolaegghead said:

onedbguru said:

Sometimes people attempt too many connections causing this error. You can look at v$resource_limit to see what your current + max sessions/processes are. 

just curious, but what version of O?
(I don't use onedbguru as a handle for nothing...)

I figured it meant one db guru long ago.

As far as Oracle dbs go, most of ours are 10g Release 10.2.0.5.0 - 64bit Production or 11g Release 11.2.0.3.0 - 64bit Production.  Some legacy archives are older, some devel/test are newer.  We probably have 40 Oracle systems.  Less than half are production.

DBA?  (I'm not a DBA).

Yes.  DBA/DBEngineer Principal Level Consultant (my company gets really big bucks for my services).   Sometimes tuning the queries can make a Uuuge difference in performance. 

I had to tune one query where they initially wanted it to execute once every hour. The query they put together would take > 2-3hrs to complete. I made a minor change to the table order and it now executes in < 2 minutes. It started out 10g (when I tuned it) -> 11g and now 12c. 

One of the main systems I work on (I was part of a small team that designed and built it about 10 years ago) is a data warehouse.  It aggregates *massive* amounts of data from labs all over the country.  This is a fairly typical problem that I work on (the DBAs ask me to fix these things).

But in our local transnational systems, it's also a problem as they are quite large.  Constant battle.

pgprescott

JohnInCarolina said:

pgprescott said:

JohnInCarolina said:

pgprescott said:

P.S. You being one of the smart guys around here, I am trying do some research and find the ideal temperature for the entire planet Earth as measured over the whole Earth throughout an individual year. Can you help as you are well read in this area?

To be clear, you're looking for an ideal mean surface temperature, right?  How are you quantifying "ideal" ?  I'm not sure your question is particularly well posed TBH.

Exactly. Now you are on to something. 

OK. Well, I'm not sure what you've been doing for research, but you might want to check out this text:

https://www.amazon.com/Global-Warming-Understanding-David-Archer/dp/1405140399

We use it in our introductory EOS courses here because it's accessible to a fairly broad audience.  I also personally like that it is written by one of my colleagues in computational science.  

My question is: What is the ideal temperature supposed to be? Is it what it is now? Is it 2 degrees cooler? Is it 5 degrees warmer? What is the correct, or ideal temperature supposed to be? Simple question. Me being less learned, I thought I would ask those more capable.