Tuesday, 2 September 2014

How to check how many users running on instance at os level?

1. How to check how many users running on instance at os level?

SM 04 we check instance vise, AL08 we check total instances only Dialog users. ST06 --LAN tab--> check there how many users are login the system wide here we check system names and ip address also.

2. How can we basis people change the database parameters?

OS level we set parameters
Linux, Oracle DB..
go to /oracle/SID/112_64/dbs/initora.sap
here we copy file initora.sap to offline_ora.sap or online_ora.sap
then inside we modify the parameters...

next we login db13 then we given profile parameter as per our backup set profile parameter.

No comments:

Post a Comment