The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.
One application ... accessing 2 different databases
Come across an interesting situation; one application is connecting to 2 different databases, where as it should connect to only one, now how to figure it out, which one is the good & correct one.
Application has different kind of users, some accessing one db, but others 2nd db, now need to figure it out, which one is the good and acceptable one.
Please advise/suggest, what should be the best possible course of action, in order to figure it out, which one is the correct one.
Need to proof this from different perspectives; data/changes, active/logged in sessions and DDL basis too.
Please guide, thanks in advance.
Application has different kind of users, some accessing one db, but others 2nd db, now need to figure it out, which one is the good and acceptable one.
Please advise/suggest, what should be the best possible course of action, in order to figure it out, which one is the correct one.
Need to proof this from different perspectives; data/changes, active/logged in sessions and DDL basis too.
Please guide, thanks in advance.
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Note too that it may be as it was designed. There is nothing that says you cannot use more than one data source.
If each group of users do different functions, and those functions are not duplicated between the two DB's, then both are correct and needed.
Jim.
If each group of users do different functions, and those functions are not duplicated between the two DB's, then both are correct and needed.
Jim.
thanks Jim, but basically there are couple of issues, I just need to tell, who is connecting from where and what users/sessions are doing on the db.
Is there any way to find all these information, some kind of logging info, we don't have login trigger, but is there any Oracle view, which can give me all these data?
Is there any way to find all these information, some kind of logging info, we don't have login trigger, but is there any Oracle view, which can give me all these data?
v$session will tell you about existing sessions.
There are many columns in that view but the basics about what you are asking is here:
select username,program,machine,o
The online docs will explain the rest of the columns.
The listener.log file on the database server should show all connections over time and not just the current ones.
Unless you have auditing turned on I don't think you can get the rest of the information you are wanting.
There are many columns in that view but the basics about what you are asking is here:
select username,program,machine,o
The online docs will explain the rest of the columns.
The listener.log file on the database server should show all connections over time and not just the current ones.
Unless you have auditing turned on I don't think you can get the rest of the information you are wanting.
Can see log.xml file under listener log folder, how to find stuff from there? Or is this the correct file?
There are many ways to view an XML file. For example: Internet Explorer should be able to open it. As far as extracting data from it, there are also many tools that will allow you to parse an XML file. You just need to find one that will work for you.
All that said:
look up a directory level from where the log.xml file is and you should see a trace folder. In there is the old style listener.log that that is plain text and can be opened with just about anything.
All that said:
look up a directory level from where the log.xml file is and you should see a trace folder. In there is the old style listener.log that that is plain text and can be opened with just about anything.
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trialIt's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I am not sure anyone here can answer that for you. If users are writing data to two different databases each with the same tables, then neither would be correct.
It would become a job then of analyzing and merging the data between the two to get a "good" database.
Jim.