In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Lsnrctl start netca name enables listening
Startup enables an instance
Shutdown immediate shuts down the instance
Netca create links, etc.
Dbca creates a database
Select * from* View
Alter user name account unlock unlocked user
Alter user name identified by password change password
Grent connect/ link permissions / resource/ additions, deletions, modifications, queries, etc. / dba/ database management on library name. Indicate who to @ IP identified by password
Create tablespace tablespace name
Datafile'/ opt/.dbf' specifies the tablespace file location
Size 10m autoentend on automatic growth
Alter tablespace tablespaces add files in space
Add datafile
'/ opt.dbf' size 20m
Autoextend on turns on automatic growth
Alter tablespace tablespace read only/ read-only write/ read-write set space permissions
Drop tablespace space name including contents delete space
Create user user name
Identified by password
Default tablespace tablespace name
Temporary tablespace temporary space
Quota unlimited on space names have no space restrictions.
Password expire login for the first time to change the password
Oracle Architecture SGA PGA UGA
SGA has shared pool data buffers, log buffers
Shared pools directly affect overall performance
Compile and analyze the syntax, make up of library cache and data dictionary, and cache statements
Data buffer
Save data and improve reading speed in memory
Log buffer
Record a log, and when a rule is reached, it will be written to the log file
Daichi
Used for backup and restore of a large amount of data
Java Pool
Used to process java instructions
When writing data to text, logging needs to go through the background process of the system
PMON automatically cleans up the failure process, releases resources, and so on
SMON replies to the free space occupied by the failed startup of the instance
DBWR manages the data buffer and writes to the
LGWR manages log buffers, writing to log files
CKPT ensures the synchronization of data files and log files
Sys is a super user.
System is the database administrator.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.