Welcome to the EGGhead Forum - a great place to visit and packed with tips and EGGspert advice! You can also join the conversation and get more information and amazing kamado recipes by following Big Green Egg to Experience our World of Flavor™ at:
Facebook  |  Twitter  |  Instagram  |  Pinterest  |  Youtube  |  Vimeo
Share your photos by tagging us and using the hashtag #BigGreenEgg.

Want to see how the EGG is made? Click to Watch

Error: ORA-00018 Maximum number of sessions exceeded

nolaegghead
nolaegghead Posts: 42,109
in EggHead Forum
 

Cause: All session state objects are in use.

Action: Increase the value of the SESSIONS initialization parameter.


______________________________________________
I love lamp..
· Share on FacebookShare on Twitter
«13

Comments

  • nolaegghead
    nolaegghead Posts: 42,109
     
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
     
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
     
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
     
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • Sardonicus
    Sardonicus Posts: 1,700

    Sometimes, I miss smoking that stuff.

    "Too bad all the people who know how to run the country are busy driving cabs and barbecuing."      - George Burns

    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    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?

    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    Source of thread subject, been working late developing stuff in Oracle.  I do process automation and efficiency development, which is a job killer.
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • SGH
    SGH Posts: 28,988
    nolaegghead said:
     which is a job killer. 
    Sounds like Obingo  =)

    Location- Just "this side" of Biloxi, Ms.

    Status- Standing by.

    The greatest barrier against all wisdom, the stronghold against knowledge itself, is the single thought, in ones mind, that they already have it all figured out. 

    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    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 love lamp..
    · Share on FacebookShare on Twitter
  • RRP
    RRP Posts: 26,451
    Nola...when do you sleep and how much sleep do you get on the average night?
    Re-gasketing the USA one yard at a time 
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    not enough.  no sleep for the wicked. ;)

    5-6 hours weeknights, 8 plus weekends
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • RRP
    RRP Posts: 26,451
    5 to 6 recharge your battery enough to function during the day at work?
    Re-gasketing the USA one yard at a time 
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    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?
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • Legume
    Legume Posts: 15,936
    I guess no answer tonight, maybe that's the answer.
    THANK YOU FOR YOUR ATTENTION TO THIS MATTER
    · Share on FacebookShare on Twitter
  • Legume
    Legume Posts: 15,936
    Oops, forgot this    !
    THANK YOU FOR YOUR ATTENTION TO THIS MATTER
    · Share on FacebookShare on Twitter
  • Eoin
    Eoin Posts: 4,304
    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?
    · Share on FacebookShare on Twitter
  • Sea2Ski
    Sea2Ski Posts: 4,131
    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.  
    --------------------------------------------------
    Burning lump in Downingtown, PA or diesel in Cape May, NJ.
    ....just look for the smoke!
    Large and MiniMax
    --------------------------------------------------

    Caliking said:   Meat in bung is my favorite. 
    · Share on FacebookShare on Twitter
  • thetrim
    thetrim Posts: 11,387
    nolaegghead said:
    not enough.  no sleep for the wicked. ;)

    5-6 hours weeknights, 8 plus weekends
    More than that at Brisket Camp
    =======================================
    XL 6/06, Mini 6/12, L 10/12, Mini #2 12/14 MiniMax 3/16 Large #2 11/20 Legacy from my FIL - RIP PitBoss Navigator 850G 11/25
    Tampa Bay, FL
    EIB 6 Oct 95
    · Share on FacebookShare on Twitter
  • pgprescott
    pgprescott Posts: 14,544
    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?
    · Share on FacebookShare on Twitter
  • JohnInCarolina
    JohnInCarolina Posts: 34,682
    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.
    "I've made a note never to piss you two off." - Stike

    "The truth is, these are not very bright guys, and things got out of hand." - Deep Throat
    · Share on FacebookShare on Twitter
  • JohnInCarolina
    JohnInCarolina Posts: 34,682
    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.
    "I've made a note never to piss you two off." - Stike

    "The truth is, these are not very bright guys, and things got out of hand." - Deep Throat
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    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.
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • RRP
    RRP Posts: 26,451
    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.
    Re-gasketing the USA one yard at a time 
    · Share on FacebookShare on Twitter
  • onedbguru
    onedbguru Posts: 1,648
    edited December 2016
    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...)
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    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).



    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • pgprescott
    pgprescott Posts: 14,544
    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. 
    · Share on FacebookShare on Twitter
  • onedbguru
    onedbguru Posts: 1,648
    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. 


    · Share on FacebookShare on Twitter
  • JohnInCarolina
    JohnInCarolina Posts: 34,682
    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.  
    "I've made a note never to piss you two off." - Stike

    "The truth is, these are not very bright guys, and things got out of hand." - Deep Throat
    · Share on FacebookShare on Twitter
  • nolaegghead
    nolaegghead Posts: 42,109
    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.
    ______________________________________________
    I love lamp..
    · Share on FacebookShare on Twitter
  • pgprescott
    pgprescott Posts: 14,544
    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.
    · Share on FacebookShare on Twitter

Categories