"ORA-12801 ORA-32696 HTI NO FREE SLOT" ON PX

Hi,
(DB10.2.0.3.0, AIX5L)
I am reading by a SQL select statement from a parallel table.

I get "ORA-12801 ORA-32696 HTI NO FREE SLOT" and Metalink note says
288808.1
"Cause: There is not enough memory.
Action: Increase memory."

What memory should I increase? The docs and the net are quite mute
about the details of this error.

Regards,
Erik
.

Relevant Pages

  • Re: SQL Server 2000 Performance - 10K vs. 15K
    ... I've been reading a lot and have noticed that most everyone says that ... sql tries to read your entire database into memory. ...
    (microsoft.public.sqlserver.setup)
  • Re: FTS Performance in SQL 2005
    ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... Can you post you query plans and the output of statistics IO ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SBS 2003 SP2 Memory
    ... MY PF is up to 4.75GB and free Physical memory is at 1.8GB. ... about the SQL instances and watching their individual need over time. ... part if your server rarely uses the pagefile. ... each of them based on usage so watch their RAM usage for a week or more and ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL .mdf privacy violation - huge file contains personal contents
    ... The .NET runtime handles memory management ... ... in memory, archived to disk, but never deleted. ... them into temp files, which again, would be a privacy violation. ... SQL Server pre-allocates space for transaction logs, fill-space, etc. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Do I need to run SQL services
    ... Thanks for using the SBS newsgroup! ... high memory usage and especially the SQL service take up much memory. ... particular server installation. ...
    (microsoft.public.windows.server.sbs)