This forum is currently locked. You can't register or post questions at this time. (read more)

My readings

All posts relating to Oracle database administration.

Moderator: Tim...

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Wed Sep 11, 2013 7:28 pm

Hi.

Stats are explained here:

http://www.oracle-base.com/articles/mis ... istics.php

You shouldn't go randomly updating the stats though. That is also very expensive for the database.

A database is made up of several tablespaces. Each tablespace is made up of one or more data files. Two database can not share the same tablespaces, and therefore can not share the same datafiles.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Thu Sep 12, 2013 7:49 pm

Respected Sir,

That means if we have 10 table spaces, we must have 10 data files are more, two or more tables spaces doesn't have one datafile, one table space is having one data file or more is it?

Secondly Today, I read in that book, product_user_profile table can restrict to user to execute some commands, more it explained we can also restrict a user to set roles his / her but there is no more explanation in that book. So I refrerred in oracle manuals in manuals we can restric user to set roles by inserting attribute column as "ROLES". Suppose if we want to restrict a user to restict 3 roles we have to insert 3 rows in product_user_profile table and each row contain a role what to restrict in char_value column. Can we replace Char_value colum to 'ALL', so that we can restrict a user to execute command set roles all; in sqlplus. Is it possible? I have checked this by insert a row in product_user_profile table while login for restricted user "missing or invaled role name" error is coming.

I and also I checked default page size in sql is 10, but in book he mentioned 24/n it means 24 or n n means any number. Is that mean default size is vary version to version ? what is the parameter author mentioned as 24/n in default page size in common sql environment variables ?

Thanks & Regards,

Anil kumar.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Fri Sep 13, 2013 7:02 am

Hi.

Your said,

"That means if we have 10 table spaces, we must have 10 data files are more, two or more tables spaces doesn't have one datafile, one table space is having one data file or more is it?"


True.

You said,

"I and also I checked default page size in sql is 10, but in book he mentioned 24/n it means 24 or n n means any number. Is that mean default size is vary version to version ? what is the parameter author mentioned as 24/n in default page size in common sql environment variables ?"


Page size is nothing to do with SQL. It is a setting in the SQL*Plus tool. You can alter the page size by issuing "SET PAGESIZE 100" or any appropriate value. It only affects how SQL*Plus displays the data. It has no affect on how Oracle processes the data.

You said,

"I read in that book, product_user_profile table can restrict to user to execute some commands, more it explained we can also restrict a user to set roles his / her but there is no more explanation in that book. So I refrerred in oracle manuals in manuals we can restric user to set roles by inserting attribute column as "ROLES". Suppose if we want to restrict a user to restict 3 roles we have to insert 3 rows in product_user_profile table and each row contain a role what to restrict in char_value column. Can we replace Char_value colum to 'ALL', so that we can restrict a user to execute command set roles all; in sqlplus. Is it possible? I have checked this by insert a row in product_user_profile table while login for restricted user "missing or invaled role name" error is coming."


Sorry. I really don't understand what you are asking here... :( Perhaps you should post the relevant script to set up an example. Maybe that will help me understand your problem...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Fri Sep 13, 2013 12:11 pm

Respected Sir,

in sysdba login, we have a table name product_user_profile, through that table we can restrict a user not to access all commands through SQL Plus such as insert, delete, update etc. This is related to Sql Plus Security. For more information about this http://docs.oracle.com/cd/B28359_01/ser ... 89/ch9.htm. OK.

I am asking, how to restrict a user not to enter set roles command. Now you read my above query which I had asked you earlier, you will get it.

Thanks & Regards,

V. Anil Kumar.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Fri Sep 13, 2013 2:15 pm

No. I don't get it...

Send the relevant CREATE USER and CREATE ROLE statements to set up a test case. Then send the INSERT statements you are trying (and failing) to get working. Maybe when I see this test case I will understand what you are asking.

Remember, when you are asking for help, you have to make it as easy as possible to people to help you. I'm extremely busy at the moment, so anything you can do to make my life easier will make me far more likely to try and help. The best way to do that is to post a complete (but simplified) test case...

Telling me to read a document is not going to help me understand *your* requirement...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Fri Sep 13, 2013 4:16 pm

Sorry sir, Though you are busy.. I am distrubing you again & again..

Let us discuss more clearly, do you have the idea of Sql Plus Security related to product_user_profile table ? product_user_profile table is the built in table for oracle software.

Thanks & Regards,

Anil Kumar

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Fri Sep 13, 2013 4:37 pm

Hi.

Send a test case. User and roles etc. Once you've done that I will look at the issue.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Fri Sep 13, 2013 5:25 pm

OK Sir,

I can describe as follows.

Code: Select all

SQL> desc product_user_profile;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PRODUCT                                   NOT NULL VARCHAR2(30)
 USERID                                             VARCHAR2(30)
 ATTRIBUTE                                          VARCHAR2(240)
 SCOPE                                              VARCHAR2(240)
 NUMERIC_VALUE                                      NUMBER(15,2)
 CHAR_VALUE                                         VARCHAR2(240)
 DATE_VALUE                                         DATE
 LONG_VALUE                                         LONG


Code: Select all

SQL> select substr(product,0,10), substr(userid,0,10), substr(scope,0,10),substr(char_value,0,10) from product_user_profile;

SUBSTR(PRO SUBSTR(USE SUBSTR(SCO SUBSTR(CHA                                     
---------- ---------- ---------- ----------                                     
SQL*Plus   HR                    ALL                                           

SQL> quit


By inserting above row in product_user_profile table we can restrict HR user not to enter set role all command in Sql plus prompt. As per document if we place any role in Char_value column, we can prevent a user to execute set role command to that particular user. That is working. But it is not working for ALL. We could not prevent a user to enter set role all command in sql plus user.

Thanks & Regards,

Anil Kumar.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Fri Sep 13, 2013 5:56 pm

Hi.

Straight from the docs, in the description of "CHAR_VALUE", from the link you provided...

"If you are disabling a role, it must contain the name of the role you wish to disable. You cannot use a wildcard."

There is no role called "ALL". In this context, "ALL" is a wildcard and so can not be used.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Fri Sep 13, 2013 6:24 pm

OK Sir,

Thanks, Here Saturday & Sunday is holiday, So I will meet you one Monday, with updated readings...

Thsnks & Regards,

Anil Kumar.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Fri Sep 13, 2013 10:29 pm

OK
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Sat Sep 14, 2013 9:41 am

Tim Sir,

How are you sir.

Tomorrow 15/09 is my birth day. By the next birth day, I want to be a DBA.

Pls give me your blessings..

Anil Kumar.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Sat Sep 14, 2013 10:23 am

Hi.

Happy birthday for tomorrow. Regarding becoming a DBA, that is totally in your hands. If you work hard you can do it. If you don't you won't. Good luck.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

anilvvkumar
Member
Posts: 41
Joined: Thu Aug 29, 2013 9:16 pm

Re: My readings

Postby anilvvkumar » Tue Sep 17, 2013 12:06 pm

Hello Sir,

How are you.

I was in total depression, becuase, I had asked to my CMD to change my department to DBA, they have conducted interview and asked me Complete Oracle Database Architecture with diagram. Since I have not yet studied that topics, I was tried to explain with diagram, but they have not satisfied. And also they told me right now we dont have that much work like that.

OK, any how I want to study complete Oracle Architecture with diagram explanation. Do you any documents or books related to this topic?

Thanks & Regards,

Anil Kumar

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: My readings

Postby Tim... » Tue Sep 17, 2013 1:13 pm

Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron