NAV: SLTechnology News&Howtos > Database >

• 

  How to modify the character set of oracle 11G, user name case sensitivity and password expiration

  This article mainly introduces how to modify the oracle 11G character set, user name case-sensitive, password expiration, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it. one

  2022-05-31 15:20:05 Views: 286
• 

  How to turn on and off archiving with Oracle

  Editor to share with you how to open Oracle, close archiving, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it! 1) log_arc in stand-alone mode

  2022-05-31 15:20:05 Views: 217
• 

  How to back up the 5T database

  This article is about how to back up the 5T database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. 1. Backup capacity: level 0 backup every Saturday, level 1 backup on other dates, enable compressed backup, and DB+ level 0 backup each time

  2022-05-31 15:20:05 Views: 225
• 

  How to choose a database

  This article is about how to choose a database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. The database is a modular system consisting of several parts: the transport layer that accepts the request, and the query that decides to run the query in the most efficient manner.

  2022-05-31 15:20:05 Views: 241
• 

  How to use autotrace

  This article is about how to use autotrace. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. Autotrace definition: autotrace is a SQL execution plan that can be obtained automatically

  2022-05-31 15:20:04 Views: 296
• 

  How to convert pdf files to word documents

  This article mainly introduces how to convert pdf files into word documents, with a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand it. Materials: PDF files, computer tools: PDF conversion

  2022-05-31 15:19:43 Views: 233
• 

  How to check the number of partitions under each user in the database

  This article mainly introduces how to check the number of partitions under each user in the database, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it. -View the number of partitions under each user

  2022-05-31 15:19:43 Views: 250
• 

  How does Oracle view historical TOP SQL

  This article is about how Oracle views historical TOP SQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. Oracle view history TOP SQL history TOP SQL can be accessed through

  2022-05-31 15:19:42 Views: 203
• 

  How to see which SP calls the corresponding table in the database

  This article mainly shows you "how to check which SP calls the corresponding table in the database". The content is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to check which SP calls the corresponding table in the database".

  2022-05-31 15:19:42 Views: 209
• 

  How to use dbms_xplan to view execution plans

  Editor to share with you how to use dbms_xplan to view the implementation plan, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it! Overview of dbms_xp

  2022-05-31 15:19:42 Views: 297
• 

  How to view the Oracle parameter

  This article mainly introduces how to check the Oracle parameters, the article is very detailed, has a certain reference value, interested friends must read it! There are many parameters in Oracle, and there are different ways to set them, such as session level (alter SES)

  2022-05-31 15:19:42 Views: 273
• 

  How to view the contents of the execution plan in the database

  This article mainly introduces how to check the contents of the implementation plan in the database, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it. How plsql chooses to view the contents of the execution plan: t

  2022-05-31 15:19:41 Views: 246
• 

  How to view users who have not logged in to the system for two consecutive days in the database

  This article mainly shows you "how to check users who have not logged in to the system for two consecutive days in the database". The content is easy to understand and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn "how to check in the database for two consecutive days without logging in to the system."

  2022-05-31 15:19:41 Views: 206
• 

  How to check whether the dmp file is exported by exp or expdp

  This article mainly introduces how to view the dmp file is derived from exp or expdp, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand it. Get the header information of the dmp file

  2022-05-31 15:19:41 Views: 227
• 

  How to view the remaining tablespaces in Oracle database

  This article is about how to view the rest of the Oracle database tablespaces. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. 1) check the name and size of the tablespace physical file SELECT tablespa

  2022-05-31 15:19:41 Views: 293
• 

  How to view locked session information scripts

  This article will explain in detail how to view the locked session information script, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article. View currently blocked objects and lock information SELECT DISTIN

  2022-05-31 15:19:41 Views: 288
• 

  How to view the number of records in each table in the SQLSERVER database

  Editor to share with you how the SQLSERVER database to view the number of records of each table, I hope you will gain something after reading this article, let's discuss it together! Click (here) to collapse or open the select a.name as table name, max (b.

  2022-05-31 15:19:40 Views: 291
• 

  How does Oracle EMGC view ports

  Editor to share with you how to check the port of Oracle EMGC, I hope you will learn something after reading this article, let's discuss it together! Oracle EMGC View Port 1: EMDC can display port information by viewing status [oracle]

  2022-05-31 15:19:40 Views: 290
• 

  How to view the slowest sql statement based on the awr report

  This article mainly introduces how to view the slowest sql sentences according to the awr report, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it. When the system has been running for some time, the system is basically

  2022-05-31 15:19:40 Views: 233
• 

  How to view the backup information script in the database

  This article mainly introduces how to view the backup information script in the database, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to know it. View a backup set SPFILESELECT D

  2022-05-31 15:19:39 Views: 249