deedsd ✭✭✭✭✭

Comments

  • OK, it tried to register but the wizard complained that the ID already existed. I may drop the ID and try again, and see what that does. With mass registration being a not-terribly-well-documented feature that is rather persnickety, I'm not sure I would use it for just one or two databases that needed the ID recreated.
    in Add a menu item to re-run the register scripts Comment by deedsd June 2014
  • Actually, it kinda scared me. I re-ran the first step of mass-register, and after the pre-registration this is what I got: All 5 of these needed to have things re-run (and I did re-run the createIgniteUser.sql script), so they were all now running properly. The wizard thought two were already registered and three were not.…
    in Add a menu item to re-run the register scripts Comment by deedsd June 2014
  • Hmm, not sure. As cranky as it was, what would it do if the database was already registered? I would hope it would complain vigorously and fail.
    in Add a menu item to re-run the register scripts Comment by deedsd June 2014
  • This has been one of mine for a while... In particular, I'd like to see more than what 6.5 offered. I would like to see functionality similar to what dbms_xplan offers - so predicate information and notes in addition to a better-formatted execution plan. Cost and cardinality estimates (with an option for pulling actual…
    in Oracle True Plans (Predicates and Adaptive Plans) Comment by deedsd February 2014
  • I am extremely pleased that the summary view didn't go away!!
    in DPA 12.0 Part 1: Query Performance Analysis and PerfStack Comment by deedsd December 2019
  • I don't know how to map it back to a username. I don't have the DPA ERD . I usually hit conss_xx for the datestamps for the particular SQL hash you can pull from above, and then use the GUI to figure out which users were running the statement. Solarwinds Support might be willing to help you get the data from the repo…
    in finding SQL with a string Comment by deedsd March 2015
  • The repo is on Oracle 11.2.
    in Monitor insert /*+ APPEND */ behavior Comment by deedsd March 2015
  • How is cdb/pdb/multi-tenant support coming along? We are working on setting up a patching schedule, and it seems like the best way to meet our goals is to go pluggable.... WIth a container db that has one pluggable at a particular version, say 12.1.0.2 PSU1, and an empty container that has 12.1.0.2 PSU2.... We unplug from…
    in What We're Working On for DPA (Updated January, 2021) Comment by deedsd May 2015
  • There are a couple of ways to do that. Is your repository running Oracle or something else? You can use the repo query tool (options .. support .. database query tool) to determine which id you are interested based on the name of the database you want to search. You then search const_xx on the st field for the string you…
    in finding SQL with a string Comment by deedsd March 2015
  • I've run into this before. The monitors are running, the data is in the repository, but it isn't showing up in DPA. While I don't know why it happens, the easy fix is to bounce the DPA web application and all of the missing data will appear after restart.
    in DPA History 'Missing" Comment by deedsd June 2015
Avatar