Alibabacloud.com offers a wide variety of articles about toad for oracle dba, easily find your toad for oracle dba information here online.
tablespaces the SCOTT user uses select T.table_name, T.tablespace_namefrom dba_all_tables twhere t.owner = ' SCOTT '; 14. View Current user-owned permissions select T.privilege from Session_privs t; Sql> Select T.privilege from Session_privs t; PRIVILEGE----------------------------------------CREATE sessionunlimited tablespacecreate tablecreate Clustercreate viewcreate sequencecreate procedurecreate triggercreate typecreate OPERATORCREATE indextype 11 rows have been selected. 14. View role (
patch to prevent memory leaks.3. How to find the session of Oracle with a special resource for the system and the statements it executes.Hp-unix can be used with GLANCE,TOP,IBM Aix topas, and PS commands are also available. By using these programs we can find the process numbers of these processes that are particularly large with system resources, and we can find out which SQL the PID is executing by using the following SQL statement, which is best p
Tags: Oracle DBA stress testThis article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/42376661Before a business system stress test, an Oracle DBA is required to do the work ahead of time:1. If the Oracle database softwar
many connections are established, the resources of the database are consumed. At the same time, some "hang dead" connections may require manual cleanup by the DBA. The following SQL statement lists the sessions established by the current database: Select Sid,serial#,username,program,machine,status From V$session; which The ID number of the SID conversation (session); The serial number of the serial# session, together with the SID, to uniquely i
This is a sophomore writing in the QQ space in an article, I remember that the problem took me the whole day to fix it, so experienced quite deep, so at that time deliberately recorded the process of the settlement, and today suddenly have the interest to find out a few college writing in the spaces in the article and share with you, In case something like that happened to me, it would take a lot of time, and the following is the full contents of the record:Today login with the user Scott landed
Tags: evel group span user false standard value RAC BSPQuery scripts that Oracle DBA must master:1: Querying the size of Oracle standard data blocks by V$parameter data fields1 ----Query the size of the Oracle standard data block by v$parameter the data dictionary. 2[Email protected]> startup3ORACLE instance started.4
Tags: training institutions RAC training database ACL android Oracle database ora AgencyNow that I've been testing, I've learned about Android before, I've been through some databases, I didn't know much about it, and I'm not sure how to get Oracle DBA to do a preliminary plan here:1. Search for the process of obtaining an Or
The Oracle 11g R2 DBA Operations Guide was the first book I learned about Oracle database knowledge, where I recorded my own learning notes, and I verified the knowledge points in the book by actual operation.1.Oracle Database Foundation 1.1. relational database 1.1.1. relational Database model 1. relational Database
Label:This article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/42425491Hardware engineers move storage (new plus storage, do other things for storage), and before they do, Oracle DBA is ready to work:1.VG information hpux:vgdisplay,pvdisplay, Vgdisplay-v vg_data Aix is: Lsvg-o, lsvg,lsvg datavg,lsvg-l datavg, LSPV 2.OCR + VD information (if RAC)
resource_limit=true;The Nineth chapter: User Management1.create a user:database authenticationSql> create user Juncky identified by Oracle default Tablespace usersSql> Temporary tablespace temp quota 10m on data password expiresql> [Account Lock|unlock] [profile Profilename|default];2.change User quota on Tablespacesql> ALTER user juncky quota 0 on users;3.drop a usersql> drop User Juncky [cascade];4. Monitor UserView:dba_users, Dba_ts_quotasTenth ch
see the exported file Expdat.dmp 9. Import role Data A. First enter the DOS console B, enter the exported data directory, such as: CD C:/userdir C, Input command, IMP D, enter user name, password, import this data to the user E, followed by the return, enter key can be F, prompt to enter the user name, password, this is the data from which user to export, is that user's 10. Sqlplus Common Commands A, set Linesize 120 can set the Sqlplus display buffer size; B, set pageSize 20 to set the displ
The final reason for the investigation is due to an issue with the Oracle database itself parameter settings.1. How to adjust the memory and CPU for the virtual machine:OAKCLI Configure VM Uat-ihub-oracle-db-prefnode 1-maxvcpu 8–vcpu 8-maxmemory 16g-memory 16G2. Add a disk:OAKCLI Create Vdisk uatdb_vdisk-repo sharedrepo-size 50g-type gkfxOAKCLI Modify VM Uat-ihub-oracle
. Import role DataA. First enter the DOS consoleB, enter the exported data directory, such as: CD C:/userdirC, Input command, IMPD, enter user name, password, import this data to the userE, followed by the return, enter key can beF, prompt to enter the user name, password, this is the data from which user to export, is that user's10. Sqlplus Common CommandsA, set Linesize 120 can set the Sqlplus display buffer size;B, set pageSize 20 to set the display size per pageC, edit the current SQL statem
link is not# Sqlnet.ora Network Configuration File:d:\app\user\product\11.2.0\dbhome_3\network\admin\sqlnet.ora# Generated by Oracle configuration tools.# This file was actually generated by NETCA. But if customers choose to# install ' Software only ', this file wont exist and without the native# Authentication, they'll is not being able to connect to the database on NT.Sqlnet. Authentication_services= (NTS)NAMES. Directory_path= (TNSNames, Ezconnect
statistics, calculate */select count (*) from ScheMa.tablename; --Statistics out the total number of rows in the table select DISTINCT (ind_row) from Schema.tablename; --the distinct value of the column in which the index is counted--is then calculated purely by hand?/* Query waits for events */select event, sum (Decode (wait_time, 0, 1, 0)) "Current Wait", Sum (Decode (wai T_time, 0, 0, 1)) "Not currently waiting", COUNT (*) "Total" from v$session_wait GROUP by event ORDER by Count (*) desc;
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
