Oracle DBA Tutorial 1 - How to install Oracle 11g Release 2 in Windows 64-Bit Operating System
Oracle DBA Tutorial 2 - How to login in Oracle Database in command line
Oracle DBA Tutorial 5 - How to check tablespace size in Oracle database
Oracle DBA Tutorial 6 - How to enable archivelog mode
Oracle DBA Tutorial 7 - How to disable archive log mode
Oracle DBA Tutorial 8 - How to resize db_recovery_file_dest_size in Oracle database
Oracle DBA Tutorial 9 - How to Lock and Unlock an user in Oracle database
Oracle DBA Tutorial 10 - How to connect Oracle database with SQL Developer
Oracle DBA Tutorial 11 - How to find and Kill the session in Oracle Database using SQL Developer
Oracle DBA Tutorial 12 - How to Find the Database ID in Oracle Database
🔰 Oracle DBA Tutorial 10 - How to connect Oracle database with SQL Developer 🔰
A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer's main objective is to help the end user save time and maximize the return on investment in the Oracle Database technology stack.
Download SQL Developer:
https://www.oracle.com/tools/downloads/sqldev-downloads-2141.html
Steps: ---
1. Login to your Oracle Database. (sqlplus / as sysdba) from command line.
2. run the below commands.
## Flow the tutorial 3 or 4 for creating user, tablespace and creating datafile.
SQL⇒ select username from dba_users;
## lets take the user chirag.
##Open SQL Developer.. and connect the database.
Get the SID details from below command.
SQL⇒ Select name from v$database;
ORCL
## using user details create the connection in SQL Developer.
## Now run the below command for getting session count.
SQL⇒ select count(*) from v$session;
Note : Flow the Process shown in video.
😉Subscribe and like for more videos:
https://www.youtube.com/@chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
0 Comments
Leave a message
