1. View all users in the current database: Select username from dba_users;2. View the user logged in for the current session: Show users or select username from user_users;3. View all tables for a user: SELECT * from Dba_tables where owner= ' username ';--username to capitalize or select table_name from dba_tables where owner= ' Netfolder ‘;4, check the location
I. Viewing data filesSql> select name from V$datafile;NAME--------------------------------------------------------D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01. DbfD:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01. DbfTwo. View Control filesSql> select name from V$controlfile;NAME----------------------
used to analyze DML operations, to Oracle9i to analyze DDL operations.4. Logminer does not support index organization tables, Long, LOB, and collection types.5, MTS Environment also can not use Logminer.
Second, the Operation steps1, set up for the Logminer analysis of the data files stored locationThis is the process of setting the Utl_file_dir parameter, my example:A, add the following line to the Initctc.ora fileUtl_file_dir=/u01/archb, the databa
used to analyze DML operations, to Oracle9i to analyze DDL operations.4. Logminer does not support index organization tables, Long, LOB, and collection types.5, MTS Environment also can not use Logminer.
Second, the Operation steps1, set up for the Logminer analysis of the data files stored locationThis is the process of setting the Utl_file_dir parameter, my example:A, add the following line to the Initctc.ora fileUtl_file_dir=/u01/archb, the databa
In the development of the company, the development of the program in the local test is normal, but in the test environment is problematic. The first reaction is to look at the log file and see what the error message is in the log file. I carried out the Vim Log.txt, and then the direct card to die, can not open.What to do, I still have to check AH. Using the Cat command, although the card is not dead, but t
Tags: style blog http io color os ar for SPThe log generated by SQL Server installation is stored in this directory:
"%ProgramFiles%\Microsoft SQL server\[sql_version]\setup bootstrap\log\"
Note: [Sql_version] is a specific version of SQL Server, such as SQL Server 2008 is, SQL SERVER2014 is 120
There are many log
View Log files in Linux 1. create the working directory mkdir-p/usr/local/viruswww.2cto. com2. download the Log analysis script cd/usr/local/logs written by laruence.
View Log files in
General programs are deployed in a Linux environment, and when viewing logs, typically less is used to meet most of the requirements.Enumerating and documenting the most common scenarios, the code takes the Tomcat log file Catalna.out as an example.View files directly Less Catalina.outAfter viewing the file, if the file is too large, hit the following command to scroll the file:J Next line K prev line
SqlServer modifies the storage location of database files and log files, and SQL server log files
-- View the current storage location select database_id, name, physical_name AS CurrentLocation, state_desc, size from sys. master_f
Many corporate LANs now have their own file servers for storing or sharing files for use by local area network users. However, in the process of setting up shared file access, it is common for shared files to be randomly copied, modified, or even deleted, which makes the security management of shared files face a greater risk. How can you make it possible for use
cannot be found. Instead, the backup is completed directly and 297 backup set is generated, which is different from the situation encountered by the customer.-- After the backup is complete, view the generated backup set[Oracle @ ora10g ~] $ Cd/u01/orabackup/backupsets/[oracle @ ora10g backupsets] $ ll-lrthtotal 1.6g.....other backup sets (omitted)-Rw-r ----- 1 oracle oinstall 606 K Sep 24 ora10g-4175411955_20140924_859118422_297.arc-rw-r ----- 1 ora
Oracle manually switches log files and clears log files
Oracle switch log file groupLog File groups are used cyclically. When a group of log files is full, the Oracle system automatical
Generation Log:
All client and server interaction protocols will be placed in this log, and Vugen will then analyze the protocol interaction and eventually generate the script.
The recorded Vugen script is generated from this log. If you want to return to the original state after an error or error modification at the end of the recording, you can use the Tools>
function, which is its log function. This Apache log series introduces Apache access logs, error logs, how to analyze log data, how to customize Apache logs, and how to generate statistical reports from log data.If Apache is installed by default, two log
Tags: mysqlMySQL enable log, view Log MYSQLEnable logging[Email protected]]# whereis My.ini[[Email protected]]# vi/etc/my.cnf[MySQLDdatadir=/var/lib/MySQLsocket=/var/lib/MySQL/MySQL. SockUser=MySQL# Default to using old password format for compatibility withMySQL3.x# clients (those using theMySQLCLIENT10 compatibility package).Old_passwords=1[MySQLD_safe]
SSH User logon log
The Linux login log is in the following directory:
The code is as follows
Copy Code
Cd/var/log
To view the login log for an SSH user:
The code is as follows
Copy Code
Less secure
abnormal LOGIN recordsMessages -- records the records output to the system console. Other information is generated by syslog.Security -- Record some examples of attempts to access the restricted scope using the UCP SystemSulog -- Record the records using the su command. It is usually in/var/adm/sulog. If you use the su command on the machine, do not forget to clear it.Utmp-records all users currently logged on to the system. This file is constantly changing as the user enters and leaves the sys
The following is a description of the 20 log files that are located under the/var/log/directory. Some of these are only available in specific versions, such as Dpkg.log, which can only be seen in Debian-based systems.
/var/log/messages -Includes overall system information, which also contains logs during system sta
If you are willing to spend some time on the Linux environment, you should first know where the log files are located and what they contain. Learning about these different log files while your system is working properly can help you find and solve problems in emergencies.The following is a description of the 20
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.