Alas, I didn't save the sa_conn_info() output, but I recently saw several consecutive connection numbers in 1000000xxx range on a 11.0.1 database, started five days earlier, with no activity since the period just after they were started. No identifying information at all. Probably not events or web services.

asked 21 Sep '10, 18:02

Breck%20Carter's gravatar image

Breck Carter
27.4k424585836
accept rate: 21%

edited 22 Sep '10, 08:40

You're on 12.0.1 already? Cutting Edge, I have to say:)

(21 Sep '10, 19:32) Volker Barth

More evidence of advancing years...

(22 Sep '10, 08:41) Breck Carter
1

That gives the "diagnostics" tag a further meaning:)

(22 Sep '10, 13:00) Volker Barth

There are a bunch of things that can cause temporary connections to be created. The list is on dcx on the connection properties page - look for the 'Name' property.

If your server is idle, it is very likely the cleaner.

permanent link

answered 21 Sep '10, 18:36

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109
accept rate: 52%

1

This is actually 11.0.1 (sorry for misleading "12.0.1" in my question). There was nothing showing in the connection name column, were the names added in version 12?

(22 Sep '10, 08:48) Breck Carter

Yes, the names are a new 12.0 feature.

(22 Sep '10, 13:10) Graeme Perrow
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×11

question asked: 21 Sep '10, 18:02

question was seen: 800 times

last updated: 22 Sep '10, 08:40