-
Tablespace Quota
A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota 200 M Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?
bassem_farouk
- Sep 17th, 2008
Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored. SQL> create user test identified by test1; User created. SQL> grant connect, reso...
vishnusivathej
- Jul 21st, 2008
There will be no such thing as default size for a tablespace u have to assign it when it is being created.. and more over by default u can have 100 datafiles in a database which is the default value used during the database creation process u can also change this value..
-
Remove Oracle memory segments
how do you remove memory segments
bassem_farouk
- Sep 18th, 2008
To see the Oracle memory segments from UNIX write ipcsthen look at the status column, the one with status is empty and owner is oraclewrite down the shmid, ex: 2 find 2 shmid 123 and 456 in order t...
-
Oracle Reserved Memory and Unreserved Memory
What is Oracle Reserved Memory and Unreserved Memory? What is the size of Oracle Reserved Memory?
bassem_farouk
- Sep 21st, 2008
Is the meomory that is allocated to each connection to Oracle, this memory is not recliamed even if the session is inactiveit is recliamed if the session is disconnected onlyto see it:D:appadminproduc...
