6. Assignment 1 on db architecture, filesystem , user ‐‐ ORACLE - sayanbhattacharya1234/Oracle_DBA GitHub Wiki

1. How to check SGA size

2. How to check database up/running

3. How to check Processes up/running

4. How to check Tablespace size

5. How to resize datafile

here i resize the datafile cars01.dbf from size 200M to 400M

6. How to offline datafile

7. How to change processes parameter value.

process parameter value if its status is IMMEDIATE then after change the value is immediatly effected.

process parameter value if its status is FALSE then after change the value we have to restart the database then we can the changed value.

8. How to check archive location

9. How to check datafile location

10. How to check controlfile location

11. How to check password file location

the password file is orapw(sid) here - orapwprod

12. How to check alert log file location

13. How to check redolog file location

14. How to drop tablespace

15. How to drop datafile

16. How to create pfile from spfile

17. How to create spfile from pfile

18. How to check maxsize of the datafile

19. How to create bigfile Tablespace

20. How to create temporary tablepsace

21. How to create undo tablespace

22. How to start database nomount

23. How to start database mount

24. How to switch logfile

25. Create tablespace myprod and datafile myprod01.dbf

26. Create user SHA

27. Give quota 2GB to user SHA

28.Increase the quota size 2GB to 5GB

29. Give system permission to user SHA

30. Drop the user SHA

31. Create another user with your first name and Set myprod as default tablespace

32. Give system privileges permission to user

33. Give select, Insert privileges of Employees table to your name user

34. Change the password of your name user

old password is oracle , new password is sayan134

35. How to unlock user

36. How to check user login time

37. how to check user last login time

38. How to check users object privileges

39. How to check users system privileges

40. How to check active and inactive session

41. How to check how many usre in database

42.Create a synonym for hr.employees table

43. Write a script to grant all privileges of hr user to your name user

44. create a role rolename like Role_1

45. How to give system privileges to role_1

46. How to give object privileges to role_1

47. How to give role_1 privileges to new role

48. How to drop role