Skip to content

January 2024

REMOTE_LOGIN_PASSWORDFILE

  • 1z0-082

V$PASSWORDFILE_INFO V$PASSWORDFILE_INFO provides information about the database password file. select * from v$passwordfile_info; show parameter remote_login_passwordfile; Remote_login_passwordfile Parameter and it’s use Remote_login_passwordfile   specifies whether Oracle checks… Read More »REMOTE_LOGIN_PASSWORDFILE

Data Dictionary Storage

Views: User_Objects, User_source, User_Errors, User_Object_size, User_Dependicies –Query the User_Objects view for all procedures and functionsSELECT object_name, statusFROM user_objectsWHERE object_type IN(‘PROCEDURE’, ‘FUNCTION’); —Determine which objects have… Read More »Data Dictionary Storage